🏠 Menú principal

← Volver a tablas

---

DWADW.FACT_XCC_BALANCES_BGC_GL

Base de datos origen: ADW COEXITO

Descripción: Español: Contiene saldos de presupuesto y consumo para cada combinación de presupuesto de control, cuenta presupuestal y período presupuestal. | English: Contains budget and consumption balances for each control budget, budget account, and budget period combination.

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	XCC_BALANCES_BGC_GL_ID	NUMBER	NO	“DWADW”.”ISEQ$$_337766”.nextval
2	CONTROLBUDGETID	NUMBER(18,0)	NO
3	BUDGETCCID	NUMBER(18,0)	NO
4	PERIODNAME	VARCHAR2(15)	NO
5	BUDGETAMOUNT	NUMBER	SI
6	BUDGETADJUSTMENTAMOUNT	NUMBER	SI
7	UNRELEASEDBUDGETAMOUNT	NUMBER	SI
8	COMMITMENTAMOUNT	NUMBER	SI
9	OBLIGATIONAMOUNT	NUMBER	SI
10	ACTUALAMOUNT	NUMBER	SI
11	OTHERAMOUNT	NUMBER	SI
12	FUNDSAVAILABLEAMOUNT	NUMBER	SI
13	APPROVEDCOMMITMENTAMOUNT	NUMBER	SI
14	APPROVEDAUTHORIZATIONAMOUNT	NUMBER	SI
15	APPROVEDOBLIGATIONAMOUNT	NUMBER	SI
16	ACCOUNTEDPAYABLESAMOUNT	NUMBER	SI
17	ACCOUNTEDRECEIPTSAMOUNT	NUMBER	SI
18	ACCOUNTEDPROJECTAMOUNT	NUMBER	SI
19	DETAILOTHERAMOUNT	NUMBER	SI
20	MISCEXPENDITURESAMOUNT	NUMBER	SI
21	CREATEDBY	VARCHAR2(64)	SI
22	CREATIONDATE	TIMESTAMP(6)	SI
23	LASTUPDATEDBY	VARCHAR2(64)	SI
24	LASTUPDATEDATE	TIMESTAMP(6)	SI
25	LASTUPDATELOGIN	VARCHAR2(32)	SI
26	AUDIT_ID	NUMBER	NO
27	ROW_ACTIVE	CHAR(1)	NO	‘A’
28	DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID	NUMBER	NO

Restricciones

CHECK: FACT_XCC_BALANCES_BGC_GL_AI_CK

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: row_active IN ('A','I')

CHECK: SYS_C00242214

• Estado: ENABLED
• Columnas: XCC_BALANCES_BGC_GL_ID
• Condición: "XCC_BALANCES_BGC_GL_ID" IS NOT NULL

CHECK: SYS_C00242215

• Estado: ENABLED
• Columnas: CONTROLBUDGETID
• Condición: "CONTROLBUDGETID" IS NOT NULL

CHECK: SYS_C00242216

• Estado: ENABLED
• Columnas: BUDGETCCID
• Condición: "BUDGETCCID" IS NOT NULL

CHECK: SYS_C00242217

• Estado: ENABLED
• Columnas: PERIODNAME
• Condición: "PERIODNAME" IS NOT NULL

CHECK: SYS_C00242218

• Estado: ENABLED
• Columnas: AUDIT_ID
• Condición: "AUDIT_ID" IS NOT NULL

CHECK: SYS_C00242219

• Estado: ENABLED
• Columnas: ROW_ACTIVE
• Condición: "ROW_ACTIVE" IS NOT NULL

CHECK: SYS_C00242220

• Estado: ENABLED
• Columnas: DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID
• Condición: "DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID" IS NOT NULL

PK: FACT_XCC_BALANCES_BGC_GL_PK

• Estado: ENABLED
• Columnas: XCC_BALANCES_BGC_GL_ID

FK: FACT_XCC_BALANCES_BGC_GL_DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_FK

• Estado: ENABLED
• Columnas: DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID
• Referencia: DWADW.DIM_XCC_BUDGET_ACCOUNTS_BGC_GL (constraint DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_PK)

UK: FACT_XCC_BALANCES_BGC_GL__UN

• Estado: ENABLED
• Columnas: CONTROLBUDGETID, BUDGETCCID, PERIODNAME

DDL

CREATE TABLE "DWADW"."FACT_XCC_BALANCES_BGC_GL" 
   (	"XCC_BALANCES_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, 
	"CONTROLBUDGETID" NUMBER(18,0) NOT NULL ENABLE, 
	"BUDGETCCID" NUMBER(18,0) NOT NULL ENABLE, 
	"PERIODNAME" VARCHAR2(15) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"BUDGETAMOUNT" NUMBER, 
	"BUDGETADJUSTMENTAMOUNT" NUMBER, 
	"UNRELEASEDBUDGETAMOUNT" NUMBER, 
	"COMMITMENTAMOUNT" NUMBER, 
	"OBLIGATIONAMOUNT" NUMBER, 
	"ACTUALAMOUNT" NUMBER, 
	"OTHERAMOUNT" NUMBER, 
	"FUNDSAVAILABLEAMOUNT" NUMBER, 
	"APPROVEDCOMMITMENTAMOUNT" NUMBER, 
	"APPROVEDAUTHORIZATIONAMOUNT" NUMBER, 
	"APPROVEDOBLIGATIONAMOUNT" NUMBER, 
	"ACCOUNTEDPAYABLESAMOUNT" NUMBER, 
	"ACCOUNTEDRECEIPTSAMOUNT" NUMBER, 
	"ACCOUNTEDPROJECTAMOUNT" NUMBER, 
	"DETAILOTHERAMOUNT" NUMBER, 
	"MISCEXPENDITURESAMOUNT" NUMBER, 
	"CREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"CREATIONDATE" TIMESTAMP (6), 
	"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"LASTUPDATEDATE" TIMESTAMP (6), 
	"LASTUPDATELOGIN" VARCHAR2(32) 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, 
	 CONSTRAINT "FACT_XCC_BALANCES_BGC_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_XCC_BALANCES_BGC_GL_PK" PRIMARY KEY ("XCC_BALANCES_BGC_GL_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_XCC_BALANCES_BGC_GL__UN" UNIQUE ("CONTROLBUDGETID", "BUDGETCCID", "PERIODNAME")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_XCC_BALANCES_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
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_XCC_BALANCES_BGC_GL"  IS 'Español: Contiene saldos de presupuesto y consumo para cada combinación de presupuesto de control, cuenta presupuestal y período presupuestal. | English: Contains budget and consumption balances for each control budget, budget account, and budget period combination.';

CREATE UNIQUE INDEX "DWADW"."FACT_XCC_BALANCES_BGC_GL_PK" ON "DWADW"."FACT_XCC_BALANCES_BGC_GL" ("XCC_BALANCES_BGC_GL_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_XCC_BALANCES_BGC_GL__UN" ON "DWADW"."FACT_XCC_BALANCES_BGC_GL" ("CONTROLBUDGETID", "BUDGETCCID", "PERIODNAME") 
  ;
  CREATE INDEX "DWADW"."FACT_XCC_BALANCES_BGC_GL_FK1_IDX" ON "DWADW"."FACT_XCC_BALANCES_BGC_GL" ("DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_ID") 
  ;

---

← Volver a tablas de DWADW

🏠 Volver al menú principal