	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

132 columns | 812 | ALPH

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00171	Interoperability-Net Change Table	2	NC	ALPH	Name - Alpha	String	Generic Edit	40	0
2	F004201	Prepayment Transaction Table	22	PT	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP01: Address Book
3	F0101	Address Book Master	4	AB	ALPH	Name - Alpha	String	Generic Edit	40	0
4	F0101Z2	Address Book - Interoperability	17	SZ	ALPH	Name - Alpha	String	Generic Edit	40	0
5	F0111	Address Book - Who's Who	8	WW	ALPH	Name - Alpha	String	Generic Edit	40	0
6	F01111Z1	Batch - Contact Information	22	CB	ALPH	Name - Alpha	String	Generic Edit	40	0
7	F0111Z1	Batch Who's Who Information	21	BW	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP02: Electronic Mail
8	F0113	Message Log Ledger File	2	ZZ	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP03: Accounts Receivable
9	F0311	Accounts Receivable Ledger	105	RP	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP03B: Enhanced Accounts Receivable
10	F03B11	Customer Ledger	90	RP	ALPH	Name - Alpha	String	Generic Edit	40	0
11	F03B11P	Customer Ledger Purge File	90	RP	ALPH	Name - Alpha	String	Generic Edit	40	0
12	F03B11Z1	Invoice Transactions - Batch File	106	VJ	ALPH	Name - Alpha	String	Generic Edit	40	0
13	F03B11Z2	F03B11 Interoperability Table	103	SY	ALPH	Name - Alpha	String	Generic Edit	40	0
14	F03B13	Receipts Header File	41	RY	ALPH	Name - Alpha	String	Generic Edit	40	0
15	F03B13P	Receipts Header Purge File	41	RY	ALPH	Name - Alpha	String	Generic Edit	40	0
16	F03B13Z2	F03B13 Interoperability Table	54	SY	ALPH	Name - Alpha	String	Generic Edit	40	0
17	F03B22	A/R Fee Journal History	19	RS	ALPH	Name - Alpha	String	Generic Edit	40	0
18	F03B23	A/R Fee Journal History Detail	18	RT	ALPH	Name - Alpha	String	Generic Edit	40	0
19	F03B575	Auto Debit Invoice Select and Build	99	RD	ALPH	Name - Alpha	String	Generic Edit	40	0
20	F03B672	Draft Remittance Work File - One World Only	40	RD	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP04: Accounts Payable
21	F04572	A/P Payment Processing - Summary File	15	KK	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP05: Time Accounting and HRM Base
22	F051171	Goal Actions	20	GL	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP05A: OW HR & PR Foundation
23	F05003	Verification of Employment Data	6	EV	ALPH	Name - Alpha	String	Generic Edit	40	0
24	F060116	Employee Master Information	2	YA	ALPH	Name - Alpha	String	Generic Edit	40	0
25	F0601161	Point-In-Time Employee Master	4	PT	ALPH	Name - Alpha	String	Generic Edit	40	0
26	F060116W	EE Master Request File	2	YA	ALPH	Name - Alpha	String	Generic Edit	40	0
27	F060116Z	Unedited Quick Hire Transaction File	15	SZ	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP05T: Time Entry
28	F06116	Employee Transaction Detail File	142	YT	ALPH	Name - Alpha	String	Generic Edit	40	0
29	F06116Z1	Employee Transactions - Batch File	155	VL	ALPH	Name - Alpha	String	Generic Edit	40	0
30	F06278	Retro Timecard Detail File	141	YT	ALPH	Name - Alpha	String	Generic Edit	40	0
31	F069136	Tip Disbursement	4	JE	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP07: Payroll
32	F065016	Automatic Bank Deposit Master	3	YG	ALPH	Name - Alpha	String	Generic Edit	40	0
33	F06560	Bank Reconciliation - Issue File	5	Y8	ALPH	Name - Alpha	String	Generic Edit	40	0
34	F06561	Bank Reconciliation - Paid File	5	Y9	ALPH	Name - Alpha	String	Generic Edit	40	0
35	F07350	Payment File	4	Y0	ALPH	Name - Alpha	String	Generic Edit	40	0
36	F07355	Pre-Payroll Error File	5	Y5	ALPH	Name - Alpha	String	Generic Edit	40	0
37	F074001	New Hire Reporting Workfile - OneWorld Only	8	NH	ALPH	Name - Alpha	String	Generic Edit	40	0
38	F07621	Employee Medical Leave Information	5	L1	ALPH	Name - Alpha	String	Generic Edit	40	0
39	F07624	Employee Medical Leave Change Information	5	L4	ALPH	Name - Alpha	String	Generic Edit	40	0
40	F077011	Tax History Integrity (Temp)	7	Y$	ALPH	Name - Alpha	String	Generic Edit	40	0
41	F077021	Transaction History Integrity(Temp)	7	Y$	ALPH	Name - Alpha	String	Generic Edit	40	0
42	F07811	Negative Amount Workfile	4	JE	ALPH	Name - Alpha	String	Generic Edit	40	0
43	F07855	Employee Fund Allocation	4	AF	ALPH	Name - Alpha	String	Generic Edit	40	0
44	F07880	SUI Magnetic Media Workfile	24	YW	ALPH	Name - Alpha	String	Generic Edit	40	0
45	F8907422	New Hire Detail File - Massachusetts (22)	4	MA	ALPH	Name - Alpha	String	Generic Edit	40	0
46	F8907428	New Hire Detail File - Nebraska(28)	6	NE	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP08: Human Resources
47	F082003	Grade/Step Progression Detail File	3	YW	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP08A: eRecruit
48	F08496	References	3	RF	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP08B: Benefits Administration
49	F08380WF	Batch Enrollment Work File	3	BE	ALPH	Name - Alpha	String	Generic Edit	40	0
50	F08381WF	Recalculate Plan Option Costs	3	RC	ALPH	Name - Alpha	String	Generic Edit	40	0
51	F08901	Participant file	2	HU	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
52	F08401	Applicant Master	2	HA	ALPH	Name - Alpha	String	Generic Edit	40	0
53	F08401WF	Applicant Work File	3	XN	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP08W: Wage and Salary
54	F08201	Salary Review Workfile	5	HR	ALPH	Name - Alpha	String	Generic Edit	40	0
55	F08830WF	Compensation Root Work Table	7	YN	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP12: Fixed Assets
56	F1205	Equipment Messages	2	FT	ALPH	Name - Alpha	String	Generic Edit	40	0
57	F1205P	Equipment Messages Purge Table	2	FT	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP15: Property Management
58	F1538	WF - Expence Participation Register	2	NZ	ALPH	Name - Alpha	String	Generic Edit	40	0
59	F1538B	EP Billing Register Work File	2	NZ	ALPH	Name - Alpha	String	Generic Edit	40	0
60	F1548	Escalation Billing Register	2	N1	ALPH	Name - Alpha	String	Generic Edit	40	0
61	F1548B	Escalation Billing Register	2	N1	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP15L: Adv Real Estate Forecasting
62	F15L001W	Work File for R15L001	4	Q1	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP17C: Call Management
63	F1757	Task Master	11	ZA	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP18: Resource Scheduling
64	F186602	Labor Rules Tag File	148	TF	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP31B: Blend Management
65	F31B02	Staff Master	3	ST	ALPH	Name - Alpha	String	Generic Edit	40	0
66	F31B111	Work Group Staff Allocation	9	GS	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP40: Inventory/OP Base
67	F40UI801	Generic Error Table	15	ZB	ALPH	Name - Alpha	String	Generic Edit	40	0
68	F49211	Sales Order Detail File - Tag File	68	UD	ALPH	Name - Alpha	String	Generic Edit	40	0
69	F49211Z1	Sales Order Detail Tag Unedited Transaction File	81	S1	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP40S: Supply Chain Self Service
70	F4947SW	Self-Service Shipment Tracking Work File	13	SW	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP41: Inventory Management
71	F41291Z	Landed Cost Cache Table	20	IG	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP42: Sales Management
72	F42UI11	SO Detail Cache File (MBF)	147	ZD	ALPH	Name - Alpha	String	Generic Edit	40	0
73	F42UI800	Sales Detail Work File - Sales Update	39	SD	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP42B: Sales Order Entry
74	F49299	S.O. Detail Tag Ledger File	68	UD	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP43E: Requisition Self Service
75	F43E22	Direct Connect Setup	9	PS	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP43Q: Strategic Sourcing
76	F43Q10	Event Header	28	EH	ALPH	Name - Alpha	String	Generic Edit	40	0
77	F43Q30	Event Invited Bidders	8	EV	ALPH	Name - Alpha	String	Generic Edit	40	0
78	F43Q40	Response Header	18	RA	ALPH	Name - Alpha	String	Generic Edit	40	0
79	F43Q50	Analyze Event Header	8	AV	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP44H: Homebuilder Management
80	F4454	Vendor Assignment (World)	8	JG	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP47: Electronic Commerce
81	F470373	EDI ASN Shipping	20	AG	ALPH	Name - Alpha	String	Generic Edit	40	0
82	F470462	EDI Invoice Expanded Header (Sales)	9	S5	ALPH	Name - Alpha	String	Generic Edit	40	0
83	F470472	EDI Invoice Expanded Detail (Sales)	10	S6	ALPH	Name - Alpha	String	Generic Edit	40	0
84	F470561	EDI Payment Order Bank N and A - Outbound	23	D2	ALPH	Name - Alpha	String	Generic Edit	40	0
85	F470561W	EDI Payment Order Bank N and A - Work	25	D2	ALPH	Name - Alpha	String	Generic Edit	40	0
86	F470562	EDI Payment Order Vendor N and A - Outbound	23	D4	ALPH	Name - Alpha	String	Generic Edit	40	0
87	F470562W	EDI Payment Order Vendor N and A - Work	23	D4	ALPH	Name - Alpha	String	Generic Edit	40	0
88	F470563	EDI Payment Order Payee N and A - Outbound	23	D5	ALPH	Name - Alpha	String	Generic Edit	40	0
89	F470563W	EDI Payment Order Payee N and A - Work	23	D5	ALPH	Name - Alpha	String	Generic Edit	40	0
90	F47061	EDI Planning Schedule Header - Inbound	28	MJ	ALPH	Name - Alpha	String	Generic Edit	40	0
91	F47066	EDI Planning Schedule Header - Outbound	28	MJ	ALPH	Name - Alpha	String	Generic Edit	40	0
92	F47081	EDI Price Sales Catalog Header - Inbound	19	FV	ALPH	Name - Alpha	String	Generic Edit	40	0
93	F47111	EDI Lockbox/Payment Header - Transaction	15	Z1	ALPH	Name - Alpha	String	Generic Edit	40	0
94	F47113	EDI Lockbox/Payment Detail - Batch	16	Z3	ALPH	Name - Alpha	String	Generic Edit	40	0
95	F47156	EDI Shipping Schedule Header - Outbound	93	SY	ALPH	Name - Alpha	String	Generic Edit	40	0
96	F4780	Address Cross-Reference	7	AX	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP49: Transportation Management
97	F49130	Shipment Document Workfile	17	BW	ALPH	Name - Alpha	String	Generic Edit	40	0
98	F49140	SSCC Print Label Workfile	9	BW	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP74: EMEA Localization
99	F7430031	Legal Document Address (Print Info) - COMM - 03B	6	PI	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP74B: Begium Localization
100	F74B200	Yearly/Quarterly VAT Listing - Belgium	2	VT	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP75J: Japan - Reporting System Only
101	F75010	Bank/Branch Master Table - Japan	4	J0	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP75T: Taiwan
102	F75T001	GUI/VAT Declaration Site - 75T	12	DS	ALPH	Name - Alpha	String	Generic Edit	40	0
103	F75T004	GUI/VAT Transaction Header - 75T	53	TH	ALPH	Name - Alpha	String	Generic Edit	40	0
104	F75T0049	GUI/VAT Transaction Header History - 75T	53	TH	ALPH	Name - Alpha	String	Generic Edit	40	0
105	F75T004P	GUI/VAT Transaction Header POS - 75T	53	TH	ALPH	Name - Alpha	String	Generic Edit	40	0
106	F75T004Z	GUI/VAT Transaction Header - Work - 75T	33	ZH	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP76A: Argentina
107	F76A8001	Generation SICORE's Files - Last Step -RG 738/99 - 04	19	V2	ALPH	Name - Alpha	String	Generic Edit	40	0
108	F76A8002	SICORE RG738 Withholding Entity	2	V3	ALPH	Name - Alpha	String	Generic Edit	40	0
109	F76A8014	CITI Report - ARG - - 04	5	CT	ALPH	Name - Alpha	String	Generic Edit	40	0
110	F76A82	A/P Payment Control Group File - ARG - 04 - 76A	25	C6	ALPH	Name - Alpha	String	Generic Edit	40	0
111	F76AUI44	CERG A/P - Work File - ARG - 04 - 04	10	WF	ALPH	Name - Alpha	String	Generic Edit	40	0
112	F76AUI46	CERG A/R -Work File - ARG - 03B - 03B	10	WF	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP76B: Brazil - Reporting System Only
113	F76B103	Verification ICMS / IPI - Information - 42	11	QD	ALPH	Name - Alpha	String	Generic Edit	40	0
114	F76B70	Physical and Legal Person Table - IN68 - 42	8	FJ	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP76C: Colombia
115	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	26	CT	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP76H: Chile
116	F76H3B31	Legal Document Header (Print Info) - CHI - 03B - 76H	7	PI	ALPH	Name - Alpha	String	Generic Edit	40	0
117	F76HUI32	Workfile for R76H3B40 - CHI - 42 - 76H	16	WF	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP76V: Venezuela
118	F76VTART	Temporal Table for Withholdings - VEN -04 - 76V	5	TR	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP77: Payroll (Canadian)
119	F77173	ROE Summary History Work File	2	JF	ALPH	Name - Alpha	String	Generic Edit	40	0
120	F77200	Canadian Employee Year-End Form Header - F77200	11	J5	ALPH	Name - Alpha	String	Generic Edit	40	0
121	F77201T	Negative Amount Print	10	NA	ALPH	Name - Alpha	String	Generic Edit	40	0
122	F77703	Payroll History Audit Report - Worktable	6	AR	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP90CA: CRM Foundation
123	F90CA041	Employee and Subordinates	3	ES	ALPH	Name - Alpha	String	Generic Edit	40	0
TOP90CB: CRM Sales Force Automation
124	F90CB02E	Opportunity_Employee Table	3	OE	ALPH	Name - Alpha	String	Generic Edit	40	0
125	F90CB040	Qualification Table	2	QL	ALPH	Name - Alpha	String	Generic Edit	40	0
TOPH90: ONEWORLD TOOLS
126	F0112	Time Log Ledger File	2	PT	ALPH	Name - Alpha	String	Generic Edit	40	0
127	F01131	PPAT Message Control File	3	ZZ	ALPH	Name - Alpha	String	Generic Edit	40	0
128	F01133	PPAT Message Detail File	3	ZT	ALPH	Name - Alpha	String	Generic Edit	40	0
TOPH91: Design Tools
129	F9801NEW	Employee Information - New Version	2	AA	ALPH	Name - Alpha	String	Generic Edit	40	0
130	F9801OLD	Employee Information - Old Version	2	AA	ALPH	Name - Alpha	String	Generic Edit	40	0
TOPH92: Interactive Engine/OL
131	F98231D	OMW Transfer Activity Rule Director - Detail	1	TD	ALPH	Name - Alpha	String	Generic Edit	40	0
132	F98231H	OMW Transfer Activity Rule Director - Header	1	TR	ALPH	Name - Alpha	String	Generic Edit	40	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

132 columns | 812 | ALPH