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
13E: Equipment Cost Analysis
1	910	F1381	EF	53	1	Equipment Analysis Filters	Extra Features Files	13E: Equipment Cost Analysis

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	EFEQGP	Equipment Group	String	Generic Edit	30	Allow NULL?
2	EFEQSP	Equipment Subgroup	String	Generic Edit	30	Allow NULL?
3	EFICLC	Include Children	Character	Generic Edit	1	Allow NULL?
4	EFCO	Company	String	Generic Edit	5	Allow NULL?
5	EFMCU	Business Unit	String	Generic Edit	12	Allow NULL?
6	EFLOC	Business Unit - Location	String	Generic Edit	12	Allow NULL?
7	EFAN8	Address Number	Numeric	UDC	8	Allow NULL?
8	EFLANO	Address Number - Lessor/Rentor/Mortgagor	Numeric	Generic Edit	8	Allow NULL?
9	EFEQST	Equipment Status	String	UDC (12 ES)	2	Allow NULL?
10	EFAAID	Parent Number	Numeric	Generic Edit	8	Allow NULL?
11	EFPRODM	Product Model	String	UDC (17 PM)	8	Allow NULL?
12	EFPRODF	Product Family	String	UDC (17 PA)	8	Allow NULL?
13	EFMMCU	Branch	String	Generic Edit	12	Allow NULL?
14	EFNUMB	Asset Item Number	Numeric	Generic Edit	8	Allow NULL?
15	EFKIT	Parent (short) Item Number	Numeric	Generic Edit	8	Allow NULL?
16	EFACL1	Major Accounting Class	String	UDC (12 C1)	3	Allow NULL?
17	EFACL2	Major Equipment Class	String	UDC (12 C2)	3	Allow NULL?
18	EFACL3	Manufacturer	String	UDC (12 C3)	3	Allow NULL?
19	EFACL4	Model Year	String	UDC (12 C4)	3	Allow NULL?
20	EFACL5	Usage Miles or Hours	String	UDC (12 C5)	3	Allow NULL?
21	EFACL6	Category Code - F/A 6	String	UDC (12 C6)	3	Allow NULL?
22	EFACL7	Category Code - F/A 7	String	UDC (12 C7)	3	Allow NULL?
23	EFACL8	Category Code - F/A 8	String	UDC (12 C8)	3	Allow NULL?
24	EFACL9	Category Code - F/A 9	String	UDC (12 C9)	3	Allow NULL?
25	EFACL0	Category Code - F/A 10 (Rate Group)	String	UDC (12 C0)	3	Allow NULL?
26	EFFA1	Category Code - F/A 11	String	UDC (12 F1)	3	Allow NULL?
27	EFFA2	Category Code - F/A 12	String	UDC (12 F2)	3	Allow NULL?
28	EFFA3	Category Code - F/A 13	String	UDC (12 F3)	3	Allow NULL?
29	EFFA4	Category Code - F/A 14	String	UDC (12 F4)	3	Allow NULL?
30	EFFA5	Category Code - F/A 15	String	UDC (12 F5)	3	Allow NULL?
31	EFFA6	Category Code - F/A 16	String	UDC (12 F6)	3	Allow NULL?
32	EFFA7	Category Code - F/A 17	String	UDC (12 F7)	3	Allow NULL?
33	EFFA8	Category Code - F/A 18	String	UDC (12 F8)	3	Allow NULL?
34	EFFA9	Category Code - F/A 19	String	UDC (12 F9)	3	Allow NULL?
35	EFFA0	Category Code - F/A 20	String	UDC (12 F0)	3	Allow NULL?
36	EFFA21	Category Code - F/A 21	String	UDC (12 21)	10	Allow NULL?
37	EFFA22	Category Code - F/A 22	String	UDC (12 22)	10	Allow NULL?
38	EFFA23	Category Code - F/A 23	String	UDC (12 23)	10	Allow NULL?
39	EFZE01	Category Code - Equipment 01	String	UDC (17 B1)	10	Allow NULL?
40	EFZE02	Category Code - Equipment 02	String	UDC (17 B2)	10	Allow NULL?
41	EFZE03	Category Code - Equipment 03	String	UDC (17 B3)	10	Allow NULL?
42	EFZE04	Category Code - Equipment 04	String	UDC (17 B4)	10	Allow NULL?
43	EFZE05	Category Code - Equipment 05	String	UDC (17 B5)	10	Allow NULL?
44	EFZE06	Category Code - Equipment 06	String	UDC (17 B6)	10	Allow NULL?
45	EFZE07	Category Code - Equipment 07	String	UDC (17 B7)	10	Allow NULL?
46	EFZE08	Category Code - Equipment 08	String	UDC (17 B8)	10	Allow NULL?
47	EFZE09	Category Code - Equipment 09	String	UDC (17 B9)	10	Allow NULL?
48	EFZE10	Category Code - Equipment 10	String	UDC (17 B0)	10	Allow NULL?
49	EFUSER	User ID	String	Generic Edit	10	Allow NULL?
50	EFPID	Program ID	String	Generic Edit	10	Allow NULL?
51	EFMKEY	Machine Key	String	Generic Edit	15	Allow NULL?
52	EFUPMJ	Date - Updated	Date	Generic Edit	6
53	EFUPMT	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

53 COLUMNS | 1 INDEXES | 910 | 13E | F1381 TABLE

TOP 910 | 13E | F1381 COLUMNS

TOP 910 | 13E | F1381 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

53 COLUMNS | 1 INDEXES | 910 | 13E | F1381 TABLE

TOP910 | 13E | F1381 COLUMNS

TOP910 | 13E | F1381 INDEXES

TOP 910 | 13E | F1381 COLUMNS

TOP 910 | 13E | F1381 INDEXES