Diccionario de Datos

Logo

Diccionario de datos de los modelos de COÉXITO

🏠 Menú principal ← Volver a tablas

DWADW.FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL

Base de datos origen: ADW COEXITO

Descripción: Español: Contiene información de distribuciones de líneas de presupuesto para cada importación, incluyendo presupuesto de control, cuenta presupuestal y período actualizado. | English: Contains budget line distribution information for each import, including control budget, budget account, and updated period.

Columnas

# Columna Tipo Nulo Default Comentario
1 XCC_BUDGET_DIST_ACCTS_BGC_GL_ID NUMBER NO “DWADW”.”ISEQ$$_337770”.nextval  
2 AMOUNT NUMBER SI    
3 BUDGETACTION VARCHAR2(30) NO    
4 BUDGETCCID NUMBER(18,0) NO    
5 CONTROLBUDGETID NUMBER(18,0) NO    
6 CREATEDBY VARCHAR2(64) SI    
7 CREATIONDATE TIMESTAMP(6) SI    
8 DATASETID NUMBER(18,0) SI    
9 FUNDSRELEASEDDATE TIMESTAMP(6) SI    
10 HEADERID NUMBER(18,0) NO    
11 LASTUPDATEDATE TIMESTAMP(6) SI    
12 LASTUPDATELOGIN VARCHAR2(32) SI    
13 LASTUPDATEDBY VARCHAR2(64) SI    
14 LINENUMBER NUMBER(18,0) NO    
15 MASTERPERIODNAME VARCHAR2(15) NO    
16 OBJECTVERSIONNUMBER NUMBER(9,0) SI    
17 ORIGINALAMOUNT NUMBER SI    
18 PERIODNAME VARCHAR2(15) NO    
19 PROCESSEDFORESSBASEFLAG VARCHAR2(1) SI    
20 AUDIT_ID NUMBER NO    
21 ROW_ACTIVE CHAR(1) NO ‘A’  
22 DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID NUMBER NO    
23 DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_ID NUMBER NO    

Restricciones

CHECK: FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_AI_CK

CHECK: SYS_C00242224

CHECK: SYS_C00242225

CHECK: SYS_C00242226

CHECK: SYS_C00242227

CHECK: SYS_C00242228

CHECK: SYS_C00242229

CHECK: SYS_C00242230

CHECK: SYS_C00242231

CHECK: SYS_C00242232

CHECK: SYS_C00242233

CHECK: SYS_C00242234

CHECK: SYS_C00242235

PK: FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_PK

FK: FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_FK

FK: FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_FK

UK: FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL__UN

DDL

CREATE TABLE "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL" 
   (	"XCC_BUDGET_DIST_ACCTS_BGC_GL_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"AMOUNT" NUMBER, 
	"BUDGETACTION" VARCHAR2(30) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"BUDGETCCID" NUMBER(18,0) NOT NULL ENABLE, 
	"CONTROLBUDGETID" NUMBER(18,0) NOT NULL ENABLE, 
	"CREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"CREATIONDATE" TIMESTAMP (6), 
	"DATASETID" NUMBER(18,0), 
	"FUNDSRELEASEDDATE" TIMESTAMP (6), 
	"HEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"LASTUPDATEDATE" TIMESTAMP (6), 
	"LASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP", 
	"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"LINENUMBER" NUMBER(18,0) NOT NULL ENABLE, 
	"MASTERPERIODNAME" VARCHAR2(15) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"OBJECTVERSIONNUMBER" NUMBER(9,0), 
	"ORIGINALAMOUNT" NUMBER, 
	"PERIODNAME" VARCHAR2(15) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"PROCESSEDFORESSBASEFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID" NUMBER NOT NULL ENABLE, 
	"DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_ID" NUMBER NOT NULL ENABLE, 
	 CONSTRAINT "FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_PK" PRIMARY KEY ("XCC_BUDGET_DIST_ACCTS_BGC_GL_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL__UN" UNIQUE ("BUDGETACTION", "BUDGETCCID", "CONTROLBUDGETID", "HEADERID", "LINENUMBER", "MASTERPERIODNAME", "PERIODNAME")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_FK" FOREIGN KEY ("DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID")
	  REFERENCES "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_BGC_GL" ("XCC_BUDGET_ACCOUNTS_BGC_GL_ID") ENABLE, 
	 CONSTRAINT "FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_FK" FOREIGN KEY ("DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_ID")
	  REFERENCES "DWADW"."DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL" ("XCC_BUDGET_DIST_HEADERS_BGC_GL_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL"  IS 'Español: Contiene información de distribuciones de líneas de presupuesto para cada importación, incluyendo presupuesto de control, cuenta presupuestal y período actualizado. | English: Contains budget line distribution information for each import, including control budget, budget account, and updated period.';

CREATE INDEX "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_UPD_IDX" ON "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL" ("LASTUPDATEDATE") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL_PK" ON "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL" ("XCC_BUDGET_DIST_ACCTS_BGC_GL_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL__UN" ON "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL" ("BUDGETACTION", "BUDGETCCID", "CONTROLBUDGETID", "HEADERID", "LINENUMBER", "MASTERPERIODNAME", "PERIODNAME") 
  ;
  CREATE INDEX "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_FK1_IDX" ON "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL" ("DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID") 
  ;
  CREATE INDEX "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_FK2_IDX" ON "DWADW"."FACT_XCC_BUDGET_DIST_ACCTS_BGC_GL" ("DIM_XCC_BUDGET_DIST_HEADERS_BGC_GL_ID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal