C11/System/NAVISION/SQL/schema/NAVISION/tables/import.Sales_Invoice_Header.sql

CREATE TABLE [import].[Sales_Invoice_Header] (
   [timestamp] [binary](8) 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](50) NOT NULL,
   [Bill-to Contact] [varchar](50) 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](50) NOT NULL,
   [Ship-to Contact] [varchar](50) 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 No_] [varchar](20) 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,
   [VAT Registration No_] [varchar](20) 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](50) NOT NULL,
   [Sell-to Contact] [varchar](50) 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,
   [Pre-Assigned No_ Series] [varchar](10) NOT NULL,
   [No_ Series] [varchar](10) NOT NULL,
   [Order No_ Series] [varchar](10) NOT NULL,
   [Pre-Assigned No_] [varchar](20) NOT NULL,
   [User ID] [varchar](20) NOT NULL,
   [Source Code] [varchar](10) NOT NULL,
   [Tax Area Code] [varchar](20) NOT NULL,
   [Tax Liable] [tinyint] NOT NULL,
   [VAT Bus_ Posting Group] [varchar](10) 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_] [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,
   [Service Order No_ 2] [varchar](20) NOT NULL,
   [Service Order Line No_] [int] NOT NULL,
   [Cockpit Posting Entry No_] [int] NOT NULL,
   [Transfer Method] [int] NOT NULL,
   [Cockpit Version No_ Warranty] [varchar](20) NOT NULL,
   [First Shipment Date] [datetime] NOT NULL,
   [Last Shipment Date] [datetime] NOT NULL,
   [Main Shipment Date] [datetime] NOT NULL,
   [Branch Code] [varchar](10) NOT NULL,
   [Vehicle Unit Price Date] [datetime] NOT NULL,
   [Cash Payment] [tinyint] NOT NULL,
   [Cash Payment Document Type] [int] NOT NULL,
   [Cash Register Receipt] [varchar](20) NOT NULL,
   [Activities Created] [tinyint] NOT NULL,
   [Disable for Requisition] [tinyint] NOT NULL,
   [Warranty Lock] [tinyint] 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_ Grp] [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,
   [VIN] [varchar](20) NOT NULL,
   [License No_] [varchar](20) 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](30) 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,
   [No_ of posted credit memos] [int] NOT NULL,
   [Existing Credit Memo Amount] [decimal](38,20) NOT NULL,
   [QR-Code] [image] NULL,
   [Client_DB] [varchar](50) NOT NULL
       DEFAULT ('1')

   ,CONSTRAINT [Sales Invoice Header$0] PRIMARY KEY CLUSTERED ([No_], [Client_DB])
)


GO