Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_XCC_BUDGET_DIST_ACCTS_BGC_GL_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | AMOUNT | NUMBER | SI | ||
| 2 | BUDGETACTION | VARCHAR2(30) | NO | ||
| 3 | BUDGETCCID | NUMBER(18,0) | NO | ||
| 4 | CONTROLBUDGETID | NUMBER(18,0) | NO | ||
| 5 | CREATEDBY | VARCHAR2(64) | SI | ||
| 6 | CREATIONDATE | TIMESTAMP(6) | SI | ||
| 7 | DATASETID | NUMBER(18,0) | SI | ||
| 8 | FUNDSRELEASEDDATE | TIMESTAMP(6) | SI | ||
| 9 | HEADERID | NUMBER(18,0) | NO | ||
| 10 | LASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 11 | LASTUPDATELOGIN | VARCHAR2(32) | SI | ||
| 12 | LASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 13 | LINENUMBER | NUMBER(18,0) | NO | ||
| 14 | MASTERPERIODNAME | VARCHAR2(15) | NO | ||
| 15 | OBJECTVERSIONNUMBER | NUMBER(9,0) | SI | ||
| 16 | ORIGINALAMOUNT | NUMBER | SI | ||
| 17 | PERIODNAME | VARCHAR2(15) | NO | ||
| 18 | PROCESSEDFORESSBASEFLAG | VARCHAR2(1) | SI | ||
| 19 | IDMAESTROCARGUE | NUMBER | NO |
Restricciones
CHECK: SYS_C00237962
- Estado: ENABLED
- Columnas: BUDGETACTION
- Condición:
"BUDGETACTION" IS NOT NULL
CHECK: SYS_C00237963
- Estado: ENABLED
- Columnas: BUDGETCCID
- Condición:
"BUDGETCCID" IS NOT NULL
CHECK: SYS_C00237964
- Estado: ENABLED
- Columnas: CONTROLBUDGETID
- Condición:
"CONTROLBUDGETID" IS NOT NULL
CHECK: SYS_C00237965
- Estado: ENABLED
- Columnas: HEADERID
- Condición:
"HEADERID" IS NOT NULL
CHECK: SYS_C00237966
- Estado: ENABLED
- Columnas: LINENUMBER
- Condición:
"LINENUMBER" IS NOT NULL
CHECK: SYS_C00237967
- Estado: ENABLED
- Columnas: MASTERPERIODNAME
- Condición:
"MASTERPERIODNAME" IS NOT NULL
CHECK: SYS_C00237968
- Estado: ENABLED
- Columnas: PERIODNAME
- Condición:
"PERIODNAME" IS NOT NULL
CHECK: SYS_C00237969
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_XCC_BUDGET_DIST_ACCTS_BGC_GL_HIST"
( "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",
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;