﻿CREATE TABLE [dbo].[QuoteFull_Q_old] (
    [Vers]            VARCHAR (5)      NOT NULL,
    [QuoteType]       CHAR (1)         NOT NULL,
    [CodQuote]        BIGINT           NOT NULL,
    [QuoteRev]        INT              NOT NULL,
    [CodClient]       NVARCHAR (50)    NOT NULL,
    [ClientName]      NVARCHAR (250)   NOT NULL,
    [CodItem]         NVARCHAR (50)    NOT NULL,
    [CodItemGroup]    NVARCHAR (50)    NOT NULL,
    [RawMat]          NVARCHAR (50)    NOT NULL,
    [UnitWeight]      DECIMAL (9, 3)   NOT NULL,
    [BatchQty]        INT              NOT NULL,
    [CodInco]         NVARCHAR (5)     NOT NULL,
    [KeyAM]           NVARCHAR (101)   NOT NULL,
    [Note]            NVARCHAR (2500)  NOT NULL,
    [FullCost]        DECIMAL (9, 6)   NOT NULL,
    [MinPrice]        DECIMAL (9, 6)   NOT NULL,
    [PriceOff]        DECIMAL (9, 6)   NOT NULL,
    [CodClientAssoc]  NVARCHAR (100)   NULL,
    [ClientNameAssoc] NVARCHAR (100)   NULL,
    [ItemDescr]       NVARCHAR (100)   NULL,
    [CodifProfilo]    NVARCHAR (100)   NULL,
    [ClasseMerc]      NVARCHAR (100)   NULL,
    [TipoDies]        NVARCHAR (100)   NULL,
    [CodDiesGroup]    NVARCHAR (100)   NULL,
    [DiamDies]        NVARCHAR (100)   NULL,
    [HoleNumDies]     NVARCHAR (100)   NULL,
    [DiesPrice]       NVARCHAR (100)   NULL,
    [DiesExpLife]     NVARCHAR (100)   NULL,
    [DiesEOLife]      NVARCHAR (100)   NULL,
    [NumDiesInList]   NVARCHAR (100)   NULL,
    [NumDiesExaust]   NVARCHAR (100)   NULL,
    [CodPlant]        NVARCHAR (100)   NULL,
    [KeyAMIL]         NVARCHAR (100)   NULL,
    [KgTeo]           NVARCHAR (100)   NULL,
    [NumSMED]         NVARCHAR (100)   NULL,
    [QuotaMan]        NVARCHAR (100)   NULL,
    [PRMWeight]       NVARCHAR (100)   NULL,
    [PWeight]         NVARCHAR (100)   NULL,
    [PTare]           NVARCHAR (100)   NULL,
    [LivPackage]      NVARCHAR (100)   NULL,
    [LivPackageDett]  NVARCHAR (100)   NULL,
    [RawMatCost]      DECIMAL (18, 6)  NOT NULL,
    [RawMatExtraCost] DECIMAL (18, 6)  NOT NULL,
    [RawMatFullCost]  DECIMAL (19, 6)  NULL,
    [CodPackag]       NVARCHAR (50)    NOT NULL,
    [PkgDesc]         NVARCHAR (100)   NULL,
    [FSR]             DECIMAL (27, 19) NULL,
    [ProvvCost]       DECIMAL (38, 7)  NOT NULL,
    [EECost]          DECIMAL (38, 7)  NOT NULL,
    [GasCost]         DECIMAL (38, 7)  NOT NULL,
    [DiesCost]        DECIMAL (38, 7)  NOT NULL,
    [PackCost]        DECIMAL (38, 7)  NOT NULL,
    [TranspCost]      DECIMAL (38, 7)  NOT NULL,
    [SellCost01]      DECIMAL (38, 7)  NOT NULL,
    [RefCost01]       DECIMAL (38, 7)  NOT NULL,
    [SellCost04]      DECIMAL (38, 7)  NOT NULL,
    [RefCost04]       DECIMAL (38, 7)  NOT NULL,
    [WSR01]           DECIMAL (9, 8)   NOT NULL,
    [MSR01]           DECIMAL (9, 8)   NOT NULL,
    [NetProd01]       DECIMAL (9, 3)   NOT NULL,
    [FC4UG01]         DECIMAL (9, 6)   NOT NULL,
    [VC4UG01]         DECIMAL (9, 6)   NOT NULL,
    [OH4UG01]         DECIMAL (9, 6)   NOT NULL,
    [SC4UG01]         DECIMAL (9, 6)   NOT NULL,
    [DSR]             DECIMAL (38, 27) NULL,
    [NetProd04]       DECIMAL (9, 3)   NOT NULL,
    [FC4UG04]         DECIMAL (9, 6)   NOT NULL,
    [VC4UG04]         DECIMAL (9, 6)   NOT NULL,
    [FVC]             DECIMAL (38, 7)  NULL,
    [Charge]          DECIMAL (9, 6)   NOT NULL
);

