• Home
• it.cnr.si.sigla
• sigla-backend
• 6.6.4
• source code
• TMP_STAMPA_RENDICONTO.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

expsigladb.temporary-table.TMP_STAMPA_RENDICONTO.sql Maven / Gradle / Ivy

  CREATE GLOBAL TEMPORARY TABLE "TMP_STAMPA_RENDICONTO" 
   (	"SEQUENZA" NUMBER NOT NULL ENABLE, 
	"TIPO" VARCHAR2(1 BYTE) NOT NULL ENABLE, 
	"TOTALE" VARCHAR2(1 BYTE) NOT NULL ENABLE, 
	"CD_LIVELLO1" VARCHAR2(5 BYTE), 
	"CD_LIVELLO2" VARCHAR2(5 BYTE), 
	"CD_LIVELLO3" VARCHAR2(5 BYTE), 
	"CD_LIVELLO4" VARCHAR2(5 BYTE), 
	"CD_LIVELLO5" VARCHAR2(5 BYTE), 
	"CD_LIVELLO6" VARCHAR2(5 BYTE), 
	"CD_LIVELLO7" VARCHAR2(5 BYTE), 
	"CD_LIVELLO8" VARCHAR2(5 BYTE), 
	"CD_LIVELLO9" VARCHAR2(5 BYTE), 
	"DS_LIVELLO1" VARCHAR2(300 BYTE), 
	"DS_LIVELLO2" VARCHAR2(300 BYTE), 
	"DS_LIVELLO3" VARCHAR2(300 BYTE), 
	"DS_LIVELLO4" VARCHAR2(300 BYTE), 
	"DS_LIVELLO5" VARCHAR2(300 BYTE), 
	"DS_LIVELLO6" VARCHAR2(300 BYTE), 
	"DS_LIVELLO7" VARCHAR2(300 BYTE), 
	"DS_LIVELLO8" VARCHAR2(300 BYTE), 
	"DS_LIVELLO9" VARCHAR2(300 BYTE), 
	"LIVELLO1_DS" VARCHAR2(20 BYTE), 
	"LIVELLO2_DS" VARCHAR2(20 BYTE), 
	"LIVELLO3_DS" VARCHAR2(20 BYTE), 
	"LIVELLO4_DS" VARCHAR2(20 BYTE), 
	"LIVELLO5_DS" VARCHAR2(20 BYTE), 
	"LIVELLO6_DS" VARCHAR2(20 BYTE), 
	"LIVELLO7_DS" VARCHAR2(20 BYTE), 
	"LIVELLO8_DS" VARCHAR2(20 BYTE), 
	"LIVELLO9_DS" VARCHAR2(20 BYTE), 
	"PREV_INI" NUMBER(17,2), 
	"VARIAZIONI" NUMBER(17,2), 
	"ASSESTATO" NUMBER(17,2), 
	"RIS_PAG" NUMBER(17,2), 
	"RIM_RIS_PAG" NUMBER(17,2), 
	"TOT_ACC_IMP" NUMBER(17,2), 
	"DIFF_COMP" NUMBER(17,2), 
	"RES_INI_ES" NUMBER(17,2), 
	"RES_RIS_PAG" NUMBER(17,2), 
	"RES_RIM_RIS_PAG" NUMBER(17,2), 
	"RES_TOTALI" NUMBER(17,2), 
	"RES_VAR_PIU" NUMBER(17,2), 
	"RES_VAR_MENO" NUMBER(17,2), 
	"CASSA_PREV" NUMBER(17,2), 
	"CASSA_RIS_PAG" NUMBER(17,2), 
	"CASSA_DIFF" NUMBER(17,2), 
	"TOT_RES_TER" NUMBER(17,2), 
	"RES_INI_ES_PREC" NUMBER(17,2), 
	"TOT_ACC_IMP_PREC" NUMBER(17,2), 
	"RIS_PAG_PREC" NUMBER(17,2), 
	"PREV_INI_ES_PREC" NUMBER(17,2), 
	"CASSA_PREV_ES_PREC" NUMBER(17,2), 
	 CONSTRAINT "PK_TMP_STAMPA_RENDICONTO" PRIMARY KEY ("SEQUENZA", "TIPO", "TOTALE") ENABLE
   ) ON COMMIT DELETE ROWS