	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

135 columns | 920 | AEXP

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018	Taxes	11	TD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP04: Accounts Payable
2	F09UI006	Tax (F0018) Replica	11	TD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP17: Customer Service Management
3	F1721	Contract Detail	74	CD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP32: Configuration Management
4	F3215	Configurator Component Table	22	CC	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
5	F32159	Configurator Component History Table	22	CH	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
6	F3216	Configurator Price/Cost Table	12	PC	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
7	F32169	Configurator Price/Cost History	12	KB	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP34: Requirements Planning
8	F3460	Forecast File	8	MF	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP36: Forecasting
9	F3400	Forecast Summary File	18	SG	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
10	F3460Z1	Forecast Unedited Transactions	21	FT	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP40: Inventory/OP Base
11	F40051	Return Material Authorization	34	RD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
12	F4011Z	Batch Receiver File - Order Details	92	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
13	F4012ZW	WF - Destination Quantity	31	SP	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
14	F40332	Preference Profile - Customer Freight	14	CF	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
15	F4211AU	Sales Order Detail Audit File	34	AU	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
16	F4211DT	Sales Order Detail Date Tracking File	19	DT	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
17	F4211Z1	Sales Order Detail Unedited Transaction File	89	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
18	F4215	Shipment Header	26	XH	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP40G: Grower Management
19	F40G95	Pay On Proceeds Log File	13	PP	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP41: Inventory Management
20	F41UI001	Inventory Transactions Detail File	193	IT	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP42: Sales Management
21	F4211	Sales Order Detail File	76	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
22	F42119	Sales Order History File	76	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
23	F42199	S.O. Detail Ledger File	76	SL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
24	F42565	Invoice Print File	27	IW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
25	F42UI11	SO Detail Cache File (MBF)	64	ZD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
26	F42UI521	Pick Slips Detail File	71	S9	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
27	F42UI800	Sales Detail Work File - Sales Update	19	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP42B: Sales Order Entry
28	F42420	Audit Log Transaction	20	AL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP42I: Outbound Inventory Management
29	F42I015	Outbound Inventory Agreement Transaction File	27	OI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP42X: In-Memory Sales Advisor
30	F42X010W	Line Advisor Work File	9	US	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
31	F42X041W	Order Upsell Item Group Opportunities WF	14	BR	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
32	F42X050W	Order Level Upsell Candidate Items	16	CI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP43: Procurement
33	F43080	Approvals Fields Constants	2	PD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
34	F4311	Purchase Order Detail File	69	PD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
35	F4311Z	Purchase Order Generator File	73	PW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
36	F4311Z1	Purchase Order Detail Unedited Transaction Table	82	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
37	F43147	Freight Distribution Workfile	29	FD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
38	F4314Z	Voucher Match Selection File	69	PN	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
39	F4316	Purchase Order Multiple Account File	32	P3	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
40	F43199	P.O. Detail Ledger File - Flexible Version	69	OL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
41	F4343	Purchase Rebate History	22	RH	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
42	F4371	Suggested Reorder Stock Items	15	PD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
43	F43UI50D	PO Print Detail Work File	16	PW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP43E: Requisition Self Service
44	F43E09	F43E09 - Approvals Activity Table	32	AA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
45	F43E11	Requisition Detail	27	RD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
46	F43E16	Requisition Multiple Account File	29	P3	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
47	F43E20	Shopping Cart Detail	11	SC	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP43Q: Strategic Sourcing
48	F43Q11	Event Detail	26	ED	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP43S: JSSS/Supplier Self Service
49	F43001	Procurement Self-Service Transaction Log	21	SA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP44H: Homebuilder Management
50	F44H611	Bid Details	49	BD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
51	F44H611W	Bid Details Work File	53	BW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
52	F44H711	Lot Start Workfile	56	SW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
53	F44H711P	After Start Purchasing	18	TP	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
54	F44H711Z	HB Lot Start Unedited Transaction File	69	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
55	F44H71W1	Lot Start Generation Workfile	56	GW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
56	F44H73W1	Lot Start - P.O. / Committment Generation Work File	30	CG	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP45: Advanced Pricing
57	F4576Z1	Ship and Debit Claims Unedited Transaction Table	143	Z1	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP46: Warehouse Management
58	F4942Z1	Work File for F4942	33	SY	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
59	F47012	EDI Purchase Order Detail - Inbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
60	F47017	EDI Purchase Order Detail - Outbound	83	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
61	F47022	EDI P.O. Acknowledgment Detail - Inbound	83	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
62	F47027	EDI P.O. Acknowledgment Detail - Outbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
63	F47037	EDI Shipping Notice Detail - Outbound	90	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
64	F470371	EDI Shipping Notice Detail - Outbound	101	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
65	F47042	EDI Invoice Detail - Inbound	60	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
66	F47044	EDI Invoice Summary - Inbound	26	SW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
67	F47047	EDI Invoice Detail (Sales) - Outbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
68	F47072	EDI Receiving Advice Detail - Inbound	84	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
69	F47077	EDI Receiving Advice Detail - Outbound	84	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
70	F47092	EDI Request for Quote Detail - Inbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
71	F47097	EDI Request for Quote Detail - Outbound	83	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
72	F47102	EDI Response to RFQ Detail - Inbound	83	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
73	F47107	EDI Response to RFQ Detail - Outbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
74	F47132	EDI Purchase Order Change Detail - Inbound	94	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
75	F47137	EDI Purchase Order Change Detail - Outbound	84	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
76	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	85	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
77	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	95	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
78	F47157	EDI Shipping Schedule Detail - Outbound	90	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
79	F47UI001	ASN Extract Work File	37	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP49: Transportation Management
80	F4941	Shipment Routing Steps	36	RS	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
81	F4942	Shipment Detail	20	IS	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
82	F49633	Load In-Transit Confirmed Quantities	26	IQ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
83	F49634	Load In-Transit Confirmed Quantities Detail	17	QD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
84	F49T10	Sales Order Release Staging Table	29	OR	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
85	F740018D	Data extraction ESL - 74	10	DE	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
86	F740018W	Data extraction ESL - Workfile - 74	10	DE	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
87	F74093	Worktable for Printing IVA Summary - Italy	11	HC	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
88	F7420033	Sales Document Line (Print Info) - COMM - 42	16	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
89	F7420034	Price Adjustment (Print Info) - COMM - 42	11	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP74R: Russia
90	F74RUI31	VAT Sales Book Workfile - RUS - 03B	20	W1	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
91	F74RUI41	VAT Purchase Book Workfile - RUS - 04	21	W1	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP75C: China
92	F75C001	Chinese GUI cross reference file	11	CR	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP75I: India
93	F75I017	Sales Order Tag File IND 42	23	SO	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
94	F75I2213	Setoff Temp Table	13	TT	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
95	F75I309	Personal Consumption - CENVAT setoff - IND - 41	32	CS	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
96	F75I322	Excise - Work File for F04211 & F4101	19	Q3	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
97	F75I322E	Excise - Work File for F04211 & F4101(Based on F75I322)	19	Q3	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
98	F75I3574	Consignment - Issues/Receipts Transactions	19	CT	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
99	F75I385	RG23D Register - Issues - IND - 42	17	ED	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
100	F75I401	Sales Form Information-IND-42	32	QA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
101	F75I401C	Sales Form Information- Secondary	24	QA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
102	F75I403	Stock Transfer Details	27	AB	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
103	F75I403T	Temp Data for F75i403	30	AB	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
104	F75I409	Personal Consumption - VAT setoff - IND - 41	22	VS	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
105	F75I4223	Sales Tax Summary/Detail	29	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
106	F75I601	TCS Register Details-IND-42	6	TR	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
107	F75I604	TCS Payment Details	14	TP	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
108	F75I605	TCS Tax Amount	5	TA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
109	F75I611	TCS Prepayment Transaction File - IND-03B	22	TT	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
110	F75I735	Order Detail by Service Category Code - IND - 75I	18	ST	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP75T: Taiwan
111	F75T42W	Work file with union of F4211 and F42119	25	SW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76A: Argentina
112	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	14	DL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
113	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	14	DL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
114	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A	14	DL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
115	F76AUI50	VAT Perception Support RG 715 WF - ARG - 04 - 76A	6	WF	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76B: Brazil
116	F76111B	Nota Fiscal - Detail (Fiscal Books) - 42	14	QU	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
117	F76111BT	Conversion table for CFOP 5 digits - F76111B - 42	14	TA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
118	F7611B	Nota Fiscal Detail - BRA - 42	38	FD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
119	F761BA	AS Fiscal file book - 09	41	FB	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
120	F76B102	Verification ICMS / IPI - Statement - 42	8	QD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
121	F76B103	Verification ICMS / IPI - Information - 42	8	QD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
122	F76B30	Nota Fiscal Header/Table for Goods - IN68 - 42	12	MM	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
123	F76B31	Nota Fiscal Detail/Table for Goods - IN68 - 42	20	IM	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
124	F76B41	Nota Fiscal Detail/Table for Services - IN68 - 42	10	IS	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
125	F76B411C	IN86-Work Table for Services Outbound Nota Fiscal Det - 42	11	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
126	F76B411D	IN86-Work Table for Merchandise Nota Fiscal Issued by - 42	19	CD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
127	F76B411E	IN86-Work Table for Merchandise NF Issued by Supplier - 41	19	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76C: Colombia
128	F76CUI02	Tax Detail - Work File - COL - 76C	14	TD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
129	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	15	TD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76H: Chile
130	F76H3B33	Legal Document Tax (Print Info) - CHI - 03B - 76H	7	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
131	F76H3B34	Sales Document Line (Print Info) - CHI - 03B - 76H	14	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
132	F76H3B35	Price Adjustment (Print Info) - CHI - 03B - 76H	11	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76V: Venezuela
133	F76VLC01	Purchase Register Temporal - VEN -04 - 76V	8	LC	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
134	F43199A	Temp F43199 for ERP 9.0 Upgrade	69	OL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOPH91: Design Tools
135	F98TCDTL	Table Conversion Detail	9	CD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2

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

135 columns | 920 | AEXP