Samuele E. Locatelli
176 lines
13 KiB
Transact-SQL
176 lines
13 KiB
Transact-SQL
CREATE TABLE [dbo].[QuoteFull_S] (
|
|
[Vers] VARCHAR (5) NOT NULL,
|
|
[QuoteType] CHAR (1) CONSTRAINT [DF_QuoteFull_S_QuoteType] DEFAULT ('S') NOT NULL,
|
|
[CodQuote] BIGINT CONSTRAINT [DF_QuoteFull_S_CodQuote] DEFAULT ((0)) NOT NULL,
|
|
[QuoteRev] INT CONSTRAINT [DF_QuoteFull_S_QuoteRev] DEFAULT ((0)) NOT NULL,
|
|
[IdxQState] INT CONSTRAINT [DF_QuoteFull_S_IdxQState] DEFAULT ((0)) 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) CONSTRAINT [DF_QuoteFull_S_UnitWeight] DEFAULT ((0)) NOT NULL,
|
|
[BatchQty] INT CONSTRAINT [DF_QuoteFull_S_BatchQty] DEFAULT ((1)) NOT NULL,
|
|
[CodInco] NVARCHAR (5) NOT NULL,
|
|
[TranspZone] NVARCHAR (50) NOT NULL,
|
|
[KeyAM] NVARCHAR (101) NOT NULL,
|
|
[Note] NVARCHAR (2500) NOT NULL,
|
|
[PriceOff] DECIMAL (9, 6) CONSTRAINT [DF_QuoteFull_S_PriceOff] DEFAULT ((0)) 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] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiamDies] DEFAULT ((0)) NOT NULL,
|
|
[HoleNumDies] INT CONSTRAINT [DF_QuoteFull_S_HoleNumDies] DEFAULT ((1)) NOT NULL,
|
|
[DiesPrice_sim] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesPrice_avg] DEFAULT ((0)) NOT NULL,
|
|
[DiesPrice] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesPrice] DEFAULT ((0)) NOT NULL,
|
|
[SamplePrice] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_TestPrice] DEFAULT ((0)) NOT NULL,
|
|
[DiesFullCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesFullCost] DEFAULT ((0)) NOT NULL,
|
|
[DiesPriceClientQuote] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesPrice1] DEFAULT ((0)) NOT NULL,
|
|
[DiesExpLife] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesExpLife] DEFAULT ((0)) NOT NULL,
|
|
[DiesEOLife] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesEOLife] DEFAULT ((0)) NOT NULL,
|
|
[DiesTecLife] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesTecLife] DEFAULT ((1)) NOT NULL,
|
|
[DiesCommLife] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesCommLife1] DEFAULT ((1)) NOT NULL,
|
|
[MonthSalesPrev] INT CONSTRAINT [DF_QuoteFull_S_DiesTecLife1] DEFAULT ((0)) NOT NULL,
|
|
[SalesPrevCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_SalesPrevCost] DEFAULT ((0)) NOT NULL,
|
|
[DiesFinCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesFinCost] DEFAULT ((0)) NOT NULL,
|
|
[ClientQuoteReven] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_ClientQuoteReven] DEFAULT ((0)) NOT NULL,
|
|
[ExtraDiscountDies] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_ExtraDiscountDies] DEFAULT ((0)) NOT NULL,
|
|
[DiesByClass] BIT CONSTRAINT [DF_QuoteFull_S_DiesByClass] DEFAULT ((0)) NOT NULL,
|
|
[NumDiesInList] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_NumDiesInList] DEFAULT ((0)) NOT NULL,
|
|
[NumDiesExaust] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_NumDiesExaust] DEFAULT ((0)) NOT NULL,
|
|
[CodPlant] NVARCHAR (100) NULL,
|
|
[KeyAMIL] NVARCHAR (100) NULL,
|
|
[KgTeo] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_KgTeo] DEFAULT ((0)) NOT NULL,
|
|
[NumSMED] INT CONSTRAINT [DF_QuoteFull_S_NumSMED] DEFAULT ((0)) NOT NULL,
|
|
[QuotaMan] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_QuotaMan] DEFAULT ((0)) NOT NULL,
|
|
[PRMWeight] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_PRMWeight] DEFAULT ((0)) NOT NULL,
|
|
[PWeight] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_PWeight] DEFAULT ((0)) NOT NULL,
|
|
[PTare] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_PTare] DEFAULT ((0)) NOT NULL,
|
|
[LivPackage] NVARCHAR (100) NULL,
|
|
[LivPackageDett] NVARCHAR (100) NULL,
|
|
[RawMatCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_RawMatCost] DEFAULT ((0)) NOT NULL,
|
|
[RawMatExtraCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_RawMatExtraCost] DEFAULT ((0)) NOT NULL,
|
|
[RawMatFullCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_RawMatFullCost] DEFAULT ((0)) NOT NULL,
|
|
[CodPackag] NVARCHAR (50) NOT NULL,
|
|
[PkgDesc] NVARCHAR (100) NULL,
|
|
[FSR] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_FSR] DEFAULT ((0)) NOT NULL,
|
|
[ProvvCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_ProvvCost] DEFAULT ((0)) NOT NULL,
|
|
[EECost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_EECost] DEFAULT ((0)) NOT NULL,
|
|
[GasCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_GasCost] DEFAULT ((0)) NOT NULL,
|
|
[DiesCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_DiesCost] DEFAULT ((0)) NOT NULL,
|
|
[PackCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_PackCost] DEFAULT ((0)) NOT NULL,
|
|
[TranspCost] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_TranspCost] DEFAULT ((0)) NOT NULL,
|
|
[SellCost01] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_SellCost01] DEFAULT ((0)) NOT NULL,
|
|
[RefCost01] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_RefCost01] DEFAULT ((0)) NOT NULL,
|
|
[SellCost04] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_SellCost04] DEFAULT ((0)) NOT NULL,
|
|
[RefCost04] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_RefCost04] DEFAULT ((0)) NOT NULL,
|
|
[WSR01_sim] DECIMAL (9, 8) CONSTRAINT [DF_QuoteFull_S_WSR01_avg] DEFAULT ((0)) NOT NULL,
|
|
[WSR01] DECIMAL (9, 8) CONSTRAINT [DF_QuoteFull_S_WSR01] DEFAULT ((0)) NOT NULL,
|
|
[MSR01_sim] DECIMAL (9, 8) CONSTRAINT [DF_QuoteFull_S_MSR01_avg] DEFAULT ((0)) NOT NULL,
|
|
[MSR01] DECIMAL (9, 8) CONSTRAINT [DF_QuoteFull_S_MSR01] DEFAULT ((0)) NOT NULL,
|
|
[NetProd01_sim] DECIMAL (9, 3) CONSTRAINT [DF_QuoteFull_S_NetProd01_avg] DEFAULT ((0)) NOT NULL,
|
|
[NetProd04_sim] DECIMAL (9, 3) CONSTRAINT [DF_QuoteFull_S_NetProd01_sim1] DEFAULT ((0)) NOT NULL,
|
|
[NetProd01] DECIMAL (9, 3) CONSTRAINT [DF_QuoteFull_S_NetProd01] DEFAULT ((0)) NOT NULL,
|
|
[FC4UG01] DECIMAL (9, 6) CONSTRAINT [DF_QuoteFull_S_FC4UG01] DEFAULT ((0)) NOT NULL,
|
|
[VC4UG01] DECIMAL (9, 6) CONSTRAINT [DF_QuoteFull_S_VC4UG01] DEFAULT ((0)) NOT NULL,
|
|
[OH4UG01] DECIMAL (9, 6) CONSTRAINT [DF_QuoteFull_S_OH4UG01] DEFAULT ((0)) NOT NULL,
|
|
[SC4UG01] DECIMAL (9, 6) CONSTRAINT [DF_QuoteFull_S_SC4UG01] DEFAULT ((0)) NOT NULL,
|
|
[DSR_sim] DECIMAL (9, 8) CONSTRAINT [DF_QuoteFull_S_DSR_avg] DEFAULT ((0)) NOT NULL,
|
|
[DSR] DECIMAL (9, 8) CONSTRAINT [DF_QuoteFull_S_DSR] DEFAULT ((0)) NOT NULL,
|
|
[NetProd04] DECIMAL (9, 3) CONSTRAINT [DF_QuoteFull_S_NetProd04] DEFAULT ((0)) NOT NULL,
|
|
[FC4UG04] DECIMAL (9, 6) CONSTRAINT [DF_QuoteFull_S_FC4UG04] DEFAULT ((0)) NOT NULL,
|
|
[VC4UG04] DECIMAL (9, 6) CONSTRAINT [DF_QuoteFull_S_VC4UG04] DEFAULT ((0)) NOT NULL,
|
|
[FVC] DECIMAL (18, 6) CONSTRAINT [DF_QuoteFull_S_FVC] DEFAULT ((0)) NOT NULL,
|
|
[Charge] DECIMAL (9, 6) CONSTRAINT [DF_QuoteFull_S_Charge] DEFAULT ((0)) NOT NULL,
|
|
[valid] BIT NOT NULL,
|
|
[errorScore] INT NOT NULL,
|
|
CONSTRAINT [PK_QuoteFull_S] PRIMARY KEY CLUSTERED ([QuoteType] ASC, [CodQuote] ASC, [QuoteRev] ASC)
|
|
);
|
|
|
|
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'scarto medio AMI', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'DSR';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'scarto medio SIMULAZIONE', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'DSR_sim';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'produttività teorica medio AMIL', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'NetProd01';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'produttività teorica SIMULAZIONE', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'NetProd01_sim';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'scarto cesoia medio AMIL', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'MSR01';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'scarto cesoia SIMULAZIONE', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'MSR01_sim';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'scarto tecnico medio AMIL', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'WSR01';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'scarto tecnico SIMULAZIONE', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'WSR01_sim';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Ricavo quota cliente', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'ExtraDiscountDies';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Ricavo quota cliente', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'ClientQuoteReven';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'oneri finanziari anticipo matrice', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'DiesFinCost';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'costi per durata commerciale', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'SalesPrevCost';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Durata commerciale in mesi prevista', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'MonthSalesPrev';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Durata commerciale in kg', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'DiesCommLife';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Durata tecnica stimata', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'DiesTecLife';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'costo prove', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'DiesFullCost';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'costo prove', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'SamplePrice';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'costo matrice per SIMULAZIONE', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'DiesPrice_sim';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Simulation', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'produttività teorica SIMULAZIONE', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'QuoteFull_S', @level2type = N'COLUMN', @level2name = N'NetProd04_sim';
|
|
|