	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

254 COLUMNS | 5 INDEXES | 910 | 43 | F4311Z TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	910	F4311Z	PW	254	5	Purchase Order Generator File	Regular Work Files	43: Procurement	Business Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT PWCTID, PWJOBS, PWACTN, PWEDFL, PWKCOO, PWDOCO, PWDCTO, PWSFXO, PWLNID, PWMCU, PWCO, PWOKCO, PWOORN, PWOCTO, PWOGNO, PWRKCO, PWRORN, PWRCTO, PWRLLN, PWDMCT, PWDMCS, PWBALU, PWAN8, PWSHAN, PWDRQJ, PWTRDJ, PWPDDJ, PWOPDJ, PWADDJ, PWCNDJ, PWPEFJ, PWPPDJ, PWPSDJ, PWDSVJ, PWDGL, PWPN, PWVR01, PWVR02, PWITM, PWLITM, PWAITM, PWLOCN, PWLOTN, PWFRGD, PWTHGD, PWFRMP, PWTHRP, PWDSC1, PWDSC2, PWLNTY, PWNXTR, PWLTTR, PWRLIT, PWPDS1, PWPDS2, PWPDS3, PWPDS4, PWPDS5, PWPDP1, PWPDP2, PWPDP3, PWPDP4, PWPDP5, PWUOM, PWUORG, PWUCHG, PWUOPN, PWUREC, PWCREC, PWURLV, PWOTQY, PWPRRC, PWAEXP, PWACHG, PWAOPN, PWAREC, PWARLV, PWFTN1, PWTRLV, PWPROV, PWAMC3, PWECST, PWCSTO, PWCSMP, PWINMG, PWASN, PWPRGR, PWCLVL, PWCATN, PWDSPR, PWPTC, PWTX, PWEXR1, PWTXA1, PWATXT, PWCNID, PWCDCD, PWNTR, PWFRTH, PWFRTC, PWZON, PWFRAT, PWRATT, PWANBY, PWANCR, PWMOT, PWCOT, PWSHCM, PWSHCN, PWUOM1, PWPQOR, PWUOM2, PWSQOR, PWUOM3, PWITWT, PWWTUM, PWITVL, PWVLUM, PWGLC, PWCTRY, PWFY, PWSTTS, PWRCD, PWFUF1, PWFUF2, PWGRWT, PWGWUM, PWLT, PWANI, PWAID, PWOMCU, PWOBJ, PWSUB, PWSBLT, PWSBL, PWASID, PWCCMP, PWTAG, PWWR01, PWPL, PWELEV, PWR001, PWRTNR, PWLCOD, PWPURG, PWPROM, PWFNLP, PWAVCH, PWPRPY, PWUNCD, PWMATY, PWRTGC, PWRCPF, PWPS01, PWPS02, PWPS03, PWPS04, PWPS05, PWPS06, PWPS07, PWPS08, PWPS09, PWPS10, PWCRMD, PWARTG, PWCORD, PWCHDT, PWDOCC, PWCHLN, PWCRCD, PWCRR, PWFRRC, PWFEA, PWFUC, PWFEC, PWFCHG, PWFAP, PWFREC, PWURCD, PWURDT, PWURAT, PWURAB, PWURRF, PWTORG, PWUSER, PWPID, PWJOBN, PWUPMJ, PWTDAY, PWIVI, PWWRTH, PWPOGS, PWSTKT, PWCNV2, PWCONV, PWMODE, PWUKID, PWSOPO, PWSEQ, PWPSRY, PWPSR, PWSFX, PWMSGT, PWMTST, PWLNIX, PWAREV, PWDETD, PWDETF, PWABT1, PWABR1, PWABT2, PWABR2, PWABT3, PWABR3, PWABT4, PWABR4, PWOSFX, PWHCLD, PWDOC8, PWODCT, PWCO0, PWSFIX, PWLINN, PWSHPN, PWPEID, PWTCID, PWDUAL, PWPRJM, PWDLEJ, PWPMTN, PWXDCK, PWMCLN, PWUNSPSC, PWCMDCDE, PWRSFX, PWVR03, PWMACT, PWBLKT, PWAFND, PWWVID, PWCNTRTID, PWCNTRTDID, PWMOADJ, PWWVTY, PWPODC01, PWPODC02, PWPODC03, PWPODC04, PWJBCD, PWSRQTY, PWSRUOM, PWCFGFL, PWPMPN, PWPNS FROM F4311Z

