Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DIM_CODECOMBINATION_GL
Base de datos origen: ADW COEXITO
Descripción: Español: Catálogo de cuentas contables del libro mayor utilizado para relacionar transacciones financieras con su combinación contable y facilitar análisis financieros. Representa la cuenta contable completa, formada por segmentos. English: General Ledger account catalog used to link financial transactions with their accounting combinations and support financial analysis. It represents the complete general ledger, consisting of segments
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | CODECOMBINATION_GL_ID | NUMBER | NO | “DWADW”.”ISEQ$$_306851”.nextval | |
| 2 | CODE_COMBINATION_ID | NUMBER | NO | ||
| 3 | ENABLE_FLAG | VARCHAR2(2000) | SI | ||
| 4 | DESCRIPTION | VARCHAR2(2000) | SI | ||
| 5 | CREATION_DATE | DATE | SI | ||
| 6 | SEGMENT1 | VARCHAR2(2000) | SI | ||
| 7 | SEGMENT2 | VARCHAR2(2000) | SI | ||
| 8 | SEGMENT3 | VARCHAR2(2000) | SI | ||
| 9 | SEGMENT4 | VARCHAR2(2000) | SI | ||
| 10 | SEGMENT5 | VARCHAR2(2000) | SI | ||
| 11 | SEGMENT6 | VARCHAR2(2000) | SI | ||
| 12 | SEGMENT7 | VARCHAR2(2000) | SI | ||
| 13 | SEGMENT8 | VARCHAR2(2000) | SI | ||
| 14 | SEGMENT9 | VARCHAR2(2000) | SI | ||
| 15 | SEGMENT10 | VARCHAR2(2000) | SI | ||
| 16 | AUDIT_ID | NUMBER(18,0) | NO | ||
| 17 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ |
Restricciones
CHECK: DIM_CODECOMBINATION_GL_AI_CK
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
row_active IN ('A','I')
CHECK: SYS_C00202781
- Estado: ENABLED
- Columnas: CODECOMBINATION_GL_ID
- Condición:
"CODECOMBINATION_GL_ID" IS NOT NULL
CHECK: SYS_C00202782
- Estado: ENABLED
- Columnas: CODE_COMBINATION_ID
- Condición:
"CODE_COMBINATION_ID" IS NOT NULL
CHECK: SYS_C00202783
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C00202784
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
PK: DIM_CODECOMBINATION_GL_PK
- Estado: ENABLED
- Columnas: CODECOMBINATION_GL_ID
UK: DIM_CODECOMBINATION_COMBINATIONID_UN
- Estado: ENABLED
- Columnas: CODE_COMBINATION_ID
DDL
CREATE TABLE "DWADW"."DIM_CODECOMBINATION_GL"
( "CODECOMBINATION_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,
"CODE_COMBINATION_ID" NUMBER(*,0) NOT NULL ENABLE,
"ENABLE_FLAG" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"DESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"CREATION_DATE" DATE,
"SEGMENT1" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT2" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT3" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT4" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT5" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT6" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT7" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT8" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT9" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"SEGMENT10" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"AUDIT_ID" NUMBER(18,0) NOT NULL ENABLE,
"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE,
CONSTRAINT "DIM_CODECOMBINATION_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE,
CONSTRAINT "DIM_CODECOMBINATION_GL_PK" PRIMARY KEY ("CODECOMBINATION_GL_ID")
USING INDEX ENABLE,
CONSTRAINT "DIM_CODECOMBINATION_COMBINATIONID_UN" UNIQUE ("CODE_COMBINATION_ID")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."DIM_CODECOMBINATION_GL" IS 'Español: Catálogo de cuentas contables del libro mayor utilizado para relacionar transacciones financieras con su combinación contable y facilitar análisis financieros. Representa la cuenta contable completa, formada por segmentos.
English: General Ledger account catalog used to link financial transactions with their accounting combinations and support financial analysis. It represents the complete general ledger, consisting of segments';
CREATE INDEX "DWADW"."DIM_CODECOMBINATION_GL_DESCRIPCION_IDX" ON "DWADW"."DIM_CODECOMBINATION_GL" ("DESCRIPTION")
;
CREATE UNIQUE INDEX "DWADW"."DIM_CODECOMBINATION_GL_PK" ON "DWADW"."DIM_CODECOMBINATION_GL" ("CODECOMBINATION_GL_ID")
;
CREATE UNIQUE INDEX "DWADW"."DIM_CODECOMBINATION_COMBINATIONID_UN" ON "DWADW"."DIM_CODECOMBINATION_GL" ("CODE_COMBINATION_ID")
;