	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

163 columns | 812 | EFTJ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F4008	Tax Areas	14	TA	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP01: Address Book
2	F01505	Tier Descriptions	5	TD	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP04: Accounts Payable
3	F04572	A/P Payment Processing - Summary File	48	KK	EFTJ	Date - Effective	Date	Generic Edit	6	0
4	F04573	A/P Payment Processing - Detail File	18	KI	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP09E: Expense Reimbursment
5	F09E108	Policy Edit Rules	5	PR	EFTJ	Date - Effective	Date	Generic Edit	6	0
6	F09E118	Expense Category / Report Type to Pay Type Mapping	3	PM	EFTJ	Date - Effective	Date	Generic Edit	6	0
7	F20103	Employee Profile Definition	10	EP	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP17C: Call Management
8	F1755	Customer Call Master	203	ZA	EFTJ	Date - Effective	Date	Generic Edit	6	0
9	F1760	Time Entry	82	ZB	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP37: Quality Management
10	F37014	Test Result Conversions	4	RC	EFTJ	Date - Effective	Date	Generic Edit	6	0
11	F37015	Test Result Conversion Tables	5	CT	EFTJ	Date - Effective	Date	Generic Edit	6	0
12	F40318	Preference Profile - Quality Management	5	QC	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP38: Agreement Management
13	F38010	Agreement Master	16	DN	EFTJ	Date - Effective	Date	Generic Edit	6	0
14	F38011	Agreement Quantities	14	DF	EFTJ	Date - Effective	Date	Generic Edit	6	0
15	F38012	Product Source/Destination Master	19	DP	EFTJ	Date - Effective	Date	Generic Edit	6	0
16	F38013	Agreement Quantities Schedule	6	DQ	EFTJ	Date - Effective	Date	Generic Edit	6	0
17	F38014	Agreement Formulas and Factors	23	DR	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP40: Inventory/OP Base
18	F4015	Order Templates	11	OT	EFTJ	Date - Effective	Date	Generic Edit	6	0
19	F4016	Print Messages	3	TU	EFTJ	Date - Effective	Date	Generic Edit	6	0
20	F40301	Preference Profile - Payment Terms	5	PT	EFTJ	Date - Effective	Date	Generic Edit	6	0
21	F40301R	Preference Resolution Ledger - Payment Terms	7	PT	EFTJ	Date - Effective	Date	Generic Edit	6	0
22	F40302	Preference Profile - Unit of Measure	5	PU	EFTJ	Date - Effective	Date	Generic Edit	6	0
23	F40302R	Preference Resolution Ledger - Pricing Unit Of Measure	7	PU	EFTJ	Date - Effective	Date	Generic Edit	6	0
24	F40303	Preference Profile - Revenue Cost Center	5	RV	EFTJ	Date - Effective	Date	Generic Edit	6	0
25	F40303R	Preference Resolution Ledger - Revenue Business Unit	7	RV	EFTJ	Date - Effective	Date	Generic Edit	6	0
26	F40304	Preference Profile - End Use	5	PE	EFTJ	Date - Effective	Date	Generic Edit	6	0
27	F40304R	Preference Resolution Ledger - End Use	7	PE	EFTJ	Date - Effective	Date	Generic Edit	6	0
28	F40305	Preference Profile - Print Messages	5	RM	EFTJ	Date - Effective	Date	Generic Edit	6	0
29	F40305R	Preference Resolution Ledger - Print Messages	7	RM	EFTJ	Date - Effective	Date	Generic Edit	6	0
30	F40306	Preference Profile - Inventory Sourcing	5	SR	EFTJ	Date - Effective	Date	Generic Edit	6	0
31	F40307	Preference Profile - Product Allocations	5	LA	EFTJ	Date - Effective	Date	Generic Edit	6	0
32	F40308	Preference Profile - Grade and Potency	5	GS	EFTJ	Date - Effective	Date	Generic Edit	6	0
33	F40308R	Preference Resolution Ledger - Grade and Potency	7	GS	EFTJ	Date - Effective	Date	Generic Edit	6	0
34	F40309	Preference Profile - Delivery Date	5	DY	EFTJ	Date - Effective	Date	Generic Edit	6	0
35	F40309R	Preference Resolution Ledger - Delivery Date	7	DY	EFTJ	Date - Effective	Date	Generic Edit	6	0
36	F40310	Preference Profile - Line of Business	5	LB	EFTJ	Date - Effective	Date	Generic Edit	6	0
37	F40310R	Preference Resolution Ledger - Line Of Business	7	LB	EFTJ	Date - Effective	Date	Generic Edit	6	0
38	F40311	Preference Profile - Price Code 1	5	P1	EFTJ	Date - Effective	Date	Generic Edit	6	0
39	F40311R	Preference Resolution Ledger - User Defined Price Code #1	7	P1	EFTJ	Date - Effective	Date	Generic Edit	6	0
40	F40312	Preference Profile - Price Code 2	5	P2	EFTJ	Date - Effective	Date	Generic Edit	6	0
41	F40312R	Preference Resolution Ledger - User Defined Price Code #2	7	P2	EFTJ	Date - Effective	Date	Generic Edit	6	0
42	F40313	Preference Profile - Price Code 3	5	P3	EFTJ	Date - Effective	Date	Generic Edit	6	0
43	F40313R	Preference Resolution Ledger - User Defined Price Code #3	7	P3	EFTJ	Date - Effective	Date	Generic Edit	6	0
44	F40314	Preference Profile - Price Adjustment Schedule	5	PJ	EFTJ	Date - Effective	Date	Generic Edit	6	0
45	F40314R	Preference Resolution Ledger - Price Adjustment Schedule	7	PJ	EFTJ	Date - Effective	Date	Generic Edit	6	0
46	F40315	Preference Profile - Invoice Cycling	5	PI	EFTJ	Date - Effective	Date	Generic Edit	6	0
47	F40315R	Preference Resolution Ledger - Invoice Cycle	7	PI	EFTJ	Date - Effective	Date	Generic Edit	6	0
48	F40316	Preference Profile - Order Preparation	5	OP	EFTJ	Date - Effective	Date	Generic Edit	6	0
49	F40316R	Preference Resolution Ledger - Order Preparation Days	7	OP	EFTJ	Date - Effective	Date	Generic Edit	6	0
50	F40318R	Preference Resolution Ledger - Quality Management	7	QC	EFTJ	Date - Effective	Date	Generic Edit	6	0
51	F40320	Preference Profile - Multi Shipping/Receiving Locations	5	LP	EFTJ	Date - Effective	Date	Generic Edit	6	0
52	F40320R	Preference Resolution Ledger - Multi ShiP/Rec Locations	6	LP	EFTJ	Date - Effective	Date	Generic Edit	6	0
53	F40329	Preference Profile - Document Distribution	5	DD	EFTJ	Date - Effective	Date	Generic Edit	6	0
54	F40330	Preference Profile - Document Set	5	DG	EFTJ	Date - Effective	Date	Generic Edit	6	0
55	F40331	Preference Profile - Options and Equipment	5	OE	EFTJ	Date - Effective	Date	Generic Edit	6	0
56	F40332	Preference Profile - Customer Freight	5	CF	EFTJ	Date - Effective	Date	Generic Edit	6	0
57	F40333	Preference Profile - Carrier	5	CA	EFTJ	Date - Effective	Date	Generic Edit	6	0
58	F40334	Preference Profile - Mode of Transport	5	MT	EFTJ	Date - Effective	Date	Generic Edit	6	0
59	F40338	Preference Profile - Payment Terms (Branch)	5	PT	EFTJ	Date - Effective	Date	Generic Edit	6	0
60	F40338R	Preference Resolution Ledger - Payment Terms (Branch)	7	PT	EFTJ	Date - Effective	Date	Generic Edit	6	0
61	F40339	Preference Profile - Product Allocations (Branch)	5	LA	EFTJ	Date - Effective	Date	Generic Edit	6	0
62	F40341	Preference Profile - Next Order Status	5	NS	EFTJ	Date - Effective	Date	Generic Edit	6	0
63	F40341R	Preference Resolution Ledger - Next Order Status	7	NS	EFTJ	Date - Effective	Date	Generic Edit	6	0
64	F40344	Preference Profile - Sales Commission	5	SA	EFTJ	Date - Effective	Date	Generic Edit	6	0
65	F40344R	Preference Resolution Ledger - Sales Commission	7	SA	EFTJ	Date - Effective	Date	Generic Edit	6	0
66	F40345	Preference Profile - Customer Currency	5	CR	EFTJ	Date - Effective	Date	Generic Edit	6	0
67	F40345R	Preference Resolution Ledger - Customer Currency	7	CR	EFTJ	Date - Effective	Date	Generic Edit	6	0
68	F40347	Preference Profile - Pricing UOM (Branch)	5	RI	EFTJ	Date - Effective	Date	Generic Edit	6	0
69	F40347R	Preference Resolution Ledger - Pricing UOM (Branch)	7	RI	EFTJ	Date - Effective	Date	Generic Edit	6	0
70	F40349	Preference Profile - Revenue Business Unit (Branch)	5	RV	EFTJ	Date - Effective	Date	Generic Edit	6	0
71	F40349R	Preference Resolution Ledger - Revenue Bus Unit (Branch)	7	RV	EFTJ	Date - Effective	Date	Generic Edit	6	0
72	F40350	Preference Profiles - Conatiner Deposit/Rental	5	OQ	EFTJ	Date - Effective	Date	Generic Edit	6	0
73	F40P01	Promotion Header File	6	PH	EFTJ	Date - Effective	Date	Generic Edit	6	0
74	F40P011	Promotion Deal Detail File	23	PD	EFTJ	Date - Effective	Date	Generic Edit	6	0
75	F40UI002	Supplier History Rebuild -workfile	11	UT	EFTJ	Date - Effective	Date	Generic Edit	6	0
76	F40UI17	Allocation Work File	15	ZG	EFTJ	Date - Effective	Date	Generic Edit	6	0
77	F4104	Item Cross Reference File	5	IV	EFTJ	Date - Effective	Date	Generic Edit	6	0
78	F4106	Item Base Price File	14	BP	EFTJ	Date - Effective	Date	Generic Edit	6	0
79	F4106NC	Base Price Extraction	20	SZ	EFTJ	Date - Effective	Date	Generic Edit	6	0
80	F49085	Scheduled Invoice Date	3	ID	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP42: Sales Management
81	F4020	Freight/Additional Charges Rate Information	13	AR	EFTJ	Date - Effective	Date	Generic Edit	6	0
82	F42430	Customer Set	3	CS	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP42B: Sales Order Entry
83	F42440	Customer Segment Items	9	CS	EFTJ	Date - Effective	Date	Generic Edit	6	0
84	F42UI440	Customer Segment Items - Work File	10	CS	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP43: Procurement
85	F41061	Supplier Price/Catalog File	17	CB	EFTJ	Date - Effective	Date	Generic Edit	6	0
86	F4340	Purchase Rebate Master File	5	RD	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP45: Advanced Pricing
87	F4070	Price Adjustment Schedule	10	SN	EFTJ	Date - Effective	Date	Generic Edit	6	0
88	F4072	Price Adjustment Detail	12	AD	EFTJ	Date - Effective	Date	Generic Edit	6	0
89	F4072W	Price Adjustment Detail Work File	12	AD	EFTJ	Date - Effective	Date	Generic Edit	6	0
90	F4075	Price Variable Table	5	VB	EFTJ	Date - Effective	Date	Generic Edit	6	0
91	F4077	Rebate Thresholds	8	RT	EFTJ	Date - Effective	Date	Generic Edit	6	0
92	F4078	Rebate Transaction Summary	8	RH	EFTJ	Date - Effective	Date	Generic Edit	6	0
93	F4079	Rebate Transaction Detail	7	SV	EFTJ	Date - Effective	Date	Generic Edit	6	0
94	F4501	Master Schedule Adjustment	5	MS	EFTJ	Date - Effective	Date	Generic Edit	6	0
95	F4502	Free Goods Catalog	3	FG	EFTJ	Date - Effective	Date	Generic Edit	6	0
96	F4511W	Pricing Structure View	49	AP	EFTJ	Date - Effective	Date	Generic Edit	6	0
97	F4551	Basket Master Detail	4	BD	EFTJ	Date - Effective	Date	Generic Edit	6	0
98	F45520	Price List Header	7	PH	EFTJ	Date - Effective	Date	Generic Edit	6	0
99	F45521	Price List Detail	4	PD	EFTJ	Date - Effective	Date	Generic Edit	6	0
100	F45715	Adjustment Balances	10	AB	EFTJ	Date - Effective	Date	Generic Edit	6	0
101	F4572	Live Promotions X-Reference by Cost Type	7	XR	EFTJ	Date - Effective	Date	Generic Edit	6	0
102	F4572Z1	Live Promotions Interface - Inbound / Outbound	21	LP	EFTJ	Date - Effective	Date	Generic Edit	6	0
103	F4572ZP	Purge Live Promotions Interface	21	PG	EFTJ	Date - Effective	Date	Generic Edit	6	0
104	F4574	Key Reference Table	18	KR	EFTJ	Date - Effective	Date	Generic Edit	6	0
105	F4575	Ship and Debit History	39	AH	EFTJ	Date - Effective	Date	Generic Edit	6	0
106	F4575TMP	Ship and Debit History - Temp Table	39	AH	EFTJ	Date - Effective	Date	Generic Edit	6	0
107	F4576Z1	Ship and Debit Claims Unedited Transaction Table	117	Z1	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP46L: License Plating
108	F46L010	License Plate Segments	3	LS	EFTJ	Date - Effective	Date	Generic Edit	6	0
109	F46L011	License Plate Next Numbers	3	LN	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP47: Electronic Commerce
110	F47082	EDI Price Sales Catalog Detail - Inbound	70	FY	EFTJ	Date - Effective	Date	Generic Edit	6	0
111	F4780	Address Cross-Reference	5	AX	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP49: Transportation Management
112	F490052	Generate Tracking Segment Next Number	4	YG	EFTJ	Date - Effective	Date	Generic Edit	6	0
113	F49015	Vehicle Status	3	ST	EFTJ	Date - Effective	Date	Generic Edit	6	0
114	F49020	Vehicle/Staff License Information	8	VL	EFTJ	Date - Effective	Date	Generic Edit	6	0
115	F49025	Connected Vehicles (Conversion from World File)	7	CV	EFTJ	Date - Effective	Date	Generic Edit	6	0
116	F49030	Vehicle Equipment (Conversion from World File)	4	VE	EFTJ	Date - Effective	Date	Generic Edit	6	0
117	F49040	Vehicle Staff (Conversion from World File)	4	VS	EFTJ	Date - Effective	Date	Generic Edit	6	0
118	F49041	Depot/Vehicle Staff	3	VS	EFTJ	Date - Effective	Date	Generic Edit	6	0
119	F49160	Document Next Number	5	NN	EFTJ	Date - Effective	Date	Generic Edit	6	0
120	F49302	Vehicle Equipment	4	VE	EFTJ	Date - Effective	Date	Generic Edit	6	0
121	F4935	Connected Vehicle Header	2	VH	EFTJ	Date - Effective	Date	Generic Edit	6	0
122	F4936	Connected Vehicle Detail	2	CW	EFTJ	Date - Effective	Date	Generic Edit	6	0
123	F4945	Shipment Charges	45	SC	EFTJ	Date - Effective	Date	Generic Edit	6	0
124	F4950	Routing Entries	32	RT	EFTJ	Date - Effective	Date	Generic Edit	6	0
125	F49501	Intermodal Detail Routing Entries	18	RD	EFTJ	Date - Effective	Date	Generic Edit	6	0
126	F4956	Option and Equipment Inclusions/Exclusions	5	IX	EFTJ	Date - Effective	Date	Generic Edit	6	0
127	F4972	Rate Detail	11	RX	EFTJ	Date - Effective	Date	Generic Edit	6	0
128	F4977	Rate Parameters	19	MR	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP74S: Spain
129	F74S505	Stamps (Timbres) Fee Header	4	SH	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP74W: Sweden - Reporting System Only
130	F74W203	Debit Advice Invoice File - 74W	9	K3	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP75C: China - Reporting System Only
131	F75C4106	Chinese Free Goods VAT base price - F75C4106	6	IB	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP76A: Argentina
132	F760401A	Gross Income Withholding Percentage - ARG	5	K2	EFTJ	Date - Effective	Date	Generic Edit	6	0
133	F760402A	V.A.T. withholding percentage - ARG	3	K1	EFTJ	Date - Effective	Date	Generic Edit	6	0
134	F760405A	Contract Withholding Percentage - ARG	3	K7	EFTJ	Date - Effective	Date	Generic Edit	6	0
135	F760410A	Eventual Services Withholding Percentage - ARG	4	K0	EFTJ	Date - Effective	Date	Generic Edit	6	0
136	F7607A	Withholding Exempt Percentage - ARG - 04 - 04	3	V4	EFTJ	Date - Effective	Date	Generic Edit	6	0
137	F76A003	A/P Tag File - CAI Storage - ARG - 00	5	RG	EFTJ	Date - Effective	Date	Generic Edit	6	0
138	F76A005	CAI - Invoice range for Preprinters - ARG - 03B	4	RH	EFTJ	Date - Effective	Date	Generic Edit	6	0
139	F76A043	A/P Tag File - CAI Storage - ARG - 04	5	RG	EFTJ	Date - Effective	Date	Generic Edit	6	0
140	F76A12	Taxes - Minimum Tax By Date - ARG - 00	2	TM	EFTJ	Date - Effective	Date	Generic Edit	6	0
141	F76A13	Taxes - Tax Values - ARG - 00	6	TV	EFTJ	Date - Effective	Date	Generic Edit	6	0
142	F76A15	Taxes - Effective and Expiration Dates - ARG - 00	4	TE	EFTJ	Date - Effective	Date	Generic Edit	6	0
143	F76A16	Taxes - Tax Groups - ARG - 00	4	TG	EFTJ	Date - Effective	Date	Generic Edit	6	0
144	F76A41	CERG G/L - Lot Detail - ARG - 09 - - 09	15	LD	EFTJ	Date - Effective	Date	Generic Edit	6	0
145	F76A48	CERG A/P - Control Payments -ARG - 04 - 04	14	PI	EFTJ	Date - Effective	Date	Generic Edit	6	0
146	F76A49	CERG A/R - Control Receipts - ARG - 03B - 03B	14	CR	EFTJ	Date - Effective	Date	Generic Edit	6	0
147	F76A8011	Supplier Information RG 726 - 04	8	PA	EFTJ	Date - Effective	Date	Generic Edit	6	0
148	F76A8020	Gross Income Exempt Percentage - ARG - 04 - 76A	3	EP	EFTJ	Date - Effective	Date	Generic Edit	6	0
149	F76A8030	Taxes - Minimun Tax By Invoice - ARG - 03B - 76A	2	MT	EFTJ	Date - Effective	Date	Generic Edit	6	0
150	F76A8050	Perceptions Exempt Percentages - 03B	3	PP	EFTJ	Date - Effective	Date	Generic Edit	6	0
151	F76A8090	V.A.T. Witholding Percentage Rg726	5	VP	EFTJ	Date - Effective	Date	Generic Edit	6	0
152	F76A8230	Percentages by state / agreement Gross Income - ARG - - 76A	4	C1	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP76C: Colombia
153	F76C0101	A/B Tag File - COL - 76C	6	V0	EFTJ	Date - Effective	Date	Generic Edit	6	0
154	F76CI1	Tax Parameters - COL - 76C	6	PI	EFTJ	Date - Effective	Date	Generic Edit	6	0
155	F76CI2	Economic Activity - COL - 76C	5	AE	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP76P: Peru
156	F76P405	IGV Withholding Percentage - PER - 04 - 76P	3	IG	EFTJ	Date - Effective	Date	Generic Edit	6	0
157	F76P410	SPOT Withholdings Percentage - PER - 04 - 76P	3	SP	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP76V: Venezuela
158	F76V4020	ISLR Withholdings Setup - VEN - 04	6	WS	EFTJ	Date - Effective	Date	Generic Edit	6	0
159	F76V4025	IM Withholdings Setup - VEN - 04	5	WS	EFTJ	Date - Effective	Date	Generic Edit	6	0
160	F76V4030	VAT Withholdings Setup - VEN - 04	3	VW	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOP89: Conversion Programs
161	F40344A	Temporay Preference Profile - Sales Commission	5	SA	EFTJ	Date - Effective	Date	Generic Edit	6	0
162	F4072TEM	Price Adjustment Detail - Temp for Upgrade	14	AD	EFTJ	Date - Effective	Date	Generic Edit	6	0
TOPH92: Interactive Engine/OL
163	F00165T	Media Object Conversion Table	11	GD	EFTJ	Date - Effective	Date	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

163 columns | 812 | EFTJ