	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

105 tables920 | 89

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
89: Conversion Programs
1	920	F00151	T1	6	1	Needed for upgrade for XE and below	Extra Features Files	11: Multi Currency	Business Data
2	920	F0086	AU	36	2	Conversion Audit File for Euro Conversion	History Files	03B: Enhanced Accounts Receivable	Business Data
3	920	F01111	WN	26	1	Contact Information	Secondary Master Files	89: Conversion Programs	Business Data
4	920	F01111Z1	CB	64	1	Batch - Contact Information	Batch Input Files	01: Address Book	Business Data
5	920	F05290T	JR	5	1	Needed for upgrade from Xe to B9	Transaction Files	05: Time Accounting and HRM Base	Business Data
6	920	F06116T	YT	11	1	Needed for upgrade from Xe to B9	Transaction Files	06: Payroll (old) - Obsolete-do not reuse	Business Data
7	920	F06116TZ	VL	12	1	Needed for upgrade from Xe to B9	Transaction Files	06: Payroll (old) - Obsolete-do not reuse	Business Data
8	920	F0618T	YT	11	1	Needed for upgrade from Xe to B9	Transaction Files	06: Payroll (old) - Obsolete-do not reuse	Business Data
9	920	F063951T	GL	5	1	Needed for upgrade from Xe to B9	Transaction Files	06: Payroll (old) - Obsolete-do not reuse	Business Data
10	920	F07186T	Y8	19	1	Piece Rate History File	Files	89: Conversion Programs	Business Data
11	920	F07352T	Y2	20	1	Piece Rate Stub Detail Tag File	Files	89: Conversion Programs	Business Data
12	920	F0901T	GM	6	1	Needed for upgrade for XE and below	Master Files	09: General Accounting	Business Data
13	920	F0902A	GD	28	1	Account Debit Balances	Files	89: Conversion Programs
14	920	F0911T	GL	26	1	Needed for upgrade for XE and below	Transaction Files	09: General Accounting	Business Data
15	920	F0911Z1T	VN	23	1	Needed for upgrade for XE and below	Batch Input Files	09: General Accounting	Business Data
16	920	F0917S	GD	5	1	Needed for upgrade for XE and below	Extra Features Files	09: General Accounting	Business Data
17	920	F186407D	OB	19	1	Labor Rules tag file one	Files	89: Conversion Programs	Business Data
18	920	F186407T	OB	8	1	Labor Rules tage file two	Files	89: Conversion Programs	Business Data
19	920	F31172TE	WS	7	1	F31172 temp table for TC merge	Files	89: Conversion Programs
20	920	F31B35T	OM	7	1	Owner Master Tag Table	Files	89: Conversion Programs	Business Data
21	920	F3214	MT	6	2	Needed for upgrade from Xe and below	Transaction Files	32: Configuration Management	Business Data
22	920	F3294	KZ	22	5	Needed for upgrade from Xe and below	Transaction Files	32: Configuration Management	Business Data
23	920	F32941	SM	10	1	Needed for upgrade from Xe and below	Secondary Master Files	32: Configuration Management	Business Data
24	920	F32942	SG	13	3	Needed for upgrade from Xe and below	Secondary Master Files	32: Configuration Management	Business Data
25	920	F32943	KO	23	5	Needed for upgrade from Xe and below	Transaction Files	32: Configuration Management	Business Data
26	920	F32944	KT	11	2	Needed for upgrade from Xe and below	Secondary Master Files	32: Configuration Management	Business Data
27	920	F32945	SI	14	4	Needed for upgrade from Xe and below	Secondary Master Files	32: Configuration Management	Business Data
28	920	F3294Z	AZ	19	1	Needed for upgrade from Xe and below	PC Download/Batch Edit Files	32: Configuration Management	Business Data
29	920	F3296	KR	21	1	Needed for upgrade from Xe and below	Transaction Files	32: Configuration Management	Business Data
30	920	F32961	KL	12	1	Needed for upgrade from Xe and below	Transaction Files	32: Configuration Management	Business Data
31	920	F329611	KB	15	1	Needed for upgrade from Xe and below	Transaction Files	32: Configuration Management	Business Data
32	920	F3296T	KA	13	1	Needed for upgrade from Xe and below	Transaction Files	32: Configuration Management	Business Data
33	920	F32UI002	WY	5	1	Needed for upgrade from Xe and below	"T" Work Files	32: Configuration Management	Business Data
34	920	F4009T	CP	6	1	OBSOLETE - Distribution Manufacturing Constants Tag File	Constants Files	89: Conversion Programs	Business Data
35	920	F40242	CS	2	1	Secondary Commodity Code	Files	43B: Voucher Match and Landed Cost
36	920	F40344A	SA	29	1	Temporay Preference Profile - Sales Commission	Extra Features Files	89: Conversion Programs	Business Data
37	920	F4072TEM	AD	35	1	Price Adjustment Detail - Temp for Upgrade	Work Files	45: Advanced Pricing
38	920	F4074TEM	AL	11	1	Price Adjustment Ledger File - Temp for Upgrade	Work Files	45: Advanced Pricing
39	920	F41001T	CI	6	1	OBSOLETE - Inventory Constants Tag File	Secondary Master Files	89: Conversion Programs	Business Data
40	920	F4100T	LM	3	1	OBSOLETE - Location Master Tag File	Secondary Master Files	89: Conversion Programs	Business Data
41	920	F4101SRM	IM	2	1	Item Master SRM Tag File	Files	41: Inventory Management
42	920	F4101T	IM	35	3	OBSOLETE - Item Master Tag File	Secondary Master Files	41: Inventory Management	Business Data
43	920	F4101TT	IX	29	1	Temp Table Merge Xe F4101T to E9 F4101	Files	41: Inventory Management
44	920	F4102SRM	IB	3	1	Item Branch SRM Tag File	Files	41: Inventory Management
45	920	F4102TT	IY	4	1	Temp Table Merge Xe F4101T to E9 F4102	Files	41: Inventory Management
46	920	F42005A	SC	52	1	Sales Commission File - Temporary	Files	42: Sales Management
47	920	F42119A	SD	5	1	Sales Order History File - temporary for upgrade (1)	Files	42B: Sales Order Entry
48	920	F42119B	SD	23	1	Sales Order History File - temporary for upgrade (2)	Files	42B: Sales Order Entry
49	920	F4211A	SD	5	1	Sales Order Detail File - temporary for upgrade (1)	Files	42B: Sales Order Entry
50	920	F4211B	SD	23	1	Sales Order Detail File - temporary for upgrade (2)	Files	42B: Sales Order Entry
51	920	F42140A	CM	6	1	Copy from F42140 to Temp Table F42140A	Files	42: Sales Management
52	920	F42150A	SH	7	1	ERP9.0 Update F42150 (Temp File)	Files	89: Conversion Programs
53	920	F4215T	XT	18	2	OBSOLETE - Shipment Header Tag File	Transaction Files	49: Transportation Management	Business Data
54	920	F42199A	SL	7	1	S.O. Detail Ledger File - temporary for upgrade	Work Files	42B: Sales Order Entry
55	920	F4311TA	PD	7	1	Temp table for ERP 9.0 upgrade	Files	89: Conversion Programs
56	920	F43121TA	PR	9	1	ERP 9.0 temp F43121T for upgrade	Files	43: Procurement
57	920	F43199A	OL	188	1	Temp F43199 for ERP 9.0 Upgrade	History Files	43: Procurement
58	920	F4600T	R1	7	3	OBSOLETE - Warehouse Requests Tag File	Transaction Files	46: Warehouse Management	Business Data
59	920	F4600TPU	R1	10	1	OBSOLETE - Warehouse Requests Tag File - Purged	Purge Files	46: Warehouse Management	Business Data
60	920	F46011T	IQ	10	1	OBSOLETE - Item Unit Of Measure Definition Tag File	Files	46: Warehouse Management	Business Data
61	920	F46091T	ID	8	1	OBSOLETE - Container and Carton Codes Tag File	Secondary Master Files	46: Warehouse Management	Business Data
62	920	F4611T	R2	7	3	OBSOLETE - Warehouse Suggestions Tag File	Transaction Files	46: Warehouse Management	Business Data
63	920	F4611TPU	R2	10	1	OBSOLETE - Warehouse Suggestions Tag File - Purged	Purge Files	46: Warehouse Management	Business Data
64	920	F4620T	CD	10	1	Carton Detail Information - Tag File	Files	46: Warehouse Management
65	920	F470375T	AK	18	1	EDI ASN Packaging Detail Tag Table	Files	47: Electronic Commerce
66	920	F49090	CZ	42	2	Work Day Calendar (Used for Table Conversions ONLY)	Extra Features Files	49: Transportation Management	Business Data
67	920	F49711	RV	20	1	OBSOLETE - Freight Rate Definition - Tag File	Master Files	49: Transportation Management	Business Data
68	920	F74401	RF	5	1	W/T Additional A/B Information - Italy	Balance Files	04: Accounts Payable	Business Data
69	920	F7460	QL	5	2	Next Auto Debit Number	Batch Input Files	03B: Enhanced Accounts Receivable	Business Data
70	920	F750401A	JJ	7	1	Address Book - Withholding Tax Category-Japan	Constants Files	04: Accounts Payable	Business Data
71	920	F75I101A	QB	26	2	TDS Ceritificate Master Tabel Extension	Files	75I: India
72	920	F894101	TC	2	1	Lookup table for CRM Product ID and F4101.IMITM	Files	90CA: CRM Foundation
73	920	F894101H	PH	4	1	Lookup table for CRM and EOne Product Hierarchy Ids	Files	90CA: CRM Foundation
74	920	F89701	PB	6	1	List of Data Items Not Used in FDA	Master Files	89: Conversion Programs	Business Data
75	920	F89702	PB	6	1	List of Data Items Not Used in RDA	Master Files	89: Conversion Programs	Business Data
76	920	F89AD020	PE	3	1	Person_Address cross reference table	Files	90CA: CRM Foundation
77	920	F89AD050	PA	2	1	Lookup table for populating CRM Partner Addresses	Files	90CA: CRM Foundation
78	920	F89AD060	AD	2	1	Lookup table for populating CRM Competitor Addresses	Files	90CA: CRM Foundation
79	920	F89CA020	PS	4	1	Lookup Table for CRM and EOne Person Ids	Files	89: Conversion Programs
80	920	F89CA050	PR	2	1	Lookup Table for CRM and EOne Partner Ids	Files	89: Conversion Programs
81	920	F89CA060	CM	2	1	Lookup Table for CRM and EOne Competitor Ids	Files	89: Conversion Programs
82	920	F89CA080	CO	2	1	Lookup Table for CRM to EOne Company Ids	Files	89: Conversion Programs
83	920	F89CA65A	TC	2	1	Table - Lookup Table for CRM Activity Call Plan ID and NN	Files	89: Conversion Programs
84	920	F89CB06C	TC	3	1	Table - Opportunity_For_FCST_ID - Opportunity Lookup Table	Files	89: Conversion Programs
85	920	F89LU001	PC	3	1	Lookup Table for CRM Person Company and Partner Ids	Files	89: Conversion Programs
86	920	F89LU002	CY	2	1	Lookup Table for CRM City Code and Name	Files	90CA: CRM Foundation
87	920	F89LU003	SR	3	1	Table - Service Request Status ID - UDC Lookup Table	Files	89: Conversion Programs
88	920	F89LU005	TC	3	1	Table - CRM Status Type Lookup Table	Files	89: Conversion Programs
89	920	F89LU006	TC	3	1	Table - CRM Priority Type Lookup Table	Files	89: Conversion Programs
90	920	F89LU007	TC	3	1	Table - CRM Problem Type Lookup Table	Files	89: Conversion Programs
91	920	F89LU008	LU	2	1	Table - Lookup Table for CRM Serivice Request - Channel	Files	89: Conversion Programs
92	920	F89LUADD	AD	4	1	Address lookup table	Files	89: Conversion Programs
93	920	F90CB072	PF	27	1	Profile Table	Files	90CB: CRM Sales Force Automation
94	920	F90CB073	PA	27	1	Profile-Answer Table	Files	90CB: CRM Sales Force Automation
95	920	F952330	BH	17	2	Context Cross-Reference Header Table for Integration	Files	89: Conversion Programs	Business Data
96	920	F952331	BH	19	2	Context Cross-Reference Detail Table for Integration	Files	89: Conversion Programs	Business Data
97	920	F952332	BH	22	1	Collaboration Configuration Table	Files	89: Conversion Programs	System Tables
98	920	F952334	PR	18	1	Metadata Table for Public Resource URL	Files	89: Conversion Programs	Business Data
99	920	F952337	PD	15	1	Related Information Publication List Detail Table	Files	89: Conversion Programs	Business Data
100	920	F98305V	WV	21	2	Batch Versions Web Versions	Files	H95: Object and Environment Tech	Versions Tables
101	920	F98950T	WO	19	2	TC Temporary table for AQ, CAFE1	Files	H95: Object and Environment Tech	Central Objects Tables
102	920	F99302	PO	11	1	Processing Options Text Table	Extra Features Files	89: Conversion Programs	Business Data
103	920	F993022	PO	11	1	Processing Options Error Table	Extra Features Files	89: Conversion Programs	Business Data
104	920	F993023	PO	11	1	Translated Processing Options Text Table	Extra Features Files	89: Conversion Programs	Business Data
105	920	F99303	PP	3	1	PO && Object Cross Reference Table	PC Download/Batch Edit Files	89: Conversion Programs	Business Data

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

105 tables920 | 89