	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

138 columns | 812 | SEQ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00021	Next Numbers by Company/Fiscal Year - Automatic	10	NL	SEQ	Sequence Number	Numeric	Generic Edit	6	0
2	F00023	Distributed Next Number Table	22	DN	SEQ	Sequence Number	Numeric	Generic Edit	6	0
3	F004201	Prepayment Transaction Table	6	PT	SEQ	Sequence Number	Numeric	Generic Edit	6	0
4	F0046	Processing Log	7	PL	SEQ	Sequence Number	Numeric	Generic Edit	6	0
5	F0047	Data Export Control	3	DE	SEQ	Sequence Number	Numeric	Generic Edit	6	0
6	F5194	Inquiry Paths	4	JE	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP05: Time Accounting and HRM Base
7	F05005	Generic UBE File	2	GF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
8	F05111	Training/Development	5	CT	SEQ	Sequence Number	Numeric	Generic Edit	6	0
9	F05112	Skills/Resources	4	ST	SEQ	Sequence Number	Numeric	Generic Edit	6	0
10	F05113	Accomplishments	3	AT	SEQ	Sequence Number	Numeric	Generic Edit	6	0
11	F05114	Certifications	4	CT	SEQ	Sequence Number	Numeric	Generic Edit	6	0
12	F05115	Education	3	ET	SEQ	Sequence Number	Numeric	Generic Edit	6	0
13	F05116	Languages	4	LT	SEQ	Sequence Number	Numeric	Generic Edit	6	0
14	F05400	Self-Service Process Flow Settings	5	PF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP07: Payroll
15	F065016	Automatic Bank Deposit Master	6	YG	SEQ	Sequence Number	Numeric	Generic Edit	6	0
16	F07811	Negative Amount Workfile	12	JE	SEQ	Sequence Number	Numeric	Generic Edit	6	0
17	F07823	Year-End Report Table	4	YF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP08AD: ADP Integration
18	F051373	ADP Employee Auto Deposit Instructions	7	AD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP08B: Benefits Administration
19	F08372	FSA - Pay Instruction File	3	BM	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP08R: Recruitment Management - (Appl. Track. & Req.)
20	F06018	Date Parameter Extension	4	YF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP09: General Accounting
21	F0917	Bank Statement Detail	7	GD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP12: Fixed Assets
22	F1201	Asset Master File	6	FA	SEQ	Sequence Number	Numeric	Generic Edit	6	0
23	F1201P	Asset Master Purge Table	6	FA	SEQ	Sequence Number	Numeric	Generic Edit	6	0
24	F1201Z1	Unedited Asset Master Transactions	19	FA	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP13: Plant/Equipment Management
25	F12122	Equipment Template Listing	3	EL	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP13E: Equipment Cost Analysis
26	F1382	Equipment Analysis Listing	3	EL	SEQ	Sequence Number	Numeric	Generic Edit	6	0
27	F1383	Equipment Analysis Costs	3	EC	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP15: Property Management
28	F15110B	Expense Participation Class Account	16	OB	SEQ	Sequence Number	Numeric	Generic Edit	6	0
29	F1514	Area Master	9	NW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
30	F1514D	Area Master - Alternate Description	7	NW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
31	F1514W	Area Work File	4	NW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
32	F159071	Market/Potential/Renewal Rent Master	6	NY	SEQ	Sequence Number	Numeric	Generic Edit	6	0
33	F159071D	Market/Potential/Renewal Rent Master - Alternate Description	4	NY	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP15L: Adv Real Estate Forecasting
34	F15L114	AREF E.P. Rules Detail	4	ED	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP16: Profit Management (EPS)
35	F1610	Cost Calculation Definitions	3	CD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
36	F1611	Cost Calculation Transactions	4	CT	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP18: Resource Scheduling
37	F186203	Employee Select Group Lines	2	SG	SEQ	Sequence Number	Numeric	Generic Edit	6	0
38	F186405	Overtime Change Rule Lines	2	OC	SEQ	Sequence Number	Numeric	Generic Edit	6	0
39	F186410	Overtime Time Card Select Lines	2	OT	SEQ	Sequence Number	Numeric	Generic Edit	6	0
40	F186704	Retropay Time Card Select Lines	2	RP	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP38: Agreement Management
41	F38011	Agreement Quantities	8	DF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
42	F38012	Product Source/Destination Master	7	DP	SEQ	Sequence Number	Numeric	Generic Edit	6	0
43	F38013	Agreement Quantities Schedule	3	DQ	SEQ	Sequence Number	Numeric	Generic Edit	6	0
44	F38111	Agreements Transaction Ledger	31	DZ	SEQ	Sequence Number	Numeric	Generic Edit	6	0
45	F38112	Agreements Committed Quantities	8	DX	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP40: Inventory/OP Base
46	F40320	Preference Profile - Multi Shipping/Receiving Locations	12	LP	SEQ	Sequence Number	Numeric	Generic Edit	6	0
47	F40320R	Preference Resolution Ledger - Multi ShiP/Rec Locations	13	LP	SEQ	Sequence Number	Numeric	Generic Edit	6	0
48	F40711	Preference Values Definition	4	PD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
49	F40721	Preference Values Detail	4	PV	SEQ	Sequence Number	Numeric	Generic Edit	6	0
50	F40741	Preference Adjustment History	7	PH	SEQ	Sequence Number	Numeric	Generic Edit	6	0
51	F40UI00T	Tax Work File	1	PN	SEQ	Sequence Number	Numeric	Generic Edit	6	0
52	F40UI16	Preference Print Message Work File	7	DS	SEQ	Sequence Number	Numeric	Generic Edit	6	0
53	F49190	Document Definition File (Conversion from World File)	5	DS	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP40G: Grower Management
54	F40G023	Block Coordinates	3	BC	SEQ	Sequence Number	Numeric	Generic Edit	6	0
55	F40G104	Grower Action Dates	3	AD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP41: Inventory Management
56	F41291Z	Landed Cost Cache Table	19	IG	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP42: Sales Management
57	F42UI11	SO Detail Cache File (MBF)	144	ZD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
58	F42UI130	Commitment Work File	10	ZC	SEQ	Sequence Number	Numeric	Generic Edit	6	0
59	F42UI520	Pick Slips Header File	1	S8	SEQ	Sequence Number	Numeric	Generic Edit	6	0
60	F42UI521	Pick Slips Detail File	1	S9	SEQ	Sequence Number	Numeric	Generic Edit	6	0
61	F42UI800	Sales Detail Work File - Sales Update	92	SD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP43: Procurement
62	F4311Z	Purchase Order Generator File	199	PW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
63	F43121Z	Receiver workfile	108	PW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
64	F43UI50D	PO Print Detail Work File	1	PW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
65	F43UI50H	PO Print Header Work File	1	PA	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP44H: Homebuilder Management
66	F44H711	Lot Start Workfile	7	SW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
67	F44H711Z	HB Lot Start Unedited Transaction File	20	SZ	SEQ	Sequence Number	Numeric	Generic Edit	6	0
68	F44H712	Lot Start Workfile Takeoff Detail	7	ST	SEQ	Sequence Number	Numeric	Generic Edit	6	0
69	F44H71W1	Lot Start Generation Workfile	8	GW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
70	F44H73W1	Lot Start - P.O. / Committment Generation Work File	8	CG	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP45: Advanced Pricing
71	F4574	Key Reference Table	77	KR	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP46: Warehouse Management
72	F46014	Replenishment Groups	3	RG	SEQ	Sequence Number	Numeric	Generic Edit	6	0
73	F46027	Available Space Tiebreaker	2	AV	SEQ	Sequence Number	Numeric	Generic Edit	6	0
74	F46029	Proximity Tiebreaker	2	LP	SEQ	Sequence Number	Numeric	Generic Edit	6	0
75	F46051	Fixed Replenisment Zones	4	LY	SEQ	Sequence Number	Numeric	Generic Edit	6	0
76	F46095	Movement Instructions	6	ET	SEQ	Sequence Number	Numeric	Generic Edit	6	0
77	F4611	Warehouse Suggestions	89	R2	SEQ	Sequence Number	Numeric	Generic Edit	6	0
78	F4611PU	Warehouse Suggestions - Purged	88	R2	SEQ	Sequence Number	Numeric	Generic Edit	6	0
79	F4611Z1	Unedited Suggestion Table	100	SZ	SEQ	Sequence Number	Numeric	Generic Edit	6	0
80	F46130	Putaway Reservations	6	R3	SEQ	Sequence Number	Numeric	Generic Edit	6	0
81	F46130PU	Putaway Reservations - Purged	6	R3	SEQ	Sequence Number	Numeric	Generic Edit	6	0
82	F46821	Random Locations	4	LX	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP48: Work Order Processing
83	F4827	Work Order Approval Routing	5	W5	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP48S: Service Billing
84	F4861	Component Table Detail	4	AF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
85	F48S80	Segment Definition	6	SD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP49: Transportation Management
86	F49141	Packing List Workfile	34	PW	SEQ	Sequence Number	Numeric	Generic Edit	6	0
87	F49191	Document Definition	5	DS	SEQ	Sequence Number	Numeric	Generic Edit	6	0
88	F49490	Document Selection	9	TQ	SEQ	Sequence Number	Numeric	Generic Edit	6	0
89	F49591	Document Print - Batch Selection	6	DB	SEQ	Sequence Number	Numeric	Generic Edit	6	0
90	F49592	Document Print Batch Document Header	2	DH	SEQ	Sequence Number	Numeric	Generic Edit	6	0
91	F4960	Load Header	18	TM	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP52: Contract Billing
92	F5216	Milestone/Progress Billing Information	27	A6	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP74: EMEA Localization
93	F7420033	Sales Document Line (Print Info) - COMM - 42	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
94	F7420034	Price Adjustment (Print Info) - COMM - 42	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
95	F7430032	Legal Document Detail (Print Info) - COMM - 03B	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
96	F7430033	A/R Document Line (Print Info) - COMM - 03B	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
97	F7430034	Legal Document Attachment (Print Info) - COMM - 03B	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
98	F7430035	Taxes by Legal Document Line - COMM - 03B	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
99	F749111	Account Group Detail- EMEA - 74	2	AG	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP74P: Poland
100	F74P3B24	Processed Documents in Finance Charge Processing - POL - 03B	5	PD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP74R: CIS
101	F74R0007	Legal Document Footer Signature Setup - RUS - 00 - 74R	7	FS	SEQ	Sequence Number	Numeric	Generic Edit	6	0
102	F74R9011	Correspondence Rules - RUS -09 - 74R	8	CR	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP74U: United Kingdom Localizations
103	F74U03BT	Lease Master Alternative UOM Tag File - 15	11	PF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP76A: Argentina
104	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	6	DL	SEQ	Sequence Number	Numeric	Generic Edit	6	0
105	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	6	DL	SEQ	Sequence Number	Numeric	Generic Edit	6	0
106	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	6	DL	SEQ	Sequence Number	Numeric	Generic Edit	6	0
107	F76AUI22	WF - Legal Reports Errors - ARG - 00	6	WF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
108	F76AUI89	Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A	3	WF	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP76B: Brazil - Reporting System Only
109	F7602B	Fiscal Book Next Number Control - Brazil	5	NJ	SEQ	Sequence Number	Numeric	Generic Edit	6	0
110	F76121B	Nota Fiscal Print Message Header - Brazil	6	FZ	SEQ	Sequence Number	Numeric	Generic Edit	6	0
111	F7612B	Nota Fiscal Print Message - Brazil	5	FY	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP76H: Chile
112	F76H3B32	Legal Document Detail (Print Info) - CHI - 03B - 76H	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
113	F76H3B34	Sales Document Line (Print Info) - CHI - 03B - 76H	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
114	F76H3B35	Price Adjustment (Print Info) - CHI - 03B - 76H	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
115	F76H3B36	Legal Document Attachment (Print Info) - CHI - 03B - 76H	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
116	F76H3B37	A/R Document Line (Print Info) - CHI - 03B - 76H	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
117	F76H3B38	Shipment Guide Line (Print Info) - CHI - 03B - 76H	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
118	F76H3B40	A/P Document Line (Print Info) - CHI - 04	4	PI	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP76P: Peru
119	F76P3B70	PDT Sales Operations with Third - PER - 03B - 76P	1	PD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP77: Payroll (Canadian)
120	F77101	Canadian Year-End Print	4	JA	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP89: Conversion Programs
121	F99302	Processing Options Text Table	9	PO	SEQ	Sequence Number	Numeric	Generic Edit	6	0
122	F993022	Processing Options Error Table	9	PO	SEQ	Sequence Number	Numeric	Generic Edit	6	0
123	F993023	Translated Processing Options Text Table	9	PO	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP90CA: CRM Foundation
124	F90CA23A	Wizard Process Flow Settings	3	WP	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOP98: Technical Tools
125	F98BLOB	DB2 Blob Support	3	KS	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOPH79: CS - Forecasting
126	F989501	User Override Language Translation Table	8	LS	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOPH91: Design Tools
127	F91410	Report Director Templates Sequence Items	2	DS	SEQ	Sequence Number	Numeric	Generic Edit	6	0
128	F91430	Smart Field Template Criteria	4	SC	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOPH92: Interactive Engine/OL
129	F9887	Install Package Build History	4	IP	SEQ	Sequence Number	Numeric	Generic Edit	6	0
130	F98950	User Overrides Table	9	UO	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOPH95: Tech Resources/Applications
131	F95401	Application Failure Recovery Detail	3	AD	SEQ	Sequence Number	Numeric	Generic Edit	6	0
132	F95410	Application Failure Administration	2	TO	SEQ	Sequence Number	Numeric	Generic Edit	6	0
133	F98950D	User Overrides Language Table	9	LO	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOPH96: Deployment
134	F98881	Specification Merge Logging File	6	SM	SEQ	Sequence Number	Numeric	Generic Edit	6	0
135	F98892	Package Deployment Scheduling	10	MT	SEQ	Sequence Number	Numeric	Generic Edit	6	0
136	F99410	OneWorld System Control File	1	OC	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOPH98: Internet
137	F986150	Server Transfer Package Contents	2	SP	SEQ	Sequence Number	Numeric	Generic Edit	6	0
TOPH99: Product Version Control
138	F0093	Library List Control	3	LL	SEQ	Sequence Number	Numeric	Generic Edit	6	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

138 columns | 812 | SEQ