	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

100 columns | 920 | OPSQ

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0911	Account Ledger	89	GL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP03: Accounts Receivable
2	F0311	Accounts Receivable Ledger	87	RP	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP04: Accounts Payable
3	F0411	Accounts Payable Ledger	67	RP	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
4	F0411A	WF - 'As Of' Accounts Payable Ledger	67	RP	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
5	F0411P	Purge - Accounts Payable Ledger	67	RP	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
6	F0411Z1	Voucher Transactions - Batch Upload	85	VL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
7	F0411Z3	F0411 Interoperability Table	90	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP05: Time Accounting and HRM Base
8	F0618	Employee Transaction History	23	YT	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP05T: Time Entry
9	F06116	Employee Transaction Detail File	23	YT	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
10	F06116Z1	Employee Transactions - Batch File	40	VL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
11	F06116Z2	ESS Timecard History	40	VM	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
12	F06278	Retro Timecard Detail File	26	YT	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP07: Payroll
13	F0716701	Employee Assignment T/E Template Information	18	EA	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
14	F0716709	Employee Assignment T/E Template Info History	18	EA	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
15	F07UI200	Timecard History Work File	26	TH	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP09: General Accounting
16	F0911P	Purge - Account Ledger	89	GL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
17	F0911Z1	Journal Entry Transactions - Batch File	106	VN	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
18	F0911Z4	F0911 Interoperability Table	111	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
19	F09UI015	Indexed Computations Multi-Tiered Entries	89	GL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP13: Plant/Equipment Management
20	F13017	Equipment Parts List	22	PL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP13R: Resource Assignments
21	F48311	Resource Assignments	5	RA	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
22	F48311S	Purge - Resource Assignments	5	RA	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
23	F48316	Maintenance Rescheduling Metrics	2	RS	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP17: Customer Service Management
24	F1775	Claim Temporary Table	29	TC	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
25	F3111Z2	Warranty Claim/Supplier Recovery processing	31	WP	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
26	F3112Z2	Warranty Claim/Supplier Recovery processing	26	WL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
27	F31172	Routing Instructions - Extension	2	WS	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
28	F31172S	Purge Routing Instructions - Extension	2	WS	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP17C: Call Management
29	F1760	Time Entry	4	ZB	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP18: Timecard Automation
30	F186602	Labor Rules Tag File	36	TF	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP30: Product Data Management
31	F300211	Lean Multi Level Bill of Material Detail	17	ED	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
32	F3002Z1	Bill of Material Transaction File	49	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
33	F300311	Lean Multi-Level Routing Detail File	8	EH	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
34	F3003T	Routing Tag File - not used in B9, obsolete in B10	5	IR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
35	F3003Z1	Routing Transactions File	23	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
36	F30UI015	BOM Item Fact Work File for BI	18	BD	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
37	F30UI016	BOM Explosion Work File for BI	16	BE	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP30A: Product Costing
38	F30UI012	Work File for Parent Child	8	PC	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP31: Shop Floor Control
39	F3102	Production Cost	3	IG	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
40	F3102S	Purge - Production Cost	3	IG	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
41	F3102WF	Production Cost Work File	3	IG	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
42	F31091	Schedule Quantity Detail	12	IQ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
43	F31091S	Schedule Quantity Detail Purge	12	IQ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
44	F3111	Work Order Parts List	18	WM	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
45	F3111S	Purge - Shop Floor Parts List	18	WM	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
46	F3111Z1	Outbound Work Order Parts List	31	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
47	F3112	Work Order Routing	13	WL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
48	F31122	Work Order Time Transactions	11	WT	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
49	F31122S	Purge Work Order Time Transactions	11	WT	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
50	F31122Z1	Work Order Time Transactions Unedited Transaction Table	24	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
51	F3112S	Purge Shop Floor Control Routing Instructions	13	WL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
52	F3112ST	Purge Shop Floor Control Routing Instructions Tag Table	2	WL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
53	F3112T	Shop Floor Control Routing Instructions Tag Table - Needed f	2	WL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
54	F3112Z1	Outbound Work Order Routings	26	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
55	F3112Z1T	Outbound Work Order Routings Tag Table - Needed for upgrade	5	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP32: Configuration Management
56	F3212	Configurator Routings File	8	RC	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
57	F3215	Configurator Component Table	28	CC	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
58	F32159	Configurator Component History Table	27	CH	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
59	F3293	Assembly Inclusions Rules	20	KY	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP33: Capacity Planning
60	F33UI001	Shop Floor Control Routing Instructions	8	WL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP34A: Advanced Planning & Scheduling
61	F34A120	Routing Master Resource Table	5	N0	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
62	F34A150	Work Order Routing Resource Table	3	RR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
63	F34A180	Routing Master Resource Set	5	RR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
64	F34A190	Routing Master Resource and Set XRef	5	RD	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
65	F34A90	Last Outbound Phantom Information	5	PI	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP34X: In-Memory Planning Advisor
66	F34X310W	Planning Advisor BOM Component Detail Table	27	PD	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP37: Quality Management
67	F3711	Test Results	61	TR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
68	F3711Z1	Test Results Unedited Transaction Table	74	SZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
69	F37900	Certificate of Analysis (COA) Extract	61	TR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
70	F40318	Preference Profile - Quality Management	45	QC	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP40: Inventory/OP Base
71	F3002	Bill of Material Master File	36	IX	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
72	F30026	Item Cost Component Add-Ons	28	IE	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
73	F3003	Routing Master File	10	IR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
74	F3011	Bill of Materials Change File	36	IZ	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
75	F3013	ECO Parts List Detail	15	CY	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
76	F30UI004	Bill of Material Update Work File	34	WF	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
77	F40318R	Preference Resolution Ledger - Quality Management	47	QC	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP41: Inventory Management
78	F4111	Item Ledger File	63	IL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP41F: Apparel Management
79	FCW67	Style Work Order Parts List	24	WM	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
80	FCW68	Style Work Order Routings	14	WL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
81	FCW85	Item Cost Component Add Ons Work File	29	IE	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP42: Sales Management
82	F42800G1	Sales Update G Batch Detail Workfile	82	DG	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP47: Electronic Commerce
83	F47057	EDI Payment Order Remittance Advice - Outbound	53	D3	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
84	F47057W	EDI Payment Order Remittance Advice - Work	53	D3	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP48S: Service Billing
85	F4812	Billing Detail Workfile	13	WD	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
86	F4812H	Billing Workfile History	13	WD	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
87	F4812HS	Billing Workfile History Purged Save	13	WD	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
88	F48S0618	Payroll Reclassification Workfile	23	YT	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
89	F48SUI01	Billing Detail Print Workfile	13	WD	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP76B: Brazil
90	F76B3010	Work Table for Item/Part List - 30	16	IP	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOP89: Conversion Programs
91	F31172TE	F31172 temp table for TC merge	2	WS	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
92	F3296T	Needed for upgrade from Xe and below	6	KA	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOPF30L: DFM Line Design
93	FF30L002	DFM Bill of Material Master	30	DH	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
94	FF30L930	DFM Routings	9	LR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
TOPF31: Lean Transactions
95	FF31111	Lean Transaction Parts List	22	PL	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
96	FF31111S	Purge - Lean Transaction Parts List	22	PR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
97	FF31112	Routing Transaction Table	53	EH	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
98	FF31112S	Purge - Routing Transaction Table	53	ET	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
99	FF31113	Lean Transaction Labor Detail	14	LD	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2
100	FF31113S	Purge - Lean Transaction Labor Detail	14	LR	OPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	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

100 columns | 920 | OPSQ