DWADW.FACT_FULFILLLINE_OM

Base de datos origen: ADW COEXITO

Descripción: Español: Tabla de hechos de cumplimiento de líneas de órdenes. Contiene cantidades ordenadas, cumplidas, canceladas y enviadas, precios, estados, artículos, organizaciones y fechas del proceso, y permite analizar el avance y cumplimiento de las órdenes a nivel de línea. English: Order fulfillment line fact table. It contains ordered, fulfilled, canceled, and shipped quantities, prices, statuses, items, organizations, and process dates and supports analysis of order progress and fulfillment at line level.

Columnas

#	Columna	Tipo	Nulo	Default
1	FULFILLLINE_OM_ID	NUMBER	NO	“DWADW”.”ISEQ$$_378180”.nextval
2	BILLTOCUSTOMERACCOUNTACCOUNTESTABLISHEDDATE	DATE	SI
3	BILLTOCUSTOMERACCOUNTLASTUPDATEDATE	DATE	NO
4	COVERAGEFLINEDETAILSFULFILLLINENUMBER	NUMBER(9,0)	NO
5	COVERAGEFLINEDETAILSSOURCEREVISIONNUMBER	NUMBER(18,0)	NO
6	COVEREDFLINEDETAILSFULFILLLINENUMBER	NUMBER(9,0)	NO
7	COVEREDFLINEDETAILSSOURCEREVISIONNUMBER	NUMBER(18,0)	NO
8	DOCUMENTREFERENCESDOCALTUSERKEY	VARCHAR2(150)	SI
9	DOCUMENTREFERENCESDOCCONTEXTID	VARCHAR2(50)	SI
10	DOCUMENTREFERENCESDOCLINEID	VARCHAR2(50)	SI
11	DOCUMENTREFERENCESDOCLINEUSERKEY	VARCHAR2(150)	SI
12	DOCUMENTREFERENCESDOCREFTYPE	VARCHAR2(30)	SI
13	DOCUMENTREFERENCESDOCSUBLINEID	VARCHAR2(50)	SI
14	DOCUMENTREFERENCESDOCSUBLINEUSERKEY	VARCHAR2(150)	SI
15	DOCUMENTREFERENCESDOCUSERKEY	VARCHAR2(150)	SI
16	FULFILLLINEACTUALCOMPLETIONDATE	DATE	SI
17	FULFILLLINEACTUALSHIPDATE	DATE	SI
18	FULFILLLINEASSETTRACKEDFLAG	VARCHAR2(1)	SI
19	FULFILLLINEBILLTOSITEUSEID	NUMBER(18,0)	SI
20	FULFILLLINECANCELREASONCODE	VARCHAR2(30)	SI
21	FULFILLLINECANCELEDFLAG	VARCHAR2(1)	SI
22	FULFILLLINECANCELEDQTY	NUMBER	SI
23	FULFILLLINECATEGORYCODE	VARCHAR2(8)	SI
24	FULFILLLINECREATEDBY	VARCHAR2(9)	NO
25	FULFILLLINECREATIONDATE	DATE	NO
26	FULFILLLINECUSTOMERPONUMBER	VARCHAR2(8)	SI
27	FULFILLLINEESTIMATEFULFILLMENTCOST	NUMBER	SI
28	FULFILLLINEFULFILLFLAG	VARCHAR2(18)	SI
29	FULFILLLINEFULFILLLINENUMBER	NUMBER(9,0)	NO
30	FULFILLLINEFULFILLORGID	NUMBER(18,0)	SI
31	FULFILLLINEFULFILLEDQTY	NUMBER	SI
32	FULFILLLINEFULFILLMENTDATE	DATE	SI
33	FULFILLLINEFULFILLMENTSPLITREFID	NUMBER(18,0)	SI
34	FULFILLLINEHEADERID	NUMBER(18,0)	NO
35	FULFILLLINEID	NUMBER(18,0)	NO
36	FULFILLLINEINVENTORYINTERFACEDFLAG	VARCHAR2(8)	SI
37	FULFILLLINEINVENTORYITEMID	NUMBER(18,0)	NO
38	FULFILLLINEINVENTORYTRANSACTIONFLAG	VARCHAR2(18)	SI
39	FULFILLLINEITEMSUBTYPECODE	VARCHAR2(9)	SI
40	FULFILLLINEITEMTYPECODE	VARCHAR2(18)	SI
41	FULFILLLINELASTUPDATEDATE	DATE	NO
42	FULFILLLINELASTUPDATEDBY	VARCHAR2(18)	NO
43	FULFILLLINELINEID	NUMBER(18,0)	NO
44	FULFILLLINELINETYPECODE	VARCHAR2(8)	SI
45	FULFILLLINEONHOLD	VARCHAR2(8)	SI
46	FULFILLLINEOPENFLAG	VARCHAR2(18)	SI
47	FULFILLLINEORDEREDQTY	NUMBER	NO
48	FULFILLLINEORDEREDUOM	VARCHAR2(18)	NO
49	FULFILLLINEPACKINGINSTRUCTIONS	VARCHAR2(18)	SI
50	FULFILLLINEPARENTFULFILLLINEIDPK	NUMBER(18,0)	NO
51	FULFILLLINEPARENTFULFILLLINENUMBER	NUMBER(9,0)	NO
52	FULFILLLINEPARTIALSHIPALLOWEDFLAG	VARCHAR2(18)	SI
53	FULFILLLINEPAYMENTTERMID	NUMBER(18,0)	SI
54	FULFILLLINEREQUESTARRIVALDATE	DATE	SI
55	FULFILLLINEREQUESTCANCELDATE	DATE	SI
56	FULFILLLINEREQUESTSHIPDATE	DATE	SI
57	FULFILLLINERESERVABLEFLAG	VARCHAR2(18)	SI
58	FULFILLLINERESERVEDQTY	NUMBER	SI
59	FULFILLLINERETURNREASONCODE	VARCHAR2(8)	SI
60	FULFILLLINERMADELIVEREDQTY	NUMBER	SI
61	FULFILLLINEROOTPARENTFULFILLLINEIDPK	NUMBER(18,0)	NO
62	FULFILLLINEROOTPARENTFULFILLLINENUMBER	NUMBER(9,0)	NO
63	FULFILLLINESCHEDULEARRIVALDATE	DATE	SI
64	FULFILLLINESCHEDULESHIPDATE	DATE	SI
65	FULFILLLINESHIPCLASSOFSERVICE	VARCHAR2(30)	SI
66	FULFILLLINESHIPMODEOFTRANSPORT	VARCHAR2(30)	SI
67	FULFILLLINESHIPTOPARTYCONTACTID	NUMBER(18,0)	SI
68	FULFILLLINESHIPTOPARTYID	NUMBER(18,0)	SI
69	FULFILLLINESHIPTOPARTYSITEID	NUMBER(18,0)	SI
70	FULFILLLINESHIPPABLEFLAG	VARCHAR2(8)	SI
71	FULFILLLINESHIPPEDQTY	NUMBER	SI
72	FULFILLLINESHIPPINGINSTRUCTIONS	VARCHAR2(8)	SI
73	FULFILLLINESOURCELINEID	VARCHAR2(18)	SI
74	FULFILLLINESOURCELINENUMBER	VARCHAR2(18)	SI
75	FULFILLLINESOURCEORDERID	VARCHAR2(18)	SI
76	FULFILLLINESOURCEORDERNUMBER	VARCHAR2(18)	SI
77	FULFILLLINESTATUSCODE	VARCHAR2(18)	SI
78	FULFILLLINETAXCLASSIFICATIONCODE	VARCHAR2(18)	SI
79	FULFILLLINETAXEXEMPTFLAG	VARCHAR2(18)	SI
80	FULFILLLINEUNITLISTPRICE	NUMBER	SI
81	FULFILLLINEUNITSELLINGPRICE	NUMBER	SI
82	FULFILLLINEUNREFERENCEDRETURNFLAG	VARCHAR2(18)	SI
83	HEADERCANCELREASONCODE	VARCHAR2(18)	SI
84	HEADERCANCELEDFLAG	VARCHAR2(18)	SI
85	HEADERCHANGEVERSIONNUMBER	NUMBER(18,0)	SI
86	HEADERCREATEDBY	VARCHAR2(8)	NO
87	HEADERCREATIONDATE	DATE	NO
88	HEADERCUSTOMERPONUMBER	VARCHAR2(8)	SI
89	HEADERHEADERID	NUMBER(18,0)	NO
90	HEADERLASTUPDATEDATE	DATE	NO
91	HEADERLASTUPDATEDBY	VARCHAR2(64)	NO
92	HEADERLEGALENTITYID	NUMBER(18,0)	SI
93	HEADERONHOLD	VARCHAR2(18)	SI
94	HEADEROPENFLAG	VARCHAR2(18)	SI
95	HEADERORDERNUMBER	VARCHAR2(18)	NO
96	HEADERORDERTYPECODE	VARCHAR2(18)	SI
97	HEADERORDEREDDATE	DATE	SI
98	HEADERORGID	NUMBER(18,0)	NO
99	HEADERREQUESTSHIPDATE	DATE	SI
100	HEADERSALESPERSONID	NUMBER(18,0)	SI
101	HEADERSOLDTOPARTYCONTACTID	NUMBER(18,0)	SI
102	HEADERSOLDTOPARTYID	NUMBER(18,0)	SI
103	HEADERSOURCEDOCUMENTTYPECODE	VARCHAR2(8)	SI
104	HEADERSOURCEORDERSYSTEM	VARCHAR2(8)	SI
105	HEADERSOURCEORGID	NUMBER(18,0)	NO
106	HEADERSTATUSCODE	VARCHAR2(8)	SI
107	HEADERSUBMITTEDBY	VARCHAR2(64)	SI
108	HEADERSUBMITTEDDATE	DATE	SI
109	HEADERSUBMITTEDFLAG	VARCHAR2(1)	SI
110	HEADERTRANSACTIONALCURRENCYCODE	VARCHAR2(15)	SI
111	LINEACTUALSHIPDATE	DATE	SI
112	LINECANCELEDFLAG	VARCHAR2(1)	SI
113	LINECANCELEDQTY	NUMBER	SI
114	LINECATEGORYCODE	VARCHAR2(18)	SI
115	LINECREATEDBY	VARCHAR2(18)	NO
116	LINECREATIONDATE	DATE	NO
117	LINEDISPLAYLINENUMBER	VARCHAR2(9)	SI
118	LINEFULFILLMENTDATE	DATE	SI
119	LINEHEADERID	NUMBER(18,0)	NO
120	LINEINVENTORYITEMID	NUMBER(18,0)	SI
121	LINEITEMTYPECODE	VARCHAR2(8)	SI
122	LINELASTUPDATEDATE	DATE	NO
123	LINELASTUPDATEDBY	VARCHAR2(64)	NO
124	LINELINEID	NUMBER(18,0)	NO
125	LINELINENUMBER	NUMBER(9,0)	NO
126	LINEONHOLD	VARCHAR2(8)	SI
127	LINEOPENFLAG	VARCHAR2(8)	SI
128	LINEORDEREDQTY	NUMBER	SI
129	LINEORDEREDUOM	VARCHAR2(8)	SI
130	LINESCHEDULESHIPDATE	DATE	SI
131	LINESHIPPEDQTY	NUMBER	SI
132	LINESOURCELINEID	VARCHAR2(8)	SI
133	LINESOURCELINENUMBER	VARCHAR2(8)	SI
134	LINESOURCEORDERID	VARCHAR2(50)	SI
135	LINESOURCEORDERNUMBER	VARCHAR2(50)	SI
136	LINESOURCESCHEDULENUMBER	VARCHAR2(50)	SI
137	LINESTATUSCODE	VARCHAR2(30)	SI
138	LINEUNITLISTPRICE	NUMBER	SI
139	LINEUNITSELLINGPRICE	NUMBER	SI
140	ROW_ACTIVE	CHAR(1)	NO	‘A’
141	AUDIT_ID	NUMBER	NO
142	DIM_ITEMREF_OM_ID	NUMBER	SI
143	DIM_FULFILLLINESTATUS_OM_ID	NUMBER	SI
144	FACT_LINEEXTRACT_OM_ID	NUMBER	SI
145	DIM_INVORGPARAMETERS_OM_ID	NUMBER	SI

