PDC_REPORT_CreazioneDB/sql/Collaudo/tabelle/test_PL_S96RischiomercatoRischiocredito.sql
2025-06-10 15:29:00 +02:00

22 lines
687 B
Transact-SQL

CREATE TABLE [test].[PL_S96RischiomercatoRischiocredito] (
[ProcedureName] nvarchar(MAX) NOT NULL,
[i_rete] varchar(1) NOT NULL,
[i_codiceFiscale] varchar(16) NOT NULL,
[RETE] varchar(1) NOT NULL,
[COD_FISCALE] varchar(16) NOT NULL,
[INSTITUTENAME] nvarchar(MAX) NOT NULL,
[CTV] decimal(38,3) NULL,
[CODICEPROFILO] int NULL,
[VARMAX] decimal(5,2) NULL,
[VAR] decimal(12,3) NULL,
[VARSTRING] nvarchar(MAX) NULL,
[RISKCLASS] int NULL,
[RISKCLASSSTRING] nvarchar(MAX) NULL,
[COVERAGE] decimal(12,3) NULL,
[COVERAGESTRING] nvarchar(MAX) NULL,
[RISKCLASSMAX] nvarchar(MAX) NULL,
[PERCENTAGE] decimal(38,6) NULL,
[ORDINE] int NOT NULL,
[Ully_perc] decimal(10,2) NULL
)
GO