	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

24 COLUMNS | 4 INDEXES | 920 | H96P | F9645 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H96P: Product Packaging Tools
1	920	F9645	UP	24	4	OneWorld Master Repair File	Install Files	H96P: Product Packaging Tools	System Tables

TOP 920 | H96P | F9645 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	UPCDNAME	CD Name	String	Generic Edit	30	0	Allow NULL?
2	UPMUNUMBER	Update Number	Numeric	Generic Edit	11	0	Allow NULL?
3	UPMUCAT	Update Category	String	UDC (H96 UC)	2	0	Allow NULL?
4	UPMUTYPE	Object Type	String	UDC (98 OF)	4	0	Allow NULL?
5	UPMUNAME	Object Name	String	Generic Edit	10	0	Allow NULL?
6	UPMUNMTHRU	Through Object Name	String	Generic Edit	10	0	Allow NULL?
7	UPMUSTATUS	Update Status	String	UDC (H96 UP)	2	0	Allow NULL?
8	UPMURANGE	Range	String	UDC (H96 UR)	2	0	Allow NULL?
9	UPMUFRMLOC	From Location	String	Generic Edit	30	0	Allow NULL?
10	UPMUFRLOC2	From Secondary Location	String	Generic Edit	30	0	Allow NULL?
11	UPMUPNAME	Package Name	String	Generic Edit	10	0	Allow NULL?
12	UPMUSAR	SAR Number	String	Generic Edit	8	0	Allow NULL?
13	UPMUMJ	Update Date	Date	Generic Edit	6	0
14	UPMUMT	Update Time	Numeric	Generic Edit	6	0	Allow NULL?
15	UPMUFUMJ	Future Use Date	Date	Generic Edit	6	0
16	UPMUFUSTR1	Future Use String	String	Generic Edit	10	0	Allow NULL?
17	UPMUFUSTR2	Future Use String	String	Generic Edit	10	0	Allow NULL?
18	UPMUFUNUM	Future Use Number	Numeric	Generic Edit	11	2	Allow NULL?
19	UPMUFUTR	Future Use Char	Character	Generic Edit	1	0	Allow NULL?
20	UPPID	Program ID	String	Generic Edit	10	0	Allow NULL?
21	UPJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
22	UPUPMJ	Date - Updated	Date	Generic Edit	6	0
23	UPUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
24	UPUSER	User ID	String	Generic Edit	10	0	Allow NULL?

Number

Description

Primary Key (Primary/Unique)

Element	Alias	Description	Sequence
1	CDNAME	CD Name	Ascending
2	MUNUMBER	Update Number	Ascending
3	MUCAT	Update Category	Ascending
4	MUTYPE	Object Type	Ascending
5	MUNAME	Object Name	Ascending
6	MUNMTHRU	Through Object Name	Ascending

Definition Status Key

Element	Alias	Description	Sequence
1	CDNAME	CD Name	Ascending
2	MUSTATUS	Update Status	Ascending

Biggest Update Number Key

Element	Alias	Description	Sequence
1	CDNAME	CD Name	Ascending
2	MUSTATUS	Update Status	Ascending
3	MUNUMBER	Update Number	Descending

Primary without NameThru

Element	Alias	Description	Sequence
1	CDNAME	CD Name	Ascending
2	MUNUMBER	Update Number	Ascending
3	MUCAT	Update Category	Ascending
4	MUTYPE	Object Type	Ascending
5	MUNAME	Object Name	Ascending