	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

218 COLUMNS | 10 INDEXES | 812 | 43 | F4311 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	812	F4311	PD	218	10	Purchase Order Detail File	Transaction Files	43: Procurement	AS400 Coexistence Tables

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 PDKCOO, PDDOCO, PDDCTO, PDSFXO, PDLNID, PDMCU, PDCO, PDOKCO, PDOORN, PDOCTO, PDOGNO, PDRKCO, PDRORN, PDRCTO, PDRLLN, PDDMCT, PDDMCS, PDBALU, PDAN8, PDSHAN, PDDRQJ, PDTRDJ, PDPDDJ, PDOPDJ, PDADDJ, PDCNDJ, PDPEFJ, PDPPDJ, PDPSDJ, PDDSVJ, PDDGL, PDPN, PDVR01, PDVR02, PDITM, PDLITM, PDAITM, PDLOCN, PDLOTN, PDFRGD, PDTHGD, PDFRMP, PDTHRP, PDDSC1, PDDSC2, PDLNTY, PDNXTR, PDLTTR, PDRLIT, PDPDS1, PDPDS2, PDPDS3, PDPDS4, PDPDS5, PDPDP1, PDPDP2, PDPDP3, PDPDP4, PDPDP5, PDUOM, PDUORG, PDUCHG, PDUOPN, PDUREC, PDCREC, PDURLV, PDOTQY, PDPRRC, PDAEXP, PDACHG, PDAOPN, PDAREC, PDARLV, PDFTN1, PDTRLV, PDPROV, PDAMC3, PDECST, PDCSTO, PDCSMP, PDINMG, PDASN, PDPRGR, PDCLVL, PDCATN, PDDSPR, PDPTC, PDTX, PDEXR1, PDTXA1, PDATXT, PDCNID, PDCDCD, PDNTR, PDFRTH, PDFRTC, PDZON, PDFRAT, PDRATT, PDANBY, PDANCR, PDMOT, PDCOT, PDSHCM, PDSHCN, PDUOM1, PDPQOR, PDUOM2, PDSQOR, PDUOM3, PDITWT, PDWTUM, PDITVL, PDVLUM, PDGLC, PDCTRY, PDFY, PDSTTS, PDRCD, PDFUF1, PDFUF2, PDGRWT, PDGWUM, PDLT, PDANI, PDAID, PDOMCU, PDOBJ, PDSUB, PDSBLT, PDSBL, PDASID, PDCCMP, PDTAG, PDWR01, PDPL, PDELEV, PDR001, PDRTNR, PDLCOD, PDPURG, PDPROM, PDFNLP, PDAVCH, PDPRPY, PDUNCD, PDMATY, PDRTGC, PDRCPF, PDPS01, PDPS02, PDPS03, PDPS04, PDPS05, PDPS06, PDPS07, PDPS08, PDPS09, PDPS10, PDCRMD, PDARTG, PDCORD, PDCHDT, PDDOCC, PDCHLN, PDCRCD, PDCRR, PDFRRC, PDFEA, PDFUC, PDFEC, PDFCHG, PDFAP, PDFREC, PDURCD, PDURDT, PDURAT, PDURAB, PDURRF, PDTORG, PDUSER, PDPID, PDJOBN, PDUPMJ, PDTDAY, PDVR05, PDVR04, PDSHPN, PDRSHT, PDPRJM, PDOSFX, PDMERL, PDMCLN, PDMACT, PDKTLN, PDFTRL, PDDUAL, PDDRQT, PDDLEJ, PDCTAM, PDCPNT, PDCHT, PDCHRT, PDCHRS, PDCHMJ, PDBCRC, PDVR03, PDLDNM, PDMKFR, PDPMTN, PDUKID, PDUNSPSC, PDCMDCDE, PDRSFX, PDWVID, PDCNTRTID, PDCNTRTDID, PDMOADJ FROM F4311

