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

CREATE TABLE [import].[SRD_File] (
   [timestamp] [timestamp] NOT NULL,
   [Register No_] [int] NOT NULL,
   [Entry No_] [int] NOT NULL,
   [SRD Item No_] [varchar](35) NOT NULL,
   [Dealer No_] [varchar](20) NOT NULL,
   [Transaction Type] [varchar](10) NOT NULL,
   [Transaction Type Specification] [varchar](10) NOT NULL,
   [xTimestamp] [varchar](20) NOT NULL,
   [Current Qty_ On-Hand] [decimal](38,20) NOT NULL,
   [Open Order Quantity] [decimal](38,20) NOT NULL,
   [Average Cost] [decimal](38,20) NOT NULL,
   [Description] [varchar](30) NOT NULL,
   [Replenishment Flag] [varchar](10) NOT NULL,
   [Minimum] [decimal](38,20) NOT NULL,
   [Maximum] [decimal](38,20) NOT NULL,
   [Location] [varchar](10) NOT NULL,
   [Distribution Code] [varchar](10) NOT NULL,
   [Parts Type] [varchar](10) NOT NULL,
   [Product Class] [varchar](10) NOT NULL,
   [Requirements Note] [varchar](10) NOT NULL,
   [Technical Note] [varchar](10) NOT NULL,
   [Requisition Code] [varchar](10) NOT NULL,
   [Gross Sales Price] [decimal](38,20) NOT NULL,
   [Discount Code] [varchar](10) NOT NULL,
   [Part No_ Interpreted] [varchar](40) NOT NULL,
   [Blocked] [varchar](10) NOT NULL,
   [Transmit] [tinyint] NOT NULL,
   [Item No_] [varchar](20) NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO