Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
STADW.ST_FULFILLLINEDETAIL_OM
Base de datos origen: ADW COEXITO
Descripción: Español: Almacena el detalle de cumplimiento de líneas de órdenes, incluyendo facturación, entregas, cantidades, estados, recepciones y seguimiento. English: Stores order fulfillline details, including billing, deliveries, quantities, statuses, receipts, and tracking.
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | FULFILLLINEDETAILFULFILLLINEDETAILID | NUMBER(18,0) | NO | ||
| 2 | FULFILLLINEDETAILBILLOFLADINGNUMBER | VARCHAR2(120) | SI | ||
| 3 | FULFILLLINEDETAILBILLINGTRANSACTIONAMOUNT | NUMBER | SI | ||
| 4 | FULFILLLINEDETAILBILLINGTRANSACTIONDATE | TIMESTAMP(6) | SI | ||
| 5 | FULFILLLINEDETAILBILLINGTRANSACTIONNUMBER | VARCHAR2(30) | SI | ||
| 6 | FULFILLLINEDETAILCREATEDBY | VARCHAR2(64) | SI | ||
| 7 | FULFILLLINEDETAILCREATIONDATE | TIMESTAMP(6) | SI | ||
| 8 | FULFILLLINEDETAILCUSTOMERTRXLINEID | NUMBER(18,0) | SI | ||
| 9 | FULFILLLINEDETAILDELIVERYNAME | VARCHAR2(120) | SI | ||
| 10 | FULFILLLINEDETAILFULFILLLINEID | NUMBER(18,0) | SI | ||
| 11 | FULFILLLINEDETAILLASTUPDATEDATE | TIMESTAMP(6) | SI | ||
| 12 | FULFILLLINEDETAILLASTUPDATELOGIN | VARCHAR2(32) | SI | ||
| 13 | FULFILLLINEDETAILLASTUPDATEDBY | VARCHAR2(64) | SI | ||
| 14 | FULFILLLINEDETAILOBJECTVERSIONNUMBER | NUMBER | SI | ||
| 15 | FULFILLLINEDETAILQUANTITY | NUMBER | SI | ||
| 16 | FULFILLLINEDETAILRMARECEIPTDATE | TIMESTAMP(6) | SI | ||
| 17 | FULFILLLINEDETAILRMARECEIPTLINENUMBER | VARCHAR2(50) | SI | ||
| 18 | FULFILLLINEDETAILRMARECEIPTNUMBER | VARCHAR2(50) | SI | ||
| 19 | FULFILLLINEDETAILRMARECEIPTTRANSACTIONID | NUMBER(18,0) | SI | ||
| 20 | FULFILLLINEDETAILSTATUS | VARCHAR2(30) | SI | ||
| 21 | FULFILLLINEDETAILSTATUSASOFDATE | TIMESTAMP(6) | SI | ||
| 22 | FULFILLLINEDETAILTASKTYPE | VARCHAR2(50) | SI | ||
| 23 | FULFILLLINEDETAILTRACKINGNUMBER | VARCHAR2(120) | SI | ||
| 24 | FULFILLLINEDETAILWAYBILLNUMBER | VARCHAR2(30) | SI | ||
| 25 | FULFILLLINEDETAILTRADECOMPLIANCETYPECODE | VARCHAR2(30) | SI | ||
| 26 | FULFILLLINEDETAILAVAILABILITYSHIPDATE | TIMESTAMP(6) | SI | ||
| 27 | FULFILLLINEDETAILEXCEPTIONFLAG | VARCHAR2(1) | SI | ||
| 28 | FULFILLLINEDETAILACTUALDELIVERYDATE | TIMESTAMP(6) | SI | ||
| 29 | FULFILLLINEDETAILTRADECOMPLIANCERESULTCODE | VARCHAR2(30) | SI | ||
| 30 | FULFILLLINEDETAILTRADECOMPLIANCECODE | VARCHAR2(30) | SI | ||
| 31 | FULFILLLINEDETAILTRADECOMPLIANCEEXPLANATION | VARCHAR2(1000) | SI | ||
| 32 | FULFILLLINEDETAILREFERENCEFLINEDETAILID | NUMBER(18,0) | SI | ||
| 33 | FULFILLLINEDETAILDELTATYPE | NUMBER(18,0) | SI | ||
| 34 | FULFILLLINEDETAILMODIFIEDFLAG | VARCHAR2(1) | SI | ||
| 35 | FULFILLLINEDETAILSHIPMENTREQUESTEDQUANTITY | NUMBER | SI | ||
| 36 | FULFILLLINEDETAILSECONDARYQUANTITY | NUMBER | SI | ||
| 37 | IDMAESTROCARGUE | NUMBER | NO |
Restricciones
CHECK: SYS_C00286291
- Estado: ENABLED
- Columnas: FULFILLLINEDETAILFULFILLLINEDETAILID
- Condición:
"FULFILLLINEDETAILFULFILLLINEDETAILID" IS NOT NULL
CHECK: SYS_C00286292
- Estado: ENABLED
- Columnas: IDMAESTROCARGUE
- Condición:
"IDMAESTROCARGUE" IS NOT NULL
DDL
CREATE TABLE "STADW"."ST_FULFILLLINEDETAIL_OM"
( "FULFILLLINEDETAILFULFILLLINEDETAILID" NUMBER(18,0) NOT NULL ENABLE,
"FULFILLLINEDETAILBILLOFLADINGNUMBER" VARCHAR2(120) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILBILLINGTRANSACTIONAMOUNT" NUMBER,
"FULFILLLINEDETAILBILLINGTRANSACTIONDATE" TIMESTAMP (6),
"FULFILLLINEDETAILBILLINGTRANSACTIONNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILCREATIONDATE" TIMESTAMP (6),
"FULFILLLINEDETAILCUSTOMERTRXLINEID" NUMBER(18,0),
"FULFILLLINEDETAILDELIVERYNAME" VARCHAR2(120) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILFULFILLLINEID" NUMBER(18,0),
"FULFILLLINEDETAILLASTUPDATEDATE" TIMESTAMP (6),
"FULFILLLINEDETAILLASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILOBJECTVERSIONNUMBER" NUMBER,
"FULFILLLINEDETAILQUANTITY" NUMBER,
"FULFILLLINEDETAILRMARECEIPTDATE" TIMESTAMP (6),
"FULFILLLINEDETAILRMARECEIPTLINENUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILRMARECEIPTNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILRMARECEIPTTRANSACTIONID" NUMBER(18,0),
"FULFILLLINEDETAILSTATUS" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILSTATUSASOFDATE" TIMESTAMP (6),
"FULFILLLINEDETAILTASKTYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILTRACKINGNUMBER" VARCHAR2(120) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILWAYBILLNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILTRADECOMPLIANCETYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILAVAILABILITYSHIPDATE" TIMESTAMP (6),
"FULFILLLINEDETAILEXCEPTIONFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILACTUALDELIVERYDATE" TIMESTAMP (6),
"FULFILLLINEDETAILTRADECOMPLIANCERESULTCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILTRADECOMPLIANCECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILTRADECOMPLIANCEEXPLANATION" VARCHAR2(1000) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILREFERENCEFLINEDETAILID" NUMBER(18,0),
"FULFILLLINEDETAILDELTATYPE" NUMBER(18,0),
"FULFILLLINEDETAILMODIFIEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP",
"FULFILLLINEDETAILSHIPMENTREQUESTEDQUANTITY" NUMBER,
"FULFILLLINEDETAILSECONDARYQUANTITY" NUMBER,
"IDMAESTROCARGUE" NUMBER NOT NULL ENABLE
) DEFAULT COLLATION "USING_NLS_COMP" ;
COMMENT ON TABLE "STADW"."ST_FULFILLLINEDETAIL_OM" IS 'Español: Almacena el detalle de cumplimiento de líneas de órdenes, incluyendo facturación, entregas, cantidades, estados, recepciones y seguimiento.
English: Stores order fulfillline details, including billing, deliveries, quantities, statuses, receipts, and tracking.';
CREATE INDEX "STADW"."ST_FULFILLLINEDETAIL_ID_IDX" ON "STADW"."ST_FULFILLLINEDETAIL_OM" ("FULFILLLINEDETAILFULFILLLINEDETAILID")
;