920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	812	F0008B	CD	63	1	Date Fiscal Patterns - 52 Period Accounting	Constants Files	00: Foundation Environment	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	CDDTPN	Fiscal Date Pattern	Character	UDC (H00 DP)	1	Allow NULL?
2	CDDFYJ	Date - Fiscal Year Begins	Date	Generic Edit	6
3	CDFQ	Fiscal Quarter (Obsolete)	String	UDC (H09 FQ)	4	Allow NULL?
4	CDD01J	Date - End of Period 01	Date	Generic Edit	6
5	CDD02J	Date - End of Period 02	Date	Generic Edit	6
6	CDD03J	Date - End of Period 03	Date	Generic Edit	6
7	CDD04J	Date - End of Period 04	Date	Generic Edit	6
8	CDD05J	Date - End of Period 05	Date	Generic Edit	6
9	CDD06J	Date - End of Period 06	Date	Generic Edit	6
10	CDD07J	Date - End of Period 07	Date	Generic Edit	6
11	CDD08J	Date - End of Period 08	Date	Generic Edit	6
12	CDD09J	Date - End of Period 09	Date	Generic Edit	6
13	CDD10J	Date - End of Period 10	Date	Generic Edit	6
14	CDD11J	Date - End of Period 11	Date	Generic Edit	6
15	CDD12J	Date - End of Period 12	Date	Generic Edit	6
16	CDD13J	Date - End of Period 13	Date	Generic Edit	6
17	CDD14J	Date - End of Period 14	Date	Generic Edit	6
18	CDD15J	Date - End of Period 15	Date	Generic Edit	6
19	CDD16J	Date - End of Period 16	Date	Generic Edit	6
20	CDD17J	Date - End of Period 17	Date	Generic Edit	6
21	CDD18J	Date - End of Period 18	Date	Generic Edit	6
22	CDD19J	Date - End of Period 19	Date	Generic Edit	6
23	CDD20J	Date - End of Period 20	Date	Generic Edit	6
24	CDD21J	Date - End of Period 21	Date	Generic Edit	6
25	CDD22J	Date - End of Period 22	Date	Generic Edit	6
26	CDD23J	Date - End of Period 23	Date	Generic Edit	6
27	CDD24J	Date - End of Period 24	Date	Generic Edit	6
28	CDD25J	Date - End of Period 25	Date	Generic Edit	6
29	CDD26J	Date - End of Period 26	Date	Generic Edit	6
30	CDD27J	Date - End of Period 27	Date	Generic Edit	6
31	CDD28J	Date - End of Period 28	Date	Generic Edit	6
32	CDD29J	Date - End of Period 29	Date	Generic Edit	6
33	CDD30J	Date - End of Period 30	Date	Generic Edit	6
34	CDD31J	Date - End of Period 31	Date	Generic Edit	6
35	CDD32J	Date - End of Period 32	Date	Generic Edit	6
36	CDD33J	Date - End of Period 33	Date	Generic Edit	6
37	CDD34J	Date - End of Period 34	Date	Generic Edit	6
38	CDD35J	Date - End of Period 35	Date	Generic Edit	6
39	CDD36J	Date - End of Period 36	Date	Generic Edit	6
40	CDD37J	Date - End of Period 37	Date	Generic Edit	6
41	CDD38J	Date - End of Period 38	Date	Generic Edit	6
42	CDD39J	Date - End of Period 39	Date	Generic Edit	6
43	CDD40J	Date - End of Period 40	Date	Generic Edit	6
44	CDD41J	Date - End of Period 41	Date	Generic Edit	6
45	CDD42J	Date - End of Period 42	Date	Generic Edit	6
46	CDD43J	Date - End of Period 43	Date	Generic Edit	6
47	CDD44J	Date - End of Period 44	Date	Generic Edit	6
48	CDD45J	Date - End of Period 45	Date	Generic Edit	6
49	CDD46J	Date - End of Period 46	Date	Generic Edit	6
50	CDD47J	Date - End of Period 47	Date	Generic Edit	6
51	CDD48J	Date - End of Period 48	Date	Generic Edit	6
52	CDD49J	Date - End of Period 49	Date	Generic Edit	6
53	CDD50J	Date - End of Period 50	Date	Generic Edit	6
54	CDD51J	Date - End of Period 51	Date	Generic Edit	6
55	CDD52J	Date - End of Period 52	Date	Generic Edit	6
56	CDD53J	Date - End of Period 53	Date	Generic Edit	6
57	CDD54J	Date - End of Period 54	Date	Generic Edit	6
58	CDPNT	Date Pattern Type	Character	UDC (00 PT)	1	Allow NULL?
59	CDUSER	User ID	String	Generic Edit	10	Allow NULL?
60	CDPID	Program ID	String	Generic Edit	10	Allow NULL?
61	CDUPMJ	Date - Updated	Date	Generic Edit	6
62	CDJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
63	CDUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

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

63 COLUMNS | 1 INDEXES | 812 | 00 | F0008B TABLE

TOP 812 | 00 | F0008B COLUMNS

TOP 812 | 00 | F0008B INDEXES

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

63 COLUMNS | 1 INDEXES | 812 | 00 | F0008B TABLE

TOP812 | 00 | F0008B COLUMNS

TOP812 | 00 | F0008B INDEXES

TOP 812 | 00 | F0008B COLUMNS

TOP 812 | 00 | F0008B INDEXES