	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

61 tables910 | 43

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

61 tables910 | 43