	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

156 columns | 910 | ALPH

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

156 columns | 910 | ALPH