	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

114 columns | 910 | DSC2

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP13: Plant/Equipment Management
1	F13017	Equipment Parts List	29	PL	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP13R: Resource Assignments
2	F48311	Resource Assignments	34	RA	DSC2	Description - Line 2	String	Generic Edit	30	0
3	F48311S	Purge - Resource Assignments	34	RA	DSC2	Description - Line 2	String	Generic Edit	30	0
4	F48316	Maintenance Rescheduling Metrics	13	RS	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP17: Customer Service Management
5	F1775	Claim Temporary Table	8	TC	DSC2	Description - Line 2	String	Generic Edit	30	0
6	F3111Z2	Warranty Claim/Supplier Recovery processing	45	WP	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP31: Shop Floor Control
7	F3111	Work Order Parts List	32	WM	DSC2	Description - Line 2	String	Generic Edit	30	0
8	F3111S	Purge - Shop Floor Parts List	32	WM	DSC2	Description - Line 2	String	Generic Edit	30	0
9	F3111Z1	Outbound Work Order Parts List	45	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP40: Inventory/OP Base
10	F4011Z	Batch Receiver File - Order Details	60	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
11	F4012ZW	WF - Destination Quantity	16	SP	DSC2	Description - Line 2	String	Generic Edit	30	0
12	F4104	Item Cross Reference File	9	IV	DSC2	Description - Line 2	String	Generic Edit	30	0
13	F4211Z1	Sales Order Detail Unedited Transaction File	57	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
14	F4220	Basic Serial Numbers	5	SW	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP41: Inventory Management
15	F4101	Item Master	5	IM	DSC2	Description - Line 2	String	Generic Edit	30	0
16	F4101A	Item File	13	IM	DSC2	Description - Line 2	String	Generic Edit	30	0
17	F4101D	Item Master - Alternative Description	6	IM	DSC2	Description - Line 2	String	Generic Edit	30	0
18	F4101Z1	F4101 Item Master Unedited Transaction Table	20	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
19	F41UI001	Inventory Transactions Detail File	213	IT	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP41B: Bulk Stock Management
20	F41012	Conversion Table Interface File	10	VA	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP41F: Apparel Management
21	F41F02WF	Style End Item Workfile	4	S1	DSC2	Description - Line 2	String	Generic Edit	30	0
22	FCW09	Item Revisions Work File	6	WR	DSC2	Description - Line 2	String	Generic Edit	30	0
23	FCW31	Proposal Order Line Details	45	LV	DSC2	Description - Line 2	String	Generic Edit	30	0
24	FCW67	Style Work Order Parts List	38	WM	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP42: Sales Management
25	F4211	Sales Order Detail File	44	SD	DSC2	Description - Line 2	String	Generic Edit	30	0
26	F42119	Sales Order History File	44	SD	DSC2	Description - Line 2	String	Generic Edit	30	0
27	F42199	S.O. Detail Ledger File	44	SL	DSC2	Description - Line 2	String	Generic Edit	30	0
28	F42565	Invoice Print File	19	IW	DSC2	Description - Line 2	String	Generic Edit	30	0
29	F42UI11	SO Detail Cache File (MBF)	43	ZD	DSC2	Description - Line 2	String	Generic Edit	30	0
30	F42UI521	Pick Slips Detail File	39	S9	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP42B: Sales Order Entry
31	F42420	Audit Log Transaction	44	AL	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP43: Procurement
32	F43080	Approvals Fields Constants	53	PD	DSC2	Description - Line 2	String	Generic Edit	30	0
33	F4311	Purchase Order Detail File	45	PD	DSC2	Description - Line 2	String	Generic Edit	30	0
34	F4311Z	Purchase Order Generator File	49	PW	DSC2	Description - Line 2	String	Generic Edit	30	0
35	F4311Z1	Purchase Order Detail Unedited Transaction Table	58	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
36	F43121Z1	Receipts Unedited Transaction Table	115	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
37	F4314Z	Voucher Match Selection File	10	PN	DSC2	Description - Line 2	String	Generic Edit	30	0
38	F43199	P.O. Detail Ledger File - Flexible Version	45	OL	DSC2	Description - Line 2	String	Generic Edit	30	0
39	F4371	Suggested Reorder Stock Items	13	PD	DSC2	Description - Line 2	String	Generic Edit	30	0
40	F43UI50D	PO Print Detail Work File	24	PW	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP43E: Requisition Self Service
41	F43E09	F43E09 - Approvals Activity Table	25	AA	DSC2	Description - Line 2	String	Generic Edit	30	0
42	F43E11	Requisition Detail	18	RD	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP44H: Homebuilder Management
43	F4450	Lot Proceed Header (World)	118	JD	DSC2	Description - Line 2	String	Generic Edit	30	0
44	F4451	Lot Proceed Detail (World)	30	JF	DSC2	Description - Line 2	String	Generic Edit	30	0
45	F4456	Lot Proceed Entry (World)	118	JI	DSC2	Description - Line 2	String	Generic Edit	30	0
46	F4461	Option Master (World)	21	JN	DSC2	Description - Line 2	String	Generic Edit	30	0
47	F44H301	Plan Master	19	PM	DSC2	Description - Line 2	String	Generic Edit	30	0
48	F44H511	Option Selections	16	OS	DSC2	Description - Line 2	String	Generic Edit	30	0
49	F44H511H	Option Selection History	17	OH	DSC2	Description - Line 2	String	Generic Edit	30	0
50	F44H611	Bid Details	37	BD	DSC2	Description - Line 2	String	Generic Edit	30	0
51	F44H611W	Bid Details Work File	41	BW	DSC2	Description - Line 2	String	Generic Edit	30	0
52	F44H711	Lot Start Workfile	43	SW	DSC2	Description - Line 2	String	Generic Edit	30	0
53	F44H711P	After Start Purchasing	32	TP	DSC2	Description - Line 2	String	Generic Edit	30	0
54	F44H711Z	HB Lot Start Unedited Transaction File	56	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
55	F44H71W1	Lot Start Generation Workfile	43	GW	DSC2	Description - Line 2	String	Generic Edit	30	0
56	F44H73W1	Lot Start - P.O. / Committment Generation Work File	38	CG	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP46: Warehouse Management
57	F4600	Warehouse Requests	57	R1	DSC2	Description - Line 2	String	Generic Edit	30	0
58	F4600PU	Warehouse Requests - Purged	55	R1	DSC2	Description - Line 2	String	Generic Edit	30	0
59	F4611	Warehouse Suggestions	65	R2	DSC2	Description - Line 2	String	Generic Edit	30	0
60	F4611PU	Warehouse Suggestions - Purged	64	R2	DSC2	Description - Line 2	String	Generic Edit	30	0
61	F4611Z1	Unedited Suggestion Table	77	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP46L: License Plating
62	F46LUI01	Assign/Remove Items To LP Work File	8	WF	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP47: Electronic Commerce
63	F47012	EDI Purchase Order Detail - Inbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
64	F47017	EDI Purchase Order Detail - Outbound	59	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
65	F47022	EDI P.O. Acknowledgment Detail - Inbound	59	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
66	F47027	EDI P.O. Acknowledgment Detail - Outbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
67	F47032	EDI Shipping Notice Detail - Inbound	54	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
68	F47037	EDI Shipping Notice Detail - Outbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
69	F470371	EDI Shipping Notice Detail - Outbound	69	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
70	F47042	EDI Invoice Detail - Inbound	51	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
71	F47047	EDI Invoice Detail (Sales) - Outbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
72	F47072	EDI Receiving Advice Detail - Inbound	60	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
73	F47077	EDI Receiving Advice Detail - Outbound	60	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
74	F47082	EDI Price Sales Catalog Detail - Inbound	20	FY	DSC2	Description - Line 2	String	Generic Edit	30	0
75	F47092	EDI Request for Quote Detail - Inbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
76	F47097	EDI Request for Quote Detail - Outbound	59	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
77	F47102	EDI Response to RFQ Detail - Inbound	59	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
78	F47107	EDI Response to RFQ Detail - Outbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
79	F47122	EDI Product Activity Data Detail - Inbound	39	MJ	DSC2	Description - Line 2	String	Generic Edit	30	0
80	F47127	EDI Product Activity Data Detail - Outbound	39	MJ	DSC2	Description - Line 2	String	Generic Edit	30	0
81	F47132	EDI Purchase Order Change Detail - Inbound	62	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
82	F47137	EDI Purchase Order Change Detail - Outbound	60	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
83	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
84	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	63	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
85	F47157	EDI Shipping Schedule Detail - Outbound	62	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP49: Transportation Management
86	F49T100	Procurement Freight Request staging table	29	OB	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP55: Reserved for Clients
87	F74H1051	Invoicing Workfile - New	28	IW	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP74: EMEA Localization
88	F7420033	Sales Document Line (Print Info) - COMM - 42	8	PI	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP74U: United Kingdom Localizations
89	F74U0424	SPC Subcontractor Payment Liability - UK - 43	31	PL	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP75I: India
90	F75I309	Personal Consumption - CENVAT setoff - IND - 41	2	CS	DSC2	Description - Line 2	String	Generic Edit	30	0
91	F75I346	Excise - D3-Form Table	36	Q9	DSC2	Description - Line 2	String	Generic Edit	30	0
92	F75I385	RG23D Register - Issues - IND - 42	32	ED	DSC2	Description - Line 2	String	Generic Edit	30	0
93	F75I409	Personal Consumption - VAT setoff - IND - 41	2	VS	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP75T: Taiwan
94	F75T42W	Work file with union of F4211 and F42119	19	SW	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP76A: Argentina
95	F760101A	A/B Tag Table - ARG - 04 - 76A	18	V0	DSC2	Description - Line 2	String	Generic Edit	30	0
96	F76A010Z	F0101Z2 Argentinean Tag Table - ARG - 01 - 76A	21	V9	DSC2	Description - Line 2	String	Generic Edit	30	0
97	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	9	DL	DSC2	Description - Line 2	String	Generic Edit	30	0
98	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	9	DL	DSC2	Description - Line 2	String	Generic Edit	30	0
99	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A	9	DL	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP76B: Brazil - Reporting System Only
100	F76111B	Nota Fiscal - Detail (Fiscal Books) - 42	9	QU	DSC2	Description - Line 2	String	Generic Edit	30	0
101	F76111BT	Conversion table for CFOP 5 digits - F76111B - 42	9	TA	DSC2	Description - Line 2	String	Generic Edit	30	0
102	F7611B	Nota Fiscal Detail - BRA - 42	31	FD	DSC2	Description - Line 2	String	Generic Edit	30	0
103	F761BA	AS Fiscal file book - 09	35	FB	DSC2	Description - Line 2	String	Generic Edit	30	0
104	F76B31	Nota Fiscal Detail/Table for Goods - IN68 - 42	11	IM	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP76H: Chile
105	F76H101T	Address Book Tag File - CHI - 01 - 76H	5	AH	DSC2	Description - Line 2	String	Generic Edit	30	0
106	F76H101Z	EDI - A/B Tag File - CHI - 76H - 76H	8	AH	DSC2	Description - Line 2	String	Generic Edit	30	0
107	F76H3B34	Sales Document Line (Print Info) - CHI - 03B - 76H	10	PI	DSC2	Description - Line 2	String	Generic Edit	30	0
108	F76H3B38	Shipment Guide Line (Print Info) - CHI - 03B - 76H	10	PI	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP76P: Peru
109	F76P101T	Address Book Tag File - PER - 01 - 76P	7	AP	DSC2	Description - Line 2	String	Generic Edit	30	0
110	F76P101Z	EDI - A/B Tag File - PER - 76P - 76P	10	AH	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP89: Conversion Programs
111	F43199A	Temp F43199 for ERP 9.0 Upgrade	45	OL	DSC2	Description - Line 2	String	Generic Edit	30	0
TOPF30L: DFM Line Design
112	FF30L501	DFM Item Definition Master	7	IB	DSC2	Description - Line 2	String	Generic Edit	30	0
TOPF31: Lean Transactions
113	FF31111	Lean Transaction Parts List	33	PL	DSC2	Description - Line 2	String	Generic Edit	30	0
114	FF31111S	Purge - Lean Transaction Parts List	33	PR	DSC2	Description - Line 2	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

114 columns | 910 | DSC2