Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_XCC_BALANCES_BGC_GL_HIST
Base de datos origen: ADW COEXITO
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_C00237569
- Estado: ENABLED
- Columnas: CONTROLBUDGETID
- Condición:
"CONTROLBUDGETID" IS NOT NULL
CHECK: SYS_C00237570
- Estado: ENABLED
- Columnas: BUDGETCCID
- Condición:
"BUDGETCCID" IS NOT NULL
CHECK: SYS_C00237571
- Estado: ENABLED
- Columnas: PERIODNAME
- Condición:
"PERIODNAME" IS NOT NULL
CHECK: SYS_C00237572
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_XCC_BALANCES_BGC_GL_HIST"
( "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" ;