C11/System/NAVISION/SQL/schema/NAVISION_BYD/tables/import.Sales_Trade-In.sql

CREATE TABLE [import].[Sales_Trade-In] (
   [timestamp] [timestamp] NOT NULL,
   [Document Type] [int] NOT NULL,
   [Document No_] [varchar](20) NOT NULL,
   [Document Line No_] [int] NOT NULL,
   [Line No_] [int] NOT NULL,
   [Trade-In for VIN] [varchar](20) NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [Description] [varchar](30) NOT NULL,
   [Model No_] [varchar](20) NOT NULL,
   [Make Code] [varchar](20) NOT NULL,
   [Unit Cost (LCY)] [decimal](38,20) NOT NULL,
   [Unit Cost Incl_ VAT (LCY)] [decimal](38,20) NOT NULL,
   [Unit Cost] [decimal](38,20) NOT NULL,
   [Unit Cost Incl_ VAT] [decimal](38,20) NOT NULL,
   [VAT Prod_ Posting Group] [varchar](10) NOT NULL,
   [Differential Taxation] [tinyint] NOT NULL,
   [VAT %] [decimal](38,20) NOT NULL,
   [Purch_ Document Type] [int] NOT NULL,
   [Purch_ Invoice No_] [varchar](20) NOT NULL,
   [Purch_ Order Line No_] [int] NOT NULL,
   [Posted Purch_ Invoice No_] [varchar](20) NOT NULL,
   [Posted Purch_ Invoice Line No_] [int] NOT NULL,
   [Purch_ Cr_ Memo No_] [varchar](20) NOT NULL,
   [Purch_ Cr_ Memo Line No_] [int] NOT NULL,
   [Posted Purch_ Cr_ Memo No_] [varchar](20) NOT NULL,
   [Posted Purch_ CM Line No_] [int] NOT NULL,
   [Customer No_] [varchar](20) NOT NULL,
   [Assigned] [tinyint] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Sales_Trade-In$0] PRIMARY KEY CLUSTERED ([Document Type], [Document No_], [Document Line No_], [Line No_], [Client_DB])
)


GO