	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

35 columns | 910 | LINE

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP17: Customer Service Management
1	F3112Z2	Warranty Claim/Supplier Recovery processing	22	WL	LINE	Line/Cell Identifier	String	Generic Edit	12	0
2	F4801TZ2	Warranty Claim/Supplier Recovery processing	15	WQ	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOP30: Product Data Management
3	F300311	Lean Multi-Level Routing Detail File	6	EH	LINE	Line/Cell Identifier	String	Generic Edit	12	0
4	F3003T	Routing Tag File - not used in B9 - obsolete in B10	4	IR	LINE	Line/Cell Identifier	String	Generic Edit	12	0
5	F3003Z1	Routing Transactions File	21	SZ	LINE	Line/Cell Identifier	String	Generic Edit	12	0
6	F3016	Kanban Master	22	KM	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOP31: Shop Floor Control
7	F3109	Line/Item Relationship Master	5	IP	LINE	Line/Cell Identifier	String	Generic Edit	12	0
8	F31091	Schedule Quantity Detail	5	IQ	LINE	Line/Cell Identifier	String	Generic Edit	12	0
9	F31091S	Schedule Quantity Detail Purge	5	IQ	LINE	Line/Cell Identifier	String	Generic Edit	12	0
10	F3112	Work Order Routing	9	WL	LINE	Line/Cell Identifier	String	Generic Edit	12	0
11	F31122	Work Order Time Transactions	40	WT	LINE	Line/Cell Identifier	String	Generic Edit	12	0
12	F31122S	Purge Work Order Time Transactions	40	WT	LINE	Line/Cell Identifier	String	Generic Edit	12	0
13	F31122ST	Purge Work Order Time Transactions Tag Table - Needed for u	3	WT	LINE	Line/Cell Identifier	String	Generic Edit	12	0
14	F31122T	Work Order Time Transactions Tag Table -- Needed for upgrade	3	WT	LINE	Line/Cell Identifier	String	Generic Edit	12	0
15	F31122Z1	Work Order Time Transactions Unedited Transaction Table	48	SZ	LINE	Line/Cell Identifier	String	Generic Edit	12	0
16	F3112S	Purge Shop Floor Control Routing Instructions	9	WL	LINE	Line/Cell Identifier	String	Generic Edit	12	0
17	F3112Z1	Outbound Work Order Routings	22	SZ	LINE	Line/Cell Identifier	String	Generic Edit	12	0
18	F31UI006	Line Scheduling Workbench - Work File	4	LS	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOP34: Requirements Planning
19	F3411	MPS/MRP/DRP Message File	27	MM	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOP34A: Advanced Planning & Scheduling
20	F34A120	Routing Master Resource Table	4	N0	LINE	Line/Cell Identifier	String	Generic Edit	12	0
21	F34A180	Routing Master Resource Set	4	RR	LINE	Line/Cell Identifier	String	Generic Edit	12	0
22	F34A190	Routing Master Resource and Set XRef	4	RD	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOP40: Inventory/OP Base
23	F3003	Routing Master File	8	IR	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOP41: Inventory Management
24	F4101	Item Master	195	IM	LINE	Line/Cell Identifier	String	Generic Edit	12	0
25	F4101M	Item Manufacturing Data	70	IM	LINE	Line/Cell Identifier	String	Generic Edit	12	0
26	F4101Z1	F4101 Item Master Unedited Transaction Table	248	SZ	LINE	Line/Cell Identifier	String	Generic Edit	12	0
27	F4102	Item Branch File	162	IB	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOP41F: Apparel Management
28	FCW68	Style Work Order Routings	10	WL	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOP48: Work Order Processing
29	F4801ST	Purge - Work Order Master Tag File	2	WA	LINE	Line/Cell Identifier	String	Generic Edit	12	0
30	F4801T	Work Order Master Tag File	2	WA	LINE	Line/Cell Identifier	String	Generic Edit	12	0
31	F4801Z1	Outbound Work Order Header	149	SY	LINE	Line/Cell Identifier	String	Generic Edit	12	0
TOPF31: Lean Transactions
32	FF31112	Routing Transaction Table	24	EH	LINE	Line/Cell Identifier	String	Generic Edit	12	0
33	FF31112S	Purge - Routing Transaction Table	24	ET	LINE	Line/Cell Identifier	String	Generic Edit	12	0
34	FF31113	Lean Transaction Labor Detail	32	LD	LINE	Line/Cell Identifier	String	Generic Edit	12	0
35	FF31113S	Purge - Lean Transaction Labor Detail	32	LR	LINE	Line/Cell Identifier	String	Generic Edit	12	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

35 columns | 910 | LINE