DWADW.FACT_FULFILLLINEDETAIL_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos con el detalle del cumplimiento de líneas de órdenes. Contiene información de entregas, facturación, cantidades, recepciones, seguimiento y estados, y permite analizar eventos y movimientos asociados al cumplimiento de cada línea. English: Fact table containing order fulfillment line details. It includes delivery, billing, quantities, receipts, tracking, and status information and supports analysis of events and movements associated with each fulfillment line.

Columnas

#	Columna	Tipo	Nulo	Default
1	FULFILLLINEDETAIL_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378183”.nextval
2	FULFILLLINEDETAILID	NUMBER(18,0)	NO
3	BILLOFLADINGNUMBER	VARCHAR2(120)	SI
4	BILLINGTRANSACTIONAMOUNT	NUMBER	SI
5	BILLINGTRANSACTIONDATE	TIMESTAMP(6)	SI
6	BILLINGTRANSACTIONNUMBER	VARCHAR2(30)	SI
7	CREATEDBY	VARCHAR2(64)	SI
8	CREATIONDATE	TIMESTAMP(6)	SI
9	CUSTOMERTRXLINEID	NUMBER(18,0)	SI
10	DELIVERYNAME	VARCHAR2(120)	SI
11	FULFILLLINEID	NUMBER(18,0)	SI
12	LASTUPDATEDATE	TIMESTAMP(6)	SI
13	LASTUPDATELOGIN	VARCHAR2(32)	SI
14	LASTUPDATEDBY	VARCHAR2(64)	SI
15	OBJECTVERSIONNUMBER	NUMBER	SI
16	QUANTITY	NUMBER	SI
17	RMARECEIPTDATE	TIMESTAMP(6)	SI
18	RMARECEIPTLINENUMBER	VARCHAR2(50)	SI
19	RMARECEIPTNUMBER	VARCHAR2(50)	SI
20	RMARECEIPTTRANSACTIONID	NUMBER(18,0)	SI
21	STATUS	VARCHAR2(30)	SI
22	STATUSASOFDATE	TIMESTAMP(6)	SI
23	TASKTYPE	VARCHAR2(50)	SI
24	TRACKINGNUMBER	VARCHAR2(120)	SI
25	WAYBILLNUMBER	VARCHAR2(30)	SI
26	TRADECOMPLIANCETYPECODE	VARCHAR2(30)	SI
27	AVAILABILITYSHIPDATE	TIMESTAMP(6)	SI
28	EXCEPTIONFLAG	VARCHAR2(1)	SI
29	ACTUALDELIVERYDATE	TIMESTAMP(6)	SI
30	TRADECOMPLIANCERESULTCODE	VARCHAR2(30)	SI
31	TRADECOMPLIANCECODE	VARCHAR2(30)	SI
32	TRADECOMPLIANCEEXPLANATION	VARCHAR2(1000)	SI
33	REFERENCEFLINEDETAILID	NUMBER(18,0)	SI
34	DELTATYPE	NUMBER(18,0)	SI
35	MODIFIEDFLAG	VARCHAR2(1)	SI
36	SHIPMENTREQUESTEDQUANTITY	NUMBER	SI
37	SECONDARYQUANTITY	NUMBER	SI
38	AUDIT_ID	NUMBER	NO
39	ROW_ACTIVE	CHAR(1)	NO	‘A’
40	FACT_FULFILLLINE_OM_ID	NUMBER	SI
41	FACT_SALESINVOICECUSTOMERTRXLINE_OM_ID	NUMBER	SI

Restricciones

CHECK: FACT_FULFILLLINEDETAIL_OM_CK

Estado: ENABLED
Columnas: ROW_ACTIVE
Condición: row_active IN ('A','I')

CHECK: SYS_C00304938

Estado: ENABLED
Columnas: FULFILLLINEDETAIL_OM_ID
Condición: "FULFILLLINEDETAIL_OM_ID" IS NOT NULL

CHECK: SYS_C00304939

Estado: ENABLED
Columnas: FULFILLLINEDETAILID
Condición: "FULFILLLINEDETAILID" IS NOT NULL

CHECK: SYS_C00304940

Estado: ENABLED
Columnas: AUDIT_ID
Condición: "AUDIT_ID" IS NOT NULL

CHECK: SYS_C00304941

Estado: ENABLED
Columnas: ROW_ACTIVE
Condición: "ROW_ACTIVE" IS NOT NULL

PK: FACT_FULFILLLINEDETAIL_OM_PK

Estado: ENABLED
Columnas: FULFILLLINEDETAIL_OM_ID

FK: FACT_FULFILLLINEDETAIL_OM_FACT_FULFILLLINE_OM_FK

Estado: ENABLED
Columnas: FACT_FULFILLLINE_OM_ID
Referencia: DWADW.FACT_FULFILLLINE_OM (constraint ST_FULFILLLINE_OM_PK)

FK: FACT_FULFILLLINEDETAIL_OM_FACT_SALESINVOICECUSTOMERTRXLINE_OM_FK

Estado: ENABLED
Columnas: FACT_SALESINVOICECUSTOMERTRXLINE_OM_ID
Referencia: DWADW.FACT_SALESINVOICECUSTOMERTRXLINE_OM (constraint FACT_SALESINVOICECUSTOMERTRXLINE_OM_PK)

UK: FACT_FULFILLLINEDETAIL_OM__UN

Estado: ENABLED
Columnas: FULFILLLINEDETAILID

DDL

CREATE TABLE "DWADW"."FACT_FULFILLLINEDETAIL_OM" 
   (	"FULFILLLINEDETAIL_OM_ID" NUMBER GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"FULFILLLINEDETAILID" NUMBER(18,0) NOT NULL ENABLE, 
	"BILLOFLADINGNUMBER" VARCHAR2(120) COLLATE "USING_NLS_COMP", 
	"BILLINGTRANSACTIONAMOUNT" NUMBER, 
	"BILLINGTRANSACTIONDATE" TIMESTAMP (6), 
	"BILLINGTRANSACTIONNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"CREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"CREATIONDATE" TIMESTAMP (6), 
	"CUSTOMERTRXLINEID" NUMBER(18,0), 
	"DELIVERYNAME" VARCHAR2(120) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEID" NUMBER(18,0), 
	"LASTUPDATEDATE" TIMESTAMP (6), 
	"LASTUPDATELOGIN" VARCHAR2(32) COLLATE "USING_NLS_COMP", 
	"LASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"OBJECTVERSIONNUMBER" NUMBER, 
	"QUANTITY" NUMBER, 
	"RMARECEIPTDATE" TIMESTAMP (6), 
	"RMARECEIPTLINENUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"RMARECEIPTNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"RMARECEIPTTRANSACTIONID" NUMBER(18,0), 
	"STATUS" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"STATUSASOFDATE" TIMESTAMP (6), 
	"TASKTYPE" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"TRACKINGNUMBER" VARCHAR2(120) COLLATE "USING_NLS_COMP", 
	"WAYBILLNUMBER" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"TRADECOMPLIANCETYPECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"AVAILABILITYSHIPDATE" TIMESTAMP (6), 
	"EXCEPTIONFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"ACTUALDELIVERYDATE" TIMESTAMP (6), 
	"TRADECOMPLIANCERESULTCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"TRADECOMPLIANCECODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"TRADECOMPLIANCEEXPLANATION" VARCHAR2(1000) COLLATE "USING_NLS_COMP", 
	"REFERENCEFLINEDETAILID" NUMBER(18,0), 
	"DELTATYPE" NUMBER(18,0), 
	"MODIFIEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"SHIPMENTREQUESTEDQUANTITY" NUMBER, 
	"SECONDARYQUANTITY" NUMBER, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"FACT_FULFILLLINE_OM_ID" NUMBER, 
	"FACT_SALESINVOICECUSTOMERTRXLINE_OM_ID" NUMBER, 
	 CONSTRAINT "FACT_FULFILLLINEDETAIL_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINEDETAIL_OM_PK" PRIMARY KEY ("FULFILLLINEDETAIL_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINEDETAIL_OM__UN" UNIQUE ("FULFILLLINEDETAILID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINEDETAIL_OM_FACT_SALESINVOICECUSTOMERTRXLINE_OM_FK" FOREIGN KEY ("FACT_SALESINVOICECUSTOMERTRXLINE_OM_ID")
	  REFERENCES "DWADW"."FACT_SALESINVOICECUSTOMERTRXLINE_OM" ("SALESINVOICECUSTOMERTRXLINE_OM_ID") ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINEDETAIL_OM_FACT_FULFILLLINE_OM_FK" FOREIGN KEY ("FACT_FULFILLLINE_OM_ID")
	  REFERENCES "DWADW"."FACT_FULFILLLINE_OM" ("FULFILLLINE_OM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_FULFILLLINEDETAIL_OM"  IS 'Español: Tabla de hechos con el detalle del cumplimiento de líneas de órdenes. Contiene información de entregas, facturación, cantidades, recepciones, seguimiento y estados, y permite analizar eventos y movimientos asociados al cumplimiento de cada línea.
English: Fact table containing order fulfillment line details. It includes delivery, billing, quantities, receipts, tracking, and status information and supports analysis of events and movements associated with each fulfillment line.';

CREATE UNIQUE INDEX "DWADW"."FACT_FULFILLLINEDETAIL_OM_PK" ON "DWADW"."FACT_FULFILLLINEDETAIL_OM" ("FULFILLLINEDETAIL_OM_ID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."FACT_FULFILLLINEDETAIL_OM__UN" ON "DWADW"."FACT_FULFILLLINEDETAIL_OM" ("FULFILLLINEDETAILID") 
  ;
  CREATE INDEX "DWADW"."FFLDETAIL_TRACKING_OM_IDX" ON "DWADW"."FACT_FULFILLLINEDETAIL_OM" ("FULFILLLINEID", "TASKTYPE") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal