	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

62 columns | 920 | U

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	32	GL	U	Units	Numeric	Generic Edit	15	2
2	F4303M	Log Models	16	PM	U	Units	Numeric	Generic Edit	15	2
TOP03: Accounts Receivable
3	F0311	Accounts Receivable Ledger	98	RP	U	Units	Numeric	Generic Edit	15	2
TOP03B: Enhanced Accounts Receivable
4	F03B11	Customer Ledger	96	RP	U	Units	Numeric	Generic Edit	15	2
5	F03B117	Revenue Recognition GL Info	24	RL	U	Units	Numeric	Generic Edit	15	2
6	F03B119	Revenue Recognition GL Info Audit	12	RN	U	Units	Numeric	Generic Edit	15	2
7	F03B11P	Customer Ledger Purge File	96	RP	U	Units	Numeric	Generic Edit	15	2
8	F03B11Z1	Batch Invoices	112	VJ	U	Units	Numeric	Generic Edit	15	2
9	F03B11Z2	F03B11 Interoperability Table	109	SY	U	Units	Numeric	Generic Edit	15	2
10	F03B29	Credit Insurance	11	IP	U	Units	Numeric	Generic Edit	15	2
11	F03B575	Auto Debit Invoice Select and Build	105	RD	U	Units	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
12	F0411	Accounts Payable Ledger	76	RP	U	Units	Numeric	Generic Edit	15	2
13	F0411A	WF - 'As Of' Accounts Payable Ledger	76	RP	U	Units	Numeric	Generic Edit	15	2
14	F0411P	Purge - Accounts Payable Ledger	76	RP	U	Units	Numeric	Generic Edit	15	2
15	F0411Z1	Voucher Transactions - Batch Upload	94	VL	U	Units	Numeric	Generic Edit	15	2
16	F0411Z3	F0411 Interoperability Table	99	SZ	U	Units	Numeric	Generic Edit	15	2
TOP05T: Time Entry
17	F063951	Payroll Journal (Compressed) File	20	GL	U	Units	Numeric	Generic Edit	15	2
TOP07: Payroll
18	F05290	WF - Payroll Journal (Detail)	20	JR	U	Units	Numeric	Generic Edit	15	2
TOP08: Human Resources
19	F08711	Employee Setup Tasks	7	ET	U	Units	Numeric	Generic Edit	15	2
TOP09: General Accounting
20	F0911P	Purge - Account Ledger	32	GL	U	Units	Numeric	Generic Edit	15	2
21	F0911R	WF - Account Ledger Reconciliation	29	GL	U	Units	Numeric	Generic Edit	15	2
22	F0911SW	Account Ledger Summary Work Table	8	GS	U	Units	Numeric	Generic Edit	15	2
23	F0911Z1	Journal Entry Transactions - Batch File	49	VN	U	Units	Numeric	Generic Edit	15	2
24	F0911Z4	F0911 Interoperability Table	54	SZ	U	Units	Numeric	Generic Edit	15	2
25	F0912	Cost Allocations/Flex Budgeting	32	RJ	U	Units	Numeric	Generic Edit	15	2
26	F0912A	Index Computation Entry File	28	RI	U	Units	Numeric	Generic Edit	15	2
27	F09UI015	Indexed Computations Multi-Tiered Entries	32	GL	U	Units	Numeric	Generic Edit	15	2
28	F09UI123	Advanced Variable Numerator Worktable	23	VW	U	Units	Numeric	Generic Edit	15	2
29	F52G11	Burdening Detail Ledger	21	BD	U	Units	Numeric	Generic Edit	15	2
30	F52G11WF	Temporary Burdened Detail Ledger Workfile	21	BW	U	Units	Numeric	Generic Edit	15	2
TOP12: Fixed Assets
31	F12911ER	Post G/L to FA Exceptions Work File	10	GL	U	Units	Numeric	Generic Edit	15	2
TOP15: Real Estate Management
32	F1540	Sales Report Control File	19	NR	U	Units	Numeric	Generic Edit	15	2
33	F1540B	Sales Report Control	28	NR	U	Units	Numeric	Generic Edit	15	2
TOP17: Customer Service Management
34	F1721	Contract Detail	65	CD	U	Units	Numeric	Generic Edit	15	2
TOP31: Shop Floor Control
35	F31UI802	Accumulate Amounts by Account	12	WG	U	Units	Numeric	Generic Edit	15	2
36	F31UI803	Work File for Summarizing Journal Entries	12	SG	U	Units	Numeric	Generic Edit	15	2
TOP31B: Blend Management
37	F31B31C	Blend Lot Costs	4	BC	U	Units	Numeric	Generic Edit	15	2
38	F31B66	Blend Transactions	9	BT	U	Units	Numeric	Generic Edit	15	2
TOP42: Sales Management
39	F42800G1	Sales Update G Batch Detail Workfile	22	DG	U	Units	Numeric	Generic Edit	15	2
TOP43: Procurement
40	F4303	Log Master	18	PK	U	Units	Numeric	Generic Edit	15	2
41	F4305	Log Master	26	PL	U	Units	Numeric	Generic Edit	15	2
42	F4314Z	Voucher Match Selection File	76	PN	U	Units	Numeric	Generic Edit	15	2
TOP44H: Homebuilder Management
43	F44H590	Closing Worksheet Accounting Instructions	16	CI	U	Units	Numeric	Generic Edit	15	2
44	F44H591	Closing Worksheet Entries	19	CW	U	Units	Numeric	Generic Edit	15	2
45	F44H73W2	Lot Start - Budget Generation Workfile	8	BG	U	Units	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
46	F47057	EDI Payment Order Remittance Advice - Outbound	87	D3	U	Units	Numeric	Generic Edit	15	2
47	F47057W	EDI Payment Order Remittance Advice - Work	87	D3	U	Units	Numeric	Generic Edit	15	2
TOP48S: Service Billing
48	F4812	Billing Detail Workfile	54	WD	U	Units	Numeric	Generic Edit	15	2
49	F4812H	Billing Workfile History	54	WD	U	Units	Numeric	Generic Edit	15	2
50	F4812HS	Billing Workfile History Purged Save	54	WD	U	Units	Numeric	Generic Edit	15	2
51	F4822	Invoice Summary Work File	37	W4	U	Units	Numeric	Generic Edit	15	2
52	F4823	Voucher Summary	33	W0	U	Units	Numeric	Generic Edit	15	2
53	F48520	Invoice Summary Access	22	AE	U	Units	Numeric	Generic Edit	15	2
54	F48S910	Billing Detail Journal Workfile	32	W2	U	Units	Numeric	Generic Edit	15	2
55	F48S911	Summarized Journal Workfile	27	W3	U	Units	Numeric	Generic Edit	15	2
56	F48S912	G/L Link	16	W6	U	Units	Numeric	Generic Edit	15	2
57	F48SUI01	Billing Detail Print Workfile	54	WD	U	Units	Numeric	Generic Edit	15	2
TOP51X: In-Memory Project Management
58	F51X0911	Account Ledger Worktable	13	AL	U	Units	Numeric	Generic Edit	15	2
TOP52: Contract Billing
59	F5202	Contract Billing Line Detail	28	G6	U	Units	Numeric	Generic Edit	15	2
TOP52G: Proj & Gov Contract Accounting
60	F4822H	Invoice Summary History	37	IH	U	Units	Numeric	Generic Edit	15	2
TOPF31: Lean Transactions
61	FF31113	Lean Transaction Labor Detail	51	LD	U	Units	Numeric	Generic Edit	15	2
62	FF31113S	Purge - Lean Transaction Labor Detail	51	LR	U	Units	Numeric	Generic Edit	15	2

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

62 columns | 920 | U