Restricciones

CHECK: FACT_FULFILLLINE_OM_CK

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

CHECK: SYS_C00304896

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

CHECK: SYS_C00304897

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

CHECK: SYS_C00304898

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

CHECK: SYS_C00304899

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

CHECK: SYS_C00304900

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

CHECK: SYS_C00304901

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

CHECK: SYS_C00304902

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

CHECK: SYS_C00304903

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

CHECK: SYS_C00304904

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

CHECK: SYS_C00304905

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

CHECK: SYS_C00304906

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

CHECK: SYS_C00304907

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

CHECK: SYS_C00304908

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

CHECK: SYS_C00304909

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

CHECK: SYS_C00304910

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

CHECK: SYS_C00304911

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

CHECK: SYS_C00304912

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

CHECK: SYS_C00304913

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

CHECK: SYS_C00304914

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

CHECK: SYS_C00304915

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

CHECK: SYS_C00304916

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

CHECK: SYS_C00304917

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

CHECK: SYS_C00304918

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

CHECK: SYS_C00304919

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

CHECK: SYS_C00304920

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

CHECK: SYS_C00304921

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

CHECK: SYS_C00304922

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

CHECK: SYS_C00304923

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

CHECK: SYS_C00304924

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

CHECK: SYS_C00304925

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

