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

CREATE TABLE [import].[Sales_Header] (
   [timestamp] [timestamp] NOT NULL,
   [Document Type] [int] NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [Sell-to Customer No_] [varchar](20) NOT NULL,
   [Bill-to Customer No_] [varchar](20) NOT NULL,
   [Bill-to Name] [varchar](50) NOT NULL,
   [Bill-to Name 2] [varchar](50) NOT NULL,
   [Bill-to Address] [varchar](50) NOT NULL,
   [Bill-to Address 2] [varchar](50) NOT NULL,
   [Bill-to City] [varchar](30) NOT NULL,
   [Bill-to Contact] [varchar](30) NOT NULL,
   [Your Reference] [varchar](30) NOT NULL,
   [Ship-to Code] [varchar](10) NOT NULL,
   [Ship-to Name] [varchar](50) NOT NULL,
   [Ship-to Name 2] [varchar](50) NOT NULL,
   [Ship-to Address] [varchar](50) NOT NULL,
   [Ship-to Address 2] [varchar](50) NOT NULL,
   [Ship-to City] [varchar](30) NOT NULL,
   [Ship-to Contact] [varchar](30) NOT NULL,
   [Order Date] [datetime] NOT NULL,
   [Posting Date] [datetime] NOT NULL,
   [Shipment Date] [datetime] NOT NULL,
   [Posting Description] [varchar](50) NOT NULL,
   [Payment Terms Code] [varchar](10) NOT NULL,
   [Due Date] [datetime] NOT NULL,
   [Payment Discount %] [decimal](38,20) NOT NULL,
   [Pmt_ Discount Date] [datetime] NOT NULL,
   [Shipment Method Code] [varchar](10) NOT NULL,
   [Location Code] [varchar](10) NOT NULL,
   [Department Code] [varchar](10) NOT NULL,
   [Make Code] [varchar](10) NOT NULL,
   [Customer Posting Group] [varchar](10) NOT NULL,
   [Currency Code] [varchar](10) NOT NULL,
   [Currency Factor] [decimal](38,20) NOT NULL,
   [Price Group Code] [varchar](10) NOT NULL,
   [Prices Including VAT] [tinyint] NOT NULL,
   [Allow Quantity Disc_] [tinyint] NOT NULL,
   [Invoice Disc_ Code] [varchar](20) NOT NULL,
   [Cust__Item Disc_ Gr_] [varchar](10) NOT NULL,
   [Language Code] [varchar](10) NOT NULL,
   [Salesperson Code] [varchar](10) NOT NULL,
   [Order Class] [varchar](10) NOT NULL,
   [No_ Printed] [int] NOT NULL,
   [On Hold] [varchar](3) NOT NULL,
   [Applies-to Doc_ Type] [int] NOT NULL,
   [Applies-to Doc_ No_] [varchar](20) NOT NULL,
   [Bal_ Account No_] [varchar](20) NOT NULL,
   [Job No_] [varchar](20) NOT NULL,
   [Ship] [tinyint] NOT NULL,
   [Invoice] [tinyint] NOT NULL,
   [Shipping No_] [varchar](20) NOT NULL,
   [Posting No_] [varchar](20) NOT NULL,
   [Last Shipping No_] [varchar](20) NOT NULL,
   [Last Posting No_] [varchar](20) NOT NULL,
   [VAT Registration No_] [varchar](20) NOT NULL,
   [Combine Shipments] [tinyint] NOT NULL,
   [Reason Code] [varchar](10) NOT NULL,
   [Gen_ Bus_ Posting Group] [varchar](10) NOT NULL,
   [EU 3-Party Trade] [tinyint] NOT NULL,
   [Transaction Type] [varchar](10) NOT NULL,
   [Transport Method] [varchar](10) NOT NULL,
   [VAT Country Code] [varchar](10) NOT NULL,
   [Sell-to Customer Name] [varchar](50) NOT NULL,
   [Sell-to Customer Name 2] [varchar](50) NOT NULL,
   [Sell-to Address] [varchar](50) NOT NULL,
   [Sell-to Address 2] [varchar](50) NOT NULL,
   [Sell-to City] [varchar](30) NOT NULL,
   [Sell-to Contact] [varchar](30) NOT NULL,
   [Bill-to Post Code] [varchar](20) NOT NULL,
   [Bill-to County] [varchar](30) NOT NULL,
   [Bill-to Country Code] [varchar](10) NOT NULL,
   [Sell-to Post Code] [varchar](20) NOT NULL,
   [Sell-to County] [varchar](30) NOT NULL,
   [Sell-to Country Code] [varchar](10) NOT NULL,
   [Ship-to Post Code] [varchar](20) NOT NULL,
   [Ship-to County] [varchar](30) NOT NULL,
   [Ship-to Country Code] [varchar](10) NOT NULL,
   [Bal_ Account Type] [int] NOT NULL,
   [Exit Point] [varchar](10) NOT NULL,
   [Correction] [tinyint] NOT NULL,
   [Document Date] [datetime] NOT NULL,
   [External Document No_] [varchar](20) NOT NULL,
   [Area] [varchar](10) NOT NULL,
   [Transaction Specification] [varchar](10) NOT NULL,
   [Payment Method Code] [varchar](10) NOT NULL,
   [Shipping Agent Code] [varchar](10) NOT NULL,
   [Package Tracking No_] [varchar](30) NOT NULL,
   [No_ Series] [varchar](10) NOT NULL,
   [Posting No_ Series] [varchar](10) NOT NULL,
   [Shipping 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,
   [Applies-to ID] [varchar](20) NOT NULL,
   [VAT Base Discount %] [decimal](38,20) NOT NULL,
   [Order Type] [int] NOT NULL,
   [Customer Confirmation Date] [datetime] NOT NULL,
   [Price Freeze Until] [datetime] NOT NULL,
   [Service Order No_ 2] [varchar](20) NOT NULL,
   [Item Sales Price Group] [varchar](10) NOT NULL,
   [Show Discount] [tinyint] NOT NULL,
   [Purch_ Order Type] [varchar](10) NOT NULL,
   [Inv_ Discount %] [decimal](38,20) NOT NULL,
   [Sell-to Salutation Code] [varchar](10) NOT NULL,
   [Bill-to Salutation Code] [varchar](10) NOT NULL,
   [Ship-to Addr_ Salutation Code] [varchar](10) NOT NULL,
   [Vehicle Sales Price Group] [varchar](10) NOT NULL,
   [Option Sales Price Group] [varchar](10) NOT NULL,
   [Copy Header Text to Next Doc_] [tinyint] NOT NULL,
   [Copy Footer Text to Next Doc_] [tinyint] NOT NULL,
   [Customer Group Code] [varchar](10) NOT NULL,
   [Cockpit Entry No_] [int] NOT NULL,
   [Transfer Method] [int] NOT NULL,
   [Cockpit Cr_ Memo Version No_] [varchar](20) NOT NULL,
   [Status Code] [varchar](20) NOT NULL,
   [First Shipment Date] [datetime] NOT NULL,
   [Last Shipment Date] [datetime] NOT NULL,
   [Main Shipment Date] [datetime] NOT NULL,
   [Print] [tinyint] NOT NULL,
   [Branch Code] [varchar](10) NOT NULL,
   [Use Inventory Buffer Quantity] [tinyint] NOT NULL,
   [Vehicle Unit Price Date] [datetime] NOT NULL,
   [Cash Payment] [tinyint] NOT NULL,
   [Cash Payment Document Type] [int] NOT NULL,
   [Disable for Requisition] [tinyint] NOT NULL,
   [Req_ Wksh_ Template Name] [varchar](20) NOT NULL,
   [Requisition Wksh_ Name] [varchar](20) NOT NULL,
   [Customer Contact Program] [tinyint] NOT NULL,
   [Mobile Service] [tinyint] NOT NULL,
   [Bulkcust_ Business] [tinyint] NOT NULL,
   [Bulk Customer No_] [varchar](30) NOT NULL,
   [Bulkcust_ Gen_ Bus_ Post_ Grp] [varchar](10) NOT NULL,
   [Bulkcust_ VAT Bus_ Post_ Group] [varchar](10) NOT NULL,
   [No_ of Bulk Customer] [varchar](10) NOT NULL,
   [Bulkcust_Veh_ Sales Price Grp] [varchar](10) NOT NULL,
   [Bulkcust_ Opt_ Sales Price Grp] [varchar](10) NOT NULL,
   [Bulkcust_ Item Sales Price Grp] [varchar](10) NOT NULL,
   [SA3 Quotation ID] [int] NOT NULL,
   [SA3 Contract No_] [int] NOT NULL,
   [SA3 Order No_] [int] NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [License No_] [varchar](11) NOT NULL,
   [Mileage] [decimal](38,20) NOT NULL,
   [Model Code] [varchar](20) NOT NULL,
   [Model No_] [varchar](20) NOT NULL,
   [Prod_ Year] [datetime] NOT NULL,
   [Model] [varchar](50) NOT NULL,
   [Type] [varchar](50) NOT NULL,
   [Initial Registration] [datetime] NOT NULL,
   [Engine Code] [varchar](10) NOT NULL,
   [Engine No_] [varchar](20) NOT NULL,
   [Customer Registration Date] [datetime] NOT NULL,
   [Labor Type] [varchar](30) NOT NULL,
   [Labor Charging Code] [varchar](10) NOT NULL,
   [Fabrication Code] [varchar](20) NOT NULL,
   [PaSS Deliver All Positions] [tinyint] NOT NULL,
   [Combine Shipment] [tinyint] NOT NULL,
   [Premium Selection] [int] NOT NULL,
   [Bulkcust_ Labor Price Group] [varchar](10) NOT NULL,
   [Bulkcust_ Ser_ Sales Price Grp] [varchar](10) NOT NULL,
   [Bulkcust_ Contact1] [varchar](20) NOT NULL,
   [Bulkcust_ Contact2] [varchar](20) NOT NULL,
   [Bulkcust_ Contact3] [varchar](20) NOT NULL,
   [Bulk_ Cont_ fleet veh_ leader] [varchar](20) NOT NULL,
   [Discount Memo] [tinyint] NOT NULL,
   [User ID] [varchar](20) NOT NULL,
   [User ID Order] [varchar](20) NOT NULL,
   [Reference-to Doc_ Type] [int] NOT NULL,
   [Reference-to Doc_ No_] [varchar](20) NOT NULL,
   [ZFSupplierNo] [varchar](10) NOT NULL,
   [ZFBMWCompCode] [varchar](10) NOT NULL,
   [ZFBMWOrderNo] [varchar](10) NOT NULL,
   [ZFBMWBusinessUnit] [varchar](10) NOT NULL,
   [ZFBMWBusinessArea] [varchar](10) NOT NULL,
   [ZFBuyerTradeParty] [varchar](10) NOT NULL,
   [WebShopRGNr] [varchar](20) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Sales_Header$0] PRIMARY KEY CLUSTERED ([Document Type], [No_], [Client_DB])
)


GO