	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

164 columns | 812 | GLC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	34	GL	GLC	G/L Offset	String	Generic Edit	4	0
TOP03: Accounts Receivable
2	F0311	Accounts Receivable Ledger	44	RP	GLC	G/L Offset	String	Generic Edit	4	0
TOP03B: Enhanced Accounts Receivable
3	F03B11	Customer Ledger	15	RP	GLC	G/L Offset	String	Generic Edit	4	0
4	F03B112	Invoice Revisions	24	RW	GLC	G/L Offset	String	Generic Edit	4	0
5	F03B112P	Invoice Revisions Purge File	24	RW	GLC	G/L Offset	String	Generic Edit	4	0
6	F03B11P	Customer Ledger Purge File	15	RP	GLC	G/L Offset	String	Generic Edit	4	0
7	F03B11Z1	Invoice Transactions - Batch File	33	VJ	GLC	G/L Offset	String	Generic Edit	4	0
8	F03B11Z2	F03B11 Interoperability Table	28	SY	GLC	G/L Offset	String	Generic Edit	4	0
9	F03B13	Receipts Header File	12	RY	GLC	G/L Offset	String	Generic Edit	4	0
10	F03B13P	Receipts Header Purge File	12	RY	GLC	G/L Offset	String	Generic Edit	4	0
11	F03B13Z2	F03B13 Interoperability Table	25	SY	GLC	G/L Offset	String	Generic Edit	4	0
12	F03B14	A/R Check Detail File	13	RZ	GLC	G/L Offset	String	Generic Edit	4	0
13	F03B14P	Receipts Detail Purge File	13	RZ	GLC	G/L Offset	String	Generic Edit	4	0
14	F03B14Z2	F03B14 Interoperability Table	26	SZ	GLC	G/L Offset	String	Generic Edit	4	0
15	F03B41	A/R Deduction Activity	16	RC	GLC	G/L Offset	String	Generic Edit	4	0
16	F03B465	A/R Netting Workfile	21	RO	GLC	G/L Offset	String	Generic Edit	4	0
17	F03B575	Auto Debit Invoice Select and Build	18	RD	GLC	G/L Offset	String	Generic Edit	4	0
18	F03B672	Draft Remittance Work File - One World Only	15	RD	GLC	G/L Offset	String	Generic Edit	4	0
19	F09UI011	Receipt Prepost Work File	26	GL	GLC	G/L Offset	String	Generic Edit	4	0
TOP04: Accounts Payable
20	F0411	Accounts Payable Ledger	43	RP	GLC	G/L Offset	String	Generic Edit	4	0
21	F0411A	WF - As Of - Accounts Payable Ledger	43	RP	GLC	G/L Offset	String	Generic Edit	4	0
22	F0411P	Purge - Accounts Payable Ledger	43	RP	GLC	G/L Offset	String	Generic Edit	4	0
23	F0411Z1	Voucher Transactions - Batch File	61	VL	GLC	G/L Offset	String	Generic Edit	4	0
24	F0411Z3	F0411 Interoperability Table	66	SZ	GLC	G/L Offset	String	Generic Edit	4	0
25	F0414	Accounts Payable Matching Document Detail	18	RN	GLC	G/L Offset	String	Generic Edit	4	0
26	F0414A	WF - As Of - Accounts Payable Payment Detail	18	RN	GLC	G/L Offset	String	Generic Edit	4	0
27	F0414P	Purge - Accounts Payable Matching Document Detail	18	RN	GLC	G/L Offset	String	Generic Edit	4	0
28	F0414Z1	F0414 Interoperability Table	31	SZ	GLC	G/L Offset	String	Generic Edit	4	0
29	F04573	A/P Payment Processing - Detail File	43	KI	GLC	G/L Offset	String	Generic Edit	4	0
30	F09UI005	Tax Offsets User Index	16	GL	GLC	G/L Offset	String	Generic Edit	4	0
TOP07: Payroll
31	F06491	Payroll/Accounts Payable Ledger Detail	17	J6	GLC	G/L Offset	String	Generic Edit	4	0
32	F07491	Payroll - Accounts Payable Summary File	17	J6	GLC	G/L Offset	String	Generic Edit	4	0
TOP09: General Accounting
33	F0911P	Purge - Account Ledger	34	GL	GLC	G/L Offset	String	Generic Edit	4	0
34	F0911R	WF - Acct Ledger File for Reconciliation	31	GL	GLC	G/L Offset	String	Generic Edit	4	0
35	F0911Z1	Journal Entry Transactions - Batch File	51	VN	GLC	G/L Offset	String	Generic Edit	4	0
36	F0911Z4	F0911 Interoperability Table	56	SZ	GLC	G/L Offset	String	Generic Edit	4	0
37	F0912	Cost Allocations/Flex Budgeting	20	RJ	GLC	G/L Offset	String	Generic Edit	4	0
38	F0912A	Index Computation Entry File	16	RI	GLC	G/L Offset	String	Generic Edit	4	0
39	F09UI015	Indexed Computations Multi-Tiered Entries	34	GL	GLC	G/L Offset	String	Generic Edit	4	0
TOP15: Property Management
40	F15012	Tenant E.P. Class Master	15	NS	GLC	G/L Offset	String	Generic Edit	4	0
41	F15012B	Tenant E.P. Class Master	16	NS	GLC	G/L Offset	String	Generic Edit	4	0
42	F15013	Sales Overage Master	52	NO	GLC	G/L Offset	String	Generic Edit	4	0
43	F15013B	Sales Overage Master File	39	NO	GLC	G/L Offset	String	Generic Edit	4	0
44	F15014	Product Scales Master	12	NP	GLC	G/L Offset	String	Generic Edit	4	0
45	F15014B	Product Scales Master	25	NP	GLC	G/L Offset	String	Generic Edit	4	0
46	F15015	Minimum rent/recoveries Master	8	NQ	GLC	G/L Offset	String	Generic Edit	4	0
47	F15015B	Min/Max Rents And Recoveries Master	17	NQ	GLC	G/L Offset	String	Generic Edit	4	0
48	F15016	Tenant Escalation Master	5	NU	GLC	G/L Offset	String	Generic Edit	4	0
49	F15016B	Tenant Escalation Master	6	NU	GLC	G/L Offset	String	Generic Edit	4	0
50	F1502	Recurring Billings Master	6	NF	GLC	G/L Offset	String	Generic Edit	4	0
51	F1502B	Recurring Billings Master	6	NF	GLC	G/L Offset	String	Generic Edit	4	0
52	F1502WAB	Rent Increase Amounts	5	NF	GLC	G/L Offset	String	Generic Edit	4	0
53	F1502WB	Estimated EP Recurring Billing Work File (OneWorld)	8	N4	GLC	G/L Offset	String	Generic Edit	4	0
54	F1505	Management Fee Master	4	ND	GLC	G/L Offset	String	Generic Edit	4	0
55	F1505B	Management Fee Master	6	ND	GLC	G/L Offset	String	Generic Edit	4	0
56	F1507	Unit Master File	31	NH	GLC	G/L Offset	String	Generic Edit	4	0
57	F1511	Tenant/Lease Billings Detail	20	NJ	GLC	G/L Offset	String	Generic Edit	4	0
58	F1511B	Tenant/Lease Billings Detail Master	20	NJ	GLC	G/L Offset	String	Generic Edit	4	0
59	F1511H	Tenant/Lease Billings Detail History	20	N#	GLC	G/L Offset	String	Generic Edit	4	0
60	F1511HB	Tenant/Lease Billings Detail History	20	NC	GLC	G/L Offset	String	Generic Edit	4	0
61	F1512	Billing Code Extension	1	NA	GLC	G/L Offset	String	Generic Edit	4	0
62	F1512D	Billing Code Extension - Alternate Description	1	NA	GLC	G/L Offset	String	Generic Edit	4	0
63	F151991	G/L Transaction A/R Application Work File	7	NB	GLC	G/L Offset	String	Generic Edit	4	0
64	F15199W	G/L Transaction Summarization Work File	4	NB	GLC	G/L Offset	String	Generic Edit	4	0
65	F1525	A/R Fee Interest	5	N0	GLC	G/L Offset	String	Generic Edit	4	0
66	F1525B	A/R Fee and Interest	5	NM	GLC	G/L Offset	String	Generic Edit	4	0
67	F1538	WF - Expence Participation Register	52	NZ	GLC	G/L Offset	String	Generic Edit	4	0
68	F1538B	EP Billing Register Work File	53	NZ	GLC	G/L Offset	String	Generic Edit	4	0
69	F1565	Security Deposit Master	6	JF	GLC	G/L Offset	String	Generic Edit	4	0
TOP15L: Adv Real Estate Forecasting
70	F15L100	AREF Building Constants	25	BC	GLC	G/L Offset	String	Generic Edit	4	0
71	F15L1001	AREF Building Constants Models	25	BM	GLC	G/L Offset	String	Generic Edit	4	0
72	F15L112	AREF Unit Assumptions Master Detail	7	AD	GLC	G/L Offset	String	Generic Edit	4	0
73	F15L114	AREF E.P. Rules Detail	7	ED	GLC	G/L Offset	String	Generic Edit	4	0
74	F15L116	AREF Recurring Bill Code Rules Detail	4	RD	GLC	G/L Offset	String	Generic Edit	4	0
75	F15L302	AREF Prior Gross Billings	15	PG	GLC	G/L Offset	String	Generic Edit	4	0
76	F15L38	AREF EP Billing Register	56	NZ	GLC	G/L Offset	String	Generic Edit	4	0
TOP17: Customer Service Management
77	F1721	Contract Detail	24	CD	GLC	G/L Offset	String	Generic Edit	4	0
TOP40: Inventory/OP Base
78	F4011Z	Batch Receiver File - Order Details	168	SZ	GLC	G/L Offset	String	Generic Edit	4	0
79	F40205	Line Type Control Constants File	14	LF	GLC	G/L Offset	String	Generic Edit	4	0
80	F40350	Preference Profiles - Conatiner Deposit/Rental	16	OQ	GLC	G/L Offset	String	Generic Edit	4	0
81	F40500	Commodity Structure Definitions	8	CC	GLC	G/L Offset	String	Generic Edit	4	0
82	F40UI74	Price Adjustment History Work File	31	AW	GLC	G/L Offset	String	Generic Edit	4	0
83	F4211Z1	Sales Order Detail Unedited Transaction File	154	SZ	GLC	G/L Offset	String	Generic Edit	4	0
TOP41: Inventory Management
84	F41181	Container Transaction File	25	CM	GLC	G/L Offset	String	Generic Edit	4	0
85	F41291Z	Landed Cost Cache Table	15	IG	GLC	G/L Offset	String	Generic Edit	4	0
TOP42: Sales Management
86	F4074	Price Adjustment Ledger File	25	AL	GLC	G/L Offset	String	Generic Edit	4	0
87	F4211	Sales Order Detail File	141	SD	GLC	G/L Offset	String	Generic Edit	4	0
88	F42119	Sales Order History File	141	SD	GLC	G/L Offset	String	Generic Edit	4	0
89	F42199	S.O. Detail Ledger File	141	SL	GLC	G/L Offset	String	Generic Edit	4	0
90	F42800G1	Sales Update G Batch Detail Workfile	87	DG	GLC	G/L Offset	String	Generic Edit	4	0
91	F42UI12	Sales Order Detail Cache 2 (MBF)	54	ZD	GLC	G/L Offset	String	Generic Edit	4	0
92	F42UI800	Sales Detail Work File - Sales Update	53	SD	GLC	G/L Offset	String	Generic Edit	4	0
TOP43: Procurement
93	F41291	Item Cost Components	15	IG	GLC	G/L Offset	String	Generic Edit	4	0
94	F43080	Approvals Fields Constants	119	PD	GLC	G/L Offset	String	Generic Edit	4	0
95	F4311	Purchase Order Detail File	115	PD	GLC	G/L Offset	String	Generic Edit	4	0
96	F4311Z	Purchase Order Generator File	119	PW	GLC	G/L Offset	String	Generic Edit	4	0
97	F4311Z1	Purchase Order Detail Unedited Transaction Table	128	SZ	GLC	G/L Offset	String	Generic Edit	4	0
98	F43121	Purchase Order Receiver File	44	PR	GLC	G/L Offset	String	Generic Edit	4	0
99	F43121Z	Receiver workfile	32	PW	GLC	G/L Offset	String	Generic Edit	4	0
100	F43121Z1	Receipts Unedited Transaction Table	61	SZ	GLC	G/L Offset	String	Generic Edit	4	0
101	F4314Z	Voucher Match Selection File	143	PN	GLC	G/L Offset	String	Generic Edit	4	0
102	F43199	P.O. Detail Ledger File - Flexible Version	115	OL	GLC	G/L Offset	String	Generic Edit	4	0
103	F4340	Purchase Rebate Master File	14	RD	GLC	G/L Offset	String	Generic Edit	4	0
TOP43E: Requisition Self Service
104	F43E11	Requisition Detail	32	RD	GLC	G/L Offset	String	Generic Edit	4	0
TOP44H: Homebuilder Management
105	F44H611	Bid Details	57	BD	GLC	G/L Offset	String	Generic Edit	4	0
106	F44H611W	Bid Details Work File	61	BW	GLC	G/L Offset	String	Generic Edit	4	0
107	F44H711	Lot Start Workfile	65	SW	GLC	G/L Offset	String	Generic Edit	4	0
108	F44H711Z	HB Lot Start Unedited Transaction File	78	SZ	GLC	G/L Offset	String	Generic Edit	4	0
109	F44H71W1	Lot Start Generation Workfile	65	GW	GLC	G/L Offset	String	Generic Edit	4	0
110	F44H73W1	Lot Start - P.O. / Committment Generation Work File	42	CG	GLC	G/L Offset	String	Generic Edit	4	0
TOP45: Advanced Pricing
111	F4071	Price Adjustment Type	7	AT	GLC	G/L Offset	String	Generic Edit	4	0
112	F4073	Free Goods Master File	10	FG	GLC	G/L Offset	String	Generic Edit	4	0
113	F4511W	Pricing Structure View	12	AP	GLC	G/L Offset	String	Generic Edit	4	0
114	F4575	Ship and Debit History	27	AH	GLC	G/L Offset	String	Generic Edit	4	0
115	F4575TMP	Ship and Debit History - Temp Table	27	AH	GLC	G/L Offset	String	Generic Edit	4	0
116	F4576Z1	Ship and Debit Claims Unedited Transaction Table	112	Z1	GLC	G/L Offset	String	Generic Edit	4	0
TOP47: Electronic Commerce
117	F47012	EDI Purchase Order Detail - Inbound	169	SZ	GLC	G/L Offset	String	Generic Edit	4	0
118	F47017	EDI Purchase Order Detail - Outbound	129	SZ	GLC	G/L Offset	String	Generic Edit	4	0
119	F47022	EDI P.O. Acknowledgment Detail - Inbound	129	SZ	GLC	G/L Offset	String	Generic Edit	4	0
120	F47027	EDI P.O. Acknowledgment Detail - Outbound	169	SZ	GLC	G/L Offset	String	Generic Edit	4	0
121	F47037	EDI Shipping Notice Detail - Outbound	147	SZ	GLC	G/L Offset	String	Generic Edit	4	0
122	F470371	EDI Shipping Notice Detail - Outbound	167	SZ	GLC	G/L Offset	String	Generic Edit	4	0
123	F47047	EDI Invoice Detail (Sales) - Outbound	169	SZ	GLC	G/L Offset	String	Generic Edit	4	0
124	F47057	EDI Payment Order Remittance Advice - Outbound	93	D3	GLC	G/L Offset	String	Generic Edit	4	0
125	F47057W	EDI Payment Order Remittance Advice - Work	93	D3	GLC	G/L Offset	String	Generic Edit	4	0
126	F47072	EDI Receiving Advice Detail - Inbound	130	SZ	GLC	G/L Offset	String	Generic Edit	4	0
127	F47077	EDI Receiving Advice Detail - Outbound	130	SZ	GLC	G/L Offset	String	Generic Edit	4	0
128	F47092	EDI Request for Quote Detail - Inbound	169	SZ	GLC	G/L Offset	String	Generic Edit	4	0
129	F47097	EDI Request for Quote Detail - Outbound	129	SZ	GLC	G/L Offset	String	Generic Edit	4	0
130	F47102	EDI Response to RFQ Detail - Inbound	129	SZ	GLC	G/L Offset	String	Generic Edit	4	0
131	F47107	EDI Response to RFQ Detail - Outbound	169	SZ	GLC	G/L Offset	String	Generic Edit	4	0
132	F47132	EDI Purchase Order Change Detail - Inbound	170	SZ	GLC	G/L Offset	String	Generic Edit	4	0
133	F47137	EDI Purchase Order Change Detail - Outbound	130	SZ	GLC	G/L Offset	String	Generic Edit	4	0
134	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	131	SZ	GLC	G/L Offset	String	Generic Edit	4	0
135	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	171	SZ	GLC	G/L Offset	String	Generic Edit	4	0
136	F47157	EDI Shipping Schedule Detail - Outbound	138	SZ	GLC	G/L Offset	String	Generic Edit	4	0
TOP48S: Service Billing
137	F4812	Billing Detail Workfile	140	WD	GLC	G/L Offset	String	Generic Edit	4	0
138	F48128	G/L Offset and Retainage Information	4	WI	GLC	G/L Offset	String	Generic Edit	4	0
139	F4812H	Billing Workfile - History	140	WD	GLC	G/L Offset	String	Generic Edit	4	0
140	F4812HS	Billing Workfile History Purged Save	140	WD	GLC	G/L Offset	String	Generic Edit	4	0
141	F4822	Invoice Summary Work File	21	W4	GLC	G/L Offset	String	Generic Edit	4	0
142	F4823	Voucher Summary	19	W0	GLC	G/L Offset	String	Generic Edit	4	0
143	F48S910	Billing Detail Journal File	27	W2	GLC	G/L Offset	String	Generic Edit	4	0
144	F48S911	Compressed Journal File	33	W3	GLC	G/L Offset	String	Generic Edit	4	0
145	F48S95	Billing AAI Information	12	WV	GLC	G/L Offset	String	Generic Edit	4	0
146	F48SUI01	Billing Detail Print Workfile	140	WD	GLC	G/L Offset	String	Generic Edit	4	0
TOP49: Transportation Management
147	F49004	Mode of Transport Constants	10	CT	GLC	G/L Offset	String	Generic Edit	4	0
148	F4978	Charge Code Definitions	2	CG	GLC	G/L Offset	String	Generic Edit	4	0
TOP52: Contract Billing
149	F5202	Contract Billing Line Detail	23	G6	GLC	G/L Offset	String	Generic Edit	4	0
TOP74: EMEA Localization
150	F74412	Customer / Supplier Balance Workfile (A/R and A/P)	6	RP	GLC	G/L Offset	String	Generic Edit	4	0
151	F74900	Foreign Receivables and Payables - EMEA	21	RP	GLC	G/L Offset	String	Generic Edit	4	0
TOP74U: United Kingdom Localizations
152	F74U25BT	Interest Tag Table - 15	5	PK	GLC	G/L Offset	String	Generic Edit	4	0
TOP74Y: Italy - Reporting System Only
153	F743B14I	Suspended IVA Generation - Receipt/Rebate Control-Italy	23	TI	GLC	G/L Offset	String	Generic Edit	4	0
TOP76A: Argentina
154	F76A10	Taxes - Tax Definition - ARG - 00 - 00	2	TD	GLC	G/L Offset	String	Generic Edit	4	0
155	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	23	WF	GLC	G/L Offset	String	Generic Edit	4	0
TOP76B: Brazil - Reporting System Only
156	F7611B	Nota Fiscal Detail - Brazil	40	FD	GLC	G/L Offset	String	Generic Edit	4	0
157	F761BA	AS Fiscal file book	43	FB	GLC	G/L Offset	String	Generic Edit	4	0
158	F76B0401	Tax Code - 04	9	CT	GLC	G/L Offset	String	Generic Edit	4	0
159	F76B0411	Voucher Additional Information Brazil - 04	18	VB	GLC	G/L Offset	String	Generic Edit	4	0
160	F76B473T	F04573 Brazilian Temp WH File - BR - 04	22	W3	GLC	G/L Offset	String	Generic Edit	4	0
TOP76C: Colombia
161	F76C031A	A/R Customer ledger As Of - F76C031A - COL - 04	15	RP	GLC	G/L Offset	String	Generic Edit	4	0
162	F76C034A	A/R Check Detail file As Of - COL - 76C	13	RZ	GLC	G/L Offset	String	Generic Edit	4	0
TOP76H: Chile
163	F76HUI52	Document Selection Work File - CHI - 42 - 76H	12	DR	GLC	G/L Offset	String	Generic Edit	4	0
TOP89: Conversion Programs
164	F43199A	Temp F43199 for ERP 9.0 Upgrade	115	OL	GLC	G/L Offset	String	Generic Edit	4	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

164 columns | 812 | GLC