Samuele E. Locatelli
23 lines
984 B
Transact-SQL
23 lines
984 B
Transact-SQL
CREATE TABLE [dbo].[QuoteFull_C] (
|
|
[Vers] VARCHAR (5) NOT NULL,
|
|
[QuoteType] CHAR (1) NOT NULL,
|
|
[CodQuote] BIGINT NOT NULL,
|
|
[QuoteRev] INT NOT NULL,
|
|
[Class01] NVARCHAR (50) NOT NULL,
|
|
[Class02] NVARCHAR (50) NOT NULL,
|
|
[CodItem] NVARCHAR (50) NOT NULL,
|
|
[RawMat] NVARCHAR (50) NOT NULL,
|
|
[CodPlant] NVARCHAR (50) NOT NULL,
|
|
[CodDiesGroup] NVARCHAR (50) NOT NULL,
|
|
[CodPackag] NVARCHAR (50) NOT NULL,
|
|
[batchQty] INT NOT NULL,
|
|
[CodInco] NVARCHAR (5) NOT NULL,
|
|
[RawMatFullCost] NUMERIC (18, 6) NOT NULL,
|
|
[FVC] DECIMAL (18, 6) NOT NULL,
|
|
[FullCost] DECIMAL (18, 6) NOT NULL,
|
|
[valid] BIT NULL,
|
|
[errorScore] INT NULL,
|
|
CONSTRAINT [PK_QuoteFull_C] PRIMARY KEY CLUSTERED ([QuoteType] ASC, [CodQuote] ASC, [QuoteRev] ASC)
|
|
);
|
|
|