	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

34 columns | 910 | DTE

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F06149	Fiscal and Anniversary Rollover Work File	3	Y7	DTE	Date	Date	Generic Edit	6	0
TOP07: Payroll
2	F06147	Fiscal and Anniversary Year History	3	YD	DTE	Date	Date	Generic Edit	6	0
3	F073911	Leave Rollover Balance Report Work File	4	Y8	DTE	Date	Date	Generic Edit	6	0
4	F074001	New Hire Reporting Workfile - OneWorld Only	110	NH	DTE	Date	Date	Generic Edit	6	0
TOP09: General Accounting
5	F0911R1	Account Reconciliations Header - OneWorld ONLY	5	GL	DTE	Date	Date	Generic Edit	6	0
TOP12: Fixed Assets
6	F1205	Equipment Messages	4	FT	DTE	Date	Date	Generic Edit	6	0
7	F1205P	Equipment Messages Purge Table	4	FT	DTE	Date	Date	Generic Edit	6	0
TOP15: Property Management
8	F151991	G/L Transaction A/R Application Work File	15	NB	DTE	Date	Date	Generic Edit	6	0
TOP31B: Blend Management
9	F31B03	Barrel Master Table	91	BM	DTE	Date	Date	Generic Edit	6	0
TOP34: Requirements Planning
10	F43213	SRS Ship Dates	5	VP	DTE	Date	Date	Generic Edit	6	0
TOP39: Advanced Stock Valuation
11	F39120W	Period Detail Work File	21	TW	DTE	Date	Date	Generic Edit	6	0
TOP40: Inventory/OP Base
12	F41508	Default Tank Information	2	PC	DTE	Date	Date	Generic Edit	6	0
TOP41B: Bulk Stock Management
13	F41503	Tank Strapping Table Maintenance	12	PB	DTE	Date	Date	Generic Edit	6	0
14	F41511	Bulk Product Transaction File	67	PA	DTE	Date	Date	Generic Edit	6	0
TOP42: Sales Management
15	F42UI01	SO Header Cache File (MBF)	99	ZH	DTE	Date	Date	Generic Edit	6	0
TOP46: Warehouse Management
16	F4600PU	Warehouse Requests - Purged	86	R1	DTE	Date	Date	Generic Edit	6	0
17	F4601PU	Warehouse Task Header - Purged	18	TH	DTE	Date	Date	Generic Edit	6	0
18	F4611PU	Warehouse Suggestions - Purged	149	R2	DTE	Date	Date	Generic Edit	6	0
19	F46130PU	Putaway Reservations - Purged	88	R3	DTE	Date	Date	Generic Edit	6	0
20	F46200PU	Bulk Pick Requests - Purged	35	BR	DTE	Date	Date	Generic Edit	6	0
TOP49: Transportation Management
21	F49631	Load In-transit Ledger	63	TO	DTE	Date	Date	Generic Edit	6	0
TOP75C: China - Reporting System Only
22	F0018CN	China - Transmitted vouchers to JinSui - 04	6	CT	DTE	Date	Date	Generic Edit	6	0
TOP75I: India
23	F75I017	Sales Order Tag File IND 42	29	SO	DTE	Date	Date	Generic Edit	6	0
24	F75I119T	Challan number wise amount	5	CN	DTE	Date	Date	Generic Edit	6	0
25	F75I2213	Setoff Temp Table	19	TT	DTE	Date	Date	Generic Edit	6	0
26	F75I3051	Excise Fiscal Years	17	FY	DTE	Date	Date	Generic Edit	6	0
27	F75I319Y	Excise - Consolidated Excise Duty Payment	3	Q1	DTE	Date	Date	Generic Edit	6	0
28	F75I324	Work File for ARE1 ARE3 IND 42	24	Q3	DTE	Date	Date	Generic Edit	6	0
29	F75I354	Excise ARE3 Tag file for Form Header IND 42	29	QW	DTE	Date	Date	Generic Edit	6	0
TOP89: Conversion Programs
30	F4600TPU	OBSOLETE - Warehouse Requests Tag File - Purged	8	R1	DTE	Date	Date	Generic Edit	6	0
31	F4611TPU	OBSOLETE - Warehouse Suggestions Tag File - Purged	8	R2	DTE	Date	Date	Generic Edit	6	0
TOPH95: Tech Resources/Applications
32	F82199	World Writer Query Conversion Log	11	FU	DTE	Date	Date	Generic Edit	6	0
33	F8399	FASTR Conversion Log	10	FU	DTE	Date	Date	Generic Edit	6	0
34	F93081	Unicode Flat File Encoding Configuration	13	UF	DTE	Date	Date	Generic Edit	6	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

34 columns | 910 | DTE