	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

107 columns | 812 | AA

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018R	Tax Reconciliation Repository	11	ED	AA	Amount	Numeric	Generic Edit	15	2
2	F0911	Account Ledger	31	GL	AA	Amount	Numeric	Generic Edit	15	2
TOP03B: Enhanced Accounts Receivable
3	F03BUI04	Work File for Integrity by Offset Account	6	W3	AA	Amount	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
4	F04514	WF - 1099 Combined Workfile (Merge of F045141 and F045143)	5	G1	AA	Amount	Numeric	Generic Edit	15	2
5	F045141	WF - 1099 G/L Workfile	5	G1	AA	Amount	Numeric	Generic Edit	15	2
6	F045143	WF - 1099 A/P WorkFile	5	G1	AA	Amount	Numeric	Generic Edit	15	2
7	F0457	A/P Payment Tape File	21	KM	AA	Amount	Numeric	Generic Edit	15	2
8	F04UI004	Integrity Report Table F04UI004	6	RP	AA	Amount	Numeric	Generic Edit	15	2
TOP05T: Time Entry
9	F063951	Payroll Journal (Compressed) File	19	GL	AA	Amount	Numeric	Generic Edit	15	2
TOP07: Payroll
10	F05290	WF - Payroll Journal (Detail)	19	JR	AA	Amount	Numeric	Generic Edit	15	2
TOP09: General Accounting
11	F0911P	Purge - Account Ledger	31	GL	AA	Amount	Numeric	Generic Edit	15	2
12	F0911R	WF - Acct Ledger File for Reconciliation	28	GL	AA	Amount	Numeric	Generic Edit	15	2
13	F0911R1	Account Reconciliations Header - OneWorld ONLY	4	GL	AA	Amount	Numeric	Generic Edit	15	2
14	F0911Z1	Journal Entry Transactions - Batch File	48	VN	AA	Amount	Numeric	Generic Edit	15	2
15	F0911Z4	F0911 Interoperability Table	53	SZ	AA	Amount	Numeric	Generic Edit	15	2
16	F0912	Cost Allocations/Flex Budgeting	31	RJ	AA	Amount	Numeric	Generic Edit	15	2
17	F0912A	Index Computation Entry File	27	RI	AA	Amount	Numeric	Generic Edit	15	2
18	F09505	WF - Bank File of Cleared Checks.	4	GN	AA	Amount	Numeric	Generic Edit	15	2
19	F09522	Cash Forecast Data	6	FD	AA	Amount	Numeric	Generic Edit	15	2
20	F09611	Electronic Bank Statement Staging Detail	13	BG	AA	Amount	Numeric	Generic Edit	15	2
21	F09UI007	Match Bank Tape to Recon File - ONE WORLD ONLY	4	GL	AA	Amount	Numeric	Generic Edit	15	2
22	F09UI013	Company by Batch Out of Balance	5	GL	AA	Amount	Numeric	Generic Edit	15	2
23	F09UI015	Indexed Computations Multi-Tiered Entries	31	GL	AA	Amount	Numeric	Generic Edit	15	2
24	F09UI618	Auto Bank Statement Process Work Table	22	NB	AA	Amount	Numeric	Generic Edit	15	2
TOP10: Financial Reporting
25	F10UI520	Cash Flow Statement Worktable	4	CW	AA	Amount	Numeric	Generic Edit	15	2
TOP12: Fixed Assets
26	F12911ER	Post G/L to FA Exceptions Work File	9	GL	AA	Amount	Numeric	Generic Edit	15	2
TOP14: Modeling - Planning & Budgeting
27	F1403	Forecast Basis	22	BD	AA	Amount	Numeric	Generic Edit	15	2
28	F14041	Forecast Results - Detail	10	BZ	AA	Amount	Numeric	Generic Edit	15	2
TOP15: Property Management
29	F1532B	Expense Participation Audit File	12	NT	AA	Amount	Numeric	Generic Edit	15	2
TOP16: Profit Management (EPS)
30	F1611	Cost Calculation Transactions	6	CT	AA	Amount	Numeric	Generic Edit	15	2
TOP31: Shop Floor Control
31	F31UI802	Accumulate Amounts by Account	4	WG	AA	Amount	Numeric	Generic Edit	15	2
32	F31UI803	Work File for Summarizing Journal Entries	4	SG	AA	Amount	Numeric	Generic Edit	15	2
33	F31UI804	Exception Report Work FIle	8	WR	AA	Amount	Numeric	Generic Edit	15	2
TOP31B: Blend Management
34	F31B31C	Blend Lot Costs	7	BC	AA	Amount	Numeric	Generic Edit	15	2
35	F31B66	Blend Transactions	12	BT	AA	Amount	Numeric	Generic Edit	15	2
TOP38: Agreement Management
36	F38011	Agreement Quantities	10	DF	AA	Amount	Numeric	Generic Edit	15	2
37	F38012	Product Source/Destination Master	12	DP	AA	Amount	Numeric	Generic Edit	15	2
38	F38013	Agreement Quantities Schedule	9	DQ	AA	Amount	Numeric	Generic Edit	15	2
39	F38111	Agreements Transaction Ledger	51	DZ	AA	Amount	Numeric	Generic Edit	15	2
40	F38112	Agreements Committed Quantities	13	DX	AA	Amount	Numeric	Generic Edit	15	2
TOP39: Advanced Stock Valuation
41	F3910	G/L Adjustment Table	10	SC	AA	Amount	Numeric	Generic Edit	15	2
TOP42: Sales Management
42	F42800G1	Sales Update G Batch Detail Workfile	10	DG	AA	Amount	Numeric	Generic Edit	15	2
TOP43: Procurement
43	F40910	Commitment Integrity Report Work File	6	P#	AA	Amount	Numeric	Generic Edit	15	2
44	F4314Z	Voucher Match Selection File	77	PN	AA	Amount	Numeric	Generic Edit	15	2
TOP44H: Homebuilder Management
45	F44H590	Closing Worksheet Accounting Instructions	15	CI	AA	Amount	Numeric	Generic Edit	15	2
46	F44H591	Closing Worksheet Entries	16	CW	AA	Amount	Numeric	Generic Edit	15	2
47	F44H73W2	Lot Start - Budget Generation Workfile	7	BG	AA	Amount	Numeric	Generic Edit	15	2
TOP48: Work Order Processing
48	F4827	Work Order Approval Routing	6	W5	AA	Amount	Numeric	Generic Edit	15	2
TOP48S: Service Billing
49	F48096	Billing Rate / Mark up Table	16	WQ	AA	Amount	Numeric	Generic Edit	15	2
50	F4812	Billing Detail Workfile	56	WD	AA	Amount	Numeric	Generic Edit	15	2
51	F4812H	Billing Workfile - History	56	WD	AA	Amount	Numeric	Generic Edit	15	2
52	F4812HS	Billing Workfile History Purged Save	56	WD	AA	Amount	Numeric	Generic Edit	15	2
53	F4822	Invoice Summary Work File	42	W4	AA	Amount	Numeric	Generic Edit	15	2
54	F4823	Voucher Summary	38	W0	AA	Amount	Numeric	Generic Edit	15	2
55	F48520	Invoice Summary Access	23	AE	AA	Amount	Numeric	Generic Edit	15	2
56	F48S910	Billing Detail Journal File	30	W2	AA	Amount	Numeric	Generic Edit	15	2
57	F48S911	Compressed Journal File	26	W3	AA	Amount	Numeric	Generic Edit	15	2
58	F48S912	G/L Link File	17	W6	AA	Amount	Numeric	Generic Edit	15	2
59	F48SUI01	Billing Detail Print Workfile	56	WD	AA	Amount	Numeric	Generic Edit	15	2
TOP49: Transportation Management
60	F49595	Document Print - Document Summary	14	DK	AA	Amount	Numeric	Generic Edit	15	2
61	F49695	Document Register	12	DR	AA	Amount	Numeric	Generic Edit	15	2
TOP51: Job Costing
62	F51911	Draw Reporting Master	17	GK	AA	Amount	Numeric	Generic Edit	15	2
TOP52: Contract Billing
63	F5216	Milestone/Progress Billing Information	11	A6	AA	Amount	Numeric	Generic Edit	15	2
64	F5280W	Contract Revenue Summary Work File	16	GY	AA	Amount	Numeric	Generic Edit	15	2
TOP55: Reserved for Clients
65	F091102	Saldi F0911 dell'anno 2002	3	GL	AA	Amount	Numeric	Generic Edit	15	2
66	F74H1001	Hierarchical Summary Work Table	5	HW	AA	Amount	Numeric	Generic Edit	15	2
67	F74H105S	Slovakian Invoice Accounting Summary	13	AS	AA	Amount	Numeric	Generic Edit	15	2
68	F74TL004	Trial Balance Temp File	14	TB	AA	Amount	Numeric	Generic Edit	15	2
69	F74T531	Customer Ledger Tranaction File	16	CT	AA	Amount	Numeric	Generic Edit	15	2
70	F74T532	Supplier Ledger Transaction File	6	SL	AA	Amount	Numeric	Generic Edit	15	2
71	F74T550	General Ledger Work File - Turkish	29	DK	AA	Amount	Numeric	Generic Edit	15	2
72	F74T133	Customer Year End Table	4	CT	AA	Amount	Numeric	Generic Edit	15	2
73	F74T134	Supplier Year End Table	4	ST	AA	Amount	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
74	F7430035	Taxes by Legal Document Line - COMM - 03B	8	PI	AA	Amount	Numeric	Generic Edit	15	2
75	F74411	Withholding Tax Detail File-Italy	33	RS	AA	Amount	Numeric	Generic Edit	15	2
TOP74R: CIS
76	F74R5110	F1201 Tag File - RUS - 12 - 74R	9	TF	AA	Amount	Numeric	Generic Edit	15	2
77	F74R9010	Profit and Loss - RUS - 09 - 74R	6	PL	AA	Amount	Numeric	Generic Edit	15	2
78	F74R9011	Correspondence Rules - RUS -09 - 74R	18	CR	AA	Amount	Numeric	Generic Edit	15	2
79	F74R9029	Open Accounts - RUS - 09 - 74R	14	OA	AA	Amount	Numeric	Generic Edit	15	2
80	F74R9030	Balance Sheet - RUS - 09 - 74R	6	BS	AA	Amount	Numeric	Generic Edit	15	2
81	F74R9040	Changes in Equity - RUS - 09 - 74R	6	CE	AA	Amount	Numeric	Generic Edit	15	2
TOP75A: Australia - Reporting System Only
82	F75A0220	Payment Summary Workfile	21	PS	AA	Amount	Numeric	Generic Edit	15	2
TOP75J: Japan - Reporting System Only
83	F750411	Withholding Tax Detail Table - Japan	17	JX	AA	Amount	Numeric	Generic Edit	15	2
TOP76A: Argentina
84	F760499A	Contract Withholding - Advances - ARG -04 - 04	5	K8	AA	Amount	Numeric	Generic Edit	15	2
85	F76A20	Credit Invoice Constants - ARG - 03B - 76A	8	IC	AA	Amount	Numeric	Generic Edit	15	2
86	F76A42	CERG G/L - Work File - ARG - 09 - 09	6	TF	AA	Amount	Numeric	Generic Edit	15	2
87	F76AUI98	Cost Account Work Table - Work in Progress Adjustment - 76A	6	CA	AA	Amount	Numeric	Generic Edit	15	2
TOP76B: Brazil - Reporting System Only
88	F7603B1	A/R Additional Information - Brazil	7	CI	AA	Amount	Numeric	Generic Edit	15	2
89	F7603B1P	Archive A/R Additional Information - Brazil - 03B	7	BP	AA	Amount	Numeric	Generic Edit	15	2
90	F76B0402	IR Progressive - 04	1	TP	AA	Amount	Numeric	Generic Edit	15	2
91	F76B0411	Voucher Additional Information Brazil - 04	15	VB	AA	Amount	Numeric	Generic Edit	15	2
92	F76B10	Account Ledger - IN68 - 09	7	AR	AA	Amount	Numeric	Generic Edit	15	2
93	F76B411A	PIS - COFINS and CSLL bellow minimum - BR - 04	7	WM	AA	Amount	Numeric	Generic Edit	15	2
94	F76B473T	F04573 Brazilian Temp WH File - BR - 04	17	W3	AA	Amount	Numeric	Generic Edit	15	2
95	F76B64	Balances/JE's w/ Currency Correction Table - IN68 - 12	10	BS	AA	Amount	Numeric	Generic Edit	15	2
96	F76B911	IN86-Work Table for Journal Entries - 09	9	BD	AA	Amount	Numeric	Generic Edit	15	2
TOP76H: Chile
97	F76H3B37	A/R Document Line (Print Info) - CHI - 03B - 76H	7	PI	AA	Amount	Numeric	Generic Edit	15	2
98	F76H3B40	A/P Document Line (Print Info) - CHI - 04	7	PI	AA	Amount	Numeric	Generic Edit	15	2
99	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	23	I1	AA	Amount	Numeric	Generic Edit	15	2
TOP76V: Venezuela
100	F76V4010	Tributary Unit Setup - 04 - VE	4	IS	AA	Amount	Numeric	Generic Edit	15	2
101	F76VLC01	Purchase Register Temporal - VEN -04 - 76V	5	LC	AA	Amount	Numeric	Generic Edit	15	2
TOP83: Management Reporting - FASTR
102	F83UI001	Balance Audit Work File - (Financial Reporting)	16	R1	AA	Amount	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
103	F06116T	Needed for upgrade from Xe to B9	6	YT	AA	Amount	Numeric	Generic Edit	15	2
104	F06116TZ	Needed for upgrade from Xe to B9	7	VL	AA	Amount	Numeric	Generic Edit	15	2
105	F0618T	Needed for upgrade from Xe to B9	6	YT	AA	Amount	Numeric	Generic Edit	15	2
TOPF31: Lean Transactions
106	FF31113	Lean Transaction Labor Detail	52	LD	AA	Amount	Numeric	Generic Edit	15	2
107	FF31113S	Purge - Lean Transaction Labor Detail	52	LR	AA	Amount	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

107 columns | 812 | AA