	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

49 tables812 | 46

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
46: Warehouse Management
1	812	F4142	CT	40	2	Warehouse Count Transactions	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
2	812	F4600	R1	99	15	Warehouse Requests	Transaction Files	46: Warehouse Management	AS400 Coexistence Tables
3	812	F4600PU	R1	95	1	Warehouse Requests - Purged	Purge Files	46: Warehouse Management	No
4	812	F4600T	R1	7	3	Warehouse Requests Tag File	Transaction Files	46: Warehouse Management	No
5	812	F4600TPU	R1	10	1	Warehouse Requests Tag File - Purged	Purge Files	46: Warehouse Management	No
6	812	F4601	TH	17	1	Warehouse Task Header	Transaction Files	46: Warehouse Management	AS400 Coexistence Tables
7	812	F46011	IQ	35	3	Item Unit Of Measure Definition	Secondary Master Files	46: Warehouse Management	AS400 Coexistence Tables
8	812	F46011T	IQ	10	1	Item Unit Of Measure Definition Tag File	Files	46: Warehouse Management	No
9	812	F46012	IS	13	1	Fixed Locations	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
10	812	F46013	EQ	10	1	Carton Recommendation Rules	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
11	812	F460131	SP	26	5	Standard Pack Recommendation Rules	Files	46: Warehouse Management	Business Data
12	812	F46014	RG	13	2	Replenishment Groups	Master Files	46: Warehouse Management	No
13	812	F46015	RR	22	2	Replenishment Information by Random Rule	Master Files	46: Warehouse Management	No
14	812	F460151	MS	7	2	Mixed Sequenced Packing Groups	Files	46: Warehouse Management
15	812	F4601PU	TH	20	1	Warehouse Task Header - Purged	Purge Files	46: Warehouse Management	No
16	812	F4602	IF	90	17	Location Detail Information	Balance Files	46: Warehouse Management	AS400 Coexistence Tables
17	812	F46021	LQ	7	1	Location Characteristics	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
18	812	F46022	LT	19	1	Location Dimensions	Master Files	46: Warehouse Management	AS400 Coexistence Tables
19	812	F46024	LC	10	1	Location Capacity	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
20	812	F46025	MQ	8	1	Maximum Putaway Quantity by Zone	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
21	812	F46026	AC	6	2	Allowed Containers by Location	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
22	812	F46027	AV	17	5	Available Space Tiebreaker	Balance Files	46: Warehouse Management	AS400 Coexistence Tables
23	812	F46029	LP	16	3	Proximity Tiebreaker	Balance Files	46: Warehouse Management	AS400 Coexistence Tables
24	812	F46051	LY	8	1	Fixed Replenisment Zones	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
25	812	F46091	ID	33	2	Container and Carton Codes	Master Files	46: Warehouse Management	AS400 Coexistence Tables
26	812	F46091T	ID	8	1	Container and Carton Codes Tag File	Secondary Master Files	41: Inventory Management	No
27	812	F46092	OZ	6	2	Order Groups	Constants Files	46: Warehouse Management	AS400 Coexistence Tables
28	812	F46093	EM	17	1	Process Selection Rules	Constants Files	46: Warehouse Management	AS400 Coexistence Tables
29	812	F46095	ET	32	1	Movement Instructions	Constants Files	46: Warehouse Management	AS400 Coexistence Tables
30	812	F46096	OU	6	2	Unit Of Measure Groups	Constants Files	46: Warehouse Management	AS400 Coexistence Tables
31	812	F46098	CB	19	3	Container Bill of Material	Files	46: Warehouse Management
32	812	F4611	R2	159	14	Warehouse Suggestions	Transaction Files	46: Warehouse Management	AS400 Coexistence Tables
33	812	F4611PU	R2	158	1	Warehouse Suggestions - Purged	Purge Files	46: Warehouse Management	No
34	812	F4611T	R2	7	3	Warehouse Suggestions Tag File	Transaction Files	46: Warehouse Management	No
35	812	F4611TPU	R2	10	1	Warehouse Suggestions Tag File - Purged	Purge Files	46: Warehouse Management	No
36	812	F4611Z1	SZ	166	1	Unedited Suggestion Table	Transaction Files	46: Warehouse Management	No
37	812	F46130	R3	87	5	Putaway Reservations	Transaction Files	46: Warehouse Management	AS400 Coexistence Tables
38	812	F46130PU	R3	90	1	Putaway Reservations - Purged	Purge Files	46: Warehouse Management	No
39	812	F4615	CR	38	6	Carton Recommendations	Files	46: Warehouse Management	Business Data
40	812	F4620	CD	65	8	Carton Detail Information	Files	46: Warehouse Management	No
41	812	F46200	BR	35	4	Bulk Pick Requests	Work Files	46: Warehouse Management	No
42	812	F46200PU	BR	37	1	Bulk Pick Requests - Purged	Purge Files	46: Warehouse Management	No
43	812	F46201	CC	12	1	Carton Charge Reference Setup	Files	46: Warehouse Management
44	812	F4622	UL	18	1	Unusable Label Numbers	Files	46: Warehouse Management
45	812	F4625	LN	15	1	Label Next Numbers	Files	46: Warehouse Management
46	812	F46821	LX	7	3	Random Locations	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
47	812	F46822	RQ	11	3	Random Tables	Extra Features Files	46: Warehouse Management	AS400 Coexistence Tables
48	812	F46UI15	RC	39	6	Carton Recommendations - Work File	Files	46: Warehouse Management	Business Data
49	812	F4942Z1	SY	52	2	Work File for F4942	Transaction Files	46: Warehouse Management	AS400 Coexistence Tables

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

49 tables812 | 46