C11/System/NAVISION/SQL/schema/NAVISION_BYD/tables/import.Customer.sql

CREATE TABLE [import].[Customer] (
   [timestamp] [binary](8) NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [Name] [varchar](50) NOT NULL,
   [Search Name] [varchar](50) NOT NULL,
   [Name 2] [varchar](50) NOT NULL,
   [Address] [varchar](50) NOT NULL,
   [Address 2] [varchar](50) NOT NULL,
   [City] [varchar](50) NOT NULL,
   [Contact] [varchar](50) NOT NULL,
   [Phone No_] [varchar](50) NOT NULL,
   [Telex No_] [varchar](20) NOT NULL,
   [Our Account No_] [varchar](20) NOT NULL,
   [Territory Code] [varchar](10) NOT NULL,
   [Department Code] [varchar](10) NOT NULL,
   [Make Code] [varchar](10) NOT NULL,
   [Chain Name] [varchar](10) NOT NULL,
   [Budgeted Amount] [decimal](38,20) NOT NULL,
   [Credit Limit (LCY)] [decimal](38,20) NOT NULL,
   [Customer Posting Group] [varchar](10) NOT NULL,
   [Currency Code] [varchar](10) NOT NULL,
   [Price Group Code] [varchar](10) NOT NULL,
   [Language Code] [varchar](10) NOT NULL,
   [Statistics Group] [int] NOT NULL,
   [Payment Terms Code] [varchar](10) NOT NULL,
   [Fin_ Charge Terms Code] [varchar](10) NOT NULL,
   [Salesperson Code] [varchar](10) NOT NULL,
   [Shipment Method Code] [varchar](10) NOT NULL,
   [Shipping Agent Code] [varchar](10) NOT NULL,
   [Place of Export] [varchar](20) NOT NULL,
   [Invoice Disc_ Code] [varchar](20) NOT NULL,
   [Cust__Item Disc_ Gr_] [varchar](10) NOT NULL,
   [Country Code] [varchar](10) NOT NULL,
   [Collection Method] [varchar](20) NOT NULL,
   [Amount] [decimal](38,20) NOT NULL,
   [Blocked] [tinyint] NOT NULL,
   [Invoice Copies] [int] NOT NULL,
   [Last Statement No_] [int] NOT NULL,
   [Print Statements] [tinyint] NOT NULL,
   [Bill-to Customer No_] [varchar](20) NOT NULL,
   [Priority] [int] NOT NULL,
   [Payment Method Code] [varchar](10) NOT NULL,
   [Last Date Modified] [datetime] NOT NULL,
   [Application Method] [int] NOT NULL,
   [Allow Quantity Disc_] [tinyint] NOT NULL,
   [Prices Including VAT] [tinyint] NOT NULL,
   [Location Code] [varchar](10) NOT NULL,
   [Fax No_] [varchar](50) NOT NULL,
   [Telex Answer Back] [varchar](20) NOT NULL,
   [VAT Registration No_] [varchar](20) NOT NULL,
   [Combine Shipments] [tinyint] NOT NULL,
   [Gen_ Bus_ Posting Group] [varchar](10) NULL,
   [Picture] [image] NULL,
   [Post Code] [varchar](20) NOT NULL,
   [County] [varchar](30) NOT NULL,
   [E-Mail] [varchar](80) NOT NULL,
   [Home Page] [varchar](80) NOT NULL,
   [Reminder Terms Code] [varchar](10) NOT NULL,
   [No_ Series] [varchar](10) NOT NULL,
   [Tax Area Code] [varchar](20) NOT NULL,
   [Tax Liable] [tinyint] NOT NULL,
   [VAT Bus_ Posting Group] [varchar](10) NOT NULL,
   [Reserve] [int] NOT NULL,
   [Home Phone No_] [varchar](50) NOT NULL,
   [Mobile Phone No_] [varchar](50) NOT NULL,
   [Service Advisor No_] [varchar](20) NOT NULL,
   [Branch Posting Group] [varchar](10) NOT NULL,
   [Address No_] [int] NOT NULL,
   [Date of Update] [datetime] NOT NULL,
   [Time of Update] [datetime] NOT NULL,
   [Updated by User ID] [varchar](20) NOT NULL,
   [Update Company] [varchar](30) NOT NULL,
   [Last Name] [varchar](50) NOT NULL,
   [First Name] [varchar](50) NOT NULL,
   [Address Salutation Code] [varchar](10) NOT NULL,
   [Letter Salutation Code] [varchar](10) NOT NULL,
   [Bulk Customer No_] [varchar](30) NOT NULL,
   [Title Code] [varchar](10) NOT NULL,
   [Customer Type] [int] NOT NULL,
   [Labor Price Group] [varchar](10) NOT NULL,
   [Ext_ Service Price Group] [varchar](10) NOT NULL,
   [Vehicle Sales Price Group] [varchar](10) NOT NULL,
   [Item Sales Price Group] [varchar](10) NOT NULL,
   [Employee No_] [varchar](20) NOT NULL,
   [Home Fax No_] [varchar](50) NOT NULL,
   [Home Mobile Phone No_] [varchar](50) NOT NULL,
   [Home E-Mail] [varchar](80) NOT NULL,
   [Home Page 2] [varchar](80) NOT NULL,
   [Date 1] [datetime] NOT NULL,
   [Date 2] [datetime] NOT NULL,
   [Extra Code 1] [varchar](10) NOT NULL,
   [Extra Code 2] [varchar](10) NOT NULL,
   [Extra Code 3] [varchar](10) NOT NULL,
   [Text 1] [varchar](50) NOT NULL,
   [Text 2] [varchar](50) NOT NULL,
   [Text 3] [varchar](50) NOT NULL,
   [Text 4] [varchar](50) NOT NULL,
   [Text 5] [varchar](50) NOT NULL,
   [Text 6] [varchar](50) NOT NULL,
   [Show Discount] [tinyint] NOT NULL,
   [Inv_ Discount %] [decimal](38,20) NOT NULL,
   [Option Sales Price Group] [varchar](10) NOT NULL,
   [Customer Group Code] [varchar](20) NOT NULL,
   [Add Service Surcharges] [tinyint] NOT NULL,
   [Creation Date] [datetime] NOT NULL,
   [Respect Inv_ Buffer Quantity] [tinyint] NOT NULL,
   [Transfer Method] [int] NOT NULL,
   [Partner Code] [varchar](20) NOT NULL,
   [EU Business Customer] [tinyint] NOT NULL,
   [Action triggered by Card form] [tinyint] NULL,
   [Disable for Requisition] [tinyint] NOT NULL,
   [Bulkcust_ Gen_ Bus_ Post_ Grp] [varchar](10) NULL,
   [Bulkcust_ VAT Bus_ Post_ Grp] [varchar](10) NULL,
   [Bulkcust_ Labor Price Group] [varchar](10) NULL,
   [Bulkcust_ Ser_ Sales Price Grp] [varchar](10) NULL,
   [Bulkcust_ Item Sales Price Grp] [varchar](10) NULL,
   [Bulkcust_ Veh_ Sales Price Grp] [varchar](10) NULL,
   [Bulkcust_ Opt_ Sales Price Grp] [varchar](10) NULL,
   [Contact 1] [varchar](20) NULL,
   [Contact 2] [varchar](20) NULL,
   [Contact 3] [varchar](20) NULL,
   [Contact to fleet veh_ leader] [varchar](20) NULL,
   [Street] [varchar](50) NOT NULL,
   [House No_] [varchar](50) NOT NULL,
   [Anz_ Posten für Begleitbrief] [int] NULL,
   [SEPA Type] [int] NULL,
   [Block for SA] [tinyint] NULL,
   [Block for aftersales] [tinyint] NULL,
   [Block for advertising] [tinyint] NULL,
   [KIA MIS Cust_ Infos blocked] [tinyint] NULL,
   [Former Address No_] [int] NULL,
   [Planned TKP Export] [tinyint] NULL,
   [Last TKP Export] [datetime] NULL,
   [Auto Planned TKP Export] [tinyint] NULL,
   [Invoice E-Mail] [varchar](80) NULL,
   [SMS Phone] [tinyint] NULL,
   [SMS Home Phone] [tinyint] NULL,
   [SMS Mobile Phone] [tinyint] NULL,
   [SMS Home Mobile Phone] [tinyint] NULL,
   [Street Sa] [varchar](50) NULL,
   [House No_ Sa] [varchar](15) NULL,
   [Post Code Sa] [varchar](20) NULL,
   [City Sa] [varchar](50) NULL,
   [Address Sa] [varchar](50) NULL,
   [Country Code Sa] [varchar](10) NULL,
   [Main Address] [int] NULL,
   [Address 2 Sa] [varchar](50) NULL,
   [ExportToRSP] [tinyint] NULL,
   [Client_DB] [varchar](50) NOT NULL
      CONSTRAINT [DF__Customer__Client__498EEC8D] DEFAULT ('1')

   ,CONSTRAINT [Customer$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB])
)


GO