	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	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

20 COLUMNS | 3 INDEXES | 910 | H95 | F952401 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H95: Tech Resources/Applications
1	910	F952401	UC	20	3	UGC Effective Dates	Files	H95: Tech Resources/Applications	System Tables

TOP 910 | H95 | F952401 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	UCOID	Java persistent Object Identifier	String	Generic Edit	50	Allow NULL?
2	UCOMWOT	Object Management Object Type	String	UDC (H92 OT)	10	Allow NULL?
3	UCOBNM	Object Name	String	Generic Edit	10	Allow NULL?
4	UCEAP	Application ID	String	Generic Edit	10	Allow NULL?
5	UCVER	Version	String	Generic Edit	10	Allow NULL?
6	UCUGCRPTNM	UGC Report Name	String	Generic Edit	50	Allow NULL?
7	UCUGCOWNER	User ID	String	Generic Edit	10	Allow NULL?
8	UCEFFUTIME	EffectiveUTime	JDE UTime	Generic Edit	11
9	UCEXPUTIME	ExpiredUTime	JDE UTime	Generic Edit	11
10	UCIDLST	Control IDs for User Overrides	String	Generic Edit	50	Allow NULL?
11	UCOMWPUS1	OMW Project User Future String 1	String	Generic Edit	30	Allow NULL?
12	UCOMWPUS2	OMW Project User Future String 2	String	Generic Edit	30	Allow NULL?
13	UCOMWPUS3	OMW Project User Future String 3	String	Generic Edit	30	Allow NULL?
14	UCOMWPUN1	OMW Project User Future Use Numeric 1	Numeric	Generic Edit	11	Allow NULL?
15	UCOMWPUN2	OMW Project User Future Use Numeric 2	Numeric	Generic Edit	11	Allow NULL?
16	UCOMWPUN3	OMW Project User Future Use Numeric 3	Numeric	Generic Edit	11	Allow NULL?
17	UCPID	Program ID	String	Generic Edit	10	Allow NULL?
18	UCUSER	User ID	String	Generic Edit	10	Allow NULL?
19	UCPMLSTUT	PM UTime Last Updated	JDE UTime	Generic Edit	11
20	UCMKEY	Machine Key	String	Generic Edit	15	Allow NULL?

Number

Description

OID_KEY (Primary/Unique)

Element	Alias	Description	Sequence
1	OID	Java persistent Object Identifier	Ascending

UNIQ_KEY (Unique)

Element	Alias	Description	Sequence
1	OMWOT	Object Management Object Type	Ascending
2	OBNM	Object Name	Ascending
3	VER	Version	Ascending
4	EAP	Application ID	Ascending
5	UGCRPTNM	UGC Report Name	Ascending
6	UGCOWNER	User ID	Ascending
7	EFFUTIME	EffectiveUTime	Descending
8	EXPUTIME	ExpiredUTime	Ascending

OWNER

Element	Alias	Description	Sequence
1	OMWOT	Object Management Object Type	Ascending
2	UGCOWNER	User ID	Ascending
3	OBNM	Object Name	Ascending
4	EAP	Application ID	Ascending
5	VER	Version	Ascending
6	EFFUTIME	EffectiveUTime	Ascending
7	EXPUTIME	ExpiredUTime	Ascending