C11/System/ARI/SQL/schema/ARI/tables/import.Labor Ledger Entry.sql

CREATE TABLE [import].[Labor Ledger Entry] (
   [timestamp] [binary](8) NOT NULL,
   [Entry No_] [int] NOT NULL,
   [Location Code] [nvarchar](10) NOT NULL,
   [Document No_] [nvarchar](20) NOT NULL,
   [Posting Date] [datetime] NOT NULL,
   [Labor No_] [nvarchar](20) NOT NULL,
   [Make Code] [nvarchar](20) NOT NULL,
   [Charging Group No_] [nvarchar](20) NOT NULL,
   [Description] [nvarchar](50) NOT NULL,
   [Work Type Code] [nvarchar](10) NOT NULL,
   [Unit of Measure Code] [nvarchar](10) NOT NULL,
   [Quantity] [decimal](38,20) NOT NULL,
   [Direct Unit Cost] [decimal](38,20) NOT NULL,
   [Unit Cost] [decimal](38,20) NOT NULL,
   [Total Cost] [decimal](38,20) NOT NULL,
   [Unit Price] [decimal](38,20) NOT NULL,
   [Total Price] [decimal](38,20) NOT NULL,
   [Department Code] [nvarchar](20) NOT NULL,
   [Qty_ per Hour] [decimal](38,20) NOT NULL,
   [Qty_ (Hour)] [decimal](38,20) NOT NULL,
   [User ID] [nvarchar](50) NOT NULL,
   [Source Code] [nvarchar](10) NOT NULL,
   [Chargeable] [tinyint] NOT NULL,
   [Journal Batch Name] [nvarchar](10) NOT NULL,
   [Reason Code] [nvarchar](10) NOT NULL,
   [Gen_ Bus_ Posting Group] [nvarchar](10) NOT NULL,
   [Gen_ Prod_ Posting Group] [nvarchar](10) NOT NULL,
   [Document Date] [datetime] NOT NULL,
   [External Document No_] [nvarchar](35) NOT NULL,
   [No_ Series] [nvarchar](10) NOT NULL,
   [Main Group Code] [nvarchar](10) NOT NULL,
   [Subgroup Code] [nvarchar](10) NOT NULL,
   [Line Group Code] [nvarchar](10) NOT NULL,
   [Sell-to Customer No_] [nvarchar](20) NOT NULL,
   [Bill-to Customer No_] [nvarchar](20) NOT NULL,
   [VIN] [nvarchar](20) NOT NULL,
   [Vehicle Type] [nvarchar](50) NOT NULL,
   [Package No_] [nvarchar](20) NOT NULL,
   [Package Version No_] [int] NOT NULL,
   [Standard Time] [decimal](38,20) NOT NULL,
   [Actual Time] [decimal](38,20) NOT NULL,
   [Entry Type] [int] NOT NULL,
   [Standard Time Type] [int] NOT NULL,
   [Service Order No_] [nvarchar](20) NOT NULL,
   [Service Order Line No_] [int] NOT NULL,
   [Document Type] [int] NOT NULL,
   [Standard Time (Hour)] [decimal](38,20) NOT NULL,
   [Branch Code] [nvarchar](10) NOT NULL,
   [Dimension Set ID] [int] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Labor Ledger Entry$0] PRIMARY KEY CLUSTERED ([Entry No_], [Client_DB])
)


GO