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

CREATE TABLE [import].[Item_Charge] (
   [timestamp] [timestamp] NOT NULL,
   [No_] [varchar](20) NOT NULL,
   [Description] [varchar](50) NOT NULL,
   [Gen_ Prod_ Posting Group] [varchar](10) NOT NULL,
   [Tax Group Code] [varchar](10) NOT NULL,
   [VAT Prod_ Posting Group] [varchar](10) NOT NULL,
   [Search Description] [varchar](50) NOT NULL,
   [Department Code] [varchar](20) NOT NULL,
   [Make Code] [varchar](20) NOT NULL,
   [Surcharge_Reduction Type] [int] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

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


GO