CREATE TABLE [import].[Service_Line] ( [timestamp] [binary](8) NOT NULL, [Document Type] [int] NOT NULL, [Document No_] [varchar](20) NOT NULL, [Line No_] [int] NOT NULL, [Sell-to Customer No_] [varchar](20) NOT NULL, [Type] [int] NOT NULL, [No_] [varchar](20) NOT NULL, [Location Code] [varchar](10) NOT NULL, [Posting Group] [varchar](30) NOT NULL, [Quantity Disc_ Code] [varchar](20) NOT NULL, [Order Date] [datetime] NOT NULL, [Description] [varchar](150) NOT NULL, [Description 2] [varchar](150) NOT NULL, [Unit of Measure] [varchar](10) NOT NULL, [Quantity] [decimal](38,20) NOT NULL, [Outstanding Quantity] [decimal](38,20) NOT NULL, [Qty_ to Invoice] [decimal](38,20) NOT NULL, [Qty_ to Ship] [decimal](38,20) NOT NULL, [Unit Price] [decimal](38,20) NOT NULL, [Unit Cost (LCY)] [decimal](38,20) NOT NULL, [VAT %] [decimal](38,20) NOT NULL, [Quantity Disc_ %] [decimal](38,20) NOT NULL, [Line Discount %] [decimal](38,20) NOT NULL, [Line Discount Amount] [decimal](38,20) NOT NULL, [Amount] [decimal](38,20) NOT NULL, [Amount Including VAT] [decimal](38,20) NOT NULL, [Gross Weight] [decimal](38,20) NOT NULL, [Net Weight] [decimal](38,20) NOT NULL, [Units per Parcel] [decimal](38,20) NOT NULL, [Unit Volume] [decimal](38,20) NOT NULL, [Appl_-to Item Entry] [int] NOT NULL, [Department Code] [varchar](10) NOT NULL, [Make Code] [varchar](10) NOT NULL, [Price Group Code] [varchar](10) NOT NULL, [Allow Quantity Disc_] [tinyint] NOT NULL, [Serial No_] [varchar](20) NOT NULL, [Cust__Item Disc_ %] [decimal](38,20) NOT NULL, [Outstanding Amount] [decimal](38,20) NOT NULL, [Qty_ Shipped Not Invoiced] [decimal](38,20) NOT NULL, [Shipped Not Invoiced] [decimal](38,20) NOT NULL, [Quantity Shipped] [decimal](38,20) NOT NULL, [Quantity Invoiced] [decimal](38,20) NOT NULL, [Profit %] [decimal](38,20) NOT NULL, [Bill-to Customer No_] [varchar](20) NOT NULL, [Gen_ Bus_ Posting Group] [varchar](10) NOT NULL, [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL, [VAT Calculation Type] [int] NOT NULL, [Transaction Type] [varchar](10) NOT NULL, [Transport Method] [varchar](10) NOT NULL, [Attached to Line No_] [int] NOT NULL, [Exit Point] [varchar](10) NOT NULL, [Area] [varchar](10) NOT NULL, [Transaction Specification] [varchar](10) NOT NULL, [Tax Area Code] [varchar](20) NOT NULL, [Tax Liable] [tinyint] NOT NULL, [Tax Group Code] [varchar](10) NOT NULL, [VAT Bus_ Posting Group] [varchar](10) NOT NULL, [VAT Prod_ Posting Group] [varchar](10) NOT NULL, [Currency Code] [varchar](10) NOT NULL, [Outstanding Amount (LCY)] [decimal](38,20) NOT NULL, [Shipped Not Invoiced (LCY)] [decimal](38,20) NOT NULL, [Reserved Quantity] [decimal](38,20) NOT NULL, [Reserve] [int] NOT NULL, [VAT Base Amount] [decimal](38,20) NOT NULL, [Unit Cost] [decimal](38,20) NOT NULL, [System-Created Entry] [tinyint] NOT NULL, [Option Code] [varchar](20) NOT NULL, [Book No_] [varchar](20) NOT NULL, [Variant Code] [varchar](10) NOT NULL, [Bin Code] [varchar](30) NOT NULL, [Qty_ per Unit of Measure] [decimal](38,20) NOT NULL, [Planned] [tinyint] NOT NULL, [Unit of Measure Code] [varchar](10) NOT NULL, [Quantity (Base)] [decimal](38,20) NOT NULL, [Outstanding Qty_ (Base)] [decimal](38,20) NOT NULL, [Qty_ to Invoice (Base)] [decimal](38,20) NOT NULL, [Qty_ to Ship (Base)] [decimal](38,20) NOT NULL, [Qty_ Shipped Not Invd_ (Base)] [decimal](38,20) NOT NULL, [Qty_ Shipped (Base)] [decimal](38,20) NOT NULL, [Qty_ Invoiced (Base)] [decimal](38,20) NOT NULL, [Reserved Qty_ (Base)] [decimal](38,20) NOT NULL, [Qty_ Invoiced (Hour)] [decimal](38,20) NOT NULL, [No Service Surcharge] [tinyint] NOT NULL, [Service Job No_] [int] NOT NULL, [Standard Time] [decimal](38,20) NOT NULL, [Qty_ per Hour] [decimal](38,20) NOT NULL, [Qty_ (Hour)] [decimal](38,20) NOT NULL, [Outstanding Qty_ (Hour)] [decimal](38,20) NOT NULL, [Qty_ Rcd_ Not Invoiced (Hour)] [decimal](38,20) NOT NULL, [Qty_ Shipped (Hour)] [decimal](38,20) NOT NULL, [Package No_] [varchar](20) NOT NULL, [Data Make Code] [varchar](10) NOT NULL, [Vehicle Appointment Code] [varchar](10) NOT NULL, [Next Appointment on] [datetime] NOT NULL, [Next Appointment at Mileage] [int] NOT NULL, [Additional Item] [int] NOT NULL, [Quantity Multiplier] [decimal](38,20) NOT NULL, [Package Version No_] [int] NOT NULL, [No Charge] [tinyint] NOT NULL, [Allow Discount] [tinyint] NOT NULL, [Exch_ Parts Tax Base] [decimal](38,20) NOT NULL, [Exch_ Parts Tax %] [decimal](38,20) NOT NULL, [Exch_ Parts Tax Amount] [decimal](38,20) NOT NULL, [Exch_ Parts VAT %] [decimal](38,20) NOT NULL, [Charging Price] [decimal](38,20) NOT NULL, [Service Posting Group] [varchar](30) NOT NULL, [Sales Department Code] [varchar](10) NOT NULL, [Fixed Price] [decimal](38,20) NOT NULL, [Standard Time Type] [int] NOT NULL, [Fair Deal] [tinyint] NOT NULL, [Text Line Link] [int] NOT NULL, [Surcharge Code] [varchar](10) NOT NULL, [Post with Book No_] [tinyint] NOT NULL, [Sending Required] [int] NOT NULL, [Suppress in Order] [tinyint] NOT NULL, [Purchase Receipt] [varchar](20) NOT NULL, [Purch_ Rcpt_ Line] [int] NOT NULL, [Find No_] [tinyint] NOT NULL, [Dimension Change] [tinyint] NOT NULL, [Value Increasing Measure] [tinyint] NOT NULL, [Inventory Posting Group Type] [int] NOT NULL, [Inventory Posting Group] [varchar](10) NOT NULL, [Shelf_Bin No_] [varchar](10) NOT NULL, [Sales Branch Code] [varchar](10) NOT NULL, [Line Status] [int] NOT NULL, [Availability Entry No_] [int] NOT NULL, [Disable for Requisition] [tinyint] NOT NULL, [Open Autom_ Stock Info_ Form] [tinyint] NOT NULL, [Labor Standard Time Type] [int] NOT NULL, [BMW BSI Indicator] [int] NOT NULL, [BMW BSI Realisation Type] [int] NOT NULL, [BMW SAM2 _ APAS Sequential No_] [int] NOT NULL, [Price is Fixed] [tinyint] NOT NULL, [Parts Clearing] [tinyint] NOT NULL, [Rush Order] [tinyint] NOT NULL, [Short Jobno_] [int] NOT NULL, [Using WIF] [tinyint] NOT NULL, [WIF Order Marker From] [varchar](30) NOT NULL, [WIF Order Marker To] [varchar](30) NOT NULL, [Not Accident Free] [tinyint] NOT NULL, [SRP-MM_MRP Package] [tinyint] NOT NULL, [Client_DB] [varchar](50) NOT NULL DEFAULT ('1') ,CONSTRAINT [Service Line$0] PRIMARY KEY CLUSTERED ([Document Type], [Document No_], [Line No_], [Client_DB]) ) GO