Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_LINEEXTRACT_OM
Base de datos origen: ADW COEXITO
Descripción: Español: Almacena el detalle de las líneas de órdenes, incluyendo artículos, cantidades, precios, estados y organizaciones asociadas. English: Stores order line details, including items, quantities, prices, statuses, and associated organizations.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | LINEID | NUMBER(18,0) | NO | ||
| 2 | LINEACTUALSHIPDATE | DATE | SI | ||
| 3 | LINECANCELEDFLAG | VARCHAR2(1) | SI | ||
| 4 | LINECANCELEDQTY | NUMBER | SI | ||
| 5 | LINECATEGORYCODE | VARCHAR2(30) | SI | ||
| 6 | LINECOMPSEQPATH | VARCHAR2(4000) | SI | ||
| 7 | LINECREATEDBY | VARCHAR2(64) | SI | ||
| 8 | LINECREATIONDATE | TIMESTAMP(6) | SI | ||
| 9 | LINEDELTATYPE | NUMBER(18,0) | SI | ||
| 10 | LINEEXTENDEDAMOUNT | NUMBER | SI | ||
| 11 | LINEFULFILLEDQTY | NUMBER | SI | ||
| 12 | LINEFULFILLMENTDATE | DATE | SI | ||
| 13 | LINEHEADERID | NUMBER(18,0) | SI | ||
| 14 | LINEINVENTORYITEMID | NUMBER(18,0) | SI | ||
| 15 | LINEINVENTORYORGANIZATIONID | NUMBER(18,0) | SI | ||
| 16 | LINEITEMTYPECODE | VARCHAR2(30) | SI | ||
| 17 | LINELASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 18 | LINELASTUPDATELOGIN | VARCHAR2(32) | SI | ||
| 19 | LINELASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 20 | LINELINENUMBER | NUMBER(9,0) | SI | ||
| 21 | LINELINETYPECODE | VARCHAR2(30) | SI | ||
| 22 | LINEOBJECTVERSIONNUMBER | NUMBER(9,0) | SI | ||
| 23 | LINEONHOLD | VARCHAR2(1) | SI | ||
| 24 | LINEOPENFLAG | VARCHAR2(1) | SI | ||
| 25 | LINEORDEREDQTY | NUMBER | SI | ||
| 26 | LINEORGID | NUMBER(18,0) | SI | ||
| 27 | LINEORDEREDUOM | VARCHAR2(3) | SI | ||
| 28 | LINEORIGSYSDOCUMENTLINEREF | VARCHAR2(50) | SI | ||
| 29 | LINEORIGSYSDOCUMENTREF | VARCHAR2(50) | SI | ||
| 30 | LINEOWNERID | NUMBER(18,0) | SI | ||
| 31 | LINEPARENTLINEID | NUMBER(18,0) | SI | ||
| 32 | LINEREFERENCELINEID | NUMBER(18,0) | SI | ||
| 33 | LINERMADELIVEREDQTY | NUMBER | SI | ||
| 34 | LINEROOTPARENTLINEID | NUMBER(18,0) | SI | ||
| 35 | LINESCHEDULESHIPDATE | DATE | SI | ||
| 36 | LINESHIPPEDQTY | NUMBER | SI | ||
| 37 | LINESOURCELINEID | VARCHAR2(50) | SI | ||
| 38 | LINESOURCELINENUMBER | VARCHAR2(50) | SI | ||
| 39 | LINESOURCEORDERID | VARCHAR2(50) | SI | ||
| 40 | LINESOURCEORDERNUMBER | VARCHAR2(50) | SI | ||
| 41 | LINESOURCEORDERSYSTEM | VARCHAR2(30) | SI | ||
| 42 | LINESOURCEORGID | NUMBER(18,0) | SI | ||
| 43 | LINESOURCESCHEDULEID | VARCHAR2(50) | SI | ||
| 44 | LINESOURCESCHEDULENUMBER | VARCHAR2(50) | SI | ||
| 45 | LINESTATUSCODE | VARCHAR2(30) | SI | ||
| 46 | LINETRANSFORMFROMLINEID | NUMBER(18,0) | SI | ||
| 47 | LINEUNITLISTPRICE | NUMBER | SI | ||
| 48 | LINEUNITSELLINGPRICE | NUMBER | SI | ||
| 49 | LINEDISPLAYLINENUMBER | VARCHAR2(100) | SI | ||
| 50 | IDMAESTROCARGUE | NUMBER | NO |
Restricciones
CHECK: SYS_C00286276
- Estado: ENABLED
- Columnas: LINEID
- Condición:
"LINEID" IS NOT NULL
CHECK: SYS_C00286277
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_LINEEXTRACT_OM"
( "LINEID" NUMBER(18,0) NOT NULL ENABLE,
"LINEACTUALSHIPDATE" DATE,
"LINECANCELEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"LINECANCELEDQTY" NUMBER,
"LINECATEGORYCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"LINECOMPSEQPATH" VARCHAR2(4000) COLLATE "USING_NLS_COMP",
"LINECREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"LINECREATIONDATE" TIMESTAMP (6),
"LINEDELTATYPE" NUMBER(18,0),
"LINEEXTENDEDAMOUNT" NUMBER,
"LINEFULFILLEDQTY" NUMBER,
"LINEFULFILLMENTDATE" DATE,
"LINEHEADERID" NUMBER(18,0),
"LINEINVENTORYITEMID" NUMBER(18,0),
"LINEINVENTORYORGANIZATIONID" NUMBER(18,0),
"LINEITEMTYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"LINELASTUPDATEDATE" TIMESTAMP (6),
"LINELASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP",
"LINELASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"LINELINENUMBER" NUMBER(9,0),
"LINELINETYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"LINEOBJECTVERSIONNUMBER" NUMBER(9,0),
"LINEONHOLD" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"LINEOPENFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"LINEORDEREDQTY" NUMBER,
"LINEORGID" NUMBER(18,0),
"LINEORDEREDUOM" VARCHAR2(3) COLLATE "USING_NLS_COMP",
"LINEORIGSYSDOCUMENTLINEREF" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LINEORIGSYSDOCUMENTREF" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LINEOWNERID" NUMBER(18,0),
"LINEPARENTLINEID" NUMBER(18,0),
"LINEREFERENCELINEID" NUMBER(18,0),
"LINERMADELIVEREDQTY" NUMBER,
"LINEROOTPARENTLINEID" NUMBER(18,0),
"LINESCHEDULESHIPDATE" DATE,
"LINESHIPPEDQTY" NUMBER,
"LINESOURCELINEID" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LINESOURCELINENUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LINESOURCEORDERID" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LINESOURCEORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LINESOURCEORDERSYSTEM" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"LINESOURCEORGID" NUMBER(18,0),
"LINESOURCESCHEDULEID" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LINESOURCESCHEDULENUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"LINESTATUSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"LINETRANSFORMFROMLINEID" NUMBER(18,0),
"LINEUNITLISTPRICE" NUMBER,
"LINEUNITSELLINGPRICE" NUMBER,
"LINEDISPLAYLINENUMBER" VARCHAR2(100) COLLATE "USING_NLS_COMP",
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "STADW"."ST_LINEEXTRACT_OM" IS 'Español: Almacena el detalle de las líneas de órdenes, incluyendo artículos, cantidades, precios, estados y organizaciones asociadas.
English: Stores order line details, including items, quantities, prices, statuses, and associated organizations.';
CREATE INDEX "STADW"."ST_LINEEXTRACT_OM_LINEID_IDX" ON "STADW"."ST_LINEEXTRACT_OM" ("LINEID")
;