	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 tables920 | 46

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

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 tables920 | 46