	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

24 columns | 920 | DATE01

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP05: Time Accounting and HRM Base
1	F05005	Generic UBE File	15	GF	DATE01	Date 01	Date	Generic Edit	6	0
2	F086011	Establishment Information	15	CO	DATE01	Date 01	Date	Generic Edit	6	0
TOP07: Payroll
3	F078507	ADP Employee Additional Information	2	YE	DATE01	Date 01	Date	Generic Edit	6	0
TOP08B: Benefits Administration
4	F08320D	Plan Master Tag Table	19	PD	DATE01	Date 01	Date	Generic Edit	6	0
TOP08H: Health and Safety
5	F08601C	Additional Health and Safety Information	17	PI	DATE01	Date 01	Date	Generic Edit	6	0
TOP08U: PeopleSoft HR US
6	F08994	COBRA Payment History	13	H1	DATE01	Date 01	Date	Generic Edit	6	0
TOP34A: Advanced Planning & Scheduling
7	F34A10	APS Integration Constants	9	N0	DATE01	Date 01	Date	Generic Edit	6	0
TOP41F: Apparel Management
8	FCW43	Proposal Processing Details	24	MO	DATE01	Date 01	Date	Generic Edit	6	0
TOP74H: Hungary
9	F74H1002	VAT Table Build Header - HUN - 04	3	VB	DATE01	Date 01	Date	Generic Edit	6	0
10	F74H1003	VAT Final Declaration Header - HUN - 04	3	VB	DATE01	Date 01	Date	Generic Edit	6	0
TOP74U: United Kingdom Localizations
11	F74U4321	Requisition Template Answers - UK - 43	18	RA	DATE01	Date 01	Date	Generic Edit	6	0
TOP75C: China
12	F75C008	Employee Record Information - China	7	EM	DATE01	Date 01	Date	Generic Edit	6	0
TOP75I: India
13	F75I344C	ARE-1 Bond Register for Cancelled Receipts-IND-00	21	CD	DATE01	Date 01	Date	Generic Edit	6	0
14	F75I406	State / Branch Plant Cross Reference	14	SB	DATE01	Date 01	Date	Generic Edit	6	0
15	F75I407	Item Category Relationship	11	IC	DATE01	Date 01	Date	Generic Edit	6	0
TOP76A: Argentina
16	F76A8500	Tag File F03B14 - ARG - 03B - 76A	35	TF	DATE01	Date 01	Date	Generic Edit	6	0
17	F76A8510	Tag File F76A60 - ARG - 03B - 76A	10	TF	DATE01	Date 01	Date	Generic Edit	6	0
18	F76A85Z1	Tag File F76A60 Batch Entry - ARG - 03B - 76A	15	BE	DATE01	Date 01	Date	Generic Edit	6	0
TOP89: Conversion Programs
19	F75I101A	TDS Ceritificate Master Tabel Extension	22	QB	DATE01	Date 01	Date	Generic Edit	6	0
TOPH91: Design Tools
20	F00085A	Daylight Savings Rules	23	DS	DATE01	Date 01	Date	Generic Edit	6	0
TOPH92: Interactive Engine/OL
21	F98231H	OMW Transfer Activity Rule Director - Header	14	TR	DATE01	Date 01	Date	Generic Edit	6	0
TOPH96P: Product Packaging Tools
22	F96413	OMW - SU Dependency Tool	2	DT	DATE01	Date 01	Date	Generic Edit	6	0
TOPH96U: Upgrade
23	F96710	Impact Analysis Results	20	RA	DATE01	Date 01	Date	Generic Edit	6	0
TOPH98: Internet
24	F986113	Subsystem Job Master	24	SS	DATE01	Date 01	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

24 columns | 920 | DATE01