﻿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)
);

