	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

64 columns | 920 | 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	F0006Z2	Business Unit Master Z File	108	SZ	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP15: Real Estate Management
5	F1501	Tenant/Lease Master	29	NE	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
6	F150122A	Share Factor Denominator Audit	5	SA	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
7	F15013	Sales Overage Master	37	NO	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
8	F15013B	Sales Overage Master File	18	NO	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
9	F15014	Product Scales Master	8	NP	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
10	F15014B	Product Scales Master	30	NP	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
11	F15017	Lease Master Detail	7	NW	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
12	F1506	Floor Master	1	OP	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
13	F1507	Unit Master	1	NH	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
14	F1511	Tenant/Lease Billings Detail	8	NJ	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
15	F1511B	Lease Billings Master	8	NJ	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
16	F1511H	Tenant/Lease Billings Detail History	8	N#	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
17	F1511HB	Lease Billings History	8	NC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
18	F15141	Gross Lease Occupied Areas	1	NC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
19	F1540	Sales Report Control File	16	NR	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
20	F1540B	Sales Report Control	32	NR	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
21	F1541	Tenant Sales History	10	N8	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
22	F15410	Tenant Weekly Sales	12	N9	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
23	F1541B	Tenant Sales History	11	N8	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
24	F1541BW	Sales History Work File	3	OW	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
25	F1542	Projected Sales	12	OJ	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
26	F1543B	Tenant Sales Analysis Reporting File	10	OA	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
27	F1547	Sales Seasonality	1	OI	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
28	F1549	Seasonality Models	1	OL	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
29	F15702	Legal Clause Space Detail	5	NF	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP15L: Adv Real Estate Forecasting
30	F15L101	AREF Unit Master	4	UM	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
31	F15L141	AREF Gross Lease Occupied Area	1	GL	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
32	F15L301	AREF Projected Sales	12	PS	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
33	F15L302	AREF Prior Gross Billings	19	PG	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
34	F15L401	AREF Share Factor Denominator Audit	6	SF	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
35	F15L402	AREF Tenant Exclusion Rule Audit	4	SG	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP17: Customer Service Management
36	F1720	Contract Header	22	CH	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
37	F1721	Contract Detail	16	CD	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP31P: Engineer To Order
38	F31P01	Project Attributes	16	PA	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP42: Sales Management
39	F42565	Invoice Print File	111	IW	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP44H: Homebuilder Management
40	F4450	Lot Proceed Header (World)	1	JD	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
41	F4451	Lot Proceed Detail (World)	1	JF	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
42	F4452	Plan Master (World)	10	JA	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
43	F4453	Lot Master (World)	1	JB	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
44	F4454	Vendor Assignment (World)	1	JG	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
45	F4456	Lot Proceed Entry (World)	1	JI	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
46	F4461	Option Master (World)	1	JN	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
47	F44H712	Lot Start Workfile Takeoff Detail	8	ST	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP48S: Service Billing
48	F48426	Service Billing Trigger Configuration	4	ST	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP51X: In-Memory Project Management
49	F51X10	Project Advisor Console Worktable	12	EX	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP52: Contract Billing
50	F5201	Contract Master	26	G4	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
51	F5202	Contract Billing Line Detail	16	G6	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
52	F52425	Contract Billing Trigger Configuration	5	TK	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP52G: Proj & Gov Contract Accounting
53	F52G01M	Advanced Contracts Modifications	31	CM	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP53: Change Management
54	F5302	F5302 World Specs	11	DK	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP54HS: Health & Safety Incident Mgt
55	F54HS01	Incident Master	26	S1	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
56	F54HS01M	Incident Master Change History	29	I1	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
57	F54HS20	Safety Hours	4	SH	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP74U: United Kingdom Localizations
58	F74U0412	Application Commitment Workfile - UK - 43	8	AC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
59	F74U0414	Certificate Commitment Workfile - UK - 43	8	CC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
60	F74U0416	Purchase Order Commitment Workfile - UK - 43	8	PC	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP76A: Argentina
61	F76A394	Adjustments - 76A	11	C4	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP76B: Brazil
62	F76B10	Account Ledger - IN68 - 09	9	AR	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
63	F76B50	Item Ledger Table - IN68 - 42	19	CE	MCUS	Business Unit - Subsequent	String	Generic Edit	12	0
TOP76H: Chile
64	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

64 columns | 920 | MCUS