	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

53 tables812 | 43

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	812	F40910	P#	14	3	Commitment Integrity Report Work File	Regular Work Files	43: Procurement	AS400 Coexistence Tables
2	812	F4095TEM	ML	9	1	F4095 Temporary Table	Constants Files	43: Procurement	No
3	812	F41061	CB	23	5	Supplier Price/Catalog File	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
4	812	F41291	IG	28	3	Item Cost Components	Secondary Master Files	43: Procurement	AS400 Coexistence Tables
5	812	F43008	AP	6	3	Approval Levels	Extra Features Files	43: Procurement	AS400 Coexistence Tables
6	812	F4301	PH	89	5	Purchase Order Header	Transaction Files	43: Procurement	AS400 Coexistence Tables
7	812	F4301Z	PA	104	5	PO Header Work File	Work Files	43: Procurement	No
8	812	F4301Z1	SY	105	1	Purchase Order Header Unedited Transaction Table	Transaction Files	43: Procurement	No
9	812	F4304	PC	7	1	Log Hierarchy Constants	Constants Files	43: Procurement
10	812	F4305	PL	34	5	Log Master	Transaction Files	43: Procurement
11	812	F43080	PD	195	1	Approvals Fields Constants	Transaction Files	43: Procurement	Business Data
12	812	F43090	PC	52	5	Supplier/Item Relationships	Extra Features Files	43: Procurement	AS400 Coexistence Tables
13	812	F43091	PP	11	1	Receipt Routing Master File	Extra Features Files	43: Procurement	AS400 Coexistence Tables
14	812	F43092	PX	22	4	Purchase Order Receipt Routing File	Extra Features Files	43: Procurement	AS400 Coexistence Tables
15	812	F43092Z	PV	58	1	Receipt Routing Work File	Regular Work Files	43A: Purchase Order Receipt/Routing	No
16	812	F43092Z1	SZ	75	1	Receipt Routing Unedited Transaction Table	Transaction Files	43: Procurement	AS400 Coexistence Tables
17	812	F43093	PE	10	1	Inspection/Sample Size Table	Extra Features Files	43: Procurement	AS400 Coexistence Tables
18	812	F43094	P5	8	1	Supplier Item Additional Routes	Extra Features Files	43: Procurement	Business Data
19	812	F43099	PO	29	1	Receipt Routing Ledger File	History Files	43: Procurement	AS400 Coexistence Tables
20	812	F43100	IX	7	1	Supplier and Branch Plant Relationship	Files	43: Procurement
21	812	F4311	PD	218	10	Purchase Order Detail File	Transaction Files	43: Procurement	AS400 Coexistence Tables
22	812	F4311T	PD	19	2	Purchase Order Detail Tag File	Transaction Files	43: Procurement	No
23	812	F4311Z	PW	244	5	Purchase Order Generator File	Regular Work Files	43: Procurement	No
24	812	F4311Z1	SZ	228	1	Purchase Order Detail Unedited Transaction Table	Transaction Files	43: Procurement	No
25	812	F43121	PR	154	11	Purchase Order Receiver File	Transaction Files	43A: Purchase Order Receipt/Routing	Business Data
26	812	F43121T	PR	26	2	Purchase Order Receiver Tag File	Transaction Files	43: Procurement	No
27	812	F43121TB	PR	10	2	Purchase Order Receiver Tag Table	Transaction Files	43A: Purchase Order Receipt/Routing
28	812	F43121Z	PW	197	3	Receiver workfile	Regular Work Files	43A: Purchase Order Receipt/Routing	No
29	812	F43121Z1	SZ	199	1	Receipts Unedited Transaction Table	Transaction Files	43: Procurement	No
30	812	F4314Z	PN	208	2	Voucher Match Selection File	Regular Work Files	43: Procurement	No
31	812	F4316	P3	55	4	Purchase Order Multiple Account File	Files	43: Procurement	Business Data
32	812	F4316M	P4	8	1	Model Purchase Order Multiple Account File	Files	43: Procurement	Business Data
33	812	F4316T	P3	16	1	Purchase Order Multiple Account Tag File	Files	43: Procurement
34	812	F4318	PY	17	1	Approval/Rejection Reasons	Transaction Files	43: Procurement	AS400 Coexistence Tables
35	812	F43199	OL	220	8	P.O. Detail Ledger File - Flexible Version	History Files	43: Procurement	AS400 Coexistence Tables
36	812	F4322	PZ	14	1	Purchasing Tolerance Rules	Constants Files	43: Procurement	AS400 Coexistence Tables
37	812	F4330	P0	14	3	Supplier Selection File	Transaction Files	43: Procurement	AS400 Coexistence Tables
38	812	F4331	P1	12	1	Quantity Breaks File	Transaction Files	43: Procurement	AS400 Coexistence Tables
39	812	F4332	P2	14	1	Multiple Requisition File	Transaction Files	43: Procurement	AS400 Coexistence Tables
40	812	F4333WF	PO	10	1	Purchase Order Dispatch Work File	Files	43: Procurement
41	812	F4340	RD	28	1	Purchase Rebate Master File	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
42	812	F4341	RL	6	1	Purchase Rebate Threshold File	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
43	812	F4342	RK	7	1	Purchase Inclusion Rules	Master Files	45: Advanced Pricing	AS400 Coexistence Tables
44	812	F4343	RH	29	1	Purchase Rebate History	Transaction Files	45: Advanced Pricing	AS400 Coexistence Tables
45	812	F4350	H1	2	1	Supplier Page Hyperlinks	Extra Features Files	43: Procurement	No
46	812	F4351	H2	3	1	Supplier Item Hyperlinks	Extra Features Files	43: Procurement	No
47	812	F4355	PT	7	1	Subcontractor Threshold	Files	43: Procurement
48	812	F43632Z	OI	27	1	Open Purchase Order by Item Work File	Regular Work Files	43: Procurement
49	812	F4371	PD	35	1	Suggested Reorder Stock Items	Files	43: Procurement
50	812	F43E09	AA	44	1	F43E09 - Approvals Activity Table	Files	43: Procurement
51	812	F43UI50D	PW	68	1	PO Print Detail Work File	Extra Features Files	43: Procurement	No
52	812	F43UI50H	PA	64	1	PO Print Header Work File	Extra Features Files	43: Procurement	No
53	812	F44445Z	SW	8	1	Subcontractor Waiver	Work Files	43: Procurement	No

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

53 tables812 | 43