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

CREATE TABLE [import].[Item_Price] (
   [timestamp] [timestamp] NOT NULL,
   [Location Code] [varchar](10) NOT NULL,
   [Item No_] [varchar](20) NOT NULL,
   [Price Group Code] [varchar](10) NOT NULL,
   [Unit of Measure Code] [varchar](10) NOT NULL,
   [Currency Code] [varchar](10) NOT NULL,
   [Starting Date] [datetime] NOT NULL,
   [Unit Price] [decimal](38,20) NOT NULL,
   [Price Includes VAT] [tinyint] NOT NULL,
   [Allow Quantity Disc_] [tinyint] NOT NULL,
   [Allow Cust__Item Disc_] [tinyint] NOT NULL,
   [Allow Invoice Disc_] [tinyint] NOT NULL,
   [VAT Bus_ Posting Gr_ (Price)] [varchar](10) NOT NULL,
   [Unit Price incl_ VAT] [decimal](38,20) NOT NULL,
   [Allow Discount] [tinyint] NOT NULL,
   [Allow Price Calculation] [tinyint] NOT NULL,
   [Ending Date] [datetime] NOT NULL,
   [Branch-Independent Price] [tinyint] NOT NULL,
   [BMW Specialprice] [tinyint] NOT NULL,
   [Client_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [Item_Price$0] PRIMARY KEY CLUSTERED ([Location Code], [Item No_], [Price Group Code], [Unit of Measure Code], [Currency Code], [Starting Date], [Client_DB])
)


GO