	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

50 columns | 812 | MCUS

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0006	Business Unit Master	95	MC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
2	F0006S	Date Effective Business Unit Master	97	MC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
3	F0006Z1	Cost Center Unedited Transaction Table	108	SZ	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
4	F1501	Tenant/Lease Master	29	NE	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP15: Property Management
5	F15013	Sales Overage Master	37	NO	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
6	F15013B	Sales Overage Master File	18	NO	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
7	F15014	Product Scales Master	8	NP	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
8	F15014B	Product Scales Master	30	NP	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
9	F15017	Lease Master Detail File	7	NW	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
10	F1506	Floor Master File	1	OP	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
11	F1507	Unit Master File	1	NH	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
12	F1511	Tenant/Lease Billings Detail	8	NJ	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
13	F1511B	Tenant/Lease Billings Detail Master	8	NJ	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
14	F1511H	Tenant/Lease Billings Detail History	8	N#	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
15	F1511HB	Tenant/Lease Billings Detail History	8	NC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
16	F15141	Gross Lease Occupied Areas	1	NC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
17	F1540	Sales Report Control File	16	NR	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
18	F1540B	Sales Report Control File	32	NR	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
19	F1541	Tenant Sales History	10	N8	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
20	F15410	Tenant Weekly Sales File	12	N9	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
21	F1541B	Tenant Sales History File	11	N8	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
22	F1541BW	Sales History Work File	3	OW	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
23	F1542	Projected Sales	12	OJ	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
24	F1543B	Tenant Sales Analysis Reporting File	10	OA	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
25	F1547	Sales Seasonality	1	OI	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
26	F1549	Seasonality Models	1	OL	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
27	F15702	Legal Clause Space Detail	5	NF	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP15L: Adv Real Estate Forecasting
28	F15L101	AREF Unit Master	4	UM	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
29	F15L141	AREF Gross Lease Occupied Area	1	GL	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
30	F15L301	AREF Projected Sales	12	PS	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
31	F15L302	AREF Prior Gross Billings	19	PG	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP17: Customer Service Management
32	F1720	Contract Header	22	CH	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
33	F1721	Contract Detail	16	CD	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP31P: Engineer To Order
34	F31P01	Project Attributes	16	PA	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP42: Sales Management
35	F42565	Invoice Print File	111	IW	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP44H: Homebuilder Management
36	F4450	Lot Proceed Header (World)	1	JD	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
37	F4451	Lot Proceed Detail (World)	1	JF	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
38	F4452	Plan Master (World)	10	JA	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
39	F4453	Lot Master (World)	1	JB	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
40	F4454	Vendor Assignment (World)	1	JG	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
41	F4456	Lot Proceed Entry (World)	1	JI	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
42	F4461	Option Master (World)	1	JN	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
43	F44H712	Lot Start Workfile Takeoff Detail	8	ST	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP52: Contract Billing
44	F5201	Contract Master File	26	G4	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
45	F5202	Contract Billing Line Detail	16	G6	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP53: Change Management
46	F5302	F5302 World Specs	11	DK	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP76A: Argentina
47	F76A394	Adjustments - 76A	11	C4	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP76B: Brazil - Reporting System Only
48	F76B10	Account Ledger - IN68 - 09	9	AR	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
49	F76B50	Item Ledger Table - IN68 - 42	19	CE	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP76H: Chile
50	F76H6205	Item Replacement Cost - CHI - 41	10	IR	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0

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

50 columns | 812 | MCUS