STADW.ST_FULFILLLINE_OM_TMP_26196

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo
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(8,0)	SI
23	FULFILLLINECATEGORYCODE	VARCHAR2(8)	SI
24	FULFILLLINECREATEDBY	VARCHAR2(9)	NO
25	FULFILLLINECREATIONDATE	DATE	NO
26	FULFILLLINECUSTOMERPONUMBER	VARCHAR2(8)	SI
27	FULFILLLINEESTIMATEFULFILLMENTCOST	NUMBER(8,0)	SI
28	FULFILLLINEFULFILLFLAG	VARCHAR2(18)	SI
29	FULFILLLINEFULFILLLINENUMBER	NUMBER(9,0)	NO
30	FULFILLLINEFULFILLORGID	NUMBER(18,0)	SI
31	FULFILLLINEFULFILLEDQTY	NUMBER(8,0)	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(8,0)	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(8,0)	SI
59	FULFILLLINERETURNREASONCODE	VARCHAR2(8)	SI
60	FULFILLLINERMADELIVEREDQTY	NUMBER(8,0)	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(8,0)	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(18,0)	SI
81	FULFILLLINEUNITSELLINGPRICE	NUMBER(8,0)	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(8,0)	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(8,0)	SI
129	LINEORDEREDUOM	VARCHAR2(8)	SI
130	LINESCHEDULESHIPDATE	DATE	SI
131	LINESHIPPEDQTY	NUMBER(8,0)	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(18,0)	SI
139	LINEUNITSELLINGPRICE	NUMBER(8,0)	SI

Restricciones

CHECK: SYS_C00291573

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

CHECK: SYS_C00291574

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

CHECK: SYS_C00291575

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

CHECK: SYS_C00291576

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

CHECK: SYS_C00291577

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

CHECK: SYS_C00291578

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

CHECK: SYS_C00291579

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

CHECK: SYS_C00291580

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

CHECK: SYS_C00291581

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

CHECK: SYS_C00291582

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

CHECK: SYS_C00291583

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

CHECK: SYS_C00291584

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

CHECK: SYS_C00291585

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

CHECK: SYS_C00291586

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

CHECK: SYS_C00291587

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

CHECK: SYS_C00291588

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

CHECK: SYS_C00291589

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

CHECK: SYS_C00291590

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

CHECK: SYS_C00291591

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

CHECK: SYS_C00291592

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

CHECK: SYS_C00291593

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

CHECK: SYS_C00291594

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

CHECK: SYS_C00291595

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

CHECK: SYS_C00291596

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

CHECK: SYS_C00291597

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

CHECK: SYS_C00291598

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

CHECK: SYS_C00291599

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

CHECK: SYS_C00291600

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

CHECK: SYS_C00291601

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

CHECK: SYS_C00291602

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

CHECK: SYS_C00291603

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

CHECK: SYS_C00291604

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

CHECK: SYS_C00291605

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

CHECK: SYS_C00291606

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

CHECK: SYS_C00291607

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

CHECK: SYS_C00291608

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

DDL

CREATE TABLE "STADW"."ST_FULFILLLINE_OM_TMP_26196" 
   (	"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(8,0), 
	"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(8,0), 
	"FULFILLLINEFULFILLFLAG" VARCHAR2(18) COLLATE "USING_NLS_COMP", 
	"FULFILLLINEFULFILLLINENUMBER" NUMBER(9,0) NOT NULL ENABLE, 
	"FULFILLLINEFULFILLORGID" NUMBER(18,0), 
	"FULFILLLINEFULFILLEDQTY" NUMBER(8,0), 
	"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(8,0) 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(8,0), 
	"FULFILLLINERETURNREASONCODE" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"FULFILLLINERMADELIVEREDQTY" NUMBER(8,0), 
	"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(8,0), 
	"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(18,0), 
	"FULFILLLINEUNITSELLINGPRICE" NUMBER(8,0), 
	"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(8,0), 
	"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(8,0), 
	"LINEORDEREDUOM" VARCHAR2(8) COLLATE "USING_NLS_COMP", 
	"LINESCHEDULESHIPDATE" DATE, 
	"LINESHIPPEDQTY" NUMBER(8,0), 
	"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(18,0), 
	"LINEUNITSELLINGPRICE" NUMBER(8,0)
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

← Volver a tablas de STADW

🏠 Volver al menú principal