Samuele E. Locatelli
74 lines
3.3 KiB
Transact-SQL
74 lines
3.3 KiB
Transact-SQL
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
|
|
);
|
|
|