	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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

76 columns | 812 | CRDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP00: Foundation Environment
1	F00151	Currency Exchange Rates (F0015 Header)	2	T1	CRDC	Currency Code - To	String	Generic Edit	3	0
2	F0087	Conversion Constants File for Euro	7	EU	CRDC	Currency Code - To	String	Generic Edit	3	0
3	F09190	Inter/Intra Company Account Relationships	5	C9	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP04: Accounts Payable
4	F0411Z3	F0411 Interoperability Table	57	SZ	CRDC	Currency Code - To	String	Generic Edit	3	0
5	F0413Z1	F0413 Interoperability Table	28	SY	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP05: Time Accounting and HRM Base
6	F0618	Employee Transaction History	115	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP05T: Time Entry
7	F06116	Employee Transaction Detail File	166	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
8	F06116Z1	Employee Transactions - Batch File	179	VL	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	Customer Call 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: Resource Scheduling
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
TOP42: Sales Management
37	F42565	Invoice Print File	87	IW	CRDC	Currency Code - To	String	Generic Edit	3	0
38	F42800G	Sales Update G Batch Workfile	29	SG	CRDC	Currency Code - To	String	Generic Edit	3	0
39	F42800G1	Sales Update G Batch Detail Workfile	53	DG	CRDC	Currency Code - To	String	Generic Edit	3	0
40	F42CSS	Customer Self Service Workfile	17	CS	CRDC	Currency Code - To	String	Generic Edit	3	0
41	F42UI01	SO Header Cache File (MBF)	104	ZH	CRDC	Currency Code - To	String	Generic Edit	3	0
42	F42UI520	Pick Slips Header File	28	S8	CRDC	Currency Code - To	String	Generic Edit	3	0
43	F42UI800	Sales Detail Work File - Sales Update	16	SD	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP43: Procurement
44	F4301Z	PO Header Work File	88	PA	CRDC	Currency Code - To	String	Generic Edit	3	0
45	F4311T	Purchase Order Detail Tag File	11	PD	CRDC	Currency Code - To	String	Generic Edit	3	0
46	F43121T	Purchase Order Receiver Tag File	18	PR	CRDC	Currency Code - To	String	Generic Edit	3	0
47	F43121Z	Receiver workfile	92	PW	CRDC	Currency Code - To	String	Generic Edit	3	0
48	F4371	Suggested Reorder Stock Items	7	PD	CRDC	Currency Code - To	String	Generic Edit	3	0
49	F43UI50H	PO Print Header Work File	33	PA	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP43E: Requisition Self Service
50	F43E01	Requisition Order Header	6	RH	CRDC	Currency Code - To	String	Generic Edit	3	0
51	F43E20	Shopping Cart Detail	12	SC	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP43Q: Strategic Sourcing
52	F43Q10	Event Header	17	EH	CRDC	Currency Code - To	String	Generic Edit	3	0
53	F43Q40	Response Header	9	RA	CRDC	Currency Code - To	String	Generic Edit	3	0
54	F43Q50	Analyze Event Header	9	AV	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP46: Warehouse Management
55	F4942Z1	Work File for F4942	41	SY	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP48: Work Order Processing
56	F4801ST	Purge - Work Order Master Tag File	91	WA	CRDC	Currency Code - To	String	Generic Edit	3	0
57	F4801T	Work Order Master Tag File	91	WA	CRDC	Currency Code - To	String	Generic Edit	3	0
58	F4817	Service Order Extension	52	SR	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP48S: Service Billing
59	F48S0618	Payroll Reclassification Workfile	115	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP49: Transportation Management
60	F4941	Shipment Routing Steps	62	RS	CRDC	Currency Code - To	String	Generic Edit	3	0
61	F4945	Shipment Charges	17	SC	CRDC	Currency Code - To	String	Generic Edit	3	0
62	F4981	Freight Audit History	35	FH	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP74: EMEA Localization
63	F0018T	Intrastat Revision	42	TD	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP74S: Spain
64	F74S70	Model 347 - Record Type 0 - Spain	18	Q0	CRDC	Currency Code - To	String	Generic Edit	3	0
65	F74S71	Model 347 - Record Type 1 - Spain	24	Q1	CRDC	Currency Code - To	String	Generic Edit	3	0
66	F74S72	Model 347 - Record Type 2 - Spain	17	Q2	CRDC	Currency Code - To	String	Generic Edit	3	0
67	F74S73	Model 347 - Record Type 3 - Spain	21	Q3	CRDC	Currency Code - To	String	Generic Edit	3	0
68	F74S90	Model 349 - Record Type 0 - Spain	24	Q0	CRDC	Currency Code - To	String	Generic Edit	3	0
69	F74S91	Model 349 - Record Type 1 - Spain	21	Q1	CRDC	Currency Code - To	String	Generic Edit	3	0
70	F74S92	Model 349 - Record Type 2 Spain	18	Q2	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP75C: China - Reporting System Only
71	F75C001	Chinese GUI cross reference file	14	CR	CRDC	Currency Code - To	String	Generic Edit	3	0
TOP89: Conversion Programs
72	F05290T	Needed for upgrade from Xe to B9	4	JR	CRDC	Currency Code - To	String	Generic Edit	3	0
73	F06116T	Needed for upgrade from Xe to B9	8	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
74	F06116TZ	Needed for upgrade from Xe to B9	9	VL	CRDC	Currency Code - To	String	Generic Edit	3	0
75	F0618T	Needed for upgrade from Xe to B9	8	YT	CRDC	Currency Code - To	String	Generic Edit	3	0
76	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

76 columns | 812 | CRDC