	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

70 columns | 920 | EXR

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	37	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
2	F4303M	Log Models	5	PM	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP03B: Enhanced Accounts Receivable
3	F03B117	Revenue Recognition GL Info	79	RL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
4	F03B119	Revenue Recognition GL Info Audit	83	RN	EXR	Name - Remark Explanation	String	Generic Edit	30	0
5	F03B13	Receipts Header	37	RY	EXR	Name - Remark Explanation	String	Generic Edit	30	0
6	F03B13P	Receipts Header Purge File	37	RY	EXR	Name - Remark Explanation	String	Generic Edit	30	0
7	F03B13Z2	F03B13 Interoperability Table	50	SY	EXR	Name - Remark Explanation	String	Generic Edit	30	0
8	F03B672	Draft Remittance	36	RD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
9	F09UI011	Receipt Prepost Work File	28	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP04: Accounts Payable
10	F04514	1099 Merged Worktables (F045141:F045143)	26	G1	EXR	Name - Remark Explanation	String	Generic Edit	30	0
11	F045141	1099 G/L Worktable	26	G1	EXR	Name - Remark Explanation	String	Generic Edit	30	0
12	F045143	1099 A/P Worktable	26	G1	EXR	Name - Remark Explanation	String	Generic Edit	30	0
13	F09UI005	Tax Offsets User Index	40	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP05: Time Accounting and HRM Base
14	F06106	Employee Pay Instructions	2	YM	EXR	Name - Remark Explanation	String	Generic Edit	30	0
15	F0618	Employee Transaction History	83	YT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
16	F069106	Union Benefits Master	4	Y1	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP05T: Time Entry
17	F06116	Employee Transaction Detail File	83	YT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
18	F06116Z1	Employee Transactions - Batch File	97	VL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
19	F06116Z2	ESS Timecard History	97	VM	EXR	Name - Remark Explanation	String	Generic Edit	30	0
20	F06278	Retro Timecard Detail File	83	YT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
21	F06290	Payroll Accounting Journal Work File	20	YR	EXR	Name - Remark Explanation	String	Generic Edit	30	0
22	F063951	Payroll Journal (Compressed) File	18	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
23	F069136	Tip Disbursement	9	JE	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP07: Payroll
24	F05290	WF - Payroll Journal (Detail)	18	JR	EXR	Name - Remark Explanation	String	Generic Edit	30	0
25	F07UI200	Timecard History Work File	86	TH	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP08AD: ADP Integration
26	F051371	ADP Employee DBA Instructions	7	AD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
27	F06012	Personnel Resume	5	YD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP09: General Accounting
28	F0911P	Purge - Account Ledger	37	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
29	F0911R	WF - Account Ledger Reconciliation	34	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
30	F0911Z1	Journal Entry Transactions - Batch File	54	VN	EXR	Name - Remark Explanation	String	Generic Edit	30	0
31	F0911Z4	F0911 Interoperability Table	59	SZ	EXR	Name - Remark Explanation	String	Generic Edit	30	0
32	F0912	Cost Allocations/Flex Budgeting	30	RJ	EXR	Name - Remark Explanation	String	Generic Edit	30	0
33	F0912A	Index Computation Entry File	26	RI	EXR	Name - Remark Explanation	String	Generic Edit	30	0
34	F097021W	Account Ledger to Account Master Work Table	14	TA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
35	F09UI015	Indexed Computations Multi-Tiered Entries	37	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
36	F52G11	Burdening Detail Ledger	27	BD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
37	F52G11WF	Temporary Burdened Detail Ledger Workfile	27	BW	EXR	Name - Remark Explanation	String	Generic Edit	30	0
38	F70UI001	Work File for G/L by Cat. Code Localization	8	WA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
39	F740911	Work File for G/L Report by Category Code Localization	11	WA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP12: Fixed Assets
40	F1201	Asset Master File	68	FA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
41	F1201P	Asset Master Purge Table	68	FA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
42	F1201Z1	Unedited Asset Master Transactions	79	FA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
43	F12911ER	Post G/L to FA Exceptions Work File	16	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP15: Real Estate Management
44	F1503	Log Standards Master	10	NB	EXR	Name - Remark Explanation	String	Generic Edit	30	0
45	F1521	Log Detail Master	9	NB	EXR	Name - Remark Explanation	String	Generic Edit	30	0
46	F1521D	Log Detail Master - Alternate Description	4	NB	EXR	Name - Remark Explanation	String	Generic Edit	30	0
47	F1523	Log Standard Master	6	OG	EXR	Name - Remark Explanation	String	Generic Edit	30	0
48	F1523D	Log Standards Master - Alternate Description	4	OG	EXR	Name - Remark Explanation	String	Generic Edit	30	0
49	F1565	Security Deposit Master	17	JF	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP18: Timecard Automation
50	F186602	Labor Rules Tag File	92	TF	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP31: Shop Floor Control
51	F31122	Work Order Time Transactions	14	WT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
52	F31122S	Purge Work Order Time Transactions	14	WT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
53	F31122Z1	Work Order Time Transactions Unedited Transaction Table	27	SZ	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP42: Sales Management
54	F42800G1	Sales Update G Batch Detail Workfile	28	DG	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP43: Procurement
55	F4303	Log Master	7	PK	EXR	Name - Remark Explanation	String	Generic Edit	30	0
56	F4305	Log Master	14	PL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP44H: Homebuilder Management
57	F44H591	Closing Worksheet Entries	5	CW	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP48S: Service Billing
58	F48096	Billing Rate / Mark up Table	28	WQ	EXR	Name - Remark Explanation	String	Generic Edit	30	0
59	F4812	Billing Detail Workfile	51	WD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
60	F4812H	Billing Workfile History	51	WD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
61	F4812HS	Billing Workfile History Purged Save	51	WD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
62	F48S0618	Payroll Reclassification Workfile	83	YT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
63	F48S910	Billing Detail Journal Workfile	26	W2	EXR	Name - Remark Explanation	String	Generic Edit	30	0
64	F48S911	Summarized Journal Workfile	36	W3	EXR	Name - Remark Explanation	String	Generic Edit	30	0
65	F48SUI01	Billing Detail Print Workfile	51	WD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP52G: Proj & Gov Contract Accounting
66	F52G90	Invoice Printing Work Table	45	WT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP74R: Russia
67	F74R0018	Russian Tax File - 74R	56	TD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP74S: Spain
68	F74S55	Expenses and Exchange Rate for Payments - Spain - 04	13	Q5	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP76B: Brazil
69	F76B10	Account Ledger - IN68 - 09	18	AR	EXR	Name - Remark Explanation	String	Generic Edit	30	0
70	F76B911	IN86-Work Table for Journal Entries - 09	16	BD	EXR	Name - Remark Explanation	String	Generic Edit	30	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

70 columns | 920 | EXR