	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

106 columns | 812 | AEXP

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0018	Sales/Use/V.A.T. Tax File	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
TOP41: Inventory Management
19	F41UI001	Inventory Transactions Detail File	193	IT	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP42: Sales Management
20	F4211	Sales Order Detail File	76	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
21	F42119	Sales Order History File	76	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
22	F42199	S.O. Detail Ledger File	76	SL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
23	F42565	Invoice Print File	27	IW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
24	F42UI11	SO Detail Cache File (MBF)	64	ZD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
25	F42UI521	Pick Slips Detail File	71	S9	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
26	F42UI800	Sales Detail Work File - Sales Update	19	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP42B: Sales Order Entry
27	F42420	Audit Log Transaction	20	AL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP43: Procurement
28	F43080	Approvals Fields Constants	2	PD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
29	F4311	Purchase Order Detail File	69	PD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
30	F4311Z	Purchase Order Generator File	73	PW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
31	F4311Z1	Purchase Order Detail Unedited Transaction Table	82	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
32	F4314Z	Voucher Match Selection File	69	PN	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
33	F4316	Purchase Order Multiple Account File	32	P3	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
34	F43199	P.O. Detail Ledger File - Flexible Version	69	OL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
35	F4343	Purchase Rebate History	22	RH	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
36	F4371	Suggested Reorder Stock Items	15	PD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
37	F43E09	F43E09 - Approvals Activity Table	32	AA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
38	F43UI50D	PO Print Detail Work File	16	PW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP43E: Requisition Self Service
39	F43E11	Requisition Detail	27	RD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
40	F43E16	Requisition Multiple Account File	29	P3	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
41	F43E20	Shopping Cart Detail	11	SC	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP43Q: Strategic Sourcing
42	F43Q11	Event Detail	26	ED	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP43S: Supplier Self Service
43	F43001	Procurement Self-Service Transaction Log	21	SA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP44H: Homebuilder Management
44	F44H611	Bid Details	49	BD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
45	F44H611W	Bid Details Work File	53	BW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
46	F44H711	Lot Start Workfile	56	SW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
47	F44H711P	After Start Purchasing	18	TP	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
48	F44H711Z	HB Lot Start Unedited Transaction File	69	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
49	F44H71W1	Lot Start Generation Workfile	56	GW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
50	F44H73W1	Lot Start - P.O. / Committment Generation Work File	30	CG	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP45: Advanced Pricing
51	F4576Z1	Ship and Debit Claims Unedited Transaction Table	143	Z1	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP46: Warehouse Management
52	F4942Z1	Work File for F4942	33	SY	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP47: Electronic Commerce
53	F47012	EDI Purchase Order Detail - Inbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
54	F47017	EDI Purchase Order Detail - Outbound	83	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
55	F47022	EDI P.O. Acknowledgment Detail - Inbound	83	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
56	F47027	EDI P.O. Acknowledgment Detail - Outbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
57	F47037	EDI Shipping Notice Detail - Outbound	90	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
58	F470371	EDI Shipping Notice Detail - Outbound	101	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
59	F47042	EDI Invoice Detail - Inbound	60	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
60	F47044	EDI Invoice Summary - Inbound	26	SW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
61	F47047	EDI Invoice Detail (Sales) - Outbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
62	F47072	EDI Receiving Advice Detail - Inbound	84	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
63	F47077	EDI Receiving Advice Detail - Outbound	84	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
64	F47092	EDI Request for Quote Detail - Inbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
65	F47097	EDI Request for Quote Detail - Outbound	83	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
66	F47102	EDI Response to RFQ Detail - Inbound	83	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
67	F47107	EDI Response to RFQ Detail - Outbound	93	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
68	F47132	EDI Purchase Order Change Detail - Inbound	94	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
69	F47137	EDI Purchase Order Change Detail - Outbound	84	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
70	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	85	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
71	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	95	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
72	F47157	EDI Shipping Schedule Detail - Outbound	90	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
73	F47UI001	ASN Extract Work File	37	SZ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP49: Transportation Management
74	F4941	Shipment Routing Steps	36	RS	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
75	F4942	Shipment Detail	20	IS	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
76	F49633	Load In-Transit Confirmed Quantities	26	IQ	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
77	F49634	Load In-Transit Confirmed Quantities Detail	17	QD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP55: Reserved for Clients
78	F74H1051	Invoicing Workfile - New	18	IW	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP74: EMEA Localization
79	F74093	Workfile for Printing IVA Summary - Italy	11	HC	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
80	F7420033	Sales Document Line (Print Info) - COMM - 42	16	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
81	F7420034	Price Adjustment (Print Info) - COMM - 42	11	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP75C: China - Reporting System Only
82	F75C001	Chinese GUI cross reference file	11	CR	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76A: Argentina
83	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	14	DL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
84	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	14	DL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
85	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	14	DL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
86	F76AUI50	VAT Perception Support RG 715 WF - ARG - 04 - 76A	6	WF	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76B: Brazil - Reporting System Only
87	F76111B	Nota Fiscal - Detail (Fiscal Books) - 42	14	QU	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
88	F76111BT	Conversion table for CFOP 5 digits - F76111B - 42	14	TA	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
89	F7611B	Nota Fiscal Detail - Brazil	38	FD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
90	F761BA	AS Fiscal file book	41	FB	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
91	F76B102	Verification ICMS / IPI - Statement - 42	8	QD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
92	F76B103	Verification ICMS / IPI - Information - 42	8	QD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
93	F76B30	Nota Fiscal Header/Table for Goods - IN68 - 42	12	MM	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
94	F76B31	Nota Fiscal Detail/Table for Goods - IN68 - 42	20	IM	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
95	F76B41	Nota Fiscal Detail/Table for Services - IN68 - 42	10	IS	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
96	F76B411C	IN86-Work Table for Services Outbound Nota Fiscal Det - 42	11	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
97	F76B411D	IN86-Work Table for Merchandise Nota Fiscal Issued by - 42	19	CD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
98	F76B411E	IN86-Work Table for Merchandise NF Issued by Supplier - 41	19	SD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76C: Colombia
99	F76CUI02	Tax Detail - Work File - COL - 76C	14	TD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
100	F76CUI04	Tax Detail for Distribution - Work File - COL - 76C	15	TD	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76H: Chile
101	F76H3B33	Legal Document Tax (Print Info) - CHI - 03B - 76H	7	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
102	F76H3B34	Sales Document Line (Print Info) - CHI - 03B - 76H	14	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
103	F76H3B35	Price Adjustment (Print Info) - CHI - 03B - 76H	11	PI	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP76V: Venezuela
104	F76VLC01	Purchase Register Temporal - VEN -04 - 76V	8	LC	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOP89: Conversion Programs
105	F43199A	Temp F43199 for ERP 9.0 Upgrade	69	OL	AEXP	Amount - Extended Price	Numeric	Generic Edit	15	2
TOPH91: Design Tools
106	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

106 columns | 812 | AEXP