Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
DWADW.DIM_JOURNALSOURCE_GL
Base de datos origen: ADW COEXITO
Descripción: Español: Catálogo de fuentes contables que identifica el origen de los asientos contables dentro del ERP. English: Accounting source catalog that identifies the origin of journal entries within the ERP.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | JOURNALSOURCE_GL_ID | NUMBER | NO | “DWADW”.”ISEQ$$_306870”.nextval | |
| 2 | SOURCE_NAME | VARCHAR2(2000) | SI | ||
| 3 | DESCRIPTION | VARCHAR2(2000) | SI | ||
| 4 | USER_SOURCE_NAME | VARCHAR2(2000) | SI | ||
| 5 | AUDIT_ID | NUMBER | NO | ||
| 6 | ROW_ACTIVE | CHAR(1) | NO | ‘A’ |
Restricciones
CHECK: DIM_JOURNALSOURCE_GL_AI_CK
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
row_active IN ('A','I')
CHECK: SYS_C00202819
- Estado: ENABLED
- Columnas: JOURNALSOURCE_GL_ID
- Condición:
"JOURNALSOURCE_GL_ID" IS NOT NULL
CHECK: SYS_C00202820
- Estado: ENABLED
- Columnas: AUDIT_ID
- Condición:
"AUDIT_ID" IS NOT NULL
CHECK: SYS_C00202821
- Estado: ENABLED
- Columnas: ROW_ACTIVE
- Condición:
"ROW_ACTIVE" IS NOT NULL
PK: DIM_JOURNALSOURCE_GL_PK
- Estado: ENABLED
- Columnas: JOURNALSOURCE_GL_ID
UK: DIM_JOURNALSOURCE_GL_NAME_UN
- Estado: ENABLED
- Columnas: SOURCE_NAME
DDL
CREATE TABLE "DWADW"."DIM_JOURNALSOURCE_GL"
( "JOURNALSOURCE_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,
"SOURCE_NAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"DESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"USER_SOURCE_NAME" VARCHAR2(2000) 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_JOURNALSOURCE_GL_AI_CK" CHECK (row_active IN ('A','I')) ENABLE,
CONSTRAINT "DIM_JOURNALSOURCE_GL_PK" PRIMARY KEY ("JOURNALSOURCE_GL_ID")
USING INDEX ENABLE,
CONSTRAINT "DIM_JOURNALSOURCE_GL_NAME_UN" UNIQUE ("SOURCE_NAME")
USING INDEX ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "DWADW"."DIM_JOURNALSOURCE_GL" IS 'Español: Catálogo de fuentes contables que identifica el origen de los asientos contables dentro del ERP.
English: Accounting source catalog that identifies the origin of journal entries within the ERP.';
CREATE UNIQUE INDEX "DWADW"."DIM_JOURNALSOURCE_GL_PK" ON "DWADW"."DIM_JOURNALSOURCE_GL" ("JOURNALSOURCE_GL_ID")
;
CREATE UNIQUE INDEX "DWADW"."DIM_JOURNALSOURCE_GL_NAME_UN" ON "DWADW"."DIM_JOURNALSOURCE_GL" ("SOURCE_NAME")
;