	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

50 COLUMNS | 4 INDEXES | 812 | H95 | F0092 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H95: Tech Resources/Applications
1	812	F0092	UL	50	4	Library Lists - User	Constants Files	H95: Tech Resources/Applications	System Tables

TOP 812 | H95 | F0092 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	ULUSER	User ID	String	Generic Edit	10	Allow NULL?
2	ULMNI	Menu Identification	String	Generic Edit	10	Allow NULL?
3	ULOUTQ	Output Queue	String	Generic Edit	10	Allow NULL?
4	ULJOBQ	Batch Job Queue	String	Generic Edit	10	Allow NULL?
5	ULJSP	Job Scheduling Priority	Character	Generic Edit	1	Allow NULL?
6	ULOUTP	Output Priority	Character	Generic Edit	1	Allow NULL?
7	ULLLVL	Logging Level	Character	UDC (H00 LL)	1	Allow NULL?
8	ULLSEV	Logging Severity	String	Generic Edit	2	Allow NULL?
9	ULLMSG	Logging Messages	String	UDC (H00 LM)	7	Allow NULL?
10	ULPRTL	Library - Print File	String	Generic Edit	10	Allow NULL?
11	ULUL01	Time Zone	String	UDC (H91 TZ)	10	Allow NULL?
12	ULUL02	Time Format	String	UDC (H95 TF)	10	Allow NULL?
13	ULUL03	User Library List3	String	Generic Edit	10	Allow NULL?
14	ULUL04	User Library List4	String	Generic Edit	10	Allow NULL?
15	ULUL05	User Library List5	String	Generic Edit	10	Allow NULL?
16	ULUL06	User Library List6	String	Generic Edit	10	Allow NULL?
17	ULUL07	User Library List7	String	Generic Edit	10	Allow NULL?
18	ULUL08	User Library List8	String	Generic Edit	10	Allow NULL?
19	ULUL09	User Library List9	String	Generic Edit	10	Allow NULL?
20	ULUL10	User Library List10	String	Generic Edit	10	Allow NULL?
21	ULUL11	User Library List11	String	Generic Edit	10	Allow NULL?
22	ULUL12	User Library List12	String	Generic Edit	10	Allow NULL?
23	ULUL13	User Library List13	String	Generic Edit	10	Allow NULL?
24	ULUL14	User Library List14	String	Generic Edit	10	Allow NULL?
25	ULUL15	User Library List15	String	Generic Edit	10	Allow NULL?
26	ULUL16	User Library List16	String	Generic Edit	10	Allow NULL?
27	ULUL17	User Library List17	String	Generic Edit	10	Allow NULL?
28	ULUL18	User Library List18	String	Generic Edit	10	Allow NULL?
29	ULUL19	User Library List19	String	Generic Edit	10	Allow NULL?
30	ULUL20	User Library List20	String	Generic Edit	10	Allow NULL?
31	ULUL21	User Library List21	String	Generic Edit	10	Allow NULL?
32	ULUL22	User Library List22	String	Generic Edit	10	Allow NULL?
33	ULUL23	User Library List23	String	Generic Edit	10	Allow NULL?
34	ULUL24	User Library List24	String	Generic Edit	10	Allow NULL?
35	ULUL25	User Library List25	String	Generic Edit	10	Allow NULL?
36	ULMSKA	Authorization Mask	Character	Generic Edit	1	Allow NULL?
37	ULMSKJ	Job Mask	Character	Generic Edit	1	Allow NULL?
38	ULMSKK	Knowledge Mask	Character	Generic Edit	1	Allow NULL?
39	ULMSKD	Department Mask	String	Generic Edit	2	Allow NULL?
40	ULMSKF	Future Use Mask	Character	UDC (H90 TL)	1	Allow NULL?
41	ULAN8	Address Number	Numeric	UDC	8	Allow NULL?
42	ULUTYP	User Type	String	Generic Edit	10	Allow NULL?
43	ULPID	Program ID	String	Generic Edit	10	Allow NULL?
44	ULMTVL	Menu Travel Flag	Character	Generic Edit	1	Allow NULL?
45	ULCMDE	Command Entry Flag	Character	Generic Edit	1	Allow NULL?
46	ULCLIB	Current Library	String	Generic Edit	10	Allow NULL?
47	ULUGRP	User / Role	String	Generic Edit	10	Allow NULL?
48	ULIPGM	Initial Program	String	Generic Edit	10	Allow NULL?
49	ULLOD	Level of Display	Character	UDC (00 LD)	1	Allow NULL?
50	ULFSTP	Fast Path Security Flag	Character	Generic Edit	1	Allow NULL?

TOP 812 | H95 | F0092 INDEXES

Number

Description

User (Primary/Unique)

Element	Alias	Description	Sequence
1	USER	User ID	Ascending

Group User (Unique)

Element	Alias	Description	Sequence
1	UGRP	User / Role	Ascending
2	USER	User ID	Ascending

Department User (Unique)

Element	Alias	Description	Sequence
1	MSKD	Department Mask	Ascending
2	USER	User ID	Ascending

Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	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

50 COLUMNS | 4 INDEXES | 812 | H95 | F0092 TABLE

TOP 812 | H95 | F0092 COLUMNS

TOP 812 | H95 | F0092 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

50 COLUMNS | 4 INDEXES | 812 | H95 | F0092 TABLE

TOP812 | H95 | F0092 COLUMNS

TOP812 | H95 | F0092 INDEXES

TOP 812 | H95 | F0092 COLUMNS

TOP 812 | H95 | F0092 INDEXES