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