Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_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 | CONTROLBUDGETID | NUMBER(18,0) | NO | ||
| 2 | BUDGETCCID | NUMBER(18,0) | NO | ||
| 3 | PERIODNAME | VARCHAR2(15) | NO | ||
| 4 | BUDGETAMOUNT | NUMBER | SI | ||
| 5 | BUDGETADJUSTMENTAMOUNT | NUMBER | SI | ||
| 6 | UNRELEASEDBUDGETAMOUNT | NUMBER | SI | ||
| 7 | COMMITMENTAMOUNT | NUMBER | SI | ||
| 8 | OBLIGATIONAMOUNT | NUMBER | SI | ||
| 9 | ACTUALAMOUNT | NUMBER | SI | ||
| 10 | OTHERAMOUNT | NUMBER | SI | ||
| 11 | FUNDSAVAILABLEAMOUNT | NUMBER | SI | ||
| 12 | APPROVEDCOMMITMENTAMOUNT | NUMBER | SI | ||
| 13 | APPROVEDAUTHORIZATIONAMOUNT | NUMBER | SI | ||
| 14 | APPROVEDOBLIGATIONAMOUNT | NUMBER | SI | ||
| 15 | ACCOUNTEDPAYABLESAMOUNT | NUMBER | SI | ||
| 16 | ACCOUNTEDRECEIPTSAMOUNT | NUMBER | SI | ||
| 17 | ACCOUNTEDPROJECTAMOUNT | NUMBER | SI | ||
| 18 | DETAILOTHERAMOUNT | NUMBER | SI | ||
| 19 | MISCEXPENDITURESAMOUNT | NUMBER | SI | ||
| 20 | CREATEDBY | VARCHAR2(64) | SI | ||
| 21 | CREATIONDATE | TIMESTAMP(6) | SI | ||
| 22 | LASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 23 | LASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 24 | LASTUPDATELOGIN | VARCHAR2(32) | SI | ||
| 25 | IDMAESTROCARGUE | NUMBER | NO |
Restricciones
CHECK: SYS_C00233654
- Estado: ENABLED
- Columnas: CONTROLBUDGETID
- Condición:
"CONTROLBUDGETID" IS NOT NULL
CHECK: SYS_C00233655
- Estado: ENABLED
- Columnas: BUDGETCCID
- Condición:
"BUDGETCCID" IS NOT NULL
CHECK: SYS_C00233656
- Estado: ENABLED
- Columnas: PERIODNAME
- Condición:
"PERIODNAME" IS NOT NULL
CHECK: SYS_C00233657
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_XCC_BALANCES_BGC_GL"
( "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",
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "STADW"."ST_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.';