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

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