ETL_DWH_LOCOSOFT/schema/LOCOSOFT/tables/parts_special_prices.sql

CREATE TABLE [dbo].[parts_special_prices] (
   [part_number] [varchar](100) NOT NULL,
   [order_classification_flag] [varchar](10) NOT NULL
      CONSTRAINT [DF_parts_special_prices_order_classification_flag] DEFAULT (''),
   [is_active] [smallint] NULL,
   [price] [numeric](11,2) NULL,
   [addition_percent] [numeric](11,5) NULL,
   [client_db] [varchar](20) NOT NULL

   ,CONSTRAINT [parts_special_prices$0] PRIMARY KEY CLUSTERED ([part_number], [order_classification_flag], [client_db])
)


GO