	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

94 columns | 920 | CRDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F0087	Conversion Constants File for Euro	7	EU	CRDC	Currency Code - To	String	Generic Edit	3	0
2	F09190	Inter/Intra Company Account Relationships	5	C9	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP04: Accounts Payable
3	F0411Z3	F0411 Interoperability Table	57	SZ	CRDC	Currency Code - To	String	Generic Edit	3	0
4	F0413Z1	F0413 Interoperability Table	28	SY	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP05: Time Accounting and HRM Base
5	F0618	Employee Transaction History	115	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP05T: Time Entry
6	F06116	Employee Transaction Detail File	166	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
7	F06116Z1	Employee Transactions - Batch File	179	VL	CRDC	Currency Code - To	String	Generic Edit	3	0
8	F06116Z2	ESS Timecard History	179	VM	CRDC	Currency Code - To	String	Generic Edit	3	0
9	F063951	Payroll Journal (Compressed) File	37	GL	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP06: Payroll (old) - Obsolete-do not reuse
10	F0618TA	Temp table for F0618T for conversion	10	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP07: Payroll
11	F05290	WF - Payroll Journal (Detail)	40	JR	CRDC	Currency Code - To	String	Generic Edit	3	0
12	F0716701	Employee Assignment T/E Template Information	88	EA	CRDC	Currency Code - To	String	Generic Edit	3	0
13	F0716709	Employee Assignment T/E Template Info History	88	EA	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP09: General Accounting
14	F0911Z4	F0911 Interoperability Table	123	SZ	CRDC	Currency Code - To	String	Generic Edit	3	0
15	F11151	Currency Cross Rates Calculation Master	2	CE	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP09E: Expense Reimbursment
16	F20112	Expense Report Detail	69	ED	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP11: Multi Currency
17	F0015	Currency Exchange Rates	2	CX	CRDC	Currency Code - To	String	Generic Edit	3	0
18	F0015Z1	External Currency Exchange Rates	24	ZE	CRDC	Currency Code - To	String	Generic Edit	3	0
19	F1113	Currency Restatement Rates File	2	C1	CRDC	Currency Code - To	String	Generic Edit	3	0
20	F1114	Company Conversions Parameter File	7	C2	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP17: Customer Service Management
21	F1775	Claim Temporary Table	35	TC	CRDC	Currency Code - To	String	Generic Edit	3	0
22	F3111Z2	Warranty Claim/Supplier Recovery processing	133	WP	CRDC	Currency Code - To	String	Generic Edit	3	0
23	F3112Z2	Warranty Claim/Supplier Recovery processing	150	WL	CRDC	Currency Code - To	String	Generic Edit	3	0
24	F31171	Parts List - Extension	40	WS	CRDC	Currency Code - To	String	Generic Edit	3	0
25	F31171S	Purge Parts List - Extension	40	WS	CRDC	Currency Code - To	String	Generic Edit	3	0
26	F31172	Routing Instructions - Extension	43	WS	CRDC	Currency Code - To	String	Generic Edit	3	0
27	F31172S	Purge Routing Instructions - Extension	43	WS	CRDC	Currency Code - To	String	Generic Edit	3	0
28	F4801TZ2	Warranty Claim/Supplier Recovery processing	104	WQ	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP17C: Call Management
29	F1755	Case Master	108	ZA	CRDC	Currency Code - To	String	Generic Edit	3	0
30	F1760	Time Entry	26	ZB	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP18: Timecard Automation
31	F186602	Labor Rules Tag File	172	TF	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP31P: Engineer To Order
32	F31P10	Project Quote Header	11	PQ	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP32: Configuration Management
33	F3201	Configurator Master Table	15	CM	CRDC	Currency Code - To	String	Generic Edit	3	0
34	F32019	Configurator Master History Table	15	CH	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP40: Inventory/OP Base
35	F4211AU	Sales Order Detail Audit File	12	AU	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP40S: Supply Chain Self Service
36	F4947SW	Self-Service Shipment Tracking Work File	19	SW	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP41F: Apparel Management
37	FCW38	Price List Exchange Rate	2	TR	CRDC	Currency Code - To	String	Generic Edit	3	0
38	FCW84	Exchange Rate for Outsource Operations	3	TR	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP42: Sales Management
39	F42565	Invoice Print File	87	IW	CRDC	Currency Code - To	String	Generic Edit	3	0
40	F42800G	Sales Update G Batch Workfile	29	SG	CRDC	Currency Code - To	String	Generic Edit	3	0
41	F42800G1	Sales Update G Batch Detail Workfile	53	DG	CRDC	Currency Code - To	String	Generic Edit	3	0
42	F42CSS	Customer Self Service Workfile	17	CS	CRDC	Currency Code - To	String	Generic Edit	3	0
43	F42UI01	SO Header Cache File (MBF)	104	ZH	CRDC	Currency Code - To	String	Generic Edit	3	0
44	F42UI520	Pick Slips Header File	28	S8	CRDC	Currency Code - To	String	Generic Edit	3	0
45	F42UI800	Sales Detail Work File - Sales Update	16	SD	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP43: Procurement
46	F4301SW	Purchase Order Summary Work Table	6	PS	CRDC	Currency Code - To	String	Generic Edit	3	0
47	F4301Z	PO Header Work File	88	PA	CRDC	Currency Code - To	String	Generic Edit	3	0
48	F4311T	Purchase Order Detail Tag File	11	PD	CRDC	Currency Code - To	String	Generic Edit	3	0
49	F43121T	Purchase Order Receiver Tag File	18	PR	CRDC	Currency Code - To	String	Generic Edit	3	0
50	F43121Z	Receiver workfile	92	PW	CRDC	Currency Code - To	String	Generic Edit	3	0
51	F4371	Suggested Reorder Stock Items	7	PD	CRDC	Currency Code - To	String	Generic Edit	3	0
52	F43UI50H	PO Print Header Work File	33	PA	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP43E: Requisition Self Service
53	F43E01	Requisition Order Header	6	RH	CRDC	Currency Code - To	String	Generic Edit	3	0
54	F43E20	Shopping Cart Detail	12	SC	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP43Q: Strategic Sourcing
55	F43Q10	Event Header	17	EH	CRDC	Currency Code - To	String	Generic Edit	3	0
56	F43Q40	Response Header	9	RA	CRDC	Currency Code - To	String	Generic Edit	3	0
57	F43Q50	Analyze Event Header	9	AV	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP46: Warehouse Management
58	F4942Z1	Work File for F4942	41	SY	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP48: Work Order Processing
59	F4801ST	Purge - Work Order Master Tag File	91	WA	CRDC	Currency Code - To	String	Generic Edit	3	0
60	F4801T	Work Order Master Tag File	91	WA	CRDC	Currency Code - To	String	Generic Edit	3	0
61	F4817	Service Order Extension	52	SR	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP48S: Service Billing
62	F48S0618	Payroll Reclassification Workfile	115	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP49: Transportation Management
63	F4941	Shipment Routing Steps	62	RS	CRDC	Currency Code - To	String	Generic Edit	3	0
64	F4945	Shipment Charges	17	SC	CRDC	Currency Code - To	String	Generic Edit	3	0
65	F4981	Freight Audit History	35	FH	CRDC	Currency Code - To	String	Generic Edit	3	0
66	F49T50	Order Release Location Staging	37	LO	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP51: Job Costing
67	F51006M	CM Currency Code Mapping	3	VM	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP74: EMEA Localization
68	F0018T	Intrastat Revision	42	TD	CRDC	Currency Code - To	String	Generic Edit	3	0
69	F740018D	Data extraction ESL - 74	33	DE	CRDC	Currency Code - To	String	Generic Edit	3	0
70	F740018W	Data extraction ESL - Workfile - 74	33	DE	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP74S: Spain
71	F74S70	Model 347 - Record Type 0 - Spain - 03B	18	Q0	CRDC	Currency Code - To	String	Generic Edit	3	0
72	F74S71	Model 347 - Record Type 1 - Spain - 03B	24	Q1	CRDC	Currency Code - To	String	Generic Edit	3	0
73	F74S72	Model 347 - Record Type 2 - Spain	18	Q2	CRDC	Currency Code - To	String	Generic Edit	3	0
74	F74S73	Model 347 - Record Type 3 - Spain	21	Q3	CRDC	Currency Code - To	String	Generic Edit	3	0
75	F74S90	Model 349 - Record Type 0 - Spain - 03B	24	Q0	CRDC	Currency Code - To	String	Generic Edit	3	0
76	F74S91	Model 349 - Record Type 1 - Spain - 03B	21	Q1	CRDC	Currency Code - To	String	Generic Edit	3	0
77	F74S92	Model 349 - Record Type 2 Spain - 03B	18	Q2	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP75C: China
78	F75C001	Chinese GUI cross reference file	14	CR	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP75I: India
79	F75I357	Consignment Header	24	CH	CRDC	Currency Code - To	String	Generic Edit	3	0
80	F75I3571	Consignment - Work Orders	25	CW	CRDC	Currency Code - To	String	Generic Edit	3	0
81	F75I3572	Consignment - Stock Transfers	28	CS	CRDC	Currency Code - To	String	Generic Edit	3	0
82	F75I3573	Consignment - Order Items	30	CO	CRDC	Currency Code - To	String	Generic Edit	3	0
83	F75I3574	Consignment - Issues/Receipts Transactions	39	CT	CRDC	Currency Code - To	String	Generic Edit	3	0
84	F75I3575	Consignment - Work Order Part List Items - Balances	22	CP	CRDC	Currency Code - To	String	Generic Edit	3	0
85	F75I3576	Stock Transfer - Work Orders	27	SW	CRDC	Currency Code - To	String	Generic Edit	3	0
86	F75I380	Excise - RG-1 - Transaction File - IND	50	RG	CRDC	Currency Code - To	String	Generic Edit	3	0
87	F75I3901	Work With Consignment - IND -43	43	CO	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP75T: Taiwan
88	F75T1113	Taiwan Exchange Rate Update	2	TR	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP89: Conversion Programs
89	F00151	Needed for upgrade for XE and below	2	T1	CRDC	Currency Code - To	String	Generic Edit	3	0
90	F05290T	Needed for upgrade from Xe to B9	4	JR	CRDC	Currency Code - To	String	Generic Edit	3	0
91	F06116T	Needed for upgrade from Xe to B9	8	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
92	F06116TZ	Needed for upgrade from Xe to B9	9	VL	CRDC	Currency Code - To	String	Generic Edit	3	0
93	F0618T	Needed for upgrade from Xe to B9	8	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
94	F063951T	Needed for upgrade from Xe to B9	4	GL	CRDC	Currency Code - To	String	Generic Edit	3	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

94 columns | 920 | CRDC