	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

38 COLUMNS | 5 INDEXES | 920 | H92 | F9860 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H92: Interactive Engine/OL
1	920	F9860	SI	38	5	Object Librarian Master Table	Master Files	H92: Interactive Engine/OL	Object Librarian Tables

TOP 920 | H92 | F9860 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	SIOBNM	Object Name	String	Generic Edit	10	Allow NULL?
2	SIMD	Description	String	Generic Edit	60	Allow NULL?
3	SISY	Product Code	String	UDC (98 SY)	4	Allow NULL?
4	SISYR	Product Code/Reporting	String	UDC (98 SY)	4	Allow NULL?
5	SIFUNO	Object Type	String	UDC (98 OF)	4	Allow NULL?
6	SIFUNU	Function Use	String	UDC (98 FU)	3	Allow NULL?
7	SIPFX	Prefix - File	String	Generic Edit	2	Allow NULL?
8	SISRCLNG	Source Language	String	UDC (98 SL)	3	Allow NULL?
9	SIANSIF	ANSI - Yes/No	Character	Generic Edit	1	Allow NULL?
10	SICATO	Object Catagory	String	UDC (98 OC)	4	Allow NULL?
11	SICLDF	Data Class	Character	UDC (H96 CL)	1	Allow NULL?
12	SICPYD	Copy Data With File	Character	Generic Edit	1	Allow NULL?
13	SIOMIT	Omit Option	Character	UDC (H98 OM)	1	Allow NULL?
14	SIOPDF	Optional Data File	Character	UDC (H00 OP)	1	Allow NULL?
15	SIAPPLID	Application ID - EnterpriseOne	Identifier (ID)	Generic Edit	11
16	SICURTYP	Type - Currency Logic	String	Generic Edit	2	Allow NULL?
17	SIBFLOCN	Location - Business Function	Character	UDC (98 EB)	1	Allow NULL?
18	SIGBOPTN	Option - Global Build	Character	UDC (98 EG)	1	Allow NULL?
19	SIGTFILE	Generic Text File	String	Generic Edit	10	Allow NULL?
20	SIGTTYPE	Generic Text Type	String	Generic Edit	10	Allow NULL?
21	SIGTFFU1	Generic Text Future Use	String	Generic Edit	10	Allow NULL?
22	SIJDETEXT	EnterpriseOne Text	Character	Check Box	1	Allow NULL?
23	SIPROPID	Processing Option ID - EnterpriseOne	Identifier (ID)	Generic Edit	11
24	SIMID1	Member ID	String	Generic Edit	10	Allow NULL?
25	SIBASE	Base Member Name	String	Generic Edit	10	Allow NULL?
26	SIPARDLL	Library - Parent DLL	String	Generic Edit	10	Allow NULL?
27	SIPAROBN	Object - Parent Object	String	Generic Edit	10	Allow NULL?
28	SIPKGCOL	Program Family	String	UDC (98 EP)	4	Allow NULL?
29	SIOLCD01	Function Type	String	UDC (98 E1)	4	Allow NULL?
30	SIOLCD02	OCM Category	String	UDC (98 E7)	4	Allow NULL?
31	SIOLCD03	ABC Priority	String	UDC (98 E3)	4	Allow NULL?
32	SIOLCD04	Process Type	String	UDC (98 E4)	4	Allow NULL?
33	SIOLCD05	Category Code - Object Librarian 05	String	UDC (98 E5)	4	Allow NULL?
34	SIPID	Program ID	String	Generic Edit	10	Allow NULL?
35	SIUSER	User ID	String	Generic Edit	10	Allow NULL?
36	SIJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
37	SIUPMJ	Date - Updated	Date	Generic Edit	6
38	SIUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

TOP 920 | H92 | F9860 INDEXES

Number

Description

Object Name (Primary/Unique)

Element	Alias	Description	Sequence
1	OBNM	Object Name	Ascending

Object ID Function Code

Element	Alias	Description	Sequence
1	APPLID	Application ID - EnterpriseOne	Ascending
2	FUNO	Object Type	Ascending

Function Code Object Name Ap (Unique)

Element	Alias	Description	Sequence
1	FUNO	Object Type	Ascending
2	OBNM	Object Name	Ascending
3	APPLID	Application ID - EnterpriseOne	Ascending

System Code Object Type +

Element	Alias	Description	Sequence
1	SY	Product Code	Ascending
2	FUNO	Object Type	Ascending

Table Group

Element	Alias	Description	Sequence
1	CLDF	Data Class	Ascending

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

38 COLUMNS | 5 INDEXES | 920 | H92 | F9860 TABLE

TOP 920 | H92 | F9860 COLUMNS

TOP 920 | H92 | F9860 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

38 COLUMNS | 5 INDEXES | 920 | H92 | F9860 TABLE

TOP920 | H92 | F9860 COLUMNS

TOP920 | H92 | F9860 INDEXES

TOP 920 | H92 | F9860 COLUMNS

TOP 920 | H92 | F9860 INDEXES