	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

149 columns | 920 | 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	F007032W	Batches Out Of Balance Work Table	7	OB	AA	Amount	Numeric	Generic Edit	15	2
3	F0911	Account Ledger	31	GL	AA	Amount	Numeric	Generic Edit	15	2
4	F097001W	Companies Out of Balance Work Table	6	CB	AA	Amount	Numeric	Generic Edit	15	2
TOP03B: Enhanced Accounts Receivable
5	F03B117	Revenue Recognition GL Info	43	RL	AA	Amount	Numeric	Generic Edit	15	2
6	F03B119	Revenue Recognition GL Info Audit	41	RN	AA	Amount	Numeric	Generic Edit	15	2
7	F03BUI04	Work File for Integrity by Offset Account	6	W3	AA	Amount	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
8	F04514	1099 Merged Worktables (F045141:F045143)	5	G1	AA	Amount	Numeric	Generic Edit	15	2
9	F045141	1099 G/L Worktable	5	G1	AA	Amount	Numeric	Generic Edit	15	2
10	F045143	1099 A/P Worktable	5	G1	AA	Amount	Numeric	Generic Edit	15	2
11	F045145	1099 Securities Identification File	4	G2	AA	Amount	Numeric	Generic Edit	15	2
12	F0457	A/P Payment Tape	21	KM	AA	Amount	Numeric	Generic Edit	15	2
13	F04614	T5018 Tax File	7	CT	AA	Amount	Numeric	Generic Edit	15	2
14	F046141	T5018 Tax Workfile	6	CU	AA	Amount	Numeric	Generic Edit	15	2
15	F04UI004	Integrity Report Worktable	6	RP	AA	Amount	Numeric	Generic Edit	15	2
TOP05T: Time Entry
16	F063951	Payroll Journal (Compressed) File	19	GL	AA	Amount	Numeric	Generic Edit	15	2
TOP07: Payroll
17	F05290	WF - Payroll Journal (Detail)	19	JR	AA	Amount	Numeric	Generic Edit	15	2
TOP09: General Accounting
18	F0911P	Purge - Account Ledger	31	GL	AA	Amount	Numeric	Generic Edit	15	2
19	F0911R	WF - Account Ledger Reconciliation	28	GL	AA	Amount	Numeric	Generic Edit	15	2
20	F0911R1	Account Reconciliations Header - OneWorld ONLY	4	GL	AA	Amount	Numeric	Generic Edit	15	2
21	F0911SW	Account Ledger Summary Work Table	7	GS	AA	Amount	Numeric	Generic Edit	15	2
22	F0911Z1	Journal Entry Transactions - Batch File	48	VN	AA	Amount	Numeric	Generic Edit	15	2
23	F0911Z4	F0911 Interoperability Table	53	SZ	AA	Amount	Numeric	Generic Edit	15	2
24	F0912	Cost Allocations/Flex Budgeting	31	RJ	AA	Amount	Numeric	Generic Edit	15	2
25	F0912A	Index Computation Entry File	27	RI	AA	Amount	Numeric	Generic Edit	15	2
26	F09505	WF - Bank File of Cleared Checks.	4	GN	AA	Amount	Numeric	Generic Edit	15	2
27	F09522	Cash Forecast Data	6	FD	AA	Amount	Numeric	Generic Edit	15	2
28	F09611	Electronic Bank Statement Staging Detail	13	BG	AA	Amount	Numeric	Generic Edit	15	2
29	F097021W	Account Ledger to Account Master Work Table	16	TA	AA	Amount	Numeric	Generic Edit	15	2
30	F09706W	Batch and Company Within Batch Out of Balance Work Table	8	NB	AA	Amount	Numeric	Generic Edit	15	2
31	F09UI007	Match Bank Tape to Recon File - ONE WORLD ONLY	4	GL	AA	Amount	Numeric	Generic Edit	15	2
32	F09UI013	Company by Batch Out of Balance	5	GL	AA	Amount	Numeric	Generic Edit	15	2
33	F09UI015	Indexed Computations Multi-Tiered Entries	31	GL	AA	Amount	Numeric	Generic Edit	15	2
34	F09UI123	Advanced Variable Numerator Worktable	20	VW	AA	Amount	Numeric	Generic Edit	15	2
35	F09UI618	Auto Bank Statement Process Work Table	22	NB	AA	Amount	Numeric	Generic Edit	15	2
36	F52G11	Burdening Detail Ledger	22	BD	AA	Amount	Numeric	Generic Edit	15	2
37	F52G11WF	Temporary Burdened Detail Ledger Workfile	22	BW	AA	Amount	Numeric	Generic Edit	15	2
38	F52G31WF	Reburdening Transactions Workfile	7	RB	AA	Amount	Numeric	Generic Edit	15	2
39	F52G60	Burden Rate Calculations Workfile	17	BW	AA	Amount	Numeric	Generic Edit	15	2
TOP10: Financial Reporting
40	F10UI520	Cash Flow Statement Worktable	4	CW	AA	Amount	Numeric	Generic Edit	15	2
TOP12: Fixed Assets
41	F12911ER	Post G/L to FA Exceptions Work File	9	GL	AA	Amount	Numeric	Generic Edit	15	2
TOP14: Modeling - Planning & Budgeting
42	F1403	Forecast Basis	22	BD	AA	Amount	Numeric	Generic Edit	15	2
43	F14041	Forecast Results - Detail	10	BZ	AA	Amount	Numeric	Generic Edit	15	2
TOP15: Real Estate Management
44	F1532B	Expense Participation Audit File	12	NT	AA	Amount	Numeric	Generic Edit	15	2
45	F1539A	EP Billing Account Adjustments Audit	11	AU	AA	Amount	Numeric	Generic Edit	15	2
TOP16: Profit Management (EPS)
46	F1611	Cost Calculation Transactions	6	CT	AA	Amount	Numeric	Generic Edit	15	2
TOP31: Shop Floor Control
47	F31UI802	Accumulate Amounts by Account	4	WG	AA	Amount	Numeric	Generic Edit	15	2
48	F31UI803	Work File for Summarizing Journal Entries	4	SG	AA	Amount	Numeric	Generic Edit	15	2
49	F31UI804	Exception Report Work FIle	8	WR	AA	Amount	Numeric	Generic Edit	15	2
TOP31B: Blend Management
50	F31B31C	Blend Lot Costs	7	BC	AA	Amount	Numeric	Generic Edit	15	2
51	F31B66	Blend Transactions	12	BT	AA	Amount	Numeric	Generic Edit	15	2
TOP38: Agreement Management
52	F38011	Agreement Quantities	10	DF	AA	Amount	Numeric	Generic Edit	15	2
53	F38012	Product Source/Destination Master	12	DP	AA	Amount	Numeric	Generic Edit	15	2
54	F38013	Agreement Quantities Schedule	9	DQ	AA	Amount	Numeric	Generic Edit	15	2
55	F38111	Agreements Transaction Ledger	51	DZ	AA	Amount	Numeric	Generic Edit	15	2
56	F38112	Agreements Committed Quantities	13	DX	AA	Amount	Numeric	Generic Edit	15	2
TOP39: Advanced Stock Valuation
57	F3910	G/L Adjustment Table	10	SC	AA	Amount	Numeric	Generic Edit	15	2
TOP42: Sales Management
58	F42800G1	Sales Update G Batch Detail Workfile	10	DG	AA	Amount	Numeric	Generic Edit	15	2
TOP42I: Outbound Inventory Management
59	F42I07	Outbound Inventory Agreement Details Change History	11	OQ	AA	Amount	Numeric	Generic Edit	15	2
TOP43: Procurement
60	F40910	Commitment Integrity Report Work File	6	P#	AA	Amount	Numeric	Generic Edit	15	2
61	F4314Z	Voucher Match Selection File	77	PN	AA	Amount	Numeric	Generic Edit	15	2
TOP44H: Homebuilder Management
62	F44H590	Closing Worksheet Accounting Instructions	15	CI	AA	Amount	Numeric	Generic Edit	15	2
63	F44H591	Closing Worksheet Entries	16	CW	AA	Amount	Numeric	Generic Edit	15	2
64	F44H73W2	Lot Start - Budget Generation Workfile	7	BG	AA	Amount	Numeric	Generic Edit	15	2
TOP48: Work Order Processing
65	F4827	Work Order Approval Routing	6	W5	AA	Amount	Numeric	Generic Edit	15	2
TOP48S: Service Billing
66	F48096	Billing Rate / Mark up Table	16	WQ	AA	Amount	Numeric	Generic Edit	15	2
67	F4812	Billing Detail Workfile	56	WD	AA	Amount	Numeric	Generic Edit	15	2
68	F4812H	Billing Workfile History	56	WD	AA	Amount	Numeric	Generic Edit	15	2
69	F4812HS	Billing Workfile History Purged Save	56	WD	AA	Amount	Numeric	Generic Edit	15	2
70	F4822	Invoice Summary Work File	42	W4	AA	Amount	Numeric	Generic Edit	15	2
71	F4823	Voucher Summary	38	W0	AA	Amount	Numeric	Generic Edit	15	2
72	F48520	Invoice Summary Access	23	AE	AA	Amount	Numeric	Generic Edit	15	2
73	F48S910	Billing Detail Journal Workfile	30	W2	AA	Amount	Numeric	Generic Edit	15	2
74	F48S911	Summarized Journal Workfile	26	W3	AA	Amount	Numeric	Generic Edit	15	2
75	F48S912	G/L Link	17	W6	AA	Amount	Numeric	Generic Edit	15	2
76	F48SUI01	Billing Detail Print Workfile	56	WD	AA	Amount	Numeric	Generic Edit	15	2
TOP49: Transportation Management
77	F49595	Document Print - Document Summary	14	DK	AA	Amount	Numeric	Generic Edit	15	2
78	F49695	Document Register	12	DR	AA	Amount	Numeric	Generic Edit	15	2
TOP51: Job Costing
79	F51911	Draw Reporting Master	17	GK	AA	Amount	Numeric	Generic Edit	15	2
TOP51X: In-Memory Project Management
80	F51X0911	Account Ledger Worktable	12	AL	AA	Amount	Numeric	Generic Edit	15	2
TOP52: Contract Billing
81	F5216	Milestone/Progress Billing Information	11	A6	AA	Amount	Numeric	Generic Edit	15	2
82	F5280W	Contract Revenue Summary Work File	16	GY	AA	Amount	Numeric	Generic Edit	15	2
TOP52G: Proj & Gov Contract Accounting
83	F4822H	Invoice Summary History	42	IH	AA	Amount	Numeric	Generic Edit	15	2
TOP70: Multi-National Products
84	F704200	Final VAT AP - COMM - 70	19	FV	AA	Amount	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
85	F7430035	Taxes by Legal Document Line - COMM - 03B	8	PI	AA	Amount	Numeric	Generic Edit	15	2
86	F743035	Display Taxes by Legal Document Line - COMM - 03B	10	DT	AA	Amount	Numeric	Generic Edit	15	2
87	F74411	Withholding Tax Detail - Italy	33	RS	AA	Amount	Numeric	Generic Edit	15	2
TOP74R: Russia
88	F74R5110	F1201 Tag File - RUS - 12 - 74R	9	TF	AA	Amount	Numeric	Generic Edit	15	2
89	F74R9010	Profit & Loss - RUS - 09 - 74R	6	PL	AA	Amount	Numeric	Generic Edit	15	2
90	F74R9011	Correspondence Rules - RUS -09 - 74R	18	CR	AA	Amount	Numeric	Generic Edit	15	2
91	F74R9029	Open Accounts - RUS - 09 - 74R	14	OA	AA	Amount	Numeric	Generic Edit	15	2
92	F74R9030	Balance Sheet - RUS - 09 - 74R	6	BS	AA	Amount	Numeric	Generic Edit	15	2
93	F74R9040	Changes in Equity - RUS - 09 - 74R	6	CE	AA	Amount	Numeric	Generic Edit	15	2
TOP74U: United Kingdom Localizations
94	F74U0408	SPC Lower Level Retention - UK - 43	9	LR	AA	Amount	Numeric	Generic Edit	15	2
95	F74U0409	SPC Lower Level MCD - UK - 43	9	LM	AA	Amount	Numeric	Generic Edit	15	2
96	F74U0445	SPC Accounts Payable Match Doc Detail Tag File - UK - 43	12	RN	AA	Amount	Numeric	Generic Edit	15	2
TOP74Z: Czech Republic
97	F74Z0010	Cash Desk Document Printed - CZE - 74Z	11	ZO	AA	Amount	Numeric	Generic Edit	15	2
98	F74ZUI01	Corresponding Accounts	7	CZ	AA	Amount	Numeric	Generic Edit	15	2
TOP75A: Australia
99	F75A0220	Payment Summary Workfile	21	PS	AA	Amount	Numeric	Generic Edit	15	2
TOP75C: China
100	F75C014	AP/AR Balances - China	9	BA	AA	Amount	Numeric	Generic Edit	15	2
101	F75C015	Cash Flow Data - China	24	CF	AA	Amount	Numeric	Generic Edit	15	2
102	F75C202	Asset Disposal Amounts - CHINA	10	DA	AA	Amount	Numeric	Generic Edit	15	2
103	F75C910	China Reports Balance -CNAO V2	7	CF	AA	Amount	Numeric	Generic Edit	15	2
TOP75I: India
104	F75I100	TDS Ceritificate Master Maintenance	12	QB	AA	Amount	Numeric	Generic Edit	15	2
105	F75I100Q	TDS Form 26Q - WorkFile (Quarterly)	13	EF	AA	Amount	Numeric	Generic Edit	15	2
106	F75I100W	TDS Form 26 - WorkFile	13	EF	AA	Amount	Numeric	Generic Edit	15	2
107	F75I101	TDS Certificate Work Maintenance	13	QB	AA	Amount	Numeric	Generic Edit	15	2
108	F75I119T	Challan number wise amount	2	CN	AA	Amount	Numeric	Generic Edit	15	2
109	F75I2241	WorkFile for VAT/CST Receivables	15	VC	AA	Amount	Numeric	Generic Edit	15	2
110	F75I2242	VAT- Deferred Amounts for the Purchase cycle	11	DA	AA	Amount	Numeric	Generic Edit	15	2
111	F75I3051	Excise Fiscal Years	13	FY	AA	Amount	Numeric	Generic Edit	15	2
112	F75I322	Excise - Work File for F04211 & F4101	20	Q3	AA	Amount	Numeric	Generic Edit	15	2
113	F75I322E	Excise - Work File for F04211 & F4101(Based on F75I322)	24	Q3	AA	Amount	Numeric	Generic Edit	15	2
114	F75I344C	ARE-1 Bond Register for Cancelled Receipts-IND-00	16	CD	AA	Amount	Numeric	Generic Edit	15	2
115	F75I382	Amount of Interest Paid per month - IND - 00	6	IP	AA	Amount	Numeric	Generic Edit	15	2
116	F75I421	Assign Price / Cost Elements	5	MA	AA	Amount	Numeric	Generic Edit	15	2
117	F75I4223	Sales Tax Summary/Detail	34	SD	AA	Amount	Numeric	Generic Edit	15	2
118	F75I732	Service Tax A/R File Additional Info - IND - 03B	11	ST	AA	Amount	Numeric	Generic Edit	15	2
119	F75I742	Service Tax A/P File Additional Info - IND - 04	12	ST	AA	Amount	Numeric	Generic Edit	15	2
TOP75J: Japan
120	F750411	Withholding Tax Detail - Japan - 04	17	JX	AA	Amount	Numeric	Generic Edit	15	2
TOP76A: Argentina
121	F760499A	Contract Withholding - Advances - ARG -04 - 76A	5	K8	AA	Amount	Numeric	Generic Edit	15	2
122	F76A20	Credit Invoice Constants - ARG - 03B - 76A	8	IC	AA	Amount	Numeric	Generic Edit	15	2
123	F76A42	CERG G/L - Work File - ARG - 09 - 76A	6	TF	AA	Amount	Numeric	Generic Edit	15	2
124	F76AUI98	Cost Account Work Table - Work in Progress Adjustment - 76A	6	CA	AA	Amount	Numeric	Generic Edit	15	2
TOP76B: Brazil
125	F7603B1	A/R Additional Information - Brazil - 03B	7	CI	AA	Amount	Numeric	Generic Edit	15	2
126	F7603B1P	Archive A/R Additional Information - Brazil - 03B	7	BP	AA	Amount	Numeric	Generic Edit	15	2
127	F76B0402	IR Progressive - 04	1	TP	AA	Amount	Numeric	Generic Edit	15	2
128	F76B0411	Voucher Additional Information Brazil - 04	15	VB	AA	Amount	Numeric	Generic Edit	15	2
129	F76B0540	Brazil Electronic Reporting Block B Worktable	14	BW	AA	Amount	Numeric	Generic Edit	15	2
130	F76B10	Account Ledger - IN68 - 09	7	AR	AA	Amount	Numeric	Generic Edit	15	2
131	F76B411A	PIS, COFINS and CSLL bellow minimum - BR - 04	7	WM	AA	Amount	Numeric	Generic Edit	15	2
132	F76B473T	F04573 Brazilian Temp WH File - BR - 04	17	W3	AA	Amount	Numeric	Generic Edit	15	2
133	F76B64	Balances/JE's w/ Currency Correction Table - IN68 - 12	10	BS	AA	Amount	Numeric	Generic Edit	15	2
134	F76B911	IN86-Work Table for Journal Entries - 09	9	BD	AA	Amount	Numeric	Generic Edit	15	2
TOP76H: Chile
135	F76H3B37	A/R Document Line (Print Info) - CHI - 03B - 76H	7	PI	AA	Amount	Numeric	Generic Edit	15	2
136	F76H3B40	A/P Document Line (Print Info) - CHI - 04	7	PI	AA	Amount	Numeric	Generic Edit	15	2
137	F76H6002	Indirect Costs Selection EPS F1602 - CHI - 41 - 76H	23	I1	AA	Amount	Numeric	Generic Edit	15	2
TOP76M: Mexico
138	F76M413	Manual Payment Header Additional Details - MEX - 04	9	MW	AA	Amount	Numeric	Generic Edit	15	2
139	F76M414	A/P Matching Detail Withholding Information - MEX - 04	5	MW	AA	Amount	Numeric	Generic Edit	15	2
140	F76M572	A/P Header Withholding Summary Details - MEX - 04	7	WS	AA	Amount	Numeric	Generic Edit	15	2
141	F76M573	PCG Detail Withholding Amounts - MEX - 04	11	WD	AA	Amount	Numeric	Generic Edit	15	2
TOP76V: Venezuela
142	F76V4010	Tributary Unit Setup - 04 - VE	4	IS	AA	Amount	Numeric	Generic Edit	15	2
143	F76VLC01	Purchase Register Temporal - VEN -04 - 76V	5	LC	AA	Amount	Numeric	Generic Edit	15	2
TOP83: Management Reporting - FASTR
144	F83UI001	Balance Audit Work File - (Financial Reporting)	16	R1	AA	Amount	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
145	F06116T	Needed for upgrade from Xe to B9	6	YT	AA	Amount	Numeric	Generic Edit	15	2
146	F06116TZ	Needed for upgrade from Xe to B9	7	VL	AA	Amount	Numeric	Generic Edit	15	2
147	F0618T	Needed for upgrade from Xe to B9	6	YT	AA	Amount	Numeric	Generic Edit	15	2
TOPF31: Lean Transactions
148	FF31113	Lean Transaction Labor Detail	52	LD	AA	Amount	Numeric	Generic Edit	15	2
149	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

149 columns | 920 | AA