ETL_DWH_ARI/schema/GC_TRANSIT_ARI/tables/import.Value_Entry.sql

CREATE TABLE [import].[Value_Entry] (
   [timestamp] [binary](8) NOT NULL,
   [Entry No_] [int] NOT NULL,
   [Item No_] [varchar](30) NOT NULL,
   [Document No_] [varchar](20) NOT NULL,
   [Description] [varchar](100) NOT NULL,
   [Invoiced Quantity] [decimal](38,20) NOT NULL,
   [Cost per Unit] [decimal](38,20) NOT NULL,
   [Amount] [decimal](38,20) NOT NULL,
   [Applies-to Entry] [int] NOT NULL,
   [Order Line No_] [int] NOT NULL,
   [Item Type] [int] NOT NULL,
   [Order No_] [varchar](20) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO