parts_special_prices.sql 416 B

12345678910111213
  1. CREATE TABLE [dbo].[parts_special_prices] (
  2. [part_number] [varchar](100) NOT NULL,
  3. [order_classification_flag] [varchar](10) NOT NULL,
  4. [is_active] [smallint] NULL,
  5. [price] [numeric](11,2) NULL,
  6. [addition_percent] [numeric](11,5) NULL,
  7. [client_db] [varchar](20) NOT NULL
  8. ,CONSTRAINT [parts_special_prices$0] PRIMARY KEY CLUSTERED ([part_number], [order_classification_flag], [client_db])
  9. )
  10. GO