	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

140 columns | 812 | TRDJ

	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	19	TD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
2	F004201	Prepayment Transaction Table	44	PT	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP04: Accounts Payable
3	F09UI006	Tax (F0018) Replica	19	TD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP17: Customer Service Management
4	F3111Z2	Warranty Claim/Supplier Recovery processing	51	WP	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
5	F3112Z2	Warranty Claim/Supplier Recovery processing	38	WL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
6	F4801Z2	Warranty Claim/Supplier Recovery processing	49	WS	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP31: Shop Floor Control
7	F3111	Work Order Parts List	38	WM	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
8	F3111S	Purge - Shop Floor Parts List	38	WM	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
9	F3111Z1	Outbound Work Order Parts List	51	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
10	F3112	Work Order Routing	25	WL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
11	F3112S	Purge Shop Floor Control Routing Instructions	25	WL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
12	F3112Z1	Outbound Work Order Routings	38	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
13	F3114	Rate Schedule Transaction File	6	IQ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
14	F3118	Shortage Maintenance Master File	8	WN	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
15	F4801S	Purge - Work Order Master file	30	WA	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
16	F4801Z1	Outbound Work Order Header	49	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP38: Agreement Management
17	F38111	Agreements Transaction Ledger	12	DZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
18	F38112	Agreements Committed Quantities	16	DX	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP39: Advanced Stock Valuation
19	F39120	Temporary Period Build File for Stock Valuation	13	TF	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
20	F39120W	Period Detail Work File	6	TW	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
21	F39121W	Additional Quantity Work File	11	AQ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP40: Inventory/OP Base
22	F30UI006	Lot Tracking Work File	28	IL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
23	F4001Z	Batch Receiver File - Order Headings	40	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
24	F4011Z	Batch Receiver File - Order Details	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
25	F4012ZW	WF - Destination Quantity	17	SP	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
26	F4201Z1	Sales Order Header Unedited Transaction File	30	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
27	F4209	Held Orders	13	HO	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
28	F4211DT	Sales Order Detail Date Tracking File	17	DT	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
29	F4211Z1	Sales Order Detail Unedited Transaction File	35	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP41: Inventory Management
30	F4111	Item Ledger File	34	IL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
31	F41181	Container Transaction File	15	CM	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
32	F41UI001	Inventory Transactions Detail File	24	IT	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP41B: Bulk Stock Management
33	F41509	Four-Point Analysis Maintenance File	36	PG	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
34	F41511	Bulk Product Transaction File	11	PA	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
35	F41512	Gain/Loss Transactions File	18	PT	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP42: Sales Management
36	F4201	Sales Order Header File	17	SH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
37	F42019	Sales Order Header History File	17	SH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
38	F4211	Sales Order Detail File	22	SD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
39	F42119	Sales Order History File	22	SD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
40	F42199	S.O. Detail Ledger File	22	SL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
41	F42UI01	SO Header Cache File (MBF)	22	ZH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
42	F42UI11	SO Detail Cache File (MBF)	26	ZD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
43	F42UI520	Pick Slips Header File	22	S8	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
44	F42UI521	Pick Slips Detail File	20	S9	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
45	F42UI800	Sales Detail Work File - Sales Update	55	SD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP43: Procurement
46	F4301	Purchase Order Header	15	PH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
47	F4301Z	PO Header Work File	19	PA	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
48	F4301Z1	Purchase Order Header Unedited Transaction Table	28	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
49	F43080	Approvals Fields Constants	31	PD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
50	F43092Z1	Receipt Routing Unedited Transaction Table	47	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
51	F4311	Purchase Order Detail File	22	PD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
52	F4311Z	Purchase Order Generator File	26	PW	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
53	F4311Z1	Purchase Order Detail Unedited Transaction Table	35	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
54	F43121	Purchase Order Receiver File	26	PR	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
55	F43121Z1	Receipts Unedited Transaction Table	43	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
56	F4314Z	Voucher Match Selection File	125	PN	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
57	F43199	P.O. Detail Ledger File - Flexible Version	22	OL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
58	F4330	Supplier Selection File	7	P0	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
59	F43E09	F43E09 - Approvals Activity Table	15	AA	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
60	F43UI50D	PO Print Detail Work File	17	PW	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
61	F43UI50H	PO Print Header Work File	25	PA	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP43E: Requisition Self Service
62	F43E01	Requisition Order Header	5	RH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
63	F43E11	Requisition Detail	10	RD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP44H: Homebuilder Management
64	F4455	Vendor Assignment (Takeoffs) (World)	9	JH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
65	F44H601	Bid Header	23	BH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
66	F44H604	Vendor Assignment	13	VA	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
67	F44H604W	Vendor Assignment Workfile	15	VW	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
68	F44H604Z	HB Vendor Assignment Unedited Transaction File	26	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
69	F44H611	Bid Details	30	BD	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
70	F44H611W	Bid Details Work File	34	BW	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
71	F44H711	Lot Start Workfile	37	SW	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
72	F44H711Z	HB Lot Start Unedited Transaction File	50	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
73	F44H71W1	Lot Start Generation Workfile	37	GW	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
74	F44H73W1	Lot Start - P.O. / Committment Generation Work File	68	CG	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP45: Advanced Pricing
75	F4576Z1	Ship and Debit Claims Unedited Transaction Table	135	Z1	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP46: Warehouse Management
76	F4600	Warehouse Requests	67	R1	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
77	F4600PU	Warehouse Requests - Purged	65	R1	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
78	F4611	Warehouse Suggestions	91	R2	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
79	F4611PU	Warehouse Suggestions - Purged	90	R2	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
80	F4611Z1	Unedited Suggestion Table	102	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP46L: License Plating
81	F46LUI01	Assign/Remove Items To LP Work File	39	WF	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP47: Electronic Commerce
82	F47011	EDI Purchase Order Header - Inbound	35	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
83	F47012	EDI Purchase Order Detail - Inbound	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
84	F47016	EDI Purchase Order Header - Outbound	30	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
85	F47017	EDI Purchase Order Detail - Outbound	35	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
86	F47021	EDI P.O. Acknowledgment Header - Inbound	30	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
87	F47022	EDI P.O. Acknowledgment Detail - Inbound	35	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
88	F47026	EDI P.O. Acknowledgment Header - Outbound	32	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
89	F47027	EDI P.O. Acknowledgment Detail - Outbound	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
90	F47031	EDI Shipping Notice Header - Inbound	31	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
91	F47032	EDI Shipping Notice Detail - Inbound	38	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
92	F47037	EDI Shipping Notice Detail - Outbound	37	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
93	F470371	EDI Shipping Notice Detail - Outbound	37	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
94	F47046	EDI Invoice Header (Sales) - Outbound	32	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
95	F47047	EDI Invoice Detail (Sales) - Outbound	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
96	F47061	EDI Planning Schedule Header - Inbound	22	MJ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
97	F47066	EDI Planning Schedule Header - Outbound	22	MJ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
98	F47071	EDI Receiving Advice Header - Inbound	31	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
99	F47072	EDI Receiving Advice Detail - Inbound	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
100	F47076	EDI Receiving Advice Header - Outbound	31	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
101	F47077	EDI Receiving Advice Detail - Outbound	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
102	F47091	EDI Request for Quote Header - Inbound	35	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
103	F47092	EDI Request for Quote Detail - Inbound	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
104	F47096	EDI Request for Quote Header - Outbound	30	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
105	F47097	EDI Request for Quote Detail - Outbound	35	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
106	F47101	EDI Response to RFQ Header - Inbound	30	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
107	F47102	EDI Response to RFQ Detail - Inbound	35	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
108	F47106	EDI Response to RFQ Header - Outbound	32	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
109	F47107	EDI Response to RFQ Detail - Outbound	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
110	F47122	EDI Product Activity Data Detail - Inbound	40	MJ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
111	F47127	EDI Product Activity Data Detail - Outbound	40	MJ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
112	F47131	EDI Purchase Order Change Header - Inbound	32	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
113	F47132	EDI Purchase Order Change Detail - Inbound	37	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
114	F47136	EDI Purchase Order Change Header - Outbound	30	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
115	F47137	EDI Purchase Order Change Detail - Outbound	36	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
116	F47141	EDI P.O. Change Acknowledgment Header - Inbound	31	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
117	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	37	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
118	F47146	EDI P.O. Change Acknowledgment Header - Outbound	33	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
119	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	38	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
120	F47156	EDI Shipping Schedule Header - Outbound	32	SY	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
121	F47157	EDI Shipping Schedule Detail - Outbound	37	SZ	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP48: Work Order Processing
122	F4801	Work Order Master File	30	WA	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
123	F48UI001	X4801 Master Business Function Workfile	32	WA	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP49: Transportation Management
124	F49631	Load In-transit Ledger	28	TO	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP74: EMEA Localization
125	F74093	Workfile for Printing IVA Summary - Italy	18	HC	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
126	F7420033	Sales Document Line (Print Info) - COMM - 42	22	PI	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP74R: CIS
127	F74R4500	Paymet Order Supplemental Data - RU - 04 - 74R	8	PO	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP75T: Taiwan
128	F75T004	GUI/VAT Transaction Header - 75T	9	TH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
129	F75T0049	GUI/VAT Transaction Header History - 75T	9	TH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
130	F75T004P	GUI/VAT Transaction Header POS - 75T	9	TH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
131	F75T004Z	GUI/VAT Transaction Header - Work - 75T	9	ZH	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP76A: Argentina
132	F76A30T	F76A30 Tag File Z1 - ARG - 04 - 76A	15	V7	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
133	F76A411Q	F76A411P Tag File Purge - ARG - 04 - 76A	17	B1	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
134	F76A411T	F760411A A/P Tag File - ARG - 04 - 76A	17	B1	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP76C: Colombia
135	F76CT2	Sales/Use/V.A.T. Tax File - COL - 76C	11	CT	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP76H: Chile
136	F76H3B34	Sales Document Line (Print Info) - CHI - 03B - 76H	16	PI	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
137	F76H611	Actual Item Ledger File - CHI - 41 - 76H	35	AL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOP89: Conversion Programs
138	F43199A	Temp F43199 for ERP 9.0 Upgrade	22	OL	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOPD3N: dcLINK (data collection) - DSI
139	FD3N4116	dcLINK Interface - Inventory Reclassification	29	IR	TRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
TOPH91: Design Tools
140	F98TCHDR	Table Conversion Header	7	HD	TRDJ	Date - Order/Transaction	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

140 columns | 812 | TRDJ