	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

54 columns | 812 | 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	F4303	Log Master	18	PK	U	Units	Numeric	Generic Edit	15	2
3	F4303M	Log Models	16	PM	U	Units	Numeric	Generic Edit	15	2
TOP03: Accounts Receivable
4	F0311	Accounts Receivable Ledger	98	RP	U	Units	Numeric	Generic Edit	15	2
TOP03B: Enhanced Accounts Receivable
5	F03B11	Customer Ledger	96	RP	U	Units	Numeric	Generic Edit	15	2
6	F03B11P	Customer Ledger Purge File	96	RP	U	Units	Numeric	Generic Edit	15	2
7	F03B11Z1	Invoice Transactions - Batch File	112	VJ	U	Units	Numeric	Generic Edit	15	2
8	F03B11Z2	F03B11 Interoperability Table	109	SY	U	Units	Numeric	Generic Edit	15	2
9	F03B29	Credit Insurance Table	11	IP	U	Units	Numeric	Generic Edit	15	2
10	F03B575	Auto Debit Invoice Select and Build	105	RD	U	Units	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
11	F0411	Accounts Payable Ledger	76	RP	U	Units	Numeric	Generic Edit	15	2
12	F0411A	WF - As Of - Accounts Payable Ledger	76	RP	U	Units	Numeric	Generic Edit	15	2
13	F0411P	Purge - Accounts Payable Ledger	76	RP	U	Units	Numeric	Generic Edit	15	2
14	F0411Z1	Voucher Transactions - Batch File	94	VL	U	Units	Numeric	Generic Edit	15	2
15	F0411Z3	F0411 Interoperability Table	99	SZ	U	Units	Numeric	Generic Edit	15	2
TOP05T: Time Entry
16	F063951	Payroll Journal (Compressed) File	20	GL	U	Units	Numeric	Generic Edit	15	2
TOP07: Payroll
17	F05290	WF - Payroll Journal (Detail)	20	JR	U	Units	Numeric	Generic Edit	15	2
TOP08: Human Resources
18	F08711	Employee Setup Tasks	7	ET	U	Units	Numeric	Generic Edit	15	2
TOP09: General Accounting
19	F0911P	Purge - Account Ledger	32	GL	U	Units	Numeric	Generic Edit	15	2
20	F0911R	WF - Acct Ledger File for Reconciliation	29	GL	U	Units	Numeric	Generic Edit	15	2
21	F0911Z1	Journal Entry Transactions - Batch File	49	VN	U	Units	Numeric	Generic Edit	15	2
22	F0911Z4	F0911 Interoperability Table	54	SZ	U	Units	Numeric	Generic Edit	15	2
23	F0912	Cost Allocations/Flex Budgeting	32	RJ	U	Units	Numeric	Generic Edit	15	2
24	F0912A	Index Computation Entry File	28	RI	U	Units	Numeric	Generic Edit	15	2
25	F09UI015	Indexed Computations Multi-Tiered Entries	32	GL	U	Units	Numeric	Generic Edit	15	2
TOP12: Fixed Assets
26	F12911ER	Post G/L to FA Exceptions Work File	10	GL	U	Units	Numeric	Generic Edit	15	2
TOP15: Property Management
27	F1540	Sales Report Control File	19	NR	U	Units	Numeric	Generic Edit	15	2
28	F1540B	Sales Report Control File	28	NR	U	Units	Numeric	Generic Edit	15	2
TOP17: Customer Service Management
29	F1721	Contract Detail	65	CD	U	Units	Numeric	Generic Edit	15	2
TOP31: Shop Floor Control
30	F31UI802	Accumulate Amounts by Account	12	WG	U	Units	Numeric	Generic Edit	15	2
31	F31UI803	Work File for Summarizing Journal Entries	12	SG	U	Units	Numeric	Generic Edit	15	2
TOP31B: Blend Management
32	F31B31C	Blend Lot Costs	4	BC	U	Units	Numeric	Generic Edit	15	2
33	F31B66	Blend Transactions	9	BT	U	Units	Numeric	Generic Edit	15	2
TOP42: Sales Management
34	F42800G1	Sales Update G Batch Detail Workfile	22	DG	U	Units	Numeric	Generic Edit	15	2
TOP43: Procurement
35	F4305	Log Master	26	PL	U	Units	Numeric	Generic Edit	15	2
36	F4314Z	Voucher Match Selection File	76	PN	U	Units	Numeric	Generic Edit	15	2
TOP44H: Homebuilder Management
37	F44H590	Closing Worksheet Accounting Instructions	16	CI	U	Units	Numeric	Generic Edit	15	2
38	F44H591	Closing Worksheet Entries	19	CW	U	Units	Numeric	Generic Edit	15	2
39	F44H73W2	Lot Start - Budget Generation Workfile	8	BG	U	Units	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
40	F47057	EDI Payment Order Remittance Advice - Outbound	87	D3	U	Units	Numeric	Generic Edit	15	2
41	F47057W	EDI Payment Order Remittance Advice - Work	87	D3	U	Units	Numeric	Generic Edit	15	2
TOP48S: Service Billing
42	F4812	Billing Detail Workfile	54	WD	U	Units	Numeric	Generic Edit	15	2
43	F4812H	Billing Workfile - History	54	WD	U	Units	Numeric	Generic Edit	15	2
44	F4812HS	Billing Workfile History Purged Save	54	WD	U	Units	Numeric	Generic Edit	15	2
45	F4822	Invoice Summary Work File	37	W4	U	Units	Numeric	Generic Edit	15	2
46	F4823	Voucher Summary	33	W0	U	Units	Numeric	Generic Edit	15	2
47	F48520	Invoice Summary Access	22	AE	U	Units	Numeric	Generic Edit	15	2
48	F48S910	Billing Detail Journal File	32	W2	U	Units	Numeric	Generic Edit	15	2
49	F48S911	Compressed Journal File	27	W3	U	Units	Numeric	Generic Edit	15	2
50	F48S912	G/L Link File	16	W6	U	Units	Numeric	Generic Edit	15	2
51	F48SUI01	Billing Detail Print Workfile	54	WD	U	Units	Numeric	Generic Edit	15	2
TOP52: Contract Billing
52	F5202	Contract Billing Line Detail	28	G6	U	Units	Numeric	Generic Edit	15	2
TOPF31: Lean Transactions
53	FF31113	Lean Transaction Labor Detail	51	LD	U	Units	Numeric	Generic Edit	15	2
54	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

54 columns | 812 | U