Samuele E. Locatelli
54 lines
3.3 KiB
Transact-SQL
54 lines
3.3 KiB
Transact-SQL
CREATE TABLE [dbo].[RawMatDet] (
|
|
[RawMat] NVARCHAR (50) NOT NULL,
|
|
[ProcCost] DECIMAL (18, 6) CONSTRAINT [DF_RawMatDet_ProcCost] DEFAULT ((0)) NOT NULL,
|
|
[ProcYield] DECIMAL (9, 6) CONSTRAINT [DF_RawMatDet_ProcYield] DEFAULT ((0)) NOT NULL,
|
|
[CSR] DECIMAL (9, 6) CONSTRAINT [DF_RawMatDet_CSR] DEFAULT ((0)) NOT NULL,
|
|
[SSR] DECIMAL (9, 6) CONSTRAINT [DF_RawMatDet_SSR] DEFAULT ((0)) NULL,
|
|
[SSVA] DECIMAL (9, 6) CONSTRAINT [DF_RawMatDet_SSVA] DEFAULT ((0)) NULL,
|
|
[SSVR] DECIMAL (9, 6) CONSTRAINT [DF_RawMatDet_SSVR] DEFAULT ((0)) NULL,
|
|
[ExtraMatCost] DECIMAL (9, 6) CONSTRAINT [DF_RawMatDet_ExtraMatCost] DEFAULT ((0)) NULL,
|
|
[ExtraServCost] DECIMAL (9, 6) CONSTRAINT [DF_RawMatDet_ExtraServCost] DEFAULT ((0)) NULL,
|
|
CONSTRAINT [PK_RawMatDet] PRIMARY KEY CLUSTERED ([RawMat] ASC)
|
|
);
|
|
|
|
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'codice MP', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'RawMat';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'costo del processo di rifusione €/kg', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'ProcCost';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'resa del processo di rifusione %', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'ProcYield';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Cut Scrape Ratio, percentuale scarto cesoia', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'CSR';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Scrape Sell Ratio, percentuale di vendita dello scarto ( da 0 a 1)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'SSR';
|
|
|
|
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Scrape Sell Value - ABSOLUTE, valore di vendita dello scarto ASSOLUTO', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'SSVA';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Scrape Sell Value - RELATIVE come valore % del valore lega', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'SSVR';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Costo extra di acquisto del materiale', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'ExtraMatCost';
|
|
|
|
|
|
GO
|
|
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'Costo extra dei servizi sul materiale (es ultrasuoni)', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'RawMatDet', @level2type = N'COLUMN', @level2name = N'ExtraServCost';
|
|
|