	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

22 columns | 812 | DETP

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP38: Agreement Management
1	F38111	Agreements Transaction Ledger	39	DZ	DETP	Density Temperature	Numeric	Generic Edit	7	2
TOP40: Inventory/OP Base
2	F41011	Bulk Item Master	12	PK	DETP	Density Temperature	Numeric	Generic Edit	7	2
3	F41508	Default Tank Information	10	PC	DETP	Density Temperature	Numeric	Generic Edit	7	2
4	F49211	Sales Order Detail File - Tag File	29	UD	DETP	Density Temperature	Numeric	Generic Edit	7	2
5	F49211Z1	Sales Order Detail Tag Unedited Transaction File	42	S1	DETP	Density Temperature	Numeric	Generic Edit	7	2
6	F49219	Sales Order Detail - Tag History File	29	UD	DETP	Density Temperature	Numeric	Generic Edit	7	2
TOP41: Inventory Management
7	F4101B	Item Master Bulk Data	19	IM	DETP	Density Temperature	Numeric	Generic Edit	7	2
8	F4101Z1A	F4101 Detail Item Master Unedited Transaction	50	SZ	DETP	Density Temperature	Numeric	Generic Edit	7	2
TOP41B: Bulk Stock Management
9	F415091	Four-Point Temperature Maintenance	10	PG	DETP	Density Temperature	Numeric	Generic Edit	7	2
10	F41511	Bulk Product Transaction File	22	PA	DETP	Density Temperature	Numeric	Generic Edit	7	2
11	F41515	Multi-Meter Readings	35	PQ	DETP	Density Temperature	Numeric	Generic Edit	7	2
TOP42: Sales Management
12	F42565	Invoice Print File	96	IW	DETP	Density Temperature	Numeric	Generic Edit	7	2
TOP42B: Sales Order Entry
13	F49299	S.O. Detail Tag Ledger File	29	UD	DETP	Density Temperature	Numeric	Generic Edit	7	2
TOP43: Procurement
14	F43121Z	Receiver workfile	114	PW	DETP	Density Temperature	Numeric	Generic Edit	7	2
15	F43121Z1	Receipts Unedited Transaction Table	134	SZ	DETP	Density Temperature	Numeric	Generic Edit	7	2
TOP49: Transportation Management
16	F49110	Transportation Bill of Lading Workfile	49	BW	DETP	Density Temperature	Numeric	Generic Edit	7	2
17	F4963	Load In-transit	21	TI	DETP	Density Temperature	Numeric	Generic Edit	7	2
18	F49631	Load In-transit Ledger	47	TO	DETP	Density Temperature	Numeric	Generic Edit	7	2
19	F49632	Load In-transit Left on Board	29	LB	DETP	Density Temperature	Numeric	Generic Edit	7	2
TOP76A: Argentina
20	F76A0219	Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A	35	DL	DETP	Density Temperature	Numeric	Generic Edit	7	2
21	F76A021P	Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A	35	DL	DETP	Density Temperature	Numeric	Generic Edit	7	2
22	F76AUI21	Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00	35	DL	DETP	Density Temperature	Numeric	Generic Edit	7	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

22 columns | 812 | DETP