	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

118 tables920 | 00

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	920	F0000194	SY	5	1	Generic Interface Table for B0000194	Files	09: General Accounting	Business Data
2	920	F0002	NN	31	1	Next Numbers - Automatic	Constants Files	09: General Accounting	Control Tables
3	920	F00021	NL	10	1	Next Numbers by Company/Fiscal Year - Automatic	Constants Files	09: General Accounting	Control Tables
4	920	F00022	UK	2	1	Unique Key File - Next Available Unique Key	Constants Files	41: Inventory Management	Business Data
5	920	F00023	DN	24	5	Distributed Next Number Table	Master Files	90CA: CRM Foundation	System Tables
6	920	F0006	MC	152	7	Business Unit Master	Master Files	09: General Accounting	Business Data
7	920	F0006D	LJ	7	2	Business Unit Alternate Description Master	Extra Features Files	09: General Accounting	Business Data
8	920	F0006DZ1	SZ	26	1	Business Unit Alternate Description Z file	Extra Features Files	09: General Accounting	Business Data
9	920	F0006S	MC	157	1	Date Effective Business Unit Master	Extra Features Files	09: General Accounting	Business Data
10	920	F0006S1	SH	8	1	Business Unit Snapshot Header	Extra Features Files	09: General Accounting	Business Data
11	920	F0006Z1	SZ	161	1	Cost Center Unedited Transaction Table	Batch Input Files	05A: PeopleSoft HR & PR Foundation	Business Data
12	920	F0006Z2	SZ	165	1	Business Unit Master Z File	Master Files	09: General Accounting	Business Data
13	920	F0007	CZ	43	3	Workday Calendar	Extra Features Files	30: Product Data Management	Business Data
14	920	F0008	CD	25	2	Date Fiscal Patterns	Constants Files	09: General Accounting	Business Data
15	920	F00085	DS	18	1	Daylight Savings Rules	Constants Files	H91: Design Tools	System Tables
16	920	F0008B	CD	63	1	Date Fiscal Patterns - 52 Period Accounting	Constants Files	09: General Accounting	Business Data
17	920	F0009	GC	66	1	General Constants	Constants Files	09: General Accounting	Business Data
18	920	F00090	T1	22	1	Supplemental Database Setup	Constants Files	41: Inventory Management	Business Data
19	920	F00090D	T5	8	1	Supplemental Database Language Preferences	Transaction Files	41: Inventory Management	Business Data
20	920	F00091	T2	34	1	Supplemental Database Data Types	Transaction Files	41: Inventory Management	Business Data
21	920	F00092	T3	30	5	Supplemental Data	Transaction Files	41: Inventory Management	Business Data
22	920	F00093	FM	12	2	Flash Messages	Extra Features Files	17: Customer Service Management	Business Data
23	920	F00094	T1	10	1	CTI Properties	Extra Features Files	09: General Accounting	Business Data
24	920	F00095	A1	7	3	Business Object Reservation	Extra Features Files	42: Sales Management
25	920	F00096	M0	37	1	Default Media Object Category by Table	Extra Features Files	42: Sales Management	Business Data
26	920	F00098	ED	9	1	Enable Distributed Next Numner	Files	90CA: CRM Foundation	Business Data
27	920	F0010	CC	65	5	Company Constants	Constants Files	09: General Accounting	Business Data
28	920	F00101	CC	8	2	Company by Country - 00	Files	00: Foundation Environment
29	920	F0010T	CC	12	1	Company Constants Tag Table	Files	09: General Accounting
30	920	F0010Z	SZ	84	1	Company Constants Z File	Constants Files	09: General Accounting	Business Data
31	920	F0011	IC	24	1	Batch Control Records	Extra Features Files	09: General Accounting	Business Data
32	920	F0011W	IC	5	1	F0011W - WF - Batch To Detail	Files	09: General Accounting
33	920	F0012	KG	20	2	Automatic Accounting Instructions Master	Constants Files	09: General Accounting	Business Data
34	920	F0012D	LJ	8	1	AAI Alternate Description Master	Extra Features Files	09: General Accounting	Business Data
35	920	F0013	CV	10	1	Currency Codes	Extra Features Files	09: General Accounting	Business Data
36	920	F0014	PN	16	1	Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	Business Data
37	920	F00141	L3	5	3	Advanced Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	Business Data
38	920	F00142	L4	23	1	Due Date Rules	Constants Files	03B: Enhanced Accounts Receivable	Business Data
39	920	F00143	L5	6	1	Due Date Rules Day Range	Constants Files	03B: Enhanced Accounts Receivable	Business Data
40	920	F00144	L6	6	3	Installment Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	Business Data
41	920	F00147	L8	16	1	Multitiered Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	Business Data
42	920	F0018	TD	68	6	Taxes	Extra Features Files	09: General Accounting	Business Data
43	920	F00189	TG	20	2	WF - Tax Reconciliation	Regular Work Files	09: General Accounting	Business Data
44	920	F0018R	ED	27	2	Tax Reconciliation Repository	Files	09: General Accounting
45	920	F0019	CG	6	1	Generic Message/Rate Types	Extra Features Files	48: Work Order Processing	Business Data
46	920	F00191	CE	6	1	Generic Message/Rates	Extra Features Files	48: Work Order Processing	Business Data
47	920	F00192	CF	5	1	General Message Detail	Extra Features Files	48: Work Order Processing	Business Data
48	920	F0022	VA	11	1	Tax Rules	Constants Files	04: Accounts Payable	Business Data
49	920	F0024	UG	2	2	Batch Approval / Post Security File	Extra Features Files	09: General Accounting	Business Data
50	920	F0025	LH	28	2	Ledger Type Master File	Constants Files	09: General Accounting	Business Data
51	920	F0026	CL	18	1	Job Cost Constants	Constants Files	51: Job Costing	Business Data
52	920	F0028	TE	10	1	Sales Tax Work File by Taxing Authority	Regular Work Files	09: General Accounting	Business Data
53	920	F0029	TF	14	1	Sales Tax Work File by Taxing Authority and Document	Regular Work Files	09: General Accounting	Business Data
54	920	F0030	AY	34	6	Bank Transit Master	Master Files	04: Accounts Payable	Business Data
55	920	F0030T	AZ	9	1	Bank Account X12 Information	Secondary Master Files	04: Accounts Payable	Business Data
56	920	F0031	AV	7	1	Bank Transit Master Tag Table	Files	00: Foundation Environment
57	920	F0039	GN	28	2	Generated Documents Definition	Extra Features Files	42: Sales Management	Business Data
58	920	F0039M	GH	12	1	Generated Document Media Object History	History Files	42: Sales Management	Business Data
59	920	F0040Z1	ZB	12	2	Error Message Log Table	Batch Input Files	42B: Sales Order Entry	Business Data
60	920	F0041Z1	ZF	11	4	Transaction Control File	Batch Input Files	42B: Sales Order Entry	Business Data
61	920	F004201	PT	72	3	Prepayment Transaction Table	Transaction Files	42: Sales Management	Business Data
62	920	F00421	RS	15	3	Column Relationships	Files	09: General Accounting	Business Data
63	920	F00422	RB	15	5	Data Relationships	Files	09: General Accounting	Business Data
64	920	F00422A	VR	10	4	Value Relationships - Work Table	Files	09: General Accounting
65	920	F00424	AC	9	1	Relationship Columns	Files	09: General Accounting	Business Data
66	920	F0045	ER	21	2	Services Error Recovery	Files	34A: Advanced Planning & Scheduling
67	920	F0046	PL	10	2	Processing Log	Transaction Files	09: General Accounting	Business Data
68	920	F0047	DE	15	2	Data Export Control	Transaction Files	09: General Accounting	Business Data
69	920	F0048	CM	13	5	Code Mappings Master	Transaction Files	00: Foundation Environment	Business Data
70	920	F0049	CA	15	2	Business Function Call Abstraction Register	Files	34A: Advanced Planning & Scheduling
71	920	F0050	MA	12	4	Organization Structure Master File	Extra Features Files	09: General Accounting	Business Data
72	920	F00690	M1	9	1	Cost Center Types of Data	Extra Features Files	41: Inventory Management	Business Data
73	920	F00692	M2	8	1	Cost Center Supplemental Data Codes	Extra Features Files	41: Inventory Management	Business Data
74	920	F00693	M3	6	1	Cost Center Supplemental Data Text	Extra Features Files	41: Inventory Management	Business Data
75	920	F0070	CK	12	1	Country Constants Master File	Constants Files	09: General Accounting	Business Data
76	920	F007021W	TB	17	1	Transactions to Batch Headers Work Table	Files	00: Foundation Environment
77	920	F007032W	OB	7	1	Batches Out Of Balance Work Table	Files	09: General Accounting
78	920	F0075	CC	11	5	Credit Card Information	Files	09E: Expense Reimbursment	Business Data
79	920	F0080	S2	5	1	Supplemental Data Type Security File	Extra Features Files	41: Inventory Management	Business Data
80	920	F0085	YN	3	1	Audit Record Y/N File - Euro	Constants Files	09: General Accounting	Business Data
81	920	F0087	EU	7	2	Conversion Constants File for Euro	Extra Features Files	09: General Accounting	Business Data
82	920	F0095	IT	5	1	Integration Timestamp	Files	00: Foundation Environment
83	920	F00UI391	GW	16	1	Generated Document Work Table	Work Files	42: Sales Management	Business Data
84	920	F00UI392	GW	15	1	Text Substitution Work Table	Work Files	42: Sales Management	Business Data
85	920	F00UI393	GW	13	1	Bookmark Work Table	Work Files	42: Sales Management	Business Data
86	920	F01RS01W	TH	6	1	PCFGTV Header Public Data	Work Files	H95: Object and Environment Tech
87	920	F01RS11W	TD	49	1	PCFGTV Detail Public Data	Work Files	H95: Object and Environment Tech
88	920	F01RS12W	TR	4	1	PCFGTV Role Public Data	Files	H95: Object and Environment Tech
89	920	F01RS13W	TA	14	1	PCFGTV By Role Public Data	Files	H95: Object and Environment Tech
90	920	F03B470	PG	7	2	Pay When Paid Group Header	Extra Features Files	03B: Enhanced Accounts Receivable	Business Data
91	920	F0401Z1	VO	95	1	Supplier Master - Batch Upload	Batch Input Files	01: Address Book	Business Data
92	920	F0901WO	WO	2	1	Account Master Search Word Occurrence	Extra Features Files	09: General Accounting	Business Data
93	920	F0901WS	WS	4	3	Account - Word Search	Extra Features Files	09: General Accounting	Business Data
94	920	F0902	GB	56	9	Account Balances	Balance Files	09: General Accounting	Business Data
95	920	F0911	GL	141	24	Account Ledger	Transaction Files	09: General Accounting	Business Data
96	920	F09190	C9	10	4	Inter/Intra Company Account Relationships	Files	11: Multi Currency	Business Data
97	920	F097001W	CB	7	1	Companies Out of Balance Work Table	Files	09: General Accounting
98	920	F15019	NL	29	1	Billing Frequency Master	Master Files	15: Real Estate Management	Business Data
99	920	F17001	CS	61	1	Service/Warranty Constants Table - F17001	Constants Files	17C: Call Management	Business Data
100	920	F4008	TA	35	2	Tax Areas	Extra Features Files	04: Accounts Payable	Business Data
101	920	F40081	EU	27	2	Alternate Tax Rate/Area Definition	Files	00: Foundation Environment
102	920	F40082	AC	8	2	Alternate Tax Area by Country - 00	Files	00: Foundation Environment
103	920	F4096	FA	21	1	Sales Flex Accounting	Master Files	42: Sales Management	Business Data
104	920	F4303M	PM	26	2	Log Models	Extra Features Files	43: Procurement	Business Data
105	920	F5192	JC	11	1	Inquiry Columns	Constants Files	43: Procurement	Business Data
106	920	F5192D	JC	6	1	Supplier Analysis Alternate Language Description	Extra Features Files	43: Procurement	Business Data
107	920	F5193	JD	7	1	Inquiry Formats	Constants Files	43: Procurement	Business Data
108	920	F5194	JE	5	1	Inquiry Paths	Constants Files	43: Procurement	Business Data
109	920	F5301	DI	43	6	Change Request Master Table	Master Files	53: Change Management	Business Data
110	920	F744008	TA	9	1	Tax areas - Tag Table EMEA - Spain / Italy	Master Files	04: Accounts Payable	Business Data
111	920	F800010	TD	17	2	Time Dimension	Master Files	00: Foundation Environment	Business Data
112	920	F80D306	HD	14	1	Action Definition	Files	80D: Plant Manager Dashboard
113	920	F80D307	HD	11	1	Metric Action Cross Reference	Files	80D: Plant Manager Dashboard
114	920	F80D309	MS	12	1	Metric Series Cross Ref	Files	80D: Plant Manager Dashboard
115	920	F80D310	AL	13	1	Alert Definition	Files	80D: Plant Manager Dashboard
116	920	F80D312	AS	12	1	Alert Subscription	Files	80D: Plant Manager Dashboard
117	920	F80D321	MG	12	1	UI Metric Group Definition	Files	80D: Plant Manager Dashboard
118	920	F80D322	MD	17	1	UI Metric Group Detail	Files	80D: Plant Manager Dashboard

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

118 tables920 | 00