Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_FLEX_BI_JOURNALLINEDFF_GL
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | CREATIONDATE | DATE | SI | ||
| 2 | LCLS_C_THRTPRTY_N_ | VARCHAR2(2000) | SI | ||
| 3 | LASTUPDATEDATE | DATE | SI | ||
| 4 | S_K_5000 | NUMBER | SI | ||
| 5 | S_K_5001 | NUMBER | SI | ||
| 6 | IDMAESTROCARGUE | NUMBER(18,0) | NO |
Restricciones
CHECK: SYS_C00186419
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_FLEX_BI_JOURNALLINEDFF_GL"
( "CREATIONDATE" DATE,
"LCLS_C_THRTPRTY_N_" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"LASTUPDATEDATE" DATE,
"S_K_5000" NUMBER,
"S_K_5001" NUMBER,
"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
CREATE UNIQUE INDEX "STADW"."SYS_IL0000290419C00011$$" ON "STADW"."ST_FLEX_BI_JOURNALLINEDFF_GL"
;