	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

104 columns | 812 | 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
TOP42: Sales Management
21	F4211	Sales Order Detail File	44	SD	DSC2	Description - Line 2	String	Generic Edit	30	0
22	F42119	Sales Order History File	44	SD	DSC2	Description - Line 2	String	Generic Edit	30	0
23	F42199	S.O. Detail Ledger File	44	SL	DSC2	Description - Line 2	String	Generic Edit	30	0
24	F42565	Invoice Print File	19	IW	DSC2	Description - Line 2	String	Generic Edit	30	0
25	F42UI11	SO Detail Cache File (MBF)	43	ZD	DSC2	Description - Line 2	String	Generic Edit	30	0
26	F42UI521	Pick Slips Detail File	39	S9	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP42B: Sales Order Entry
27	F42420	Audit Log Transaction	44	AL	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP43: Procurement
28	F43080	Approvals Fields Constants	53	PD	DSC2	Description - Line 2	String	Generic Edit	30	0
29	F4311	Purchase Order Detail File	45	PD	DSC2	Description - Line 2	String	Generic Edit	30	0
30	F4311Z	Purchase Order Generator File	49	PW	DSC2	Description - Line 2	String	Generic Edit	30	0
31	F4311Z1	Purchase Order Detail Unedited Transaction Table	58	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
32	F43121Z1	Receipts Unedited Transaction Table	115	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
33	F4314Z	Voucher Match Selection File	10	PN	DSC2	Description - Line 2	String	Generic Edit	30	0
34	F43199	P.O. Detail Ledger File - Flexible Version	45	OL	DSC2	Description - Line 2	String	Generic Edit	30	0
35	F4371	Suggested Reorder Stock Items	13	PD	DSC2	Description - Line 2	String	Generic Edit	30	0
36	F43E09	F43E09 - Approvals Activity Table	25	AA	DSC2	Description - Line 2	String	Generic Edit	30	0
37	F43UI50D	PO Print Detail Work File	24	PW	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP43E: Requisition Self Service
38	F43E11	Requisition Detail	18	RD	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP44H: Homebuilder Management
39	F4450	Lot Proceed Header (World)	118	JD	DSC2	Description - Line 2	String	Generic Edit	30	0
40	F4451	Lot Proceed Detail (World)	30	JF	DSC2	Description - Line 2	String	Generic Edit	30	0
41	F4456	Lot Proceed Entry (World)	118	JI	DSC2	Description - Line 2	String	Generic Edit	30	0
42	F4461	Option Master (World)	21	JN	DSC2	Description - Line 2	String	Generic Edit	30	0
43	F44H301	Plan Master	19	PM	DSC2	Description - Line 2	String	Generic Edit	30	0
44	F44H511	Option Selections	16	OS	DSC2	Description - Line 2	String	Generic Edit	30	0
45	F44H511H	Option Selection History	17	OH	DSC2	Description - Line 2	String	Generic Edit	30	0
46	F44H611	Bid Details	37	BD	DSC2	Description - Line 2	String	Generic Edit	30	0
47	F44H611W	Bid Details Work File	41	BW	DSC2	Description - Line 2	String	Generic Edit	30	0
48	F44H711	Lot Start Workfile	43	SW	DSC2	Description - Line 2	String	Generic Edit	30	0
49	F44H711P	After Start Purchasing	32	TP	DSC2	Description - Line 2	String	Generic Edit	30	0
50	F44H711Z	HB Lot Start Unedited Transaction File	56	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
51	F44H71W1	Lot Start Generation Workfile	43	GW	DSC2	Description - Line 2	String	Generic Edit	30	0
52	F44H73W1	Lot Start - P.O. / Committment Generation Work File	38	CG	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP46: Warehouse Management
53	F4600	Warehouse Requests	57	R1	DSC2	Description - Line 2	String	Generic Edit	30	0
54	F4600PU	Warehouse Requests - Purged	55	R1	DSC2	Description - Line 2	String	Generic Edit	30	0
55	F4611	Warehouse Suggestions	65	R2	DSC2	Description - Line 2	String	Generic Edit	30	0
56	F4611PU	Warehouse Suggestions - Purged	64	R2	DSC2	Description - Line 2	String	Generic Edit	30	0
57	F4611Z1	Unedited Suggestion Table	77	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP46L: License Plating
58	F46LUI01	Assign/Remove Items To LP Work File	8	WF	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP47: Electronic Commerce
59	F47012	EDI Purchase Order Detail - Inbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
60	F47017	EDI Purchase Order Detail - Outbound	59	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
61	F47022	EDI P.O. Acknowledgment Detail - Inbound	59	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
62	F47027	EDI P.O. Acknowledgment Detail - Outbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
63	F47032	EDI Shipping Notice Detail - Inbound	54	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
64	F47037	EDI Shipping Notice Detail - Outbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
65	F470371	EDI Shipping Notice Detail - Outbound	69	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
66	F47042	EDI Invoice Detail - Inbound	51	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
67	F47047	EDI Invoice Detail (Sales) - Outbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
68	F47072	EDI Receiving Advice Detail - Inbound	60	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
69	F47077	EDI Receiving Advice Detail - Outbound	60	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
70	F47082	EDI Price Sales Catalog Detail - Inbound	20	FY	DSC2	Description - Line 2	String	Generic Edit	30	0
71	F47092	EDI Request for Quote Detail - Inbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
72	F47097	EDI Request for Quote Detail - Outbound	59	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
73	F47102	EDI Response to RFQ Detail - Inbound	59	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
74	F47107	EDI Response to RFQ Detail - Outbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
75	F47122	EDI Product Activity Data Detail - Inbound	39	MJ	DSC2	Description - Line 2	String	Generic Edit	30	0
76	F47127	EDI Product Activity Data Detail - Outbound	39	MJ	DSC2	Description - Line 2	String	Generic Edit	30	0
77	F47132	EDI Purchase Order Change Detail - Inbound	62	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
78	F47137	EDI Purchase Order Change Detail - Outbound	60	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
79	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	61	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
80	F47147	EDI P.O. Change Acknowledgment Detail - Outbound	63	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
81	F47157	EDI Shipping Schedule Detail - Outbound	62	SZ	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP55: Reserved for Clients
82	F74H1051	Invoicing Workfile - New	28	IW	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP74: EMEA Localization
83	F7420033	Sales Document Line (Print Info) - COMM - 42	8	PI	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP76A: Argentina
84	F760101A	A/B Tag File - ARG	18	V0	DSC2	Description - Line 2	String	Generic Edit	30	0
85	F76A010Z	F0101Z2 Argentinean Tag Table - ARG - 01 - 76A	21	V9	DSC2	Description - Line 2	String	Generic Edit	30	0
86	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	9	DL	DSC2	Description - Line 2	String	Generic Edit	30	0
87	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	9	DL	DSC2	Description - Line 2	String	Generic Edit	30	0
88	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	9	DL	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP76B: Brazil - Reporting System Only
89	F76111B	Nota Fiscal - Detail (Fiscal Books) - 42	9	QU	DSC2	Description - Line 2	String	Generic Edit	30	0
90	F76111BT	Conversion table for CFOP 5 digits - F76111B - 42	9	TA	DSC2	Description - Line 2	String	Generic Edit	30	0
91	F7611B	Nota Fiscal Detail - Brazil	31	FD	DSC2	Description - Line 2	String	Generic Edit	30	0
92	F761BA	AS Fiscal file book	35	FB	DSC2	Description - Line 2	String	Generic Edit	30	0
93	F76B31	Nota Fiscal Detail/Table for Goods - IN68 - 42	11	IM	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP76H: Chile
94	F76H101T	Address Book Tag File - CHI - 01 - 76H	5	AH	DSC2	Description - Line 2	String	Generic Edit	30	0
95	F76H101Z	EDI - A/B Tag File - CHI - 76H - 76H	8	AH	DSC2	Description - Line 2	String	Generic Edit	30	0
96	F76H3B34	Sales Document Line (Print Info) - CHI - 03B - 76H	10	PI	DSC2	Description - Line 2	String	Generic Edit	30	0
97	F76H3B38	Shipment Guide Line (Print Info) - CHI - 03B - 76H	10	PI	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP76P: Peru
98	F76P101T	Address Book Tag File - PER - 01 - 76P	7	AP	DSC2	Description - Line 2	String	Generic Edit	30	0
99	F76P101Z	EDI - A/B Tag File - PER - 76P - 76P	10	AH	DSC2	Description - Line 2	String	Generic Edit	30	0
TOP89: Conversion Programs
100	F43199A	Temp F43199 for ERP 9.0 Upgrade	45	OL	DSC2	Description - Line 2	String	Generic Edit	30	0
TOPF30L: DFM Line Design
101	FF30L501	DFM Item Definition Master	7	IB	DSC2	Description - Line 2	String	Generic Edit	30	0
TOPF31: Lean Transactions
102	FF31111	Lean Transaction Parts List	33	PL	DSC2	Description - Line 2	String	Generic Edit	30	0
103	FF31111S	Purge - Lean Transaction Parts List	33	PR	DSC2	Description - Line 2	String	Generic Edit	30	0
TOPH91: Design Tools
104	F98EVHDR	Event Header File	3	EH	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

104 columns | 812 | DSC2