Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_JOURNALSOURCE_GL_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | JESOURCENAME | VARCHAR2(2000) | SI | ||
| 2 | JRNLSRCTRANSLATEDDESCRIPTION | VARCHAR2(2000) | SI | ||
| 3 | JRNLSRCTRANSLATEDUSERJESOURCENAME | VARCHAR2(2000) | SI | ||
| 4 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 5 | JRNLSRCLASTUPDATEDATE | DATE | SI | ||
| 6 | JRNLSRCTRANSLATEDLANGUAGE | CHAR(2) | SI |
Restricciones
CHECK: SYS_C00214763
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_JOURNALSOURCE_GL_HIST"
( "JESOURCENAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"JRNLSRCTRANSLATEDDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"JRNLSRCTRANSLATEDUSERJESOURCENAME" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE,
"JRNLSRCLASTUPDATEDATE" DATE,
"JRNLSRCTRANSLATEDLANGUAGE" CHAR(2) COLLATE "USING_NLS_COMP"
) DEFAULT COLLATION "USING_NLS_COMP" ;