	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

71 columns | 920 | ASID

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	52	GL	ASID	Serial Number	String	Generic Edit	25	0
TOP03B: Enhanced Accounts Receivable
2	F03B117	Revenue Recognition GL Info	57	RL	ASID	Serial Number	String	Generic Edit	25	0
3	F03B119	Revenue Recognition GL Info Audit	55	RN	ASID	Serial Number	String	Generic Edit	25	0
TOP05T: Time Entry
4	F063951	Payroll Journal (Compressed) File	14	GL	ASID	Serial Number	String	Generic Edit	25	0
TOP07: Payroll
5	F05290	WF - Payroll Journal (Detail)	14	JR	ASID	Serial Number	String	Generic Edit	25	0
TOP09: General Accounting
6	F0911P	Purge - Account Ledger	52	GL	ASID	Serial Number	String	Generic Edit	25	0
7	F0911R	WF - Account Ledger Reconciliation	42	GL	ASID	Serial Number	String	Generic Edit	25	0
8	F0911Z1	Journal Entry Transactions - Batch File	69	VN	ASID	Serial Number	String	Generic Edit	25	0
9	F0911Z4	F0911 Interoperability Table	74	SZ	ASID	Serial Number	String	Generic Edit	25	0
10	F0912	Cost Allocations/Flex Budgeting	26	RJ	ASID	Serial Number	String	Generic Edit	25	0
11	F0912A	Index Computation Entry File	22	RI	ASID	Serial Number	String	Generic Edit	25	0
12	F09UI015	Indexed Computations Multi-Tiered Entries	52	GL	ASID	Serial Number	String	Generic Edit	25	0
TOP12: Fixed Assets
13	F1201	Asset Master File	5	FA	ASID	Serial Number	String	Generic Edit	25	0
14	F1201P	Asset Master Purge Table	5	FA	ASID	Serial Number	String	Generic Edit	25	0
15	F1201Z1	Unedited Asset Master Transactions	18	FA	ASID	Serial Number	String	Generic Edit	25	0
16	F12911ER	Post G/L to FA Exceptions Work File	11	GL	ASID	Serial Number	String	Generic Edit	25	0
TOP13: Plant/Equipment Management
17	F1207	Maintenance Schedule File	3	FW	ASID	Serial Number	String	Generic Edit	25	0
18	F12071	Equipment PM Schedule (Model)	60	FZ	ASID	Serial Number	String	Generic Edit	25	0
19	F1207P	Maintenance Schedule Purge Table	3	FW	ASID	Serial Number	String	Generic Edit	25	0
20	F12120Z1	Unedited Meter Reading Transactions	17	SZ	ASID	Serial Number	String	Generic Edit	25	0
21	F1306	Meter Reading Estimates	3	F5	ASID	Serial Number	String	Generic Edit	25	0
22	F1306P	Meter Reading Estimates Purge Table	3	F5	ASID	Serial Number	String	Generic Edit	25	0
23	F1393	Maintenance Rules	14	GO	ASID	Serial Number	String	Generic Edit	25	0
TOP13C: Condition-Base Maintenance
24	F1310	Condition-Based Alerts	4	CA	ASID	Serial Number	String	Generic Edit	25	0
25	F1310Z1	Unedited Condition-Based Alerts	17	CB	ASID	Serial Number	String	Generic Edit	25	0
TOP13E: Equipment Cost Analysis
26	F1382	Equipment Analysis Listing	7	EL	ASID	Serial Number	String	Generic Edit	25	0
27	F1383	Equipment Analysis Costs	12	EC	ASID	Serial Number	String	Generic Edit	25	0
TOP17: Customer Service Management
28	F4801TZ2	Warranty Claim/Supplier Recovery processing	26	WQ	ASID	Serial Number	String	Generic Edit	25	0
TOP40R: Demand Scheduling
29	F47UI002	ASN Extract Packaging Work File	46	SP	ASID	Serial Number	String	Generic Edit	25	0
TOP41: Inventory Management
30	F4111	Item Ledger File	50	IL	ASID	Serial Number	String	Generic Edit	25	0
TOP42: Sales Management
31	F42800G1	Sales Update G Batch Detail Workfile	26	DG	ASID	Serial Number	String	Generic Edit	25	0
TOP43: Procurement
32	F43080	Approvals Fields Constants	132	PD	ASID	Serial Number	String	Generic Edit	25	0
33	F4311	Purchase Order Detail File	132	PD	ASID	Serial Number	String	Generic Edit	25	0
34	F4311Z	Purchase Order Generator File	136	PW	ASID	Serial Number	String	Generic Edit	25	0
35	F4311Z1	Purchase Order Detail Unedited Transaction Table	145	SZ	ASID	Serial Number	String	Generic Edit	25	0
36	F43121	Purchase Order Receiver File	52	PR	ASID	Serial Number	String	Generic Edit	25	0
37	F43121Z	Receiver workfile	42	PW	ASID	Serial Number	String	Generic Edit	25	0
38	F43121Z1	Receipts Unedited Transaction Table	69	SZ	ASID	Serial Number	String	Generic Edit	25	0
39	F4314Z	Voucher Match Selection File	152	PN	ASID	Serial Number	String	Generic Edit	25	0
40	F43199	P.O. Detail Ledger File - Flexible Version	132	OL	ASID	Serial Number	String	Generic Edit	25	0
TOP43Q: Strategic Sourcing
41	F43Q11	Event Detail	19	ED	ASID	Serial Number	String	Generic Edit	25	0
TOP44H: Homebuilder Management
42	F44H73W1	Lot Start - P.O. / Committment Generation Work File	39	CG	ASID	Serial Number	String	Generic Edit	25	0
TOP46: Warehouse Management
43	F4620	Carton Detail Information	55	CD	ASID	Serial Number	String	Generic Edit	25	0
TOP47: Electronic Commerce
44	F47017	EDI Purchase Order Detail - Outbound	146	SZ	ASID	Serial Number	String	Generic Edit	25	0
45	F47022	EDI P.O. Acknowledgment Detail - Inbound	146	SZ	ASID	Serial Number	String	Generic Edit	25	0
46	F47032	EDI Shipping Notice Detail - Inbound	103	SZ	ASID	Serial Number	String	Generic Edit	25	0
47	F470375	EDI ASN Packaging Detail	36	AK	ASID	Serial Number	String	Generic Edit	25	0
48	F47072	EDI Receiving Advice Detail - Inbound	147	SZ	ASID	Serial Number	String	Generic Edit	25	0
49	F47077	EDI Receiving Advice Detail - Outbound	147	SZ	ASID	Serial Number	String	Generic Edit	25	0
50	F47097	EDI Request for Quote Detail - Outbound	146	SZ	ASID	Serial Number	String	Generic Edit	25	0
51	F47102	EDI Response to RFQ Detail - Inbound	146	SZ	ASID	Serial Number	String	Generic Edit	25	0
52	F47137	EDI Purchase Order Change Detail - Outbound	147	SZ	ASID	Serial Number	String	Generic Edit	25	0
53	F47142	EDI P.O. Change Acknowledgment Detail - Inbound	148	SZ	ASID	Serial Number	String	Generic Edit	25	0
54	F47157	EDI Shipping Schedule Detail - Outbound	155	SZ	ASID	Serial Number	String	Generic Edit	25	0
TOP48: Work Order Processing
55	F4801ST	Purge - Work Order Master Tag File	13	WA	ASID	Serial Number	String	Generic Edit	25	0
56	F4801T	Work Order Master Tag File	13	WA	ASID	Serial Number	String	Generic Edit	25	0
57	F4801Z1	Outbound Work Order Header	160	SY	ASID	Serial Number	String	Generic Edit	25	0
TOP48S: Service Billing
58	F48S910	Billing Detail Journal Workfile	29	W2	ASID	Serial Number	String	Generic Edit	25	0
TOP75C: China
59	F75C201	Modification Methods Information - CHINA	3	MM	ASID	Serial Number	String	Generic Edit	25	0
TOP75I: India
60	F75I357	Consignment Header	19	CH	ASID	Serial Number	String	Generic Edit	25	0
61	F75I3571	Consignment - Work Orders	20	CW	ASID	Serial Number	String	Generic Edit	25	0
62	F75I3572	Consignment - Stock Transfers	23	CS	ASID	Serial Number	String	Generic Edit	25	0
63	F75I3573	Consignment - Order Items	25	CO	ASID	Serial Number	String	Generic Edit	25	0
64	F75I3574	Consignment - Issues/Receipts Transactions	34	CT	ASID	Serial Number	String	Generic Edit	25	0
65	F75I3575	Consignment - Work Order Part List Items - Balances	17	CP	ASID	Serial Number	String	Generic Edit	25	0
66	F75I3576	Stock Transfer - Work Orders	22	SW	ASID	Serial Number	String	Generic Edit	25	0
67	F75I380	Excise - RG-1 - Transaction File - IND	41	RG	ASID	Serial Number	String	Generic Edit	25	0
68	F75I3901	Work With Consignment - IND -43	38	CO	ASID	Serial Number	String	Generic Edit	25	0
69	F75I402	Purchase Tax Form Details	32	PT	ASID	Serial Number	String	Generic Edit	25	0
70	F75I402T	Purchase Tax Form Details -Secondary	32	PT	ASID	Serial Number	String	Generic Edit	25	0
TOP89: Conversion Programs
71	F43199A	Temp F43199 for ERP 9.0 Upgrade	132	OL	ASID	Serial Number	String	Generic Edit	25	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

71 columns | 920 | ASID