24 lines
798 B
Transact-SQL
24 lines
798 B
Transact-SQL
CREATE TABLE [test].[PL_S80Alternativa] (
|
|
[ProcedureName] varchar(33) NOT NULL,
|
|
[i_rete] char(1) NULL,
|
|
[i_codiceFiscale] varchar(16) NULL,
|
|
[RETE] varchar(1) NOT NULL,
|
|
[Cod_Fiscale] varchar(16) NOT NULL,
|
|
[Fase] int NOT NULL,
|
|
[DataFase] datetime NOT NULL,
|
|
[Partita_viaggiante] decimal(15,2) NOT NULL,
|
|
[CTV_EXT] decimal(15,3) NOT NULL,
|
|
[CTV_INV] decimal(15,3) NOT NULL,
|
|
[CTV_PRE] decimal(15,3) NOT NULL,
|
|
[CTV_RIS] decimal(15,3) NOT NULL,
|
|
[CTV_LIQ] decimal(15,3) NOT NULL,
|
|
[RisorseAllocate] decimal(19,3) NULL,
|
|
[RisorseNonAllocate] decimal(15,3) NOT NULL,
|
|
[RisorseFinanziarie] decimal(20,3) NULL,
|
|
[Contocorrente] decimal(15,3) NOT NULL,
|
|
[ctvself] decimal(18,3) NOT NULL,
|
|
[TotalePatrimonio] decimal(23,3) NULL,
|
|
[DettMov] varchar(50) NULL,
|
|
[NumeroAsterischiNota] int NOT NULL
|
|
)
|
|
GO |