	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

31 columns | 920 | CPNB

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP13: Plant/Equipment Management
1	F13017	Equipment Parts List	9	PL	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP17: Customer Service Management
2	F3111Z2	Warranty Claim/Supplier Recovery processing	100	WP	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP30: Product Data Management
3	F300211	Lean Multi Level Bill of Material Detail	90	ED	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
4	F3002Z1	Bill of Material Transaction File	91	SZ	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
5	F30UI015	BOM Item Fact Work File for BI	17	BD	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP30A: Product Costing
6	F30UI012	Work File for Parent Child	9	PC	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP31: Shop Floor Control
7	F3111	Work Order Parts List	86	WM	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
8	F3111S	Purge - Shop Floor Parts List	86	WM	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
9	F3111Z1	Outbound Work Order Parts List	100	SZ	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP34X: In-Memory Planning Advisor
10	F34X310W	Planning Advisor BOM Component Detail Table	14	PD	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP40: Inventory/OP Base
11	F3002	Bill of Material Master File	78	IX	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
12	F3011	Bill of Materials Change File	78	IZ	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
13	F3013	ECO Parts List Detail	54	CY	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
14	F3015	Component Locator File	13	CQ	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
15	F30UI002	Bill of Material Structure Analysis Work File	14	IX	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
16	F30UI004	Bill of Material Update Work File	70	WF	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP41F: Apparel Management
17	FCW49	Bill of Material Association Detail	15	BD	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
18	FCW50	Bill of Material Association Matrix	43	BX	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
19	FCW51	BOM Usage	13	BU	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
20	FCW86	BOM Quantity Work File	10	WF	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP46: Warehouse Management
21	F4600	Warehouse Requests	71	R1	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
22	F4600PU	Warehouse Requests - Purged	91	R1	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
23	F4611	Warehouse Suggestions	36	R2	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
24	F4611PU	Warehouse Suggestions - Purged	154	R2	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
25	F4611Z1	Unedited Suggestion Table	162	SZ	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOP76B: Brazil
26	F76B3010	Work Table for Item/Part List - 30	18	IP	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOPF30L: DFM Line Design
27	FF30L002	DFM Bill of Material Master	59	DH	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
28	FF30L116	Components Consumed	5	CC	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
TOPF31: Lean Transactions
29	FF31111	Lean Transaction Parts List	10	PL	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
30	FF311114	Related Purchase Orders for Lean Pay on Consumption Issues	7	PC	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2
31	FF31111S	Purge - Lean Transaction Parts List	10	PR	CPNB	Component Line Number BOM	Numeric	Generic Edit	8	2

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

31 columns | 920 | CPNB