	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 | 812 | 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	F4303	Log Master	7	PK	EXR	Name - Remark Explanation	String	Generic Edit	30	0
3	F4303M	Log Models	5	PM	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP03B: Enhanced Accounts Receivable
4	F03B13	Receipts Header File	37	RY	EXR	Name - Remark Explanation	String	Generic Edit	30	0
5	F03B13P	Receipts Header Purge File	37	RY	EXR	Name - Remark Explanation	String	Generic Edit	30	0
6	F03B13Z2	F03B13 Interoperability Table	50	SY	EXR	Name - Remark Explanation	String	Generic Edit	30	0
7	F03B672	Draft Remittance Work File - One World Only	36	RD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
8	F09UI011	Receipt Prepost Work File	28	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP04: Accounts Payable
9	F04514	WF - 1099 Combined Workfile (Merge of F045141 and F045143)	26	G1	EXR	Name - Remark Explanation	String	Generic Edit	30	0
10	F045141	WF - 1099 G/L Workfile	26	G1	EXR	Name - Remark Explanation	String	Generic Edit	30	0
11	F045143	WF - 1099 A/P WorkFile	26	G1	EXR	Name - Remark Explanation	String	Generic Edit	30	0
12	F09UI005	Tax Offsets User Index	40	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP05: Time Accounting and HRM Base
13	F06106	Employee Pay Instructions	2	YM	EXR	Name - Remark Explanation	String	Generic Edit	30	0
14	F0618	Employee Transaction History	83	YT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
15	F069106	Union Benefits Master	4	Y1	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP05T: Time Entry
16	F06116	Employee Transaction Detail File	83	YT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
17	F06116Z1	Employee Transactions - Batch File	97	VL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
18	F06278	Retro Timecard Detail File	83	YT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
19	F06290	Payroll Accounting Journal Work File	20	YR	EXR	Name - Remark Explanation	String	Generic Edit	30	0
20	F063951	Payroll Journal (Compressed) File	18	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
21	F069136	Tip Disbursement	9	JE	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP07: Payroll
22	F05290	WF - Payroll Journal (Detail)	18	JR	EXR	Name - Remark Explanation	String	Generic Edit	30	0
23	F07UI200	Timecard History Work File	86	TH	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP08AD: ADP Integration
24	F051371	ADP Employee DBA Instructions	7	AD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
25	F06012	Personnel Resume	5	YD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP09: General Accounting
26	F0911P	Purge - Account Ledger	37	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
27	F0911R	WF - Acct Ledger File for Reconciliation	34	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
28	F0911Z1	Journal Entry Transactions - Batch File	54	VN	EXR	Name - Remark Explanation	String	Generic Edit	30	0
29	F0911Z4	F0911 Interoperability Table	59	SZ	EXR	Name - Remark Explanation	String	Generic Edit	30	0
30	F0912	Cost Allocations/Flex Budgeting	30	RJ	EXR	Name - Remark Explanation	String	Generic Edit	30	0
31	F0912A	Index Computation Entry File	26	RI	EXR	Name - Remark Explanation	String	Generic Edit	30	0
32	F09UI015	Indexed Computations Multi-Tiered Entries	37	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
33	F70UI001	Work File for G/L by Cat. Code Localization	8	WA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
34	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
35	F1201	Asset Master File	68	FA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
36	F1201P	Asset Master Purge Table	68	FA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
37	F1201Z1	Unedited Asset Master Transactions	79	FA	EXR	Name - Remark Explanation	String	Generic Edit	30	0
38	F12911ER	Post G/L to FA Exceptions Work File	16	GL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP15: Property Management
39	F1503	Log Standards Master	10	NB	EXR	Name - Remark Explanation	String	Generic Edit	30	0
40	F1521	Log Detail Master	9	NB	EXR	Name - Remark Explanation	String	Generic Edit	30	0
41	F1521D	Log Detail Master - Alternate Description	4	NB	EXR	Name - Remark Explanation	String	Generic Edit	30	0
42	F1523	Log Standard Master	6	OG	EXR	Name - Remark Explanation	String	Generic Edit	30	0
43	F1523D	Log Standards Master - Alternate Description	4	OG	EXR	Name - Remark Explanation	String	Generic Edit	30	0
44	F1565	Security Deposit Master	17	JF	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP18: Resource Scheduling
45	F186602	Labor Rules Tag File	92	TF	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP31: Shop Floor Control
46	F31122	Work Order Time Transactions	14	WT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
47	F31122S	Purge Work Order Time Transactions	14	WT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
48	F31122Z1	Work Order Time Transactions Unedited Transaction Table	27	SZ	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP42: Sales Management
49	F42800G1	Sales Update G Batch Detail Workfile	28	DG	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP43: Procurement
50	F4305	Log Master	14	PL	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP44H: Homebuilder Management
51	F44H591	Closing Worksheet Entries	5	CW	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP48S: Service Billing
52	F48096	Billing Rate / Mark up Table	28	WQ	EXR	Name - Remark Explanation	String	Generic Edit	30	0
53	F4812	Billing Detail Workfile	51	WD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
54	F4812H	Billing Workfile - History	51	WD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
55	F4812HS	Billing Workfile History Purged Save	51	WD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
56	F48S0618	Payroll Reclassification Workfile	83	YT	EXR	Name - Remark Explanation	String	Generic Edit	30	0
57	F48S910	Billing Detail Journal File	26	W2	EXR	Name - Remark Explanation	String	Generic Edit	30	0
58	F48S911	Compressed Journal File	36	W3	EXR	Name - Remark Explanation	String	Generic Edit	30	0
59	F48SUI01	Billing Detail Print Workfile	51	WD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP57: Reserved for Clients
60	F74T550	General Ledger Work File - Turkish	31	DK	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP74: EMEA Localization
61	F74S55	Expenses and Exchange Rate for Payments - Spain	13	Q5	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP74R: CIS
62	F74R0018	Russian Tax File - 74R	56	TD	EXR	Name - Remark Explanation	String	Generic Edit	30	0
TOP76B: Brazil - Reporting System Only
63	F76B10	Account Ledger - IN68 - 09	18	AR	EXR	Name - Remark Explanation	String	Generic Edit	30	0
64	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

64 columns | 812 | EXR