	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

101 tables812 | 00

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	812	F0000194	SY	5	1	Generic Interface Table for B0000194	Files	00: Foundation Environment	No
2	812	F0002	NN	31	1	Next Numbers - Automatic	Constants Files	00: Foundation Environment	Control Tables
3	812	F00021	NL	10	1	Next Numbers by Company/Fiscal Year - Automatic	Constants Files	00: Foundation Environment	Control Tables
4	812	F00022	UK	2	1	Unique Key File - Next Available Unique Key	Constants Files	41: Inventory Management	AS400 Coexistence Tables
5	812	F00023	DN	24	5	Distributed Next Number Table	Master Files	42: Sales Management	No
6	812	F0006	MC	120	5	Business Unit Master	Master Files	00: Foundation Environment	AS400 Coexistence Tables
7	812	F0006D	LJ	7	1	Business Unit Alternate Description Master	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
8	812	F0006S	MC	125	1	Date Effective Business Unit Master	Extra Features Files	00: Foundation Environment	No
9	812	F0006S1	SH	8	1	Business Unit Snapshot Header	Extra Features Files	00: Foundation Environment	No
10	812	F0006Z1	SZ	136	1	Cost Center Unedited Transaction Table	Batch Input Files	00: Foundation Environment	No
11	812	F0007	CZ	43	3	Work Day Calendar	Extra Features Files	30: Product Data Management	AS400 Coexistence Tables
12	812	F0008	CD	25	2	Date Fiscal Patterns	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
13	812	F00085	DS	18	1	Daylight Savings Rules	Constants Files	H91: Design Tools	System Tables
14	812	F0008B	CD	63	1	Date Fiscal Patterns - 52 Period Accounting	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
15	812	F0009	GC	65	1	General Constants	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
16	812	F00090	T1	22	1	Supplemental Database Setup	Constants Files	41: Inventory Management	AS400 Coexistence Tables
17	812	F00090D	T5	8	1	Supplemental Database Language Preferences	Transaction Files	41: Inventory Management	AS400 Coexistence Tables
18	812	F00091	T2	34	1	Supplemental Database Data Types	Transaction Files	41: Inventory Management	AS400 Coexistence Tables
19	812	F00092	T3	30	5	Supplemental Data	Transaction Files	41: Inventory Management	AS400 Coexistence Tables
20	812	F00093	FM	12	2	Flash Messages	Extra Features Files	00: Foundation Environment	No
21	812	F00094	T1	10	1	CTI Properties	Extra Features Files	00: Foundation Environment	No
22	812	F00095	A1	7	3	Business Object Reservation	Extra Features Files	00: Foundation Environment	No
23	812	F00096	M0	37	1	Default Media Object Category by Table	Extra Features Files	42: Sales Management	No
24	812	F00098	ED	9	1	Enable Distributed Next Numner	Files	42: Sales Management	No
25	812	F0010	CC	65	4	Company Constants	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
26	812	F0011	IC	24	1	Batch Control Records	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
27	812	F0011W	IC	5	1	F0011W - WF - Batch To Detail	Files	09: General Accounting
28	812	F0012	KG	20	2	Automatic Accounting Instructions Master	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
29	812	F0012D	LJ	8	1	AAI Alternate Description Master	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
30	812	F0013	CV	10	1	Currency Codes	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
31	812	F0014	PN	16	1	Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
32	812	F00141	L3	5	3	Advanced Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
33	812	F00142	L4	23	1	Due Date Rules	Constants Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
34	812	F00143	L5	6	1	Due Date Rules Day Range	Constants Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
35	812	F00144	L6	6	3	Installment Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	AS400 Coexistence Tables
36	812	F00147	L8	16	1	Multi-Tiered Payment Terms	Constants Files	03B: Enhanced Accounts Receivable	No
37	812	F00151	T1	6	1	Currency Exchange Rates (F0015 Header)	Extra Features Files	11: Multi Currency	AS400 Coexistence Tables
38	812	F00171	NC	4	1	Interoperability-Net Change Table	Files	00: Foundation Environment	No
39	812	F0018	TD	68	5	Sales/Use/V.A.T. Tax File	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
40	812	F00189	TG	20	2	WF - Tax Reconciliation	Regular Work Files	00: Foundation Environment	AS400 Coexistence Tables
41	812	F0018R	ED	27	2	Tax Reconciliation Repository	Files	09: General Accounting
42	812	F0019	CG	6	1	Generic Message/Rate Types	Extra Features Files	48: Work Order Processing	AS400 Coexistence Tables
43	812	F00191	CE	6	1	Generic Message/Rates	Extra Features Files	48: Work Order Processing	AS400 Coexistence Tables
44	812	F00192	CF	5	1	General Message Detail	Extra Features Files	48: Work Order Processing	AS400 Coexistence Tables
45	812	F0022	VA	11	1	Tax Rules	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
46	812	F0024	UG	2	2	Batch Approval / Post Security File	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
47	812	F0025	LH	28	2	Ledger Type Master File	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
48	812	F0026	CL	18	1	Job Cost Constants	Constants Files	51: Job Costing	AS400 Coexistence Tables
49	812	F0028	TE	10	1	Sales Tax Work File by Taxing Authority	Regular Work Files	00: Foundation Environment	AS400 Coexistence Tables
50	812	F0029	TF	14	1	Sales Tax Work File by Taxing Authority and Document	Regular Work Files	00: Foundation Environment	AS400 Coexistence Tables
51	812	F0030	AY	34	5	Bank Transit Number Master File	Master Files	04: Accounts Payable	AS400 Coexistence Tables
52	812	F0030T	AZ	9	1	Bank Account X12 Information	Secondary Master Files	04: Accounts Payable	AS400 Coexistence Tables
53	812	F0039	GN	28	2	Generated Documents Definition	Extra Features Files	42: Sales Management	No
54	812	F0039M	GH	12	1	Generated Document Media Object History	History Files	42: Sales Management	No
55	812	F0040Z1	ZB	12	2	Error Message Log Table	Batch Input Files	42B: Sales Order Entry	No
56	812	F0041Z1	ZF	11	4	Transaction Control File	Batch Input Files	42B: Sales Order Entry	No
57	812	F004201	PT	72	3	Prepayment Transaction Table	Transaction Files	42: Sales Management	No
58	812	F0045	ER			Services Error Recovery	Files	34A: Advanced Planning & Scheduling
59	812	F0046	PL	10	2	Processing Log	Transaction Files	00: Foundation Environment	AS400 Coexistence Tables
60	812	F0047	DE	15	2	Data Export Control	Transaction Files	00: Foundation Environment	AS400 Coexistence Tables
61	812	F0048	CM	13	5	Code Mappings Master	Transaction Files	00: Foundation Environment	AS400 Coexistence Tables
62	812	F0050	MA	12	4	Organization Structure Master File	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
63	812	F00690	M1	9	1	Cost Center Types of Data	Extra Features Files	41: Inventory Management	AS400 Coexistence Tables
64	812	F00692	M2	8	1	Cost Center Supplemental Data Codes	Extra Features Files	41: Inventory Management	AS400 Coexistence Tables
65	812	F00693	M3	6	1	Cost Center Supplemental Data Text	Extra Features Files	41: Inventory Management	AS400 Coexistence Tables
66	812	F0070	CK	12	1	Country Constants Master File	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
67	812	F007101	TA	20	1	Text Processor Header	Transaction Files	00: Foundation Environment	No
68	812	F007111	TB	14	2	Text Processor Detail Table	Transaction Files	00: Foundation Environment	No
69	812	F0075	CC	11	5	Credit Card Information	Files	09E: Expense Reimbursment	No
70	812	F0080	S2	5	1	Supplemental Data Type Security File	Extra Features Files	41: Inventory Management	AS400 Coexistence Tables
71	812	F0085	YN	3	1	Audit Record Y/N File - Euro	Constants Files	00: Foundation Environment	AS400 Coexistence Tables
72	812	F0087	EU	7	2	Conversion Constants File for Euro	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
73	812	F00UI391	GW	16	1	Generated Document Work Table	Work Files	42: Sales Management	No
74	812	F00UI392	GW	15	1	Text Substitution Work Table	Work Files	42: Sales Management	No
75	812	F00UI393	GW	13	1	Bookmark Work Table	Work Files	42: Sales Management	No
76	812	F01RS01W	TH	6	1	PCFGTV Header Public Data	Work Files	H95: Tech Resources/Applications
77	812	F01RS11W	TD	49	1	PCFGTV Detail Public Data	Work Files	H95: Tech Resources/Applications
78	812	F01RS12W	TR	4	1	PCFGTV Role Public Data	Files	H95: Tech Resources/Applications
79	812	F01RS13W	TA	14	1	PCFGTV By Role Public Data	Files	H95: Tech Resources/Applications
80	812	F03B470	PG	7	2	Pay When Paid Group Header	Extra Features Files	03B: Enhanced Accounts Receivable	Internal Table
81	812	F0401Z1	VO	94	1	Supplier Master - Batch File	Batch Input Files	01: Address Book	No
82	812	F0901T	GM	6	1	Account Master Tag File	Master Files	09: General Accounting	No
83	812	F0901WO	WO	2	1	Account Master Search Word Occurrence	Extra Features Files	00: Foundation Environment	No
84	812	F0901WS	WS	4	3	Account - Word Search	Extra Features Files	00: Foundation Environment	No
85	812	F0902	GB	56	9	Account Balances	Balance Files	09: General Accounting	AS400 Coexistence Tables
86	812	F0911	GL	134	25	Account Ledger	Transaction Files	09: General Accounting	AS400 Coexistence Tables
87	812	F0911T	GL	26	1	Account Ledger Tag File	Transaction Files	09: General Accounting	No
88	812	F09190	C9	10	4	Inter/Intra Company Account Relationships	Files	11: Multi Currency	Business Data
89	812	F1501	NE	72	3	Tenant/Lease Master	Master Files	15: Property Management	AS400 Coexistence Tables
90	812	F15019	NL	29	1	Billing Frequency Master	Master Files	15: Property Management	No
91	812	F17001	CS	61	1	Customer Service Constants Table - F17001	Constants Files	17C: Call Management	No
92	812	F4008	TA	35	2	Tax Areas	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
93	812	F4096	FA	21	1	Sales Flex Accounting	Master Files	42: Sales Management	AS400 Coexistence Tables
94	812	F4303	PK	28	3	Log Master	Transaction Files	43: Procurement	AS400 Coexistence Tables
95	812	F4303M	PM	26	2	Log Models	Extra Features Files	43: Procurement	No
96	812	F49090	CZ	42	2	Work Day Calendar	Extra Features Files	00: Foundation Environment	AS400 Coexistence Tables
97	812	F5192	JC	11	1	Inquiry Columns	Constants Files	43: Procurement	AS400 Coexistence Tables
98	812	F5192D	JC	6	1	Supplier Analysis Alternate Language Description	Extra Features Files	43: Procurement	AS400 Coexistence Tables
99	812	F5193	JD	7	1	Inquiry Formats	Constants Files	43: Procurement	AS400 Coexistence Tables
100	812	F5194	JE	5	1	Inquiry Paths	Constants Files	43: Procurement	AS400 Coexistence Tables
101	812	F5301	DI	43	6	Change Request Master Table	Master Files	53: Change Management	AS400 Coexistence Tables

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

101 tables812 | 00