STADW.ST_FULFILLLINE

Base de datos origen: ADW COEXITO

Columnas

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

Restricciones

CHECK: SYS_C0034327

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

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

PK: SYS_C0034364

Estado: ENABLED
Columnas: ID

DDL

CREATE TABLE "STADW"."ST_FULFILLLINE" 
   (	"ID" NUMBER(*,0) GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"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(8,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(8,0), 
	"LINEUNITSELLINGPRICE" NUMBER(8,0), 
	 PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "STADW"."SYS_C0034364" ON "STADW"."ST_FULFILLLINE" ("ID") 
  ;

← Volver a tablas de STADW

🏠 Volver al menú principal