Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_ITEMS_PIM
Base de datos origen: ADW COEXITO
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | ITEMBASEPEOINVENTORYITEMID | NUMBER(38,0) | NO | ||
| 2 | ITEMBASEPEOORGANIZATIONID | NUMBER(38,0) | NO | ||
| 3 | ITEMTRANSLATIONPEOLANGUAGE | VARCHAR2(10) | SI | ||
| 4 | ITEMBASEPEOCREATIONDATE | DATE | NO | ||
| 5 | ITEMBASEPEOENABLEDFLAG | VARCHAR2(255) | NO | ||
| 6 | ITEMBASEPEOITEMNUMBER | VARCHAR2(255) | NO | ||
| 7 | ITEMBASEPEOPRIMARYUOMCODE | VARCHAR2(10) | SI | ||
| 8 | ITEMBASEPEOUNITOFISSUE | FLOAT | SI | ||
| 9 | ITEMBASEPEOUNITVOLUME | FLOAT | NO | ||
| 10 | ITEMBASEPEOUNITWEIGHT | FLOAT | NO | ||
| 11 | ITEMBASEPEOVOLUMEUOMCODE | VARCHAR2(255) | SI | ||
| 12 | ITEMBASEPEOWEIGHTUOMCODE | VARCHAR2(255) | SI | ||
| 13 | ITEMBASEPEOTRANSLATIONCREATIONDATE | DATE | NO | ||
| 14 | ITEMBASEPEOTRANSLATIONDESCRIPTION | VARCHAR2(2000) | SI | ||
| 15 | ITEMBASEPEOLASTUPDATEDATE | DATE | SI | ||
| 16 | IDMAESTROCARGUE | NUMBER(18,0) | NO |
Restricciones
CHECK: SYS_C00186370
- Estado: ENABLED
- Columnas: ITEMBASEPEOINVENTORYITEMID
- Condición:
"ITEMBASEPEOINVENTORYITEMID" IS NOT NULL
CHECK: SYS_C00186371
- Estado: ENABLED
- Columnas: ITEMBASEPEOORGANIZATIONID
- Condición:
"ITEMBASEPEOORGANIZATIONID" IS NOT NULL
CHECK: SYS_C00186373
- Estado: ENABLED
- Columnas: ITEMBASEPEOCREATIONDATE
- Condición:
"ITEMBASEPEOCREATIONDATE" IS NOT NULL
CHECK: SYS_C00186374
- Estado: ENABLED
- Columnas: ITEMBASEPEOENABLEDFLAG
- Condición:
"ITEMBASEPEOENABLEDFLAG" IS NOT NULL
CHECK: SYS_C00186375
- Estado: ENABLED
- Columnas: ITEMBASEPEOITEMNUMBER
- Condición:
"ITEMBASEPEOITEMNUMBER" IS NOT NULL
CHECK: SYS_C00186376
- Estado: ENABLED
- Columnas: ITEMBASEPEOUNITVOLUME
- Condición:
"ITEMBASEPEOUNITVOLUME" IS NOT NULL
CHECK: SYS_C00186377
- Estado: ENABLED
- Columnas: ITEMBASEPEOUNITWEIGHT
- Condición:
"ITEMBASEPEOUNITWEIGHT" IS NOT NULL
CHECK: SYS_C00186378
- Estado: ENABLED
- Columnas: ITEMBASEPEOTRANSLATIONCREATIONDATE
- Condición:
"ITEMBASEPEOTRANSLATIONCREATIONDATE" IS NOT NULL
CHECK: SYS_C00191249
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_ITEMS_PIM"
( "ITEMBASEPEOINVENTORYITEMID" NUMBER(38,0) NOT NULL ENABLE,
"ITEMBASEPEOORGANIZATIONID" NUMBER(38,0) NOT NULL ENABLE,
"ITEMTRANSLATIONPEOLANGUAGE" VARCHAR2(10) COLLATE "USING_NLS_COMP",
"ITEMBASEPEOCREATIONDATE" DATE NOT NULL ENABLE,
"ITEMBASEPEOENABLEDFLAG" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"ITEMBASEPEOITEMNUMBER" VARCHAR2(255) COLLATE "USING_NLS_COMP" NOT NULL ENABLE,
"ITEMBASEPEOPRIMARYUOMCODE" VARCHAR2(10) COLLATE "USING_NLS_COMP",
"ITEMBASEPEOUNITOFISSUE" FLOAT(126),
"ITEMBASEPEOUNITVOLUME" FLOAT(126) NOT NULL ENABLE,
"ITEMBASEPEOUNITWEIGHT" FLOAT(126) NOT NULL ENABLE,
"ITEMBASEPEOVOLUMEUOMCODE" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"ITEMBASEPEOWEIGHTUOMCODE" VARCHAR2(255) COLLATE "USING_NLS_COMP",
"ITEMBASEPEOTRANSLATIONCREATIONDATE" DATE NOT NULL ENABLE,
"ITEMBASEPEOTRANSLATIONDESCRIPTION" VARCHAR2(2000) COLLATE "USING_NLS_COMP",
"ITEMBASEPEOLASTUPDATEDATE" DATE,
"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;