Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DIM_XCC_BUDGET_ACCOUNTS_BGC_GL
Base de datos origen: ADW COEXITO
Descripción: Español: Contiene todas las combinaciones de cuentas del presupuesto de control y los valores de segmentos definidos en su estructura. | English: Contains all control budget account combinations and the segment values defined in the control budget structure.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | XCC_BUDGET_ACCOUNTS_BGC_GL_ID | NUMBER | NO | “DWADW”.”ISEQ$$_337757”.nextval | |
| 2 | BUDGETCHARTOFACCOUNTSID | NUMBER(18,0) | SI | ||
| 3 | BUDGETCODECOMBINATIONID | NUMBER(18,0) | NO | ||
| 4 | CREATEDBY | VARCHAR2(64) | SI | ||
| 5 | CREATIONDATE | TIMESTAMP(6) | SI | ||
| 6 | LASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 7 | LASTUPDATELOGIN | VARCHAR2(32) | SI | ||
| 8 | LASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 9 | OBJECTVERSIONNUMBER | NUMBER(9,0) | SI | ||
| 10 | SEGMENTVALUE1 | VARCHAR2(50) | SI | ||
| 11 | SEGMENTVALUE2 | VARCHAR2(50) | SI | ||
| 12 | SEGMENTVALUE3 | VARCHAR2(50) | SI | ||
| 13 | SEGMENTVALUE4 | VARCHAR2(50) | SI | ||
| 14 | SEGMENTVALUE5 | VARCHAR2(50) | SI | ||
| 15 | SEGMENTVALUE6 | VARCHAR2(50) | SI | ||
| 16 | SEGMENTVALUE7 | VARCHAR2(50) | SI | ||
| 17 | SEGMENTVALUE8 | VARCHAR2(50) | SI | ||
| 18 | SEGMENTVALUE9 | VARCHAR2(50) | SI | ||
| 19 | SEGMENTVALUE10 | VARCHAR2(50) | SI | ||
| 20 | SEGMENTVALUE11 | VARCHAR2(50) | SI | ||
| 21 | SEGMENTVALUE12 | VARCHAR2(50) | SI | ||
| 22 | SEGMENTVALUE13 | VARCHAR2(50) | SI | ||
| 23 | SEGMENTVALUE14 | VARCHAR2(50) | SI | ||
| 24 | SEGMENTVALUE15 | VARCHAR2(50) | SI | ||
| 25 | SEGMENTVALUE16 | VARCHAR2(50) | SI | ||
| 26 | SEGMENTVALUE17 | VARCHAR2(50) | SI | ||
| 27 | SEGMENTVALUE18 | VARCHAR2(50) | SI | ||
| 28 | SEGMENTVALUE19 | VARCHAR2(50) | SI | ||
| 29 | SEGMENTVALUE20 | VARCHAR2(50) | SI | ||
| 30 | SEGMENTVALUE21 | VARCHAR2(50) | SI | ||
| 31 | SEGMENTVALUE22 | VARCHAR2(50) | SI | ||
| 32 | SEGMENTVALUE23 | VARCHAR2(50) | SI | ||
| 33 | SEGMENTVALUE24 | VARCHAR2(50) | SI | ||
| 34 | SEGMENTVALUE25 | VARCHAR2(50) | SI | ||
| 35 | SEGMENTVALUE26 | VARCHAR2(50) | SI | ||
| 36 | SEGMENTVALUE27 | VARCHAR2(50) | SI | ||
| 37 | SEGMENTVALUE28 | VARCHAR2(50) | SI | ||
| 38 | SEGMENTVALUE29 | VARCHAR2(50) | SI | ||
| 39 | SEGMENTVALUE30 | VARCHAR2(50) | SI | ||
| 40 | SUMMARYFLAG | VARCHAR2(1) | SI | ||
| 41 | ENABLEDFLAG | VARCHAR2(1) | SI | ||
| 42 | AUDIT_ID | NUMBER | NO | ||
| 43 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ |
Restricciones
CHECK: DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_AI_CK
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
row_active IN ('A','I')
CHECK: SYS_C00242200
- Estado: ENABLED
- Columnas: XCC_BUDGET_ACCOUNTS_BGC_GL_ID
- Condición:
"XCC_BUDGET_ACCOUNTS_BGC_GL_ID" IS NOT NULL
CHECK: SYS_C00242201
- Estado: ENABLED
- Columnas: BUDGETCODECOMBINATIONID
- Condición:
"BUDGETCODECOMBINATIONID" IS NOT NULL
CHECK: SYS_C00242202
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C00242203
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
PK: DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_PK
- Estado: ENABLED
- Columnas: XCC_BUDGET_ACCOUNTS_BGC_GL_ID
UK: DIM_XCC_BUDGET_ACCOUNTS_BGC_GL__UN
- Estado: ENABLED
- Columnas: BUDGETCODECOMBINATIONID
DDL
CREATE TABLE "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_BGC_GL"
( "XCC_BUDGET_ACCOUNTS_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,
"BUDGETCHARTOFACCOUNTSID" NUMBER(18,0),
"BUDGETCODECOMBINATIONID" NUMBER(18,0) NOT NULL ENABLE,
"CREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"CREATIONDATE" TIMESTAMP (6),
"LASTUPDATEDATE" TIMESTAMP (6),
"LASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP",
"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"OBJECTVERSIONNUMBER" NUMBER(9,0),
"SEGMENTVALUE1" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE2" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE3" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE4" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE5" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE6" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE7" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE8" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE9" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE10" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE11" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE12" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE13" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE14" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE15" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE16" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE17" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE18" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE19" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE20" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE21" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE22" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE23" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE24" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE25" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE26" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE27" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE28" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE29" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SEGMENTVALUE30" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"SUMMARYFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"ENABLEDFLAG" 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,
CONSTRAINT "DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE,
CONSTRAINT "DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_PK" PRIMARY KEY ("XCC_BUDGET_ACCOUNTS_BGC_GL_ID")
USING INDEX ENABLE,
CONSTRAINT "DIM_XCC_BUDGET_ACCOUNTS_BGC_GL__UN" UNIQUE ("BUDGETCODECOMBINATIONID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_BGC_GL" IS 'Español: Contiene todas las combinaciones de cuentas del presupuesto de control y los valores de segmentos definidos en su estructura. | English: Contains all control budget account combinations and the segment values defined in the control budget structure.';
CREATE UNIQUE INDEX "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_BGC_GL_PK" ON "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_BGC_GL" ("XCC_BUDGET_ACCOUNTS_BGC_GL_ID")
;
CREATE UNIQUE INDEX "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_BGC_GL__UN" ON "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_BGC_GL" ("BUDGETCODECOMBINATIONID")
;
CREATE INDEX "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_UPD_IDX" ON "DWADW"."DIM_XCC_BUDGET_ACCOUNTS_BGC_GL" ("LASTUPDATEDATE")
;