	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

127 COLUMNS | 6 INDEXES | 920 | 43 | F4301 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	920	F4301	PH	127	6	Purchase Order Header	Transaction 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 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, PHPOHP01, PHPOHP02, PHPOHP03, PHPOHP04, PHPOHP05, PHPOHP06, PHPOHP07, PHPOHP08, PHPOHP09, PHPOHP10, PHPOHP11, PHPOHP12, PHPOHC01, PHPOHC02, PHPOHC03, PHPOHC04, PHPOHC05, PHPOHC06, PHPOHC07, PHPOHC08, PHPOHC09, PHPOHC10, PHPOHC11, PHPOHC12, PHPOHD01, PHPOHD02, PHPOHAB01, PHPOHAB02, PHCUKID, PHPOHP13, PHPOHU01, PHPOHU02, PHRETI, PHCLASS01, PHCLASS02, PHCLASS03, PHCLASS04, PHCLASS05 FROM F4301

TOP 920 | 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	Generic Edit	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?
90	PHPOHP01	Purchase Order Property 01	Character	Generic Edit	1	0	Allow NULL?
91	PHPOHP02	Purchase Order Property 02	Character	Generic Edit	1	0	Allow NULL?
92	PHPOHP03	Purchase Order Property 03	Character	Generic Edit	1	0	Allow NULL?
93	PHPOHP04	Purchase Order Property 04	Character	Generic Edit	1	0	Allow NULL?
94	PHPOHP05	Purchase Order Property 05	Character	Generic Edit	1	0	Allow NULL?
95	PHPOHP06	Purchase Order Property 06	Character	Generic Edit	1	0	Allow NULL?
96	PHPOHP07	Purchase Order Property 07	Character	Generic Edit	1	0	Allow NULL?
97	PHPOHP08	Purchase Order Property 08	Character	Generic Edit	1	0	Allow NULL?
98	PHPOHP09	Purchase Order Property 09	Character	Generic Edit	1	0	Allow NULL?
99	PHPOHP10	Purchase Order Property 10	Character	Generic Edit	1	0	Allow NULL?
100	PHPOHP11	Purchase Order Property 11	Character	Generic Edit	1	0	Allow NULL?
101	PHPOHP12	Purchase Order Property 12	Character	Generic Edit	1	0	Allow NULL?
102	PHPOHC01	Purchase Order Code 01	String	UDC (43 C1)	3	0	Allow NULL?
103	PHPOHC02	Purchase Order Code 02	String	UDC (43 C2)	3	0	Allow NULL?
104	PHPOHC03	Purchase Order Code 03	String	UDC (43 C3)	3	0	Allow NULL?
105	PHPOHC04	Purchase Order Code 04	String	UDC (43 C4)	3	0	Allow NULL?
106	PHPOHC05	Purchase Order Code 05	String	UDC (43 C5)	3	0	Allow NULL?
107	PHPOHC06	Purchase Order Code 06	String	UDC (43 C6)	3	0	Allow NULL?
108	PHPOHC07	Purchase Order Code 07	String	UDC (43 L1)	10	0	Allow NULL?
109	PHPOHC08	Purchase Order Code 08	String	UDC (43 L2)	10	0	Allow NULL?
110	PHPOHC09	Purchase Order Code 09	String	UDC (43 L3)	10	0	Allow NULL?
111	PHPOHC10	Purchase Order Code 10	String	UDC (43 L4)	10	0	Allow NULL?
112	PHPOHC11	Purchase Order Code 11	String	UDC (43 L5)	10	0	Allow NULL?
113	PHPOHC12	Purchase Order Code 12	String	UDC (43 L6)	10	0	Allow NULL?
114	PHPOHD01	Purchase Order Date 01	Date	Generic Edit	6	0
115	PHPOHD02	Purchase Order Date 02	Date	Generic Edit	6	0
116	PHPOHAB01	Purchase Order Address Book 01	Numeric	Generic Edit	8	0	Allow NULL?
117	PHPOHAB02	Purchase Order Address Book 02	Numeric	Generic Edit	8	0	Allow NULL?
118	PHCUKID	Clause Unique ID	Numeric	Generic Edit	15	0	Allow NULL?
119	PHPOHP13	Purchase Order Property 13	String	Generic Edit	30	0	Allow NULL?
120	PHPOHU01	Purchase Order Universal Date 01	JDE UTime	Generic Edit	11	0
121	PHPOHU02	Purchase Order Universal Date 02	JDE UTime	Generic Edit	11	0
122	PHRETI	Retainage Indicator	Character	Generic Edit	1	0	Allow NULL?
123	PHCLASS01	Classification Code 01	String	UDC (01 CA)	3	0	Allow NULL?
124	PHCLASS02	Classification Code 02	String	UDC (01 CB)	3	0	Allow NULL?
125	PHCLASS03	Classification Code 03	String	UDC (01 CC)	3	0	Allow NULL?
126	PHCLASS04	Classification Code 04	String	UDC (01 CD)	3	0	Allow NULL?
127	PHCLASS05	Classification Code 05	String	UDC (01 CE)	3	0	Allow NULL?

TOP 920 | 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

Related Order Number Type

Element	Alias	Description	Sequence
1	RORN	Related PO/SO/WO Number	Ascending
2	RCTO	Related PO/SO/WO Order Type	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

127 COLUMNS | 6 INDEXES | 920 | 43 | F4301 TABLE

TOP 920 | 43 | F4301 COLUMNS

TOP 920 | 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

127 COLUMNS | 6 INDEXES | 920 | 43 | F4301 TABLE

TOP920 | 43 | F4301 COLUMNS

TOP920 | 43 | F4301 INDEXES

TOP 920 | 43 | F4301 COLUMNS

TOP 920 | 43 | F4301 INDEXES