	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

176 columns | 812 | DSC1

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP13: Plant/Equipment Management
1	F13017	Equipment Parts List	28	PL	DSC1	Description	String	Generic Edit	30	0
TOP13C: Condition-Base Maintenance
2	F1310	Condition-Based Alerts	21	CA	DSC1	Description	String	Generic Edit	30	0
3	F1310Z1	Unedited Condition-Based Alerts	35	CB	DSC1	Description	String	Generic Edit	30	0
TOP13R: Resource Assignments
4	F48311	Resource Assignments	33	RA	DSC1	Description	String	Generic Edit	30	0
5	F48311S	Purge - Resource Assignments	33	RA	DSC1	Description	String	Generic Edit	30	0
6	F48316	Maintenance Rescheduling Metrics	12	RS	DSC1	Description	String	Generic Edit	30	0
TOP17: Customer Service Management
7	F1775	Claim Temporary Table	5	TC	DSC1	Description	String	Generic Edit	30	0
8	F3111Z2	Warranty Claim/Supplier Recovery processing	44	WP	DSC1	Description	String	Generic Edit	30	0
9	F3112Z2	Warranty Claim/Supplier Recovery processing	25	WL	DSC1	Description	String	Generic Edit	30	0
TOP17C: Call Management
10	F1760	Time Entry	13	ZB	DSC1	Description	String	Generic Edit	30	0
TOP30: Product Data Management
11	F300210	Lean Multi Level Bill of Material Header	19	EH	DSC1	Description	String	Generic Edit	30	0
12	F300211	Lean Multi Level Bill of Material Detail	59	ED	DSC1	Description	String	Generic Edit	30	0
13	F3002Z1	Bill of Material Transaction File	63	SZ	DSC1	Description	String	Generic Edit	30	0
14	F300311	Lean Multi Level Routing Detail File	5	EH	DSC1	Description	String	Generic Edit	30	0
15	F3003Z1	Routing Transactions File	20	SZ	DSC1	Description	String	Generic Edit	30	0
16	F30UI008	Bill of Material Comparison Work File	14	IJ	DSC1	Description	String	Generic Edit	30	0
TOP31: Shop Floor Control
17	F3111	Work Order Parts List	31	WM	DSC1	Description	String	Generic Edit	30	0
18	F3111S	Purge - Shop Floor Parts List	31	WM	DSC1	Description	String	Generic Edit	30	0
19	F3111Z1	Outbound Work Order Parts List	44	SZ	DSC1	Description	String	Generic Edit	30	0
20	F3112	Work Order Routing	12	WL	DSC1	Description	String	Generic Edit	30	0
21	F3112S	Purge Shop Floor Control Routing Instructions	12	WL	DSC1	Description	String	Generic Edit	30	0
22	F3112Z1	Outbound Work Order Routings	25	SZ	DSC1	Description	String	Generic Edit	30	0
TOP31B: Blend Management
23	F31B0710	Harvest Assumptions	4	HA	DSC1	Description	String	Generic Edit	30	0
TOP32: Configuration Management
24	F3212	Configurator Routings File	7	RC	DSC1	Description	String	Generic Edit	30	0
25	F3215	Configurator Component Table	6	CC	DSC1	Description	String	Generic Edit	30	0
26	F32159	Configurator Component History Table	6	CH	DSC1	Description	String	Generic Edit	30	0
27	F3216	Configurator Price/Cost Table	4	PC	DSC1	Description	String	Generic Edit	30	0
28	F32169	Configurator Price/Cost History	4	KB	DSC1	Description	String	Generic Edit	30	0
29	F3281	Rules Table Definition	3	RT	DSC1	Description	String	Generic Edit	30	0
30	F3291	Configured Item Segments	8	KW	DSC1	Description	String	Generic Edit	30	0
31	F3293	Assembly Inclusions Rules	10	KY	DSC1	Description	String	Generic Edit	30	0
32	F3295	Segment Value History File	4	KS	DSC1	Description	String	Generic Edit	30	0
33	F32961	Configurator Cost/Price Adjustment File	12	KL	DSC1	Description	String	Generic Edit	30	0
34	F329611	Configurator Detail Cost/Price Adjustment Table	14	KB	DSC1	Description	String	Generic Edit	30	0
35	F3296T	Configurator Level Sequence File Table	13	KA	DSC1	Description	String	Generic Edit	30	0
TOP33: Capacity Planning
36	F3311	Capacity Message File	11	CN	DSC1	Description	String	Generic Edit	30	0
TOP34: Requirements Planning
37	F3411	MPS/MRP/DRP Message File	13	MM	DSC1	Description	String	Generic Edit	30	0
TOP34A: Advanced Planning & Scheduling
38	F34A110	Work Center Resource Table	5	N0	DSC1	Description	String	Generic Edit	30	0
39	F34A120	Routing Master Resource Table	25	N0	DSC1	Description	String	Generic Edit	30	0
40	F34A80	Resource Master Table	2	N0	DSC1	Description	String	Generic Edit	30	0
TOP37: Quality Management
41	F3701	Test Definitions Master File	7	QA	DSC1	Description	String	Generic Edit	30	0
42	F37013	Test Result Name	2	TR	DSC1	Description	String	Generic Edit	30	0
43	F37014	Test Result Conversions	2	RC	DSC1	Description	String	Generic Edit	30	0
44	F37015	Test Result Conversion Tables	3	CT	DSC1	Description	String	Generic Edit	30	0
45	F3702	Specifications Definitions Master File	3	QS	DSC1	Description	String	Generic Edit	30	0
TOP39: Advanced Stock Valuation
46	F3905	Valuation Method Master	2	SV	DSC1	Description	String	Generic Edit	30	0
TOP40: Inventory/OP Base
47	F3002	Bill of Material Master File	50	IX	DSC1	Description	String	Generic Edit	30	0
48	F3003	Routing Master File	7	IR	DSC1	Description	String	Generic Edit	30	0
49	F3011	Bill of Materials Change File	50	IZ	DSC1	Description	String	Generic Edit	30	0
50	F3013	ECO Parts List Detail	47	CY	DSC1	Description	String	Generic Edit	30	0
51	F30UI004	Bill of Material Update Work File	67	WF	DSC1	Description	String	Generic Edit	30	0
52	F4011Z	Batch Receiver File - Order Details	59	SZ	DSC1	Description	String	Generic Edit	30	0
53	F4012ZW	WF - Destination Quantity	15	SP	DSC1	Description	String	Generic Edit	30	0
54	F4080	Related Order Cross Reference Table	17	RO	DSC1	Description	String	Generic Edit	30	0
55	F40UI74	Price Adjustment History Work File	40	AW	DSC1	Description	String	Generic Edit	30	0
56	F4104	Item Cross Reference File	8	IV	DSC1	Description	String	Generic Edit	30	0
57	F42008	Order Hold Constants	10	HC	DSC1	Description	String	Generic Edit	30	0
58	F4211Z1	Sales Order Detail Unedited Transaction File	56	SZ	DSC1	Description	String	Generic Edit	30	0
59	F4220	Basic Serial Numbers	4	SW	DSC1	Description	String	Generic Edit	30	0
TOP41: Inventory Management
60	F4101	Item Master	4	IM	DSC1	Description	String	Generic Edit	30	0
61	F4101A	Item File	12	IM	DSC1	Description	String	Generic Edit	30	0
62	F4101D	Item Master - Alternative Description	5	IM	DSC1	Description	String	Generic Edit	30	0
63	F4101HD	Item Hierarchy - Alternate Description	4	IH	DSC1	Description	String	Generic Edit	30	0
64	F4101Z1	F4101 Item Master Unedited Transaction Table	19	SZ	DSC1	Description	String	Generic Edit	30	0
65	F41291Z	Landed Cost Cache Table	9	IG	DSC1	Description	String	Generic Edit	30	0
66	F4140	Cycle Count Header File	2	PI	DSC1	Description	String	Generic Edit	30	0
67	F41UI001	Inventory Transactions Detail File	160	IT	DSC1	Description	String	Generic Edit	30	0
68	F41UI003	ABC Analysis Detail - Work File	7	AA	DSC1	Description	String	Generic Edit	30	0
TOP41B: Bulk Stock Management
69	F41012	Conversion Table Interface File	2	VA	DSC1	Description	String	Generic Edit	30	0
TOP42: Sales Management
70	F4211	Sales Order Detail File	43	SD	DSC1	Description	String	Generic Edit	30	0
71	F42119	Sales Order History File	43	SD	DSC1	Description	String	Generic Edit	30	0
72	F42199	S.O. Detail Ledger File	43	SL	DSC1	Description	String	Generic Edit	30	0
73	F42565	Invoice Print File	18	IW	DSC1	Description	String	Generic Edit	30	0
74	F42UI11	SO Detail Cache File (MBF)	42	ZD	DSC1	Description	String	Generic Edit	30	0
75	F42UI521	Pick Slips Detail File	38	S9	DSC1	Description	String	Generic Edit	30	0
TOP42B: Sales Order Entry
76	F42420	Audit Log Transaction	26	AL	DSC1	Description	String	Generic Edit	30	0
TOP43: Procurement
77	F43080	Approvals Fields Constants	52	PD	DSC1	Description	String	Generic Edit	30	0
78	F4311	Purchase Order Detail File	44	PD	DSC1	Description	String	Generic Edit	30	0
79	F4311Z	Purchase Order Generator File	48	PW	DSC1	Description	String	Generic Edit	30	0
80	F4311Z1	Purchase Order Detail Unedited Transaction Table	57	SZ	DSC1	Description	String	Generic Edit	30	0
81	F43121Z	Receiver workfile	89	PW	DSC1	Description	String	Generic Edit	30	0
82	F43121Z1	Receipts Unedited Transaction Table	114	SZ	DSC1	Description	String	Generic Edit	30	0
83	F4314Z	Voucher Match Selection File	9	PN	DSC1	Description	String	Generic Edit	30	0
84	F43199	P.O. Detail Ledger File - Flexible Version	44	OL	DSC1	Description	String	Generic Edit	30	0
85	F43632Z	Open Purchase Order by Item Work File	16	OI	DSC1	Description	String	Generic Edit	30	0
86	F4371	Suggested Reorder Stock Items	12	PD	DSC1	Description	String	Generic Edit	30	0
87	F43E09	F43E09 - Approvals Activity Table	24	AA	DSC1	Description	String	Generic Edit	30	0
88	F43UI50D	PO Print Detail Work File	9	PW	DSC1	Description	String	Generic Edit	30	0
89	F43UI50H	PO Print Header Work File	34	PA	DSC1	Description	String	Generic Edit	30	0
TOP43E: Requisition Self Service
90	F43E11	Requisition Detail	17	RD	DSC1	Description	String	Generic Edit	30	0
TOP43Q: Strategic Sourcing
91	F43Q11	Event Detail	21	ED	DSC1	Description	String	Generic Edit	30	0
92	F43Q41	Response Line	16	RB	DSC1	Description	String	Generic Edit	30	0
93	F43Q51	Analyze Event Detail	12	ED	DSC1	Description	String	Generic Edit	30	0
TOP44H: Homebuilder Management
94	F4450	Lot Proceed Header (World)	117	JD	DSC1	Description	String	Generic Edit	30	0
95	F4451	Lot Proceed Detail (World)	29	JF	DSC1	Description	String	Generic Edit	30	0
96	F4456	Lot Proceed Entry (World)	117	JI	DSC1	Description	String	Generic Edit	30	0
97	F4461	Option Master (World)	20	JN	DSC1	Description	String	Generic Edit	30	0
98	F44H301	Plan Master	18	PM	DSC1	Description	String	Generic Edit	30	0
99	F44H511	Option Selections	15	OS	DSC1	Description	String	Generic Edit	30	0
100	F44H511H	Option Selection History	16	OH	DSC1	Description	String	Generic Edit	30	0
101	F44H611	Bid Details	36	BD	DSC1	Description	String	Generic Edit	30	0
102	F44H611W	Bid Details Work File	40	BW	DSC1	Description	String	Generic Edit	30	0
103	F44H711	Lot Start Workfile	42	SW	DSC1	Description	String	Generic Edit	30	0
104	F44H711P	After Start Purchasing	31	TP	DSC1	Description	String	Generic Edit	30	0
105	F44H711Z	HB Lot Start Unedited Transaction File	55	SZ	DSC1	Description	String	Generic Edit	30	0
106	F44H71W1	Lot Start Generation Workfile	42	GW	DSC1	Description	String	Generic Edit	30	0
107	F44H73W1	Lot Start - P.O. / Committment Generation Work File	37	CG	DSC1	Description	String	Generic Edit	30	0
TOP45: Advanced Pricing
108	F4576	Ship and Debit Claims	46	AC	DSC1	Description	String	Generic Edit	30	0
109	F4576TMP	Ship and Debit Claims- Temp Table	46	AC	DSC1	Description	String	Generic Edit	30	0
110	F4576Z1	Ship and Debit Claims Unedited Transaction Table	59	Z1	DSC1	Description	String	Generic Edit	30	0
TOP46: Warehouse Management
111	F4600	Warehouse Requests	56	R1	DSC1	Description	String	Generic Edit	30	0
112	F4600PU	Warehouse Requests - Purged	54	R1	DSC1	Description	String	Generic Edit	30	0
113	F4611	Warehouse Suggestions	64	R2	DSC1	Description	String	Generic Edit	30	0
114	F4611PU	Warehouse Suggestions - Purged	63	R2	DSC1	Description	String	Generic Edit	30	0
115	F4611Z1	Unedited Suggestion Table	76	SZ	DSC1	Description	String	Generic Edit	30	0
TOP46L: License Plating
116	F46LUI01	Assign/Remove Items To LP Work File	7	WF	DSC1	Description	String	Generic Edit	30	0
TOP47: Electronic Commerce
117	F47012	EDI Purchase Order Detail - Inbound	60	SZ	DSC1	Description	String	Generic Edit	30	0
118	F47017	EDI Purchase Order Detail - Outbound	58	SZ	DSC1	Description	String	Generic Edit	30	0
119	F47022	EDI P.O. Acknowledgment Detail - Inbound	58	SZ	DSC1	Description	String	Generic Edit	30	0
120	F47027	EDI P.O. Acknowledgment Detail - Outbound	60	SZ	DSC1	Description	String	Generic Edit	30	0
121	F47032	EDI Shipping Notice Detail - Inbound	53	SZ	DSC1	Description	String	Generic Edit	30	0
122	F47037	EDI Shipping Notice Detail - Outbound	60	SZ	DSC1	Description	String	Generic Edit	30	0
123	F470371	EDI Shipping Notice Detail - Outbound	68	SZ	DSC1	Description	String	Generic Edit	30	0
124	F47042	EDI Invoice Detail - Inbound	50	SZ	DSC1	Description	String	Generic Edit	30	0
125	F47047	EDI Invoice Detail (Sales) - Outbound	60	SZ	DSC1	Description	String	Generic Edit	30	0
126	F47062	EDI Planning Schedule Detail - Inbound	19	MY	DSC1	Description	String	Generic Edit	30	0
127	F47067	EDI Planning Schedule Detail - Outbound	19	MY	DSC1	Description	String	Generic Edit	30	0
128	F47072	EDI Receiving Advice Detail - Inbound	59	SZ	DSC1	Description	String	Generic Edit	30	0
129	F47077	EDI Receiving Advice Detail - Outbound	59	SZ	DSC1	Description	String	Generic Edit	30	0
130	F47082	EDI Price Sales Catalog Detail - Inbound	19	FY	DSC1	Description	String	Generic Edit	30	0
131	F47092	EDI Request for Quote Detail - Inbound	60	SZ	DSC1	Description	String	Generic Edit	30	0
132	F47097	EDI Request for Quote Detail - Outbound	58	SZ	DSC1	Description	String	Generic Edit	30	0
133	F47102	EDI Response to RFQ Detail - Inbound	58	SZ	DSC1	Description	String	Generic Edit	30	0
134	F47107	EDI Response to RFQ Detail - Outbound	60	SZ	DSC1	Description	String	Generic Edit	30	0
135	F47122	EDI Product Activity Data Detail - Inbound	38	MJ	DSC1	Description	String	Generic Edit	30	0
136	F47127	EDI Product Activity Data Detail - Outbound	38	MJ	DSC1	Description	String	Generic Edit	30	0
137	F47132	EDI Purchase Order Change Detail - Inbound	61	SZ	DSC1	Description	String	Generic Edit	30	0
138	F47137	EDI Purchase Order Change Detail - Outbound	59	SZ	DSC1	Description	String	Generic Edit	30	0
139	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	60	SZ	DSC1	Description	String	Generic Edit	30	0
140	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	62	SZ	DSC1	Description	String	Generic Edit	30	0
141	F47157	EDI Shipping Schedule Detail - Outbound	61	SZ	DSC1	Description	String	Generic Edit	30	0
TOP55: Reserved for Clients
142	F74H1051	Invoicing Workfile - New	27	IW	DSC1	Description	String	Generic Edit	30	0
TOP74: EMEA Localization
143	F7420033	Sales Document Line (Print Info) - COMM - 42	7	PI	DSC1	Description	String	Generic Edit	30	0
TOP75T: Taiwan
144	F75T004	GUI/VAT Transaction Header - 75T	63	TH	DSC1	Description	String	Generic Edit	30	0
145	F75T0049	GUI/VAT Transaction Header History - 75T	63	TH	DSC1	Description	String	Generic Edit	30	0
146	F75T004P	GUI/VAT Transaction Header POS - 75T	63	TH	DSC1	Description	String	Generic Edit	30	0
147	F75T005	GUI/VAT Transaction Detail - 75T	7	TD	DSC1	Description	String	Generic Edit	30	0
148	F75T0059	GUI/VAT Transaction Detail History - 75T	7	TD	DSC1	Description	String	Generic Edit	30	0
149	F75T005P	GUI/VAT Transaction Detail POS - 75T	7	TD	DSC1	Description	String	Generic Edit	30	0
150	F75T005Z	GUI/VAT Transaction Detail - Work - 75T	13	ZD	DSC1	Description	String	Generic Edit	30	0
TOP76A: Argentina
151	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	8	DL	DSC1	Description	String	Generic Edit	30	0
152	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	8	DL	DSC1	Description	String	Generic Edit	30	0
153	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	8	DL	DSC1	Description	String	Generic Edit	30	0
TOP76B: Brazil - Reporting System Only
154	F76111B	Nota Fiscal - Detail (Fiscal Books) - 42	8	QU	DSC1	Description	String	Generic Edit	30	0
155	F76111BT	Conversion table for CFOP 5 digits - F76111B - 42	8	TA	DSC1	Description	String	Generic Edit	30	0
156	F7611B	Nota Fiscal Detail - Brazil	30	FD	DSC1	Description	String	Generic Edit	30	0
157	F761BA	AS Fiscal file book	34	FB	DSC1	Description	String	Generic Edit	30	0
158	F76B103	Verification ICMS / IPI - Information - 42	7	QD	DSC1	Description	String	Generic Edit	30	0
159	F76B105	GNRE Table - 42	14	QC	DSC1	Description	String	Generic Edit	30	0
160	F76B31	Nota Fiscal Detail/Table for Goods - IN68 - 42	10	IM	DSC1	Description	String	Generic Edit	30	0
161	F76B400G	IN86-Work Table for Item Number and Service Code - 41	4	IS	DSC1	Description	String	Generic Edit	30	0
162	T76B002	Temporary file for DIPJ - Material - 42	2	QB	DSC1	Description	String	Generic Edit	30	0
TOP76H: Chile
163	F76H3B34	Sales Document Line (Print Info) - CHI - 03B - 76H	9	PI	DSC1	Description	String	Generic Edit	30	0
164	F76H3B38	Shipment Guide Line (Print Info) - CHI - 03B - 76H	9	PI	DSC1	Description	String	Generic Edit	30	0
TOP89: Conversion Programs
165	F43199A	Temp F43199 for ERP 9.0 Upgrade	44	OL	DSC1	Description	String	Generic Edit	30	0
TOPF30L: DFM Line Design
166	FF30L002	DFM Bill of Material Master	44	DH	DSC1	Description	String	Generic Edit	30	0
167	FF30L102	Mixed Model Family Items	5	FD	DSC1	Description	String	Generic Edit	30	0
168	FF30L501	DFM Item Definition Master	6	IB	DSC1	Description	String	Generic Edit	30	0
169	FF30L801	Sales Order Master	8	SD	DSC1	Description	String	Generic Edit	30	0
170	FF30L930	DFM Routings	6	LR	DSC1	Description	String	Generic Edit	30	0
TOPF31: Lean Transactions
171	FF31111	Lean Transaction Parts List	32	PL	DSC1	Description	String	Generic Edit	30	0
172	FF31111S	Purge - Lean Transaction Parts List	32	PR	DSC1	Description	String	Generic Edit	30	0
173	FF31112	Routing Transaction Table	25	EH	DSC1	Description	String	Generic Edit	30	0
174	FF31112S	Purge - Routing Transaction Table	25	ET	DSC1	Description	String	Generic Edit	30	0
TOPF34S: DFM Production Sequencing
175	FF34S01W	DFM Plan Demand Work File	20	PD	DSC1	Description	String	Generic Edit	30	0
TOPH91: Design Tools
176	F98EVHDR	Event Header File	7	EH	DSC1	Description	String	Generic Edit	30	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

176 columns | 812 | DSC1