Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_FULFILLLINESTATUS_OM_HIST
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | IDMAESTROCARGUE | NUMBER(18,0) | NO | ||
| 2 | FULFILLLINESTATUSCREATEDBY | VARCHAR2(64) | NO | ||
| 3 | FULFILLLINESTATUSCREATIONDATE | DATE | NO | ||
| 4 | FULFILLLINESTATUSLASTUPDATEDATE | DATE | NO | ||
| 5 | FULFILLLINESTATUSLASTUPDATEDBY | VARCHAR2(64) | NO | ||
| 6 | FULFILLLINESTATUSSTATUSCODE | VARCHAR2(30) | NO | ||
| 7 | LINESTATUSID | NUMBER(18,0) | NO | ||
| 8 | STATUSTRANSLATIONCREATEDBY | VARCHAR2(64) | NO | ||
| 9 | STATUSTRANSLATIONCREATIONDATE | DATE | NO | ||
| 10 | STATUSTRANSLATIONDISPLAYNAME | VARCHAR2(240) | NO | ||
| 11 | STATUSTRANSLATIONLANGUAGE | VARCHAR2(4) | NO | ||
| 12 | STATUSTRANSLATIONLASTUPDATEDBY | VARCHAR2(64) | NO | ||
| 13 | STATUSTRANSLATIONSOURCELANG | VARCHAR2(4) | NO |
Restricciones
CHECK: SYS_C00262450
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
CHECK: SYS_C00262451
- Estado: ENABLED
- Columnas: FULFILLLINESTATUSCREATEDBY
- Condición:
"FULFILLLINESTATUSCREATEDBY" IS NOT NULL
CHECK: SYS_C00262452
- Estado: ENABLED
- Columnas: FULFILLLINESTATUSCREATIONDATE
- Condición:
"FULFILLLINESTATUSCREATIONDATE" IS NOT NULL
CHECK: SYS_C00262453
- Estado: ENABLED
- Columnas: FULFILLLINESTATUSLASTUPDATEDATE
- Condición:
"FULFILLLINESTATUSLASTUPDATEDATE" IS NOT NULL
CHECK: SYS_C00262454
- Estado: ENABLED
- Columnas: FULFILLLINESTATUSLASTUPDATEDBY
- Condición:
"FULFILLLINESTATUSLASTUPDATEDBY" IS NOT NULL
CHECK: SYS_C00262455
- Estado: ENABLED
- Columnas: FULFILLLINESTATUSSTATUSCODE
- Condición:
"FULFILLLINESTATUSSTATUSCODE" IS NOT NULL
CHECK: SYS_C00262456
- Estado: ENABLED
- Columnas: LINESTATUSID
- Condición:
"LINESTATUSID" IS NOT NULL
CHECK: SYS_C00262457
- Estado: ENABLED
- Columnas: STATUSTRANSLATIONCREATEDBY
- Condición:
"STATUSTRANSLATIONCREATEDBY" IS NOT NULL
CHECK: SYS_C00262458
- Estado: ENABLED
- Columnas: STATUSTRANSLATIONCREATIONDATE
- Condición:
"STATUSTRANSLATIONCREATIONDATE" IS NOT NULL
CHECK: SYS_C00262459
- Estado: ENABLED
- Columnas: STATUSTRANSLATIONDISPLAYNAME
- Condición:
"STATUSTRANSLATIONDISPLAYNAME" IS NOT NULL
CHECK: SYS_C00262460
- Estado: ENABLED
- Columnas: STATUSTRANSLATIONLANGUAGE
- Condición:
"STATUSTRANSLATIONLANGUAGE" IS NOT NULL
CHECK: SYS_C00262461
- Estado: ENABLED
- Columnas: STATUSTRANSLATIONLASTUPDATEDBY
- Condición:
"STATUSTRANSLATIONLASTUPDATEDBY" IS NOT NULL
CHECK: SYS_C00262462
- Estado: ENABLED
- Columnas: STATUSTRANSLATIONSOURCELANG
- Condición:
"STATUSTRANSLATIONSOURCELANG" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_FULFILLLINESTATUS_OM_HIST"
( "IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE,
"FULFILLLINESTATUSCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"FULFILLLINESTATUSCREATIONDATE" DATE NOT NULL ENABLE,
"FULFILLLINESTATUSLASTUPDATEDATE" DATE NOT NULL ENABLE,
"FULFILLLINESTATUSLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"FULFILLLINESTATUSSTATUSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"LINESTATUSID" NUMBER(18,0) NOT NULL ENABLE,
"STATUSTRANSLATIONCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"STATUSTRANSLATIONCREATIONDATE" DATE NOT NULL ENABLE,
"STATUSTRANSLATIONDISPLAYNAME" VARCHAR2(240) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"STATUSTRANSLATIONLANGUAGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"STATUSTRANSLATIONLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"STATUSTRANSLATIONSOURCELANG" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;