TOP 910 | 43 | F4311Z COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PWCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	PWJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	PWACTN	Action Code	Character	Generic Edit	1	0	Allow NULL?
4	PWEDFL	Flag - Transaction Edit	Character	Generic Edit	1	0	Allow NULL?
5	PWKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
6	PWDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	PWDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
8	PWSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
9	PWLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
10	PWMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
11	PWCO	Company	String	Generic Edit	5	0	Allow NULL?
12	PWOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
13	PWOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
14	PWOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	PWOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
16	PWRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
17	PWRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
18	PWRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
19	PWRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
20	PWDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
21	PWDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
22	PWBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
23	PWAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
24	PWSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
25	PWDRQJ	Date - Requested	Date	Generic Edit	6	0
26	PWTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
27	PWPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
28	PWOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
29	PWADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
30	PWCNDJ	Date - Cancel	Date	Generic Edit	6	0
31	PWPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
32	PWPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
33	PWPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
34	PWDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
35	PWDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
36	PWPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
37	PWVR01	Reference	String	Generic Edit	25	0	Allow NULL?
38	PWVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
39	PWITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
40	PWLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
41	PWAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
42	PWLOCN	Location	String	Generic Edit	20	0	Allow NULL?
43	PWLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
44	PWFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
45	PWTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
46	PWFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
47	PWTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
48	PWDSC1	Description	String	Generic Edit	30	0	Allow NULL?
49	PWDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
50	PWLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
51	PWNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
52	PWLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
53	PWRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
54	PWPDS1	Reporting Code 1 - Sales	String	Generic Edit	3	0	Allow NULL?
55	PWPDS2	Reporting Code 2 - Sales	String	Generic Edit	3	0	Allow NULL?
56	PWPDS3	Reporting Code 3 - Sales	String	Generic Edit	3	0	Allow NULL?
57	PWPDS4	Reporting Code 4 - Sales	String	Generic Edit	3	0	Allow NULL?
58	PWPDS5	Reporting Code 5 - Sales	String	Generic Edit	3	0	Allow NULL?
59	PWPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
60	PWPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
61	PWPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
62	PWPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
63	PWPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
64	PWUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
65	PWUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
66	PWUCHG	Units - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
67	PWUOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
68	PWUREC	Units - Received	Numeric	Generic Edit	15	2	Allow NULL?
69	PWCREC	Units - Cumulative Received	Numeric	Generic Edit	15	2	Allow NULL?
70	PWURLV	Units - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
71	PWOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
72	PWPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
73	PWAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
74	PWACHG	Amount - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
75	PWAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
76	PWAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
77	PWARLV	Amount - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
78	PWFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
79	PWTRLV	Amount - Tax Relieved	Numeric	Generic Edit	15	2	Allow NULL?
80	PWPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
81	PWAMC3	Unit Cost - Purchasing	Numeric	Generic Edit	15	4	Allow NULL?
82	PWECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
83	PWCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
84	PWCSMP	Costing Method - Purchasing	Character	Generic Edit	1	0	Allow NULL?
85	PWINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
86	PWASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
87	PWPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
88	PWCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
89	PWCATN	Catalog	String	UDC (40 CN)	8	0	Allow NULL?
90	PWDSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
91	PWPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
92	PWTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
93	PWEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
94	PWTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
95	PWATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
96	PWCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
97	PWCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
98	PWNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
99	PWFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
100	PWFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
101	PWZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
102	PWFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
103	PWRATT	Rate Type - Freight/Misc	Character	Generic Edit	1	0	Allow NULL?
104	PWANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
105	PWANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
106	PWMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
107	PWCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
108	PWSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
109	PWSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
110	PWUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
111	PWPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
112	PWUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
113	PWSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
114	PWUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
115	PWITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
116	PWWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
117	PWITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
118	PWVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
119	PWGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
120	PWCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
121	PWFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
122	PWSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
123	PWRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
124	PWFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
125	PWFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
126	PWGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
127	PWGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
128	PWLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
129	PWANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
130	PWAID	Account ID	String	Generic Edit	8	0	Allow NULL?
131	PWOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
132	PWOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
133	PWSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
134	PWSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
135	PWSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
136	PWASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
137	PWCCMP	Cost Component Number	Numeric	Generic Edit	3	0	Allow NULL?
138	PWTAG	Tag - Reference	String	Generic Edit	8	0	Allow NULL?
139	PWWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
140	PWPL	Plan Number	String	Generic Edit	4	0	Allow NULL?
141	PWELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
142	PWR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
143	PWRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
144	PWLCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
145	PWPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
146	PWPROM	Processing Mode	Character	UDC (H40 PQ)	1	0	Allow NULL?
147	PWFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
148	PWAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
149	PWPRPY	Pre-Payment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
150	PWUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
151	PWMATY	Type - Match Type	Character	UDC (H40 MB)	1	0	Allow NULL?
152	PWRTGC	Routing Process (Y/N)	Character	Generic Edit	1	0	Allow NULL?
153	PWRCPF	Leadtime Recalculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
154	PWPS01	Transfer/Direct Ship Flag	Character	Generic Edit	1	0	Allow NULL?
155	PWPS02	Purchase Order Status 02	Character	Generic Edit	1	0	Allow NULL?
156	PWPS03	Purchase Order Status 03	Character	Generic Edit	1	0	Allow NULL?
157	PWPS04	Purchase Order Status 04	Character	Generic Edit	1	0	Allow NULL?
158	PWPS05	Purchase Order Status 05	Character	Generic Edit	1	0	Allow NULL?
159	PWPS06	Purchase Order Status 06	Character	Generic Edit	1	0	Allow NULL?
160	PWPS07	Purchase Order Status 07	Character	Generic Edit	1	0	Allow NULL?
161	PWPS08	Purchase Order Status 08	Character	Generic Edit	1	0	Allow NULL?
162	PWPS09	Purchase Order Status 09	Character	Generic Edit	1	0	Allow NULL?
163	PWPS10	Purchase Order Status 10	Character	UDC (00 XS)	1	0	Allow NULL?
164	PWCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
165	PWARTG	Code - Approval Routing	String	Generic Edit	12	0	Allow NULL?
166	PWCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
167	PWCHDT	Change Order Type	String	UDC (00 DT)	2	0	Allow NULL?
168	PWDOCC	Document (Change Order #)	Numeric	Generic Edit	8	0	Allow NULL?
169	PWCHLN	Change Order Line Number	Numeric	Generic Edit	7	3	Allow NULL?
170	PWCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
171	PWCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
172	PWFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
173	PWFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
174	PWFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
175	PWFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
176	PWFCHG	Amount - Foreign Changed Amount	Numeric	Generic Edit	15	2	Allow NULL?
177	PWFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
178	PWFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
179	PWURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
180	PWURDT	User Reserved Date	Date	Generic Edit	6	0
181	PWURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
182	PWURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
183	PWURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
184	PWTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
185	PWUSER	User ID	String	Generic Edit	10	0	Allow NULL?
186	PWPID	Program ID	String	Generic Edit	10	0	Allow NULL?
187	PWJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
188	PWUPMJ	Date - Updated	Date	Generic Edit	6	0
189	PWTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
190	PWIVI	Inventory Interface Y/N - Distribution	Character	UDC (H40 IV)	1	0	Allow NULL?
191	PWWRTH	Flag - Write Ledger Record (Y/N)	Character	Generic Edit	1	0	Allow NULL?
192	PWPOGS	PO Generator Source System	Character	Generic Edit	1	0	Allow NULL?
193	PWSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
194	PWCNV2	Conversion Factor - Purchasing to Primar	Numeric	Generic Edit	15	7	Allow NULL?
195	PWCONV	Conversion Factor	Numeric	Generic Edit	15	7	Allow NULL?
196	PWMODE	Mode - Processing	Character	Generic Edit	1	0	Allow NULL?
197	PWUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
198	PWSOPO	Flag - Sales/Purchasing	Character	Generic Edit	1	0	Allow NULL?
199	PWSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
200	PWPSRY	Source Type	String	UDC (38 DY)	2	0	Allow NULL?
201	PWPSR	Source	String	Generic Edit	12	0	Allow NULL?
202	PWSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
203	PWMSGT	Message Type	Character	UDC (34 MT)	1	0	Allow NULL?
204	PWMTST	Material Status Code W.O.	String	UDC (31 MS)	2	0	Allow NULL?
205	PWLNIX	Line Number - X-REF	Numeric	Generic Edit	6	3	Allow NULL?
206	PWAREV	Adjustment Revision Level	Numeric	Generic Edit	3	0	Allow NULL?
207	PWDETD	Amount - Detached Adj. Domestic	Numeric	Generic Edit	15	4	Allow NULL?
208	PWDETF	Amount - Detached Adj. Foreign	Numeric	Generic Edit	15	4	Allow NULL?
209	PWABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
210	PWABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
211	PWABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
212	PWABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
213	PWABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
214	PWABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
215	PWABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
216	PWABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
217	PWOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
218	PWHCLD	Hold Code	Character	UDC (34 HC)	1	0	Allow NULL?
219	PWDOC8	Document	String	Generic Edit	8	0	Allow NULL?
220	PWODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
221	PWCO0	Company	String	Generic Edit	5	0	Allow NULL?
222	PWSFIX	Suffix	String	Generic Edit	3	0	Allow NULL?
223	PWLINN	Line Number	Numeric	Generic Edit	7	3	Allow NULL?
224	PWSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
225	PWPEID	Process ID	Numeric	Generic Edit	15	0	Allow NULL?
226	PWTCID	Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
227	PWDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
228	PWPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
229	PWDLEJ	Lot Effectivity Date	Date	Generic Edit	6	0
230	PWPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
231	PWXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
232	PWMCLN	Matrix Control Line Number	Numeric	Generic Edit	6	3	Allow NULL?
233	PWUNSPSC	UNSPSC Commodity Code	String	Generic Edit	8	0	Allow NULL?
234	PWCMDCDE	Commodity Code	String	Generic Edit	15	0	Allow NULL?
235	PWRSFX	Related Order Suffix	String	Generic Edit	3	0	Allow NULL?
236	PWVR03	Reference	String	Generic Edit	25	0	Allow NULL?
237	PWMACT	Multiple Accounts	Character	UDC (40 MU)	1	0	Allow NULL?
238	PWBLKT	Blankets Exists	Character	Generic Edit	1	0	Allow NULL?
239	PWAFND	Contracts Found	Numeric	Generic Edit	15	0	Allow NULL?
240	PWWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
241	PWCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
242	PWCNTRTDID	Contract Detail ID	Numeric	Generic Edit	15	0	Allow NULL?
243	PWMOADJ	Manual Override Adjustment Flag	Character	Check Box	1	0	Allow NULL?
244	PWWVTY	Vessel Class	Character	Generic Edit	1	0	Allow NULL?
245	PWPODC01	Purchase Line Code 01	String	UDC (43 C7)	3	0	Allow NULL?
246	PWPODC02	Purchase Line Code 02	String	UDC (43 C8)	3	0	Allow NULL?
247	PWPODC03	Purchase Line Code 03	String	UDC (43 L7)	10	0	Allow NULL?
248	PWPODC04	Purchase Line Code 04	String	UDC (43 L8)	10	0	Allow NULL?
249	PWJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
250	PWSRQTY	Service Quantity	Numeric	Generic Edit	15	4	Allow NULL?
251	PWSRUOM	Service Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
252	PWCFGFL	Created By Configurator Flag	Character	Generic Edit	1	0	Allow NULL?
253	PWPMPN	Production Number	String	Generic Edit	30	0	Allow NULL?
254	PWPNS	Production Number Short	Numeric	Generic Edit	10	0	Allow NULL?

TOP 910 | 43 | F4311Z INDEXES

Number

Description

Machine Key Job Number A (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	PEID	Process ID	Ascending
3	TCID	Transaction ID	Ascending
4	JOBS	Job Number	Ascending
5	SFXO	Order Suffix	Ascending
6	LNID	Line Number	Ascending

Original Order Number Type +

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
3	OORN	Original Order Number	Ascending
4	OCTO	Original Order Type	Ascending
5	OKCO	Document Company (Original Order)	Ascending
6	OGNO	Original Line Number	Ascending

Original Order Type Key +

Element	Alias	Description	Sequence
1	OORN	Original Order Number	Ascending
2	OCTO	Original Order Type	Ascending
3	OKCO	Document Company (Original Order)	Ascending
4	OGNO	Original Line Number	Ascending
5	SFX	Document Pay Item	Ascending

CTID PEID TCID JOBS A+

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	PEID	Process ID	Ascending
3	TCID	Transaction ID	Ascending
4	JOBS	Job Number	Ascending
5	SFXO	Order Suffix	Ascending
6	ACTN	Action Code	Ascending
7	LNID	Line Number	Ascending

CTID PEID TCID MCLN+

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	PEID	Process ID	Ascending
3	TCID	Transaction ID	Ascending
4	JOBS	Job Number	Ascending
5	SFXO	Order Suffix	Ascending
6	MCLN	Matrix Control Line Number	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

254 COLUMNS | 5 INDEXES | 910 | 43 | F4311Z TABLE

TOP 910 | 43 | F4311Z COLUMNS

TOP 910 | 43 | F4311Z INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

254 COLUMNS | 5 INDEXES | 910 | 43 | F4311Z TABLE

TOP910 | 43 | F4311Z COLUMNS

TOP910 | 43 | F4311Z INDEXES

TOP 910 | 43 | F4311Z COLUMNS

TOP 910 | 43 | F4311Z INDEXES