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