	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

62 tables920 | 43

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	920	F40910	P#	14	3	Commitment Integrity Report Work File	Regular Work Files	43: Procurement	Business Data
2	920	F4095TEM	ML	9	1	F4095 Temporary Table	Constants Files	43: Procurement	Business Data
3	920	F41061	CB	23	5	Supplier Price/Catalog File	Master Files	45: Advanced Pricing	Business Data
4	920	F41291	IG	28	3	Item Cost Components	Secondary Master Files	43B: Voucher Match and Landed Cost
5	920	F43008	AP	6	3	Approval Levels	Extra Features Files	43: Procurement	Business Data
6	920	F4301	PH	127	6	Purchase Order Header	Transaction Files	43: Procurement	Business Data
7	920	F4301SW	PS	8	1	Purchase Order Summary Work Table	Files	43: Procurement
8	920	F4301Z	PA	142	5	PO Header Work File	Work Files	43: Procurement	Business Data
9	920	F4301Z1	SY	143	1	Purchase Order Header Unedited Transaction Table	Transaction Files	43: Procurement
10	920	F4303	PK	28	3	Log Master	Transaction Files	43: Procurement	Business Data
11	920	F4304	PC	7	1	Log Hierarchy Constants	Constants Files	43: Procurement
12	920	F4305	PL	34	5	Log Master	Transaction Files	43: Procurement
13	920	F43080	PD	195	1	Approvals Fields Constants	Transaction Files	43: Procurement	Business Data
14	920	F43090	PC	52	5	Supplier/Item Relationships	Extra Features Files	43: Procurement	Business Data
15	920	F43091	PP	11	1	Receipt Routing Master File	Extra Features Files	43A: Purchase Order Receipt/Routing	Business Data
16	920	F43092	PX	22	4	Purchase Order Receipt Routing File	Extra Features Files	43A: Purchase Order Receipt/Routing	Business Data
17	920	F43092Z	PV	58	1	Receipt Routing Work File	Regular Work Files	43A: Purchase Order Receipt/Routing	Business Data
18	920	F43092Z1	SZ	75	1	Receipt Routing Unedited Transaction Table	Transaction Files	43A: Purchase Order Receipt/Routing	Business Data
19	920	F43093	PE	10	1	Inspection/Sample Size Table	Extra Features Files	43A: Purchase Order Receipt/Routing	Business Data
20	920	F43094	P5	8	1	Supplier Item Additional Routes	Extra Features Files	43: Procurement	Business Data
21	920	F43099	PO	29	1	Receipt Routing Ledger File	History Files	43A: Purchase Order Receipt/Routing	Business Data
22	920	F43100	IX	7	1	Supplier and Branch Plant Relationship	Files	43: Procurement
23	920	F4310X	CM	11	2	CM Purchase Order Cross Reference	Files	43: Procurement	Business Data
24	920	F4311	PD	228	12	Purchase Order Detail File	Transaction Files	43: Procurement
25	920	F4311T	PD	19	2	Purchase Order Detail Tag File	Transaction Files	43: Procurement	Business Data
26	920	F4311Z	PW	254	5	Purchase Order Generator File	Regular Work Files	43: Procurement	Business Data
27	920	F4311Z1	SZ	237	1	Purchase Order Detail Unedited Transaction Table	Transaction Files	43: Procurement
28	920	F43121	PR	163	12	Purchase Order Receiver File	Transaction Files	43A: Purchase Order Receipt/Routing	Business Data
29	920	F43121T	PR	26	2	Purchase Order Receiver Tag File	Transaction Files	43A: Purchase Order Receipt/Routing	Business Data
30	920	F43121TB	PR	10	2	Purchase Order Receiver Tag Table	Transaction Files	43A: Purchase Order Receipt/Routing
31	920	F43121Z	PW	212	3	Receiver workfile	Regular Work Files	43A: Purchase Order Receipt/Routing	Business Data
32	920	F43121Z1	SZ	203	1	Receipts Unedited Transaction Table	Transaction Files	43A: Purchase Order Receipt/Routing	Business Data
33	920	F43147	FD	59	2	Freight Distribution Workfile	Work Files	43B: Voucher Match and Landed Cost
34	920	F4314Z	PN	213	2	Voucher Match Selection File	Regular Work Files	43B: Voucher Match and Landed Cost
35	920	F4316	P3	57	4	Purchase Order Multiple Account File	Files	43: Procurement	Business Data
36	920	F4316M	P4	8	1	Model Purchase Order Multiple Account File	Files	43: Procurement	Business Data
37	920	F4316T	P3	16	1	Purchase Order Multiple Account Tag File	Files	43: Procurement
38	920	F4317	PD	24	1	Purchase Order Detail Non-Billable	Files	43: Procurement	Business Data
39	920	F4318	PY	17	1	Approval/Rejection Reasons	Transaction Files	43: Procurement	Business Data
40	920	F43199	OL	230	8	P.O. Detail Ledger File - Flexible Version	History Files	43: Procurement	Business Data
41	920	F4320	PC	13	1	Purchase Order Clauses	Files	43: Procurement
42	920	F4322	PZ	14	1	Purchasing Tolerance Rules	Constants Files	43: Procurement	Business Data
43	920	F4330	P0	14	3	Supplier Selection File	Transaction Files	43: Procurement	Business Data
44	920	F4331	P1	12	1	Quantity Breaks File	Transaction Files	43: Procurement	Business Data
45	920	F4332	P2	14	1	Multiple Requisition File	Transaction Files	43: Procurement	Business Data
46	920	F4333WF	PO	10	1	Purchase Order Dispatch Work File	Files	43: Procurement
47	920	F4340	RD	28	1	Purchase Rebate Master File	Master Files	45: Advanced Pricing	Business Data
48	920	F4341	RL	6	1	Purchase Rebate Threshold File	Master Files	45: Advanced Pricing	Business Data
49	920	F4342	RK	7	1	Purchase Inclusion Rules	Master Files	45: Advanced Pricing	Business Data
50	920	F4343	RH	29	1	Purchase Rebate History	Transaction Files	45: Advanced Pricing	Business Data
51	920	F4350	H1	2	1	Supplier Page Hyperlinks	Extra Features Files	43: Procurement	Business Data
52	920	F4351	H2	3	1	Supplier Item Hyperlinks	Extra Features Files	43: Procurement	Business Data
53	920	F4355	PT	7	1	Subcontractor Threshold	Files	43: Procurement
54	920	F43632Z	OI	27	1	Open Purchase Order by Item Work File	Regular Work Files	43: Procurement
55	920	F4371	PD	35	1	Suggested Reorder Stock Items	Files	43: Procurement
56	920	F43UI50C	WC	19	2	PO Print Clauses Table	Files	43: Procurement
57	920	F43UI50D	PW	80	1	PO Print Detail Work File	Extra Features Files	43: Procurement	Business Data
58	920	F43UI50H	PA	106	1	PO Print Header Work File	Extra Features Files	43: Procurement	Business Data
59	920	F44445Z	SW	8	1	Subcontractor Waiver	Work Files	43: Procurement	Business Data
60	920	F74U0140	AC	22	1	ACM - Application Certificate Constants	Master Files	43B: Voucher Match and Landed Cost
61	920	F74U0141	AC	45	7	ACM - Application / Certificate Master	Master Files	43B: Voucher Match and Landed Cost
62	920	F74U0142	DH	26	1	ACM - Application / Certificate Status History	History Files	43B: Voucher Match and Landed Cost

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

62 tables920 | 43