CHECK: SYS_C00304926

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

CHECK: SYS_C00304927

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

CHECK: SYS_C00304928

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

CHECK: SYS_C00304929

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

CHECK: SYS_C00304930

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

CHECK: SYS_C00304931

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

CHECK: SYS_C00304932

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

CHECK: SYS_C00304933

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

PK: ST_FULFILLLINE_OM_PK

Estado: ENABLED
Columnas: FULFILLLINE_OM_ID

FK: FACT_FULFILLLINE_OM_DIM_FULFILLLINESTATUS_OM_FK

Estado: ENABLED
Columnas: DIM_FULFILLLINESTATUS_OM_ID
Referencia: DWADW.DIM_FULFILLLINESTATUS_OM (constraint ST_FULFILLLINESTATUS_OM_PK)

FK: FACT_FULFILLLINE_OM_DIM_INVORGPARAMETERS_OM_FK

Estado: ENABLED
Columnas: DIM_INVORGPARAMETERS_OM_ID
Referencia: DWADW.DIM_INVORGPARAMETERS_OM (constraint DIM_INVORGPARAMETERS_OM_PK)

FK: FACT_FULFILLLINE_OM_DIM_ITEMREF_OM_FK

Estado: ENABLED
Columnas: DIM_ITEMREF_OM_ID
Referencia: DWADW.DIM_ITEMREF_OM (constraint ST_ITEMREF_OM_PK)

