🏠 Menú principal

← Volver a tablas

---

STADW.ST_FULFILLLINE_OM_TMP_39482

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	IDMAESTROCARGUE	NUMBER(18,0)	NO
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

Restricciones

CHECK: SYS_C00356022

• Estado: ENABLED
• Columnas: IDMAESTROCARGUE
• Condición: "IDMAESTROCARGUE" IS NOT NULL

CHECK: SYS_C00356023

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

CHECK: SYS_C00356024

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

CHECK: SYS_C00356025

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

CHECK: SYS_C00356026

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

CHECK: SYS_C00356027

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

CHECK: SYS_C00356028

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

CHECK: SYS_C00356029

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

CHECK: SYS_C00356030

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

CHECK: SYS_C00356031

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

CHECK: SYS_C00356032

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

CHECK: SYS_C00356033

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

CHECK: SYS_C00356034

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

CHECK: SYS_C00356035

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

CHECK: SYS_C00356036

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

CHECK: SYS_C00356037

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

CHECK: SYS_C00356038

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

CHECK: SYS_C00356039

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

CHECK: SYS_C00356040

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

CHECK: SYS_C00356041

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

CHECK: SYS_C00356042

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

CHECK: SYS_C00356043

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

CHECK: SYS_C00356044

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

CHECK: SYS_C00356045

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

CHECK: SYS_C00356046

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

CHECK: SYS_C00356047

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

CHECK: SYS_C00356048

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

CHECK: SYS_C00356049

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

CHECK: SYS_C00356050

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

CHECK: SYS_C00356051

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

CHECK: SYS_C00356052

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

CHECK: SYS_C00356053

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

CHECK: SYS_C00356054

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

CHECK: SYS_C00356055

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

CHECK: SYS_C00356056

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

CHECK: SYS_C00356057

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

DDL

CREATE TABLE "STADW"."ST_FULFILLLINE_OM_TMP_39482" 
   (	"IDMAESTROCARGUE" NUMBER(18,0) 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
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal