STADW.ST_FULFILLLINE_OM

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_C0034328

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

CHECK: SYS_C0034329

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

CHECK: SYS_C0034330

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

CHECK: SYS_C0034331

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

CHECK: SYS_C0034332

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

CHECK: SYS_C0034333

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

CHECK: SYS_C0034334

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

CHECK: SYS_C0034335

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

CHECK: SYS_C0034336

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

CHECK: SYS_C0034337

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

CHECK: SYS_C0034338

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

CHECK: SYS_C0034339

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

CHECK: SYS_C0034340

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

CHECK: SYS_C0034341

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

CHECK: SYS_C0034342

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

CHECK: SYS_C0034343

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

CHECK: SYS_C0034344

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

CHECK: SYS_C0034345

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

CHECK: SYS_C0034346

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

CHECK: SYS_C0034347

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

CHECK: SYS_C0034348

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

CHECK: SYS_C0034349

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

CHECK: SYS_C0034350

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

CHECK: SYS_C0034351

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

CHECK: SYS_C0034352

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

CHECK: SYS_C0034353

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

CHECK: SYS_C0034354

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

CHECK: SYS_C0034355

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

CHECK: SYS_C0034356

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

CHECK: SYS_C0034357

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

CHECK: SYS_C0034358

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

CHECK: SYS_C0034359

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

CHECK: SYS_C0034360

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

CHECK: SYS_C0034361

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

CHECK: SYS_C0034362

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

CHECK: SYS_C0034363

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

DDL

CREATE TABLE "STADW"."ST_FULFILLLINE_OM" 
   (	"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" ;

GRANT ALTER ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT DELETE ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT INDEX ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT INSERT ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT SELECT ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT UPDATE ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT REFERENCES ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT READ ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT ON COMMIT REFRESH ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT QUERY REWRITE ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT DEBUG ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT FLASHBACK ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";
  GRANT ASSERTION REFERENCES ON "STADW"."ST_FULFILLLINE_OM" TO "BICC";

← Volver a tablas de STADW

🏠 Volver al menú principal