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

CREATE TABLE [import].[SRD_Transaction] (
   [timestamp] [binary](8) 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,
   [Customer Backorder] [decimal](38,20) NOT NULL,
   [Enable for Requisition] [tinyint] NOT NULL,
   [Area] [int] NOT NULL,
   [Document Type] [int] NOT NULL,
   [Document No_] [varchar](20) NOT NULL,
   [Posting Date] [datetime] NOT NULL,
   [Quantity] [decimal](38,20) NOT NULL,
   [Gross Price] [decimal](38,20) NOT NULL,
   [Unit Price] [decimal](38,20) NOT NULL,
   [Customer Order No_] [varchar](20) NOT NULL,
   [Customer Text] [varchar](30) NOT NULL,
   [Customer No_] [varchar](20) NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [Mileage] [decimal](38,20) NOT NULL,
   [Salesperson Code] [varchar](10) NOT NULL,
   [Item No_] [varchar](20) NOT NULL,
   [Client_DB] [varchar](50) NOT NULL
       DEFAULT ('1')

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


GO