	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

39 columns | 920 | YR

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0007	Workday Calendar	3	CZ	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP02: Electronic Mail
2	F0126	'Flash' Schedule Master File	3	A#	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP07: Payroll
3	F06720	W-2/1099 Processing Control	3	JE	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
4	F07727	Canadian Pension Information	1	J7	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
5	F078651	W2 EFW2 Electronic Filing Build	4	RM	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
6	F078652	W-2C EFW2C Electronic Filing Build	3	RF	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP15: Real Estate Management
7	F15011	Billings Generation Control Master	5	NK	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
8	F15011B	BIllings Generation Control	5	NK	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
9	F1502WB	Estimated EP Recurring Billings	63	N4	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
10	F1511	Tenant/Lease Billings Detail	22	NJ	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
11	F1511B	Lease Billings Master	22	NJ	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
12	F1511H	Tenant/Lease Billings Detail History	22	N#	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
13	F1511HB	Lease Billings History	22	NC	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
14	F1513	FASB 13 Lease Control File	5	O3	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
15	F1513B	FASB 13 Lease Control	5	O3	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
16	F1540	Sales Report Control File	6	NR	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
17	F1540B	Sales Report Control	10	NR	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
18	F1541	Tenant Sales History	7	N8	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
19	F15410	Tenant Weekly Sales	8	N9	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
20	F1541B	Tenant Sales History	8	N8	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
21	F1541BW	Sales History Work File	10	OW	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
22	F1542	Projected Sales	9	OJ	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
23	F1543B	Tenant Sales Analysis Reporting File	3	OA	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
24	F1547	Sales Seasonality	5	OI	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
25	F1550	Escalation Index Master	3	NV	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP15L: Adv Real Estate Forecasting
26	F15L301	AREF Projected Sales	8	PS	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
27	F15L302	AREF Prior Gross Billings	11	PG	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP30: Product Data Management
28	F0007Z1	Work Day Calendar Transaction File	16	SZ	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
29	F3007	Work Center Resource Units	2	WU	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP34: Requirements Planning
30	F3460	Forecast File	19	MF	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP34X: In-Memory Planning Advisor
31	F34X200W	Planning Details Supply/Demand Work Table	66	SD	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP70: Multi-National Products
32	F70404	G/L Registration Balance - 09	1	Z7	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP74B: Begium Localization
33	F74B150	Yearly/Quarterly VAT File - Belgium	3	YT	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP75I: India
34	F75I100	TDS Ceritificate Master Maintenance	50	QB	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP76A: Argentina
35	F76A24	Credit Invoice Information - Accounts Payable - ARG - - 76A	23	IE	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
36	F76A391	Adjustment Indexes - 76A	3	C1	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
37	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	21	C6	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
TOP89: Conversion Programs
38	F49090	Work Day Calendar (Used for Table Conversions ONLY)	5	CZ	YR	Year - Calendar Year	Numeric	Generic Edit	2	0
39	F75I101A	TDS Ceritificate Master Tabel Extension	8	QB	YR	Year - Calendar Year	Numeric	Generic Edit	2	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

39 columns | 920 | YR