	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

151 columns | 920 | RMK

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00092	Supplemental Data	18	T3	RMK	Name - Remark	String	Generic Edit	30	0
2	F00189	WF - Tax Reconciliation	19	TG	RMK	Name - Remark	String	Generic Edit	30	0
3	F0050	Organization Structure Master File	7	MA	RMK	Name - Remark	String	Generic Edit	30	0
4	F00692	Cost Center Supplemental Data Codes	7	M2	RMK	Name - Remark	String	Generic Edit	30	0
5	F5301	Change Request Master Table	4	DI	RMK	Name - Remark	String	Generic Edit	30	0
TOP01: Address Book
6	F0101	Address Book Master	63	AB	RMK	Name - Remark	String	Generic Edit	30	0
7	F0101Z2	Address Book - Interoperability	76	SZ	RMK	Name - Remark	String	Generic Edit	30	0
8	F01092	Supplemental Database - Code	9	A2	RMK	Name - Remark	String	Generic Edit	30	0
9	F0150	Address Organization Structure Master	7	MA	RMK	Name - Remark	String	Generic Edit	30	0
10	F01501	Enhanced Parent Child	9	PR	RMK	Name - Remark	String	Generic Edit	30	0
TOP03: Accounts Receivable
11	F0311	Accounts Receivable Ledger	93	RP	RMK	Name - Remark	String	Generic Edit	30	0
12	F0312	A/R Batch Cash Application	24	RU	RMK	Name - Remark	String	Generic Edit	30	0
TOP03B: Enhanced Accounts Receivable
13	F03B11	Customer Ledger	89	RP	RMK	Name - Remark	String	Generic Edit	30	0
14	F03B112	Invoice Revisions	25	RW	RMK	Name - Remark	String	Generic Edit	30	0
15	F03B112P	Invoice Revisions Purge File	25	RW	RMK	Name - Remark	String	Generic Edit	30	0
16	F03B11P	Customer Ledger Purge File	89	RP	RMK	Name - Remark	String	Generic Edit	30	0
17	F03B11Z1	Batch Invoices	105	VJ	RMK	Name - Remark	String	Generic Edit	30	0
18	F03B11Z2	F03B11 Interoperability Table	102	SY	RMK	Name - Remark	String	Generic Edit	30	0
19	F03B13Z1	Electronic Receipts Input	31	RU	RMK	Name - Remark	String	Generic Edit	30	0
20	F03B14	Receipts Detail	77	RZ	RMK	Name - Remark	String	Generic Edit	30	0
21	F03B14P	Receipts Detail Purge File	77	RZ	RMK	Name - Remark	String	Generic Edit	30	0
22	F03B14Z2	F03B14 Interoperability Table	90	SZ	RMK	Name - Remark	String	Generic Edit	30	0
23	F03B21	A/R Notification History Detail	14	ZS	RMK	Name - Remark	String	Generic Edit	30	0
24	F03B22	A/R Fee Journal History	18	RS	RMK	Name - Remark	String	Generic Edit	30	0
25	F03B31	Customer Activity Log	8	ZG	RMK	Name - Remark	String	Generic Edit	30	0
26	F03B575	Auto Debit Invoice Select and Build	98	RD	RMK	Name - Remark	String	Generic Edit	30	0
TOP04: Accounts Payable
27	F0411	Accounts Payable Ledger	71	RP	RMK	Name - Remark	String	Generic Edit	30	0
28	F0411A	WF - 'As Of' Accounts Payable Ledger	71	RP	RMK	Name - Remark	String	Generic Edit	30	0
29	F0411P	Purge - Accounts Payable Ledger	71	RP	RMK	Name - Remark	String	Generic Edit	30	0
30	F0411Z1	Voucher Transactions - Batch Upload	89	VL	RMK	Name - Remark	String	Generic Edit	30	0
31	F0411Z3	F0411 Interoperability Table	94	SZ	RMK	Name - Remark	String	Generic Edit	30	0
32	F0414	Accounts Payable Matching Document Detail	29	RN	RMK	Name - Remark	String	Generic Edit	30	0
33	F0414A	WF - 'As Of' Accounts Payable Payment Detail	29	RN	RMK	Name - Remark	String	Generic Edit	30	0
34	F0414P	Purge - Accounts Payable Matching Document Detail	29	RN	RMK	Name - Remark	String	Generic Edit	30	0
35	F0414Z1	F0414 Interoperability Table	42	SZ	RMK	Name - Remark	String	Generic Edit	30	0
36	F04572	A/P Payment Processing - Summary	37	KK	RMK	Name - Remark	String	Generic Edit	30	0
37	F04573	A/P Payment Processing - Detail	21	KI	RMK	Name - Remark	String	Generic Edit	30	0
38	F09UI005	Tax Offsets User Index	32	GL	RMK	Name - Remark	String	Generic Edit	30	0
TOP05A: PeopleSoft HR & PR Foundation
39	F08097	HR Generic Table Ranges	7	H#	RMK	Name - Remark	String	Generic Edit	30	0
TOP07: Payroll
40	F06491	Payroll/Accounts Payable Ledger Detail	8	J6	RMK	Name - Remark	String	Generic Edit	30	0
41	F07107	Employee Wage Attachment Rules	15	JW	RMK	Name - Remark	String	Generic Edit	30	0
42	F07491	Payroll - Accounts Payable Summary File	8	J6	RMK	Name - Remark	String	Generic Edit	30	0
TOP08: Human Resources
43	F08092	Human Resources General Description-User Def Codes	12	JZ	RMK	Name - Remark	String	Generic Edit	30	0
TOP08P: Position Control
44	F08111	Position Budget Detail	13	HQ	RMK	Name - Remark	String	Generic Edit	30	0
45	F08111P	Purge - Position Budget Detail	13	HQ	RMK	Name - Remark	String	Generic Edit	30	0
TOP08W: Wage and Salary
46	F082001	Pay Grade/Salary Range Table	8	HS	RMK	Name - Remark	String	Generic Edit	30	0
47	F08201	Salary Review Workfile	46	HR	RMK	Name - Remark	String	Generic Edit	30	0
TOP09: General Accounting
48	F0917	Bank Statement Detail	20	GD	RMK	Name - Remark	String	Generic Edit	30	0
49	F09617	Auto Bank Statement Detail	23	GM	RMK	Name - Remark	String	Generic Edit	30	0
TOP12: Fixed Assets
50	F1201	Asset Master File	51	FA	RMK	Name - Remark	String	Generic Edit	30	0
51	F1201P	Asset Master Purge Table	51	FA	RMK	Name - Remark	String	Generic Edit	30	0
52	F1201Z1	Unedited Asset Master Transactions	64	FA	RMK	Name - Remark	String	Generic Edit	30	0
53	F1204	Location Tracking Table	5	FM	RMK	Name - Remark	String	Generic Edit	30	0
54	F1204P	Location Tracking Purge Table	5	FM	RMK	Name - Remark	String	Generic Edit	30	0
55	F12092	Fixed Assets Supplemental Data Codes Type	7	F3	RMK	Name - Remark	String	Generic Edit	30	0
TOP13: Plant/Equipment Management
56	F1207	Maintenance Schedule File	9	FW	RMK	Name - Remark	String	Generic Edit	30	0
57	F12071	Equipment PM Schedule (Model)	32	FZ	RMK	Name - Remark	String	Generic Edit	30	0
58	F1207P	Maintenance Schedule Purge Table	9	FW	RMK	Name - Remark	String	Generic Edit	30	0
59	F1307	Status History File	14	F1	RMK	Name - Remark	String	Generic Edit	30	0
60	F1307P	Status History Purge Table	14	F1	RMK	Name - Remark	String	Generic Edit	30	0
TOP15: Real Estate Management
61	F15012B	Tenant E.P. Class Master	97	NS	RMK	Name - Remark	String	Generic Edit	30	0
62	F15016	Tenant Escalation Master	35	NU	RMK	Name - Remark	String	Generic Edit	30	0
63	F15016B	Tenant Escalation Master	36	NU	RMK	Name - Remark	String	Generic Edit	30	0
64	F1502	Recurring Billings Master	7	NF	RMK	Name - Remark	String	Generic Edit	30	0
65	F1502B	Recurring Billings Master	7	NF	RMK	Name - Remark	String	Generic Edit	30	0
66	F1502BD	Recurring Billings Master - Alternate Description	4	NF	RMK	Name - Remark	String	Generic Edit	30	0
67	F1502WB	Estimated EP Recurring Billings	9	N4	RMK	Name - Remark	String	Generic Edit	30	0
68	F15152	Lease E.P. Caps	21	LC	RMK	Name - Remark	String	Generic Edit	30	0
69	F151521	Lease E.P. Accounts Not Subject to Cap	12	LO	RMK	Name - Remark	String	Generic Edit	30	0
70	F1530	Expense Participation Class Master	26	NG	RMK	Name - Remark	String	Generic Edit	30	0
71	F15301	E.P. Class Account Overrides	24	AO	RMK	Name - Remark	String	Generic Edit	30	0
72	F1533B	Tenant Account Exclusions	49	NM	RMK	Name - Remark	String	Generic Edit	30	0
TOP17C: Call Management
73	F1731	Equipment Master Location History	11	LQ	RMK	Name - Remark	String	Generic Edit	30	0
TOP40R: Demand Scheduling
74	F471721	EDI Demand Supplemental Data	24	EU	RMK	Name - Remark	String	Generic Edit	30	0
TOP41: Inventory Management
75	F41092	Item Supplemental Data Base User Defined Codes	9	T2	RMK	Name - Remark	String	Generic Edit	30	0
76	F4160	Tag Inventory File	20	IT	RMK	Name - Remark	String	Generic Edit	30	0
TOP43: Procurement
77	F4301	Purchase Order Header	27	PH	RMK	Name - Remark	String	Generic Edit	30	0
78	F4301Z	PO Header Work File	31	PA	RMK	Name - Remark	String	Generic Edit	30	0
79	F4301Z1	Purchase Order Header Unedited Transaction Table	40	SY	RMK	Name - Remark	String	Generic Edit	30	0
80	F4314Z	Voucher Match Selection File	61	PN	RMK	Name - Remark	String	Generic Edit	30	0
81	F4318	Approval/Rejection Reasons	7	PY	RMK	Name - Remark	String	Generic Edit	30	0
82	F43UI50H	PO Print Header Work File	44	PA	RMK	Name - Remark	String	Generic Edit	30	0
83	F74U0142	ACM - Application / Certificate Status History	15	DH	RMK	Name - Remark	String	Generic Edit	30	0
TOP44H: Homebuilder Management
84	F44H402	Option Relationships	12	PK	RMK	Name - Remark	String	Generic Edit	30	0
85	F44H601	Bid Header	17	BH	RMK	Name - Remark	String	Generic Edit	30	0
86	F44H711	Lot Start Workfile	44	SW	RMK	Name - Remark	String	Generic Edit	30	0
87	F44H711Z	HB Lot Start Unedited Transaction File	57	SZ	RMK	Name - Remark	String	Generic Edit	30	0
88	F44H71W1	Lot Start Generation Workfile	44	GW	RMK	Name - Remark	String	Generic Edit	30	0
89	F44H73W1	Lot Start - P.O. / Committment Generation Work File	72	CG	RMK	Name - Remark	String	Generic Edit	30	0
TOP47: Electronic Commerce
90	F47016	EDI Purchase Order Header - Outbound	42	SY	RMK	Name - Remark	String	Generic Edit	30	0
91	F47021	EDI P.O. Acknowledgment Header - Inbound	42	SY	RMK	Name - Remark	String	Generic Edit	30	0
92	F47031	EDI Shipping Notice Header - Inbound	40	SY	RMK	Name - Remark	String	Generic Edit	30	0
93	F47041	EDI Invoice Header - Inbound	51	SY	RMK	Name - Remark	String	Generic Edit	30	0
94	F47042	EDI Invoice Detail - Inbound	89	SZ	RMK	Name - Remark	String	Generic Edit	30	0
95	F47057	EDI Payment Order Remittance Advice - Outbound	80	D3	RMK	Name - Remark	String	Generic Edit	30	0
96	F47057W	EDI Payment Order Remittance Advice - Work	80	D3	RMK	Name - Remark	String	Generic Edit	30	0
97	F47071	EDI Receiving Advice Header - Inbound	43	SY	RMK	Name - Remark	String	Generic Edit	30	0
98	F47076	EDI Receiving Advice Header - Outbound	43	SY	RMK	Name - Remark	String	Generic Edit	30	0
99	F47096	EDI Request for Quote Header - Outbound	42	SY	RMK	Name - Remark	String	Generic Edit	30	0
100	F47101	EDI Response to RFQ Header - Inbound	42	SY	RMK	Name - Remark	String	Generic Edit	30	0
101	F47114	EDI Lockbox/Payment Detail - Payment	18	Z4	RMK	Name - Remark	String	Generic Edit	30	0
102	F47136	EDI Purchase Order Change Header - Outbound	42	SY	RMK	Name - Remark	String	Generic Edit	30	0
103	F47141	EDI P.O. Change Acknowledgment Header - Inbound	43	SY	RMK	Name - Remark	String	Generic Edit	30	0
104	F47156	EDI Shipping Schedule Header - Outbound	45	SY	RMK	Name - Remark	String	Generic Edit	30	0
TOP48: Work Order Processing
105	F48092	WO Supplemental DB User Defined	7	W8	RMK	Name - Remark	String	Generic Edit	30	0
TOP48S: Service Billing
106	F4822	Invoice Summary Work File	92	W4	RMK	Name - Remark	String	Generic Edit	30	0
107	F4823	Voucher Summary	64	W0	RMK	Name - Remark	String	Generic Edit	30	0
TOP52: Contract Billing
108	F5202	Contract Billing Line Detail	72	G6	RMK	Name - Remark	String	Generic Edit	30	0
TOP52G: Proj & Gov Contract Accounting
109	F4822H	Invoice Summary History	92	IH	RMK	Name - Remark	String	Generic Edit	30	0
TOP53: Change Management
110	F5301B	Change Request Master Table	5	DI	RMK	Name - Remark	String	Generic Edit	30	0
111	F5301BZ1	Change Request Master Table Workfile	9	DI	RMK	Name - Remark	String	Generic Edit	30	0
TOP74: EMEA Localization
112	F7430033	A/R Document Line (Print Info) - COMM - 03B	5	PI	RMK	Name - Remark	String	Generic Edit	30	0
TOP74P: Poland
113	F74P03BW	A/R Trial Balance - POL - 03B - 74P	15	P3	RMK	Name - Remark	String	Generic Edit	30	0
114	F74P04W	A/P Trial Balance Work Table - POL - 04 - 74P	15	P2	RMK	Name - Remark	String	Generic Edit	30	0
TOP74R: Russia
115	F74R5110	F1201 Tag File - RUS - 12 - 74R	24	TF	RMK	Name - Remark	String	Generic Edit	30	0
TOP74U: United Kingdom Localizations
116	F74U0118	Payment Voucher Status History - 04	14	VH	RMK	Name - Remark	String	Generic Edit	30	0
117	F74U0205	Payment Profile - 15	32	P8	RMK	Name - Remark	String	Generic Edit	30	0
118	F74U0405	SPC Certificate Holding Table - UK - 43	13	CH	RMK	Name - Remark	String	Generic Edit	30	0
119	F74U0420	SPC - Application Master - UK - 43	74	SE	RMK	Name - Remark	String	Generic Edit	30	0
120	F74U0425	SPC - Certificate Master - UK - 43	76	SF	RMK	Name - Remark	String	Generic Edit	30	0
TOP75C: China
121	F75C010W	AP & AR XML Workfile - China -75C	21	AA	RMK	Name - Remark	String	Generic Edit	30	0
TOP75I: India
122	F75I320Y	Excise - Payment Details	37	QB	RMK	Name - Remark	String	Generic Edit	30	0
123	F75I344Y	Print ARE-1Bond Register-IND-00	37	CD	RMK	Name - Remark	String	Generic Edit	30	0
124	F75I346	Excise - D3-Form Table	29	Q9	RMK	Name - Remark	String	Generic Edit	30	0
125	F75I701	Bill of Entry - Header	65	QH	RMK	Name - Remark	String	Generic Edit	30	0
TOP76A: Argentina
126	F760473A	PCG Detail Information Tag Table - ARG - 04 - 76A	12	E5	RMK	Name - Remark	String	Generic Edit	30	0
127	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	21	DL	RMK	Name - Remark	String	Generic Edit	30	0
128	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	21	DL	RMK	Name - Remark	String	Generic Edit	30	0
129	F76A24	Credit Invoice Information - Accounts Payable - ARG - - 76A	19	IE	RMK	Name - Remark	String	Generic Edit	30	0
130	F76A393	Calculated costs detail - 76A	21	C3	RMK	Name - Remark	String	Generic Edit	30	0
131	F76A394	Adjustments - 76A	17	C4	RMK	Name - Remark	String	Generic Edit	30	0
132	F76A8500	Tag File F03B14 - ARG - 03B - 76A	24	TF	RMK	Name - Remark	String	Generic Edit	30	0
133	F76A8510	Tag File F76A60 - ARG - 03B - 76A	23	TF	RMK	Name - Remark	String	Generic Edit	30	0
134	F76A85Z1	Tag File F76A60 Batch Entry - ARG - 03B - 76A	28	BE	RMK	Name - Remark	String	Generic Edit	30	0
135	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A	21	DL	RMK	Name - Remark	String	Generic Edit	30	0
136	F76AUI81	Draft - Invoices Work File - ARG - 03B - 76A	34	WF	RMK	Name - Remark	String	Generic Edit	30	0
137	F76AUI83	Draft - Application Drafts - Invoices Work File - ARG - 76A	43	WF	RMK	Name - Remark	String	Generic Edit	30	0
138	F76AUI89	Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A	13	WF	RMK	Name - Remark	String	Generic Edit	30	0
TOP76B: Brazil
139	F76B473T	F04573 Brazilian Temp WH File - BR - 04	32	W3	RMK	Name - Remark	String	Generic Edit	30	0
140	F76B8602	IN86-Work Table for Suppliers and Customers - 04	7	PR	RMK	Name - Remark	String	Generic Edit	30	0
TOP76C: Colombia
141	F76C0003	VAT Certificates Retention - COL - 76C	8	CR	RMK	Name - Remark	String	Generic Edit	30	0
142	F76C034A	A/R Check Detail file As Of - COL - 03B	74	RZ	RMK	Name - Remark	String	Generic Edit	30	0
TOP76H: Chile
143	F76H3B33	Legal Document Tax (Print Info) - CHI - 03B - 76H	5	PI	RMK	Name - Remark	String	Generic Edit	30	0
144	F76H3B37	A/R Document Line (Print Info) - CHI - 03B - 76H	6	PI	RMK	Name - Remark	String	Generic Edit	30	0
145	F76H3B40	A/P Document Line (Print Info) - CHI - 04	6	PI	RMK	Name - Remark	String	Generic Edit	30	0
146	F76H3B50	Lot of Printing - Header - CHI - 03B - 76H	8	LP	RMK	Name - Remark	String	Generic Edit	30	0
TOP76P: Peru
147	F76P473T	F04573 Tag File - PER - 04 - 76P	12	K3	RMK	Name - Remark	String	Generic Edit	30	0
TOPF30L: DFM Line Design
148	FF30L301	DFM Customer Master	5	CM	RMK	Name - Remark	String	Generic Edit	30	0
149	FF30L401	DFM Supplier Master	4	SM	RMK	Name - Remark	String	Generic Edit	30	0
150	FF30L601	DFM Employee Master	4	EM	RMK	Name - Remark	String	Generic Edit	30	0
TOPH90: EnterpriseOne TOOLS
151	F0112	Time Log Ledger File	4	PT	RMK	Name - Remark	String	Generic Edit	30	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

151 columns | 920 | RMK