TOP 812 | 43 | F4311 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PDKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
2	PDDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	PDDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	PDSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
5	PDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
6	PDMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
7	PDCO	Company	String	Generic Edit	5	0	Allow NULL?
8	PDOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
9	PDOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
10	PDOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
11	PDOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
12	PDRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
13	PDRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
14	PDRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	PDRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
16	PDDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
17	PDDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
18	PDBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
19	PDAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
20	PDSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
21	PDDRQJ	Date - Requested	Date	Generic Edit	6	0
22	PDTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
23	PDPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
24	PDOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
25	PDADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
26	PDCNDJ	Date - Cancel	Date	Generic Edit	6	0
27	PDPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
28	PDPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
29	PDPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
30	PDDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
31	PDDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
32	PDPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
33	PDVR01	Reference	String	Generic Edit	25	0	Allow NULL?
34	PDVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
35	PDITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
36	PDLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
37	PDAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
38	PDLOCN	Location	String	Generic Edit	20	0	Allow NULL?
39	PDLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
40	PDFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
41	PDTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
42	PDFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
43	PDTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
44	PDDSC1	Description	String	Generic Edit	30	0	Allow NULL?
45	PDDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
46	PDLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
47	PDNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
48	PDLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
49	PDRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
50	PDPDS1	Reporting Code 1 - Sales	String	Generic Edit	3	0	Allow NULL?
51	PDPDS2	Reporting Code 2 - Sales	String	Generic Edit	3	0	Allow NULL?
52	PDPDS3	Reporting Code 3 - Sales	String	Generic Edit	3	0	Allow NULL?
53	PDPDS4	Reporting Code 4 - Sales	String	Generic Edit	3	0	Allow NULL?
54	PDPDS5	Reporting Code 5 - Sales	String	Generic Edit	3	0	Allow NULL?
55	PDPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
56	PDPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
57	PDPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
58	PDPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
59	PDPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
60	PDUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
61	PDUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
62	PDUCHG	Units - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
63	PDUOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
64	PDUREC	Units - Received	Numeric	Generic Edit	15	2	Allow NULL?
65	PDCREC	Units - Cumulative Received	Numeric	Generic Edit	15	2	Allow NULL?
66	PDURLV	Units - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
67	PDOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
68	PDPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
69	PDAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
70	PDACHG	Amount - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
71	PDAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
72	PDAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
73	PDARLV	Amount - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
74	PDFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
75	PDTRLV	Amount - Tax Relieved	Numeric	Generic Edit	15	2	Allow NULL?
76	PDPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
77	PDAMC3	Unit Cost - Purchasing	Numeric	Generic Edit	15	4	Allow NULL?
78	PDECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
79	PDCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
80	PDCSMP	Costing Method - Purchasing	Character	Generic Edit	1	0	Allow NULL?
81	PDINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
82	PDASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
83	PDPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
84	PDCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
85	PDCATN	Catalog	String	UDC (40 CN)	8	0	Allow NULL?
86	PDDSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
87	PDPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
88	PDTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
89	PDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
90	PDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
91	PDATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
92	PDCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
93	PDCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
94	PDNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
95	PDFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
96	PDFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
97	PDZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
98	PDFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
99	PDRATT	Rate Type - Freight/Misc	Character	Generic Edit	1	0	Allow NULL?
100	PDANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
101	PDANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
102	PDMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
103	PDCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
104	PDSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
105	PDSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
106	PDUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
107	PDPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
108	PDUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
109	PDSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
110	PDUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
111	PDITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
112	PDWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
113	PDITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
114	PDVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
115	PDGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
116	PDCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
117	PDFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
118	PDSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
119	PDRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
120	PDFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
121	PDFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
122	PDGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
123	PDGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
124	PDLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
125	PDANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
126	PDAID	Account ID	String	Generic Edit	8	0	Allow NULL?
127	PDOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
128	PDOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
129	PDSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
130	PDSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
131	PDSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
132	PDASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
133	PDCCMP	Cost Component Number	Numeric	Generic Edit	3	0	Allow NULL?
134	PDTAG	Tag - Reference	String	Generic Edit	8	0	Allow NULL?
135	PDWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
136	PDPL	Plan Number	String	Generic Edit	4	0	Allow NULL?
137	PDELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
138	PDR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
139	PDRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
140	PDLCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
141	PDPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
142	PDPROM	Processing Mode	Character	UDC (H40 PQ)	1	0	Allow NULL?
143	PDFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
144	PDAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
145	PDPRPY	Pre-Payment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
146	PDUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
147	PDMATY	Type - Match Type	Character	UDC (H40 MB)	1	0	Allow NULL?
148	PDRTGC	Routing Process (Y/N)	Character	Generic Edit	1	0	Allow NULL?
149	PDRCPF	Leadtime Recalculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
150	PDPS01	Transfer/Direct Ship Flag	Character	Generic Edit	1	0	Allow NULL?
151	PDPS02	Purchase Order Status 02	Character	Generic Edit	1	0	Allow NULL?
152	PDPS03	Purchase Order Status 03	Character	Generic Edit	1	0	Allow NULL?
153	PDPS04	Purchase Order Status 04	Character	Generic Edit	1	0	Allow NULL?
154	PDPS05	Purchase Order Status 05	Character	Generic Edit	1	0	Allow NULL?
155	PDPS06	Purchase Order Status 06	Character	Generic Edit	1	0	Allow NULL?
156	PDPS07	Purchase Order Status 07	Character	Generic Edit	1	0	Allow NULL?
157	PDPS08	Purchase Order Status 08	Character	Generic Edit	1	0	Allow NULL?
158	PDPS09	Purchase Order Status 09	Character	Generic Edit	1	0	Allow NULL?
159	PDPS10	Purchase Order Status 10	Character	UDC (00 XS)	1	0	Allow NULL?
160	PDCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
161	PDARTG	Code - Approval Routing	String	Generic Edit	12	0	Allow NULL?
162	PDCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
163	PDCHDT	Change Order Type	String	UDC (00 DT)	2	0	Allow NULL?
164	PDDOCC	Document (Change Order #)	Numeric	Generic Edit	8	0	Allow NULL?
165	PDCHLN	Change Order Line Number	Numeric	Generic Edit	7	3	Allow NULL?
166	PDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
167	PDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
168	PDFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
169	PDFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
170	PDFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
171	PDFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
172	PDFCHG	Amount - Foreign Changed Amount	Numeric	Generic Edit	15	2	Allow NULL?
173	PDFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
174	PDFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
175	PDURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
176	PDURDT	User Reserved Date	Date	Generic Edit	6	0
177	PDURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
178	PDURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
179	PDURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
180	PDTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
181	PDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
182	PDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
183	PDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
184	PDUPMJ	Date - Updated	Date	Generic Edit	6	0
185	PDTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
186	PDVR05	Outside Reference 2	String	Generic Edit	25	0	Allow NULL?
187	PDVR04	Outside Reference 1	String	Generic Edit	25	0	Allow NULL?
188	PDSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
189	PDRSHT	Requested Ship Time	Numeric	Generic Edit	6	0	Allow NULL?
190	PDPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
191	PDOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
192	PDMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
193	PDMCLN	Matrix Control Line Number	Numeric	Generic Edit	6	3	Allow NULL?
194	PDMACT	Multiple Accounts	Character	UDC (40 MU)	1	0	Allow NULL?
195	PDKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
196	PDFTRL	Amount - Foreign Tax Relieved	Numeric	Generic Edit	15	2	Allow NULL?
197	PDDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
198	PDDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
199	PDDLEJ	Lot Effectivity Date	Date	Generic Edit	6	0
200	PDCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
201	PDCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
202	PDCHT	Change Order Time of Day	Numeric	Generic Edit	7	0	Allow NULL?
203	PDCHRT	Time - Scheduled Required (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
204	PDCHRS	Shift Code - Scheduled Required	Character	UDC (00 SH)	1	0	Allow NULL?
205	PDCHMJ	Change Order Date - Updated	Date	Generic Edit	6	0
206	PDBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
207	PDVR03	Reference	String	Generic Edit	25	0	Allow NULL?
208	PDLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
209	PDMKFR	Address Number - Mark-for	Numeric	Generic Edit	8	0	Allow NULL?
210	PDPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
211	PDUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
212	PDUNSPSC	UNSPSC Commodity Code	String	Generic Edit	8	0	Allow NULL?
213	PDCMDCDE	Commodity Code	String	Generic Edit	15	0	Allow NULL?
214	PDRSFX	Related Order Suffix	String	Generic Edit	3	0	Allow NULL?
215	PDWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
216	PDCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
217	PDCNTRTDID	Contract Detail ID	Numeric	Generic Edit	15	0	Allow NULL?
218	PDMOADJ	Manual Override Adjustment Flag	Character	Check Box	1	0	Allow NULL?

TOP 812 | 43 | F4311 INDEXES

Number

Description

Doc No Order Type + 1 (Primary/Unique)

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SFXO	Order Suffix	Ascending
5	LNID	Line Number	Ascending

Order Type Next Status +

Element	Alias	Description	Sequence
1	DCTO	Order Type	Ascending
2	NXTR	Status Code - Next	Ascending
3	LNTY	Line Type	Ascending

Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

Item Number Branch + A

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	MCU	Business Unit	Ascending
3	PDDJ	Date - Scheduled Pick	Ascending

Item Number Order Type +

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	DCTO	Order Type	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	SFXO	Order Suffix	Ascending
6	LNID	Line Number	Ascending

Order Number Order Type +

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	PDDJ	Date - Scheduled Pick	Ascending

Address No Item no (Short) +

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	ITM	Item Number - Short	Ascending
3	UOM	Unit of Measure as Input	Ascending
4	CRCD	Currency Code - From	Ascending
5	OTQY	Other Quantity (1/2)	Ascending
6	DCTO	Order Type	Ascending
7	DOCO	Document (Order No Invoice etc.)	Ascending

AID DCTO DOCO KCOO SFXO LNID

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending
2	DCTO	Order Type	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	SFXO	Order Suffix	Ascending
6	LNID	Line Number	Ascending

Subledger Subledger Type

Element	Alias	Description	Sequence
1	SBL	Subledger - G/L	Ascending
2	SBLT	Subledger Type	Ascending

DOCO DCTO KCOO SHAN +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SHAN	Address Number - Ship To	Ascending
5	SFXO	Order Suffix	Ascending
6	LNID	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

218 COLUMNS | 10 INDEXES | 812 | 43 | F4311 TABLE

TOP 812 | 43 | F4311 COLUMNS

TOP 812 | 43 | F4311 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

218 COLUMNS | 10 INDEXES | 812 | 43 | F4311 TABLE

TOP812 | 43 | F4311 COLUMNS

TOP812 | 43 | F4311 INDEXES

TOP 812 | 43 | F4311 COLUMNS

TOP 812 | 43 | F4311 INDEXES