	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 | 812 | H96P | F96409 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H96P: Product Packaging Tools
1	812	F96409	EM	20	3	Software Update E-mail Notification	Files	H96P: Product Packaging Tools

TOP 812 | H96P | F96409 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	EMESUP	ESU Prefix	String	Generic Edit	10	Allow NULL?
2	EMSUTYPE	Software Update Type	String	UDC (H96 UT)	2	Allow NULL?
3	EMHOSTTYPE	Host Type	String	UDC (H90 HT)	2	Allow NULL?
4	EMSUEMAIL	Email Address of the User	String	Generic Edit	255	Allow NULL?
5	EMSUEMACTV	Software Update Active E-mail	Character	UDC (H96P AE)	1	Allow NULL?
6	EMSUEMSTAT	Software Update E-mail Status	Character	UDC (H96P ES)	1	Allow NULL?
7	EMSUNOTYPE	Software Update Notification Type	String	UDC (H96P NT)	2	Allow NULL?
8	EMSUNOSRC	Software Update Notification Type Source	String	Generic Edit	40	Allow NULL?
9	EMSUF1CHAR	Software Update Future Use Character	Character	Generic Edit	1	Allow NULL?
10	EMSUF2CHAR	Software Update Future Use Character	Character	Generic Edit	1	Allow NULL?
11	EMSUF1NUM	Software Update Future Use Numeric	Numeric	Generic Edit	15	Allow NULL?
12	EMSUF2NUM	Software Update Future Use Numeric	Numeric	Generic Edit	15	Allow NULL?
13	EMSUF1STR	Software Update Future Use String	String	Generic Edit	10	Allow NULL?
14	EMSUF2STR	Software Update Future Use String	String	Generic Edit	30	Allow NULL?
15	EMSUFDATE	Software Update Future Use Date	Date	Generic Edit	6
16	EMSUFTIME	Software Update Future Use Time	Numeric	Generic Edit	6	Allow NULL?
17	EMJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
18	EMUSER	User ID	String	Generic Edit	10	Allow NULL?
19	EMUPMJ	Date - Updated	Date	Generic Edit	6
20	EMUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	ESUP	ESU Prefix	Ascending
2	SUTYPE	Software Update Type	Ascending
3	HOSTTYPE	Host Type	Ascending
4	SUEMAIL	Email Address of the User	Ascending

Active

Element	Alias	Description	Sequence
1	ESUP	ESU Prefix	Ascending
2	SUTYPE	Software Update Type	Ascending
3	HOSTTYPE	Host Type	Ascending
4	SUEMACTV	Software Update Active E-mail	Ascending

NotificationTypeSource

Element	Alias	Description	Sequence
1	ESUP	ESU Prefix	Ascending
2	SUTYPE	Software Update Type	Ascending
3	HOSTTYPE	Host Type	Ascending
4	SUNOSRC	Software Update Notification Type Source	Ascending