	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

89 COLUMNS | 5 INDEXES | 812 | 43 | F4301 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	812	F4301	PH	89	5	Purchase Order Header	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 PHKCOO, PHDOCO, PHDCTO, PHSFXO, PHMCU, PHOKCO, PHOORN, PHOCTO, PHRKCO, PHRORN, PHRCTO, PHAN8, PHSHAN, PHDRQJ, PHTRDJ, PHPDDJ, PHOPDJ, PHADDJ, PHCNDJ, PHPEFJ, PHPPDJ, PHPSDJ, PHVR01, PHVR02, PHDEL1, PHDEL2, PHRMK, PHDESC, PHINMG, PHASN, PHPRGP, PHPTC, PHEXR1, PHTXA1, PHTXCT, PHHOLD, PHATXT, PHINVC, PHNTR, PHCNID, PHFRTH, PHZON, PHANBY, PHANCR, PHMOT, PHCOT, PHRCD, PHFRTC, PHFUF1, PHFUF2, PHOTOT, PHPCRT, PHRTNR, PHWUMD, PHVUMD, PHPURG, PHLGCT, PHPROM, PHMATY, PHOSTS, PHAVCH, PHPRPY, PHCRMD, PHPRP5, PHARTG, PHCORD, PHCRRM, PHCRCD, PHCRR, PHLNGP, PHFAP, PHORBY, PHTKBY, PHURCD, PHURDT, PHURAT, PHURAB, PHURRF, PHUSER, PHPID, PHJOBN, PHUPMJ, PHTDAY, PHRSHT, PHDRQT, PHDOC1, PHDCT4, PHBCRC, PHMKFR FROM F4301

TOP 812 | 43 | F4301 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PHKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
2	PHDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	PHDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	PHSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
5	PHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	PHOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
7	PHOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
8	PHOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
9	PHRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
10	PHRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
11	PHRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
12	PHAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
13	PHSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
14	PHDRQJ	Date - Requested	Date	Generic Edit	6	0
15	PHTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
16	PHPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
17	PHOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
18	PHADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
19	PHCNDJ	Date - Cancel	Date	Generic Edit	6	0
20	PHPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
21	PHPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
22	PHPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
23	PHVR01	Reference	String	Generic Edit	25	0	Allow NULL?
24	PHVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
25	PHDEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
26	PHDEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
27	PHRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
28	PHDESC	Description	String	Generic Edit	30	0	Allow NULL?
29	PHINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
30	PHASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
31	PHPRGP	Pricing Group	String	UDC (40 PC)	8	0	Allow NULL?
32	PHPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
33	PHEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
34	PHTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
35	PHTXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
36	PHHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
37	PHATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
38	PHINVC	Invoice Copies	Numeric	Generic Edit	2	0	Allow NULL?
39	PHNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
40	PHCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
41	PHFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
42	PHZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
43	PHANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
44	PHANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
45	PHMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
46	PHCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
47	PHRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
48	PHFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
49	PHFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
50	PHFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
51	PHOTOT	Amount - Order Gross	Numeric	Generic Edit	15	2	Allow NULL?
52	PHPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
53	PHRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
54	PHWUMD	Unit of Measure - Weight Display	String	UDC (00 UM)	2	0	Allow NULL?
55	PHVUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
56	PHPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
57	PHLGCT	Logic Control	Character	Generic Edit	1	0	Allow NULL?
58	PHPROM	Processing Mode	Character	UDC (H40 PQ)	1	0	Allow NULL?
59	PHMATY	Type - Match Type	Character	UDC (H40 MB)	1	0	Allow NULL?
60	PHOSTS	Status - Purchase Order	Character	Generic Edit	1	0	Allow NULL?
61	PHAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
62	PHPRPY	Pre-Payment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
63	PHCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
64	PHPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
65	PHARTG	Code - Approval Routing	String	Generic Edit	12	0	Allow NULL?
66	PHCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
67	PHCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
68	PHCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
69	PHCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
70	PHLNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
71	PHFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
72	PHORBY	Ordered By	String	Generic Edit	10	0	Allow NULL?
73	PHTKBY	Order Taken By	String	Generic Edit	10	0	Allow NULL?
74	PHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
75	PHURDT	User Reserved Date	Date	Generic Edit	6	0
76	PHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
77	PHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
78	PHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
79	PHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
80	PHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
81	PHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
82	PHUPMJ	Date - Updated	Date	Generic Edit	6	0
83	PHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
84	PHRSHT	Requested Ship Time	Numeric	Generic Edit	6	0	Allow NULL?
85	PHDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
86	PHDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
87	PHDCT4	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
88	PHBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
89	PHMKFR	Address Number - Mark-for	Numeric	Generic Edit	8	0	Allow NULL?

TOP 812 | 43 | F4301 INDEXES

Number

Description

Doc. No Doc 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

Doc Co Doc No Doc Ty

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending

Address No DocT Ref ESU ONLY

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DCTO	Order Type	Ascending
3	VR01	Reference	Ascending

Address No DocT Hol ESU ONLY

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DCTO	Order Type	Ascending
3	HOLD	Hold Orders Code	Ascending

Address No DocT Doc ESU ONLY

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	DCTO	Order Type	Ascending
3	DOCO	Document (Order No Invoice etc.)	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

89 COLUMNS | 5 INDEXES | 812 | 43 | F4301 TABLE

TOP 812 | 43 | F4301 COLUMNS

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

89 COLUMNS | 5 INDEXES | 812 | 43 | F4301 TABLE

TOP812 | 43 | F4301 COLUMNS

TOP812 | 43 | F4301 INDEXES

TOP 812 | 43 | F4301 COLUMNS

TOP 812 | 43 | F4301 INDEXES