FK: FACT_FULFILLLINE_OM_FACT_LINEEXTRACT_OM_FK

Estado: ENABLED
Columnas: FACT_LINEEXTRACT_OM_ID
Referencia: DWADW.FACT_LINEEXTRACT_OM (constraint FACT_LINEEXTRACT_OM_PK)

UK: FACT_FULFILLLINE_OM__UN

Estado: ENABLED
Columnas: FULFILLLINEID

DDL

CREATE TABLE "DWADW"."FACT_FULFILLLINE_OM" 
   (	"FULFILLLINE_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, 
	"BILLTOCUSTOMERACCOUNTACCOUNTESTABLISHEDDATE" DATE, 
	"BILLTOCUSTOMERACCOUNTLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"COVERAGEFLINEDETAILSFULFILLLINENUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"COVERAGEFLINEDETAILSSOURCEREVISIONNUMBER" NUMBER(18,0) NOT NULL ENABLE, 
	"COVEREDFLINEDETAILSFULFILLLINENUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"COVEREDFLINEDETAILSSOURCEREVISIONNUMBER" NUMBER(18,0) NOT NULL ENABLE, 
	"DOCUMENTREFERENCESDOCALTUSERKEY" VARCHAR2(150) COLLATE "USING_NLS_COMP", 
	"DOCUMENTREFERENCESDOCCONTEXTID" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"DOCUMENTREFERENCESDOCLINEID" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"DOCUMENTREFERENCESDOCLINEUSERKEY" VARCHAR2(150) COLLATE "USING_NLS_COMP", 
	"DOCUMENTREFERENCESDOCREFTYPE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"DOCUMENTREFERENCESDOCSUBLINEID" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"DOCUMENTREFERENCESDOCSUBLINEUSERKEY" VARCHAR2(150) COLLATE "USING_NLS_COMP", 
	"DOCUMENTREFERENCESDOCUSERKEY" VARCHAR2(150) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEACTUALCOMPLETIONDATE" DATE, 
	"FULFILLLINEACTUALSHIPDATE" DATE, 
	"FULFILLLINEASSETTRACKEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEBILLTOSITEUSEID" NUMBER(18,0), 
	"FULFILLLINECANCELREASONCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"FULFILLLINECANCELEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"FULFILLLINECANCELEDQTY" NUMBER, 
	"FULFILLLINECATEGORYCODE" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINECREATEDBY" VARCHAR2(9) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FULFILLLINECREATIONDATE" DATE NOT NULL ENABLE, 
	"FULFILLLINECUSTOMERPONUMBER" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEESTIMATEFULFILLMENTCOST" NUMBER, 
	"FULFILLLINEFULFILLFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEFULFILLLINENUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"FULFILLLINEFULFILLORGID" NUMBER(18,0), 
	"FULFILLLINEFULFILLEDQTY" NUMBER, 
	"FULFILLLINEFULFILLMENTDATE" DATE, 
	"FULFILLLINEFULFILLMENTSPLITREFID" NUMBER(18,0), 
	"FULFILLLINEHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"FULFILLLINEID" NUMBER(18,0) NOT NULL ENABLE, 
	"FULFILLLINEINVENTORYINTERFACEDFLAG" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEINVENTORYITEMID" NUMBER(18,0) NOT NULL ENABLE, 
	"FULFILLLINEINVENTORYTRANSACTIONFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEITEMSUBTYPECODE" VARCHAR2(9) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEITEMTYPECODE" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINELASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FULFILLLINELASTUPDATEDBY" VARCHAR2(18) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FULFILLLINELINEID" NUMBER(18,0) NOT NULL ENABLE, 
	"FULFILLLINELINETYPECODE" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEONHOLD" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEOPENFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEORDEREDQTY" NUMBER NOT NULL ENABLE, 
	"FULFILLLINEORDEREDUOM" VARCHAR2(18) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FULFILLLINEPACKINGINSTRUCTIONS" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEPARENTFULFILLLINEIDPK" NUMBER(18,0) NOT NULL ENABLE, 
	"FULFILLLINEPARENTFULFILLLINENUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"FULFILLLINEPARTIALSHIPALLOWEDFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEPAYMENTTERMID" NUMBER(18,0), 
	"FULFILLLINEREQUESTARRIVALDATE" DATE, 
	"FULFILLLINEREQUESTCANCELDATE" DATE, 
	"FULFILLLINEREQUESTSHIPDATE" DATE, 
	"FULFILLLINERESERVABLEFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINERESERVEDQTY" NUMBER, 
	"FULFILLLINERETURNREASONCODE" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINERMADELIVEREDQTY" NUMBER, 
	"FULFILLLINEROOTPARENTFULFILLLINEIDPK" NUMBER(18,0) NOT NULL ENABLE, 
	"FULFILLLINEROOTPARENTFULFILLLINENUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"FULFILLLINESCHEDULEARRIVALDATE" DATE, 
	"FULFILLLINESCHEDULESHIPDATE" DATE, 
	"FULFILLLINESHIPCLASSOFSERVICE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"FULFILLLINESHIPMODEOFTRANSPORT" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"FULFILLLINESHIPTOPARTYCONTACTID" NUMBER(18,0), 
	"FULFILLLINESHIPTOPARTYID" NUMBER(18,0), 
	"FULFILLLINESHIPTOPARTYSITEID" NUMBER(18,0), 
	"FULFILLLINESHIPPABLEFLAG" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINESHIPPEDQTY" NUMBER, 
	"FULFILLLINESHIPPINGINSTRUCTIONS" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINESOURCELINEID" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINESOURCELINENUMBER" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINESOURCEORDERID" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINESOURCEORDERNUMBER" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINESTATUSCODE" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINETAXCLASSIFICATIONCODE" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINETAXEXEMPTFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEUNITLISTPRICE" NUMBER, 
	"FULFILLLINEUNITSELLINGPRICE" NUMBER, 
	"FULFILLLINEUNREFERENCEDRETURNFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"HEADERCANCELREASONCODE" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"HEADERCANCELEDFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"HEADERCHANGEVERSIONNUMBER" NUMBER(18,0), 
	"HEADERCREATEDBY" VARCHAR2(8) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"HEADERCREATIONDATE" DATE NOT NULL ENABLE, 
	"HEADERCUSTOMERPONUMBER" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"HEADERHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"HEADERLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"HEADERLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"HEADERLEGALENTITYID" NUMBER(18,0), 
	"HEADERONHOLD" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"HEADEROPENFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"HEADERORDERNUMBER" VARCHAR2(18) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"HEADERORDERTYPECODE" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"HEADERORDEREDDATE" DATE, 
	"HEADERORGID" NUMBER(18,0) NOT NULL ENABLE, 
	"HEADERREQUESTSHIPDATE" DATE, 
	"HEADERSALESPERSONID" NUMBER(18,0), 
	"HEADERSOLDTOPARTYCONTACTID" NUMBER(18,0), 
	"HEADERSOLDTOPARTYID" NUMBER(18,0), 
	"HEADERSOURCEDOCUMENTTYPECODE" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"HEADERSOURCEORDERSYSTEM" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"HEADERSOURCEORGID" NUMBER(18,0) NOT NULL ENABLE, 
	"HEADERSTATUSCODE" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"HEADERSUBMITTEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP", 
	"HEADERSUBMITTEDDATE" DATE, 
	"HEADERSUBMITTEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"HEADERTRANSACTIONALCURRENCYCODE" VARCHAR2(15) COLLATE "USING_NLS_COMP", 
	"LINEACTUALSHIPDATE" DATE, 
	"LINECANCELEDFLAG" VARCHAR2(1) COLLATE "USING_NLS_COMP", 
	"LINECANCELEDQTY" NUMBER, 
	"LINECATEGORYCODE" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"LINECREATEDBY" VARCHAR2(18) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"LINECREATIONDATE" DATE NOT NULL ENABLE, 
	"LINEDISPLAYLINENUMBER" VARCHAR2(9) COLLATE "USING_NLS_COMP", 
	"LINEFULFILLMENTDATE" DATE, 
	"LINEHEADERID" NUMBER(18,0) NOT NULL ENABLE, 
	"LINEINVENTORYITEMID" NUMBER(18,0), 
	"LINEITEMTYPECODE" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"LINELASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"LINELASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"LINELINEID" NUMBER(18,0) NOT NULL ENABLE, 
	"LINELINENUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"LINEONHOLD" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"LINEOPENFLAG" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"LINEORDEREDQTY" NUMBER, 
	"LINEORDEREDUOM" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"LINESCHEDULESHIPDATE" DATE, 
	"LINESHIPPEDQTY" NUMBER, 
	"LINESOURCELINEID" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"LINESOURCELINENUMBER" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"LINESOURCEORDERID" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESOURCEORDERNUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESOURCESCHEDULENUMBER" VARCHAR2(50) COLLATE "USING_NLS_COMP", 
	"LINESTATUSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"LINEUNITLISTPRICE" NUMBER, 
	"LINEUNITSELLINGPRICE" NUMBER, 
	"ROW_ACTIVE" CHAR(1) COLLATE "USING_NLS_COMP" DEFAULT 'A' NOT NULL ENABLE, 
	"AUDIT_ID" NUMBER NOT NULL ENABLE, 
	"DIM_ITEMREF_OM_ID" NUMBER, 
	"DIM_FULFILLLINESTATUS_OM_ID" NUMBER, 
	"FACT_LINEEXTRACT_OM_ID" NUMBER, 
	"DIM_INVORGPARAMETERS_OM_ID" NUMBER, 
	 CONSTRAINT "FACT_FULFILLLINE_OM_CK" CHECK (row_active IN ('A','I')) ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINE_OM__UN" UNIQUE ("FULFILLLINEID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "ST_FULFILLLINE_OM_PK" PRIMARY KEY ("FULFILLLINE_OM_ID")
  USING INDEX  ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINE_OM_DIM_FULFILLLINESTATUS_OM_FK" FOREIGN KEY ("DIM_FULFILLLINESTATUS_OM_ID")
	  REFERENCES "DWADW"."DIM_FULFILLLINESTATUS_OM" ("FULLFILLLINESTATUS_OM_ID") ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINE_OM_DIM_INVORGPARAMETERS_OM_FK" FOREIGN KEY ("DIM_INVORGPARAMETERS_OM_ID")
	  REFERENCES "DWADW"."DIM_INVORGPARAMETERS_OM" ("INVORGPARAMETERS_OM_ID") ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINE_OM_DIM_ITEMREF_OM_FK" FOREIGN KEY ("DIM_ITEMREF_OM_ID")
	  REFERENCES "DWADW"."DIM_ITEMREF_OM" ("ITEMREF_OM_ID") ENABLE, 
	 CONSTRAINT "FACT_FULFILLLINE_OM_FACT_LINEEXTRACT_OM_FK" FOREIGN KEY ("FACT_LINEEXTRACT_OM_ID")
	  REFERENCES "DWADW"."FACT_LINEEXTRACT_OM" ("LINEEXTRACT_OM_ID") ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

COMMENT ON TABLE "DWADW"."FACT_FULFILLLINE_OM"  IS 'Español: Tabla de hechos de cumplimiento de líneas de órdenes. Contiene cantidades ordenadas, cumplidas, canceladas y enviadas, precios, estados, artículos, organizaciones y fechas del proceso, y permite analizar el avance y cumplimiento de las órdenes a nivel de línea.
English: Order fulfillment line fact table. It contains ordered, fulfilled, canceled, and shipped quantities, prices, statuses, items, organizations, and process dates and supports analysis of order progress and fulfillment at line level.';

CREATE UNIQUE INDEX "DWADW"."FACT_FULFILLLINE_OM__UN" ON "DWADW"."FACT_FULFILLLINE_OM" ("FULFILLLINEID") 
  ;
  CREATE UNIQUE INDEX "DWADW"."ST_FULFILLLINE_OM_PK" ON "DWADW"."FACT_FULFILLLINE_OM" ("FULFILLLINE_OM_ID") 
  ;
  CREATE INDEX "DWADW"."FFL_TRACKING_OM_IDX" ON "DWADW"."FACT_FULFILLLINE_OM" ("FULFILLLINEHEADERID", "FULFILLLINELINEID", "HEADERHEADERID") 
  ;

← Volver a tablas de DWADW

🏠 Volver al menú principal