	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

25 COLUMNS | 5 INDEXES | 920 | H98 | F986113 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H98: Internet
1	920	F986113	SS	25	5	Subsystem Job Master	Master Files	H98: Internet	System Tables

TOP 920 | H98 | F986113 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SSPID	Program ID	String	Generic Edit	10	0	Allow NULL?
2	SSVERS	Version History	String	Generic Edit	10	0	Allow NULL?
3	SSJOBNBR	Server Job Number	Numeric	Generic Edit	15	0	Allow NULL?
4	SSJOBSTS	Job Status	String	UDC (98 JS)	2	0	Allow NULL?
5	SSOPCR	UBE Option Code	Character	UDC (98 CR)	1	0	Allow NULL?
6	SSEXEHOST	Execution Host Name	String	Generic Edit	40	0	Allow NULL?
7	SSORGHOST	Origination Host Name	String	Generic Edit	40	0	Allow NULL?
8	SSENHV	Environment Name	String	Generic Edit	10	0	Allow NULL?
9	SSUSER	User ID	String	Generic Edit	10	0	Allow NULL?
10	SSPSWD	Password	String	Generic Edit	10	0	Allow NULL?
11	SSSBMDATE	Date - Job Submitted	Date	Generic Edit	6	0
12	SSSBMTIME	Time Job Submitted	Numeric	Generic Edit	7	0	Allow NULL?
13	SSJOBPTY	Job Priority	String	Generic Edit	2	0	Allow NULL?
14	SSACTDATE	Date - Last Task	Date	Generic Edit	6	0
15	SSACTTIME	Time - Last Task	Numeric	Generic Edit	7	0	Allow NULL?
16	SSFUNO	Object Type	String	UDC (98 OF)	4	0	Allow NULL?
17	SSKOPT	Optional Item	Character	UDC (H00 KO)	1	0	Allow NULL?
18	SSSRVBLOBA	EnterpriseOne Foundation Blob Buffer	Binary (Blob)	Generic Edit	20000	0
19	SSFNDFUF1	Foundation - Future Use 1	String	Generic Edit	30	0	Allow NULL?
20	SSFNDFUF2	Foundation - Future Use 2	String	Generic Edit	30	0	Allow NULL?
21	SSMATH01	Math Numeric 01	Numeric	Generic Edit	15	2	Allow NULL?
22	SSMATH02	Math Numeric 02	Numeric	Generic Edit	15	2	Allow NULL?
23	SSPROCESSID	Server Process ID	Numeric	Generic Edit	15	0	Allow NULL?
24	SSDATE01	Date 01	Date	Generic Edit	6	0
25	SSDATE02	Date 02	Date	Generic Edit	6	0

Number

Description

Primary Key (Primary/Unique)

Element	Alias	Description	Sequence
1	PID	Program ID	Ascending
2	VERS	Version History	Ascending
3	SBMDATE	Date - Job Submitted	Ascending
4	SBMTIME	Time Job Submitted	Ascending
5	JOBSTS	Job Status	Ascending
6	OPCR	UBE Option Code	Ascending
7	ENHV	Environment Name	Ascending
8	JOBNBR	Server Job Number	Ascending
9	USER	User ID	Ascending
10	ORGHOST	Origination Host Name	Ascending

Key3

Element	Alias	Description	Sequence
1	PID	Program ID	Ascending
2	VERS	Version History	Ascending
3	SBMDATE	Date - Job Submitted	Ascending
4	SBMTIME	Time Job Submitted	Ascending
5	JOBSTS	Job Status	Ascending
6	OPCR	UBE Option Code	Ascending
7	ENHV	Environment Name	Ascending
8	JOBNBR	Server Job Number	Ascending
9	USER	User ID	Ascending
10	EXEHOST	Execution Host Name	Ascending

PID VERS ENHV OPCR Date Time

Element	Alias	Description	Sequence
1	PID	Program ID	Ascending
2	VERS	Version History	Ascending
3	ENHV	Environment Name	Ascending
4	OPCR	UBE Option Code	Ascending
5	SBMDATE	Date - Job Submitted	Ascending
6	SBMTIME	Time Job Submitted	Ascending

PID VERS HOST STAT

Element	Alias	Description	Sequence
1	PID	Program ID	Ascending
2	VERS	Version History	Ascending
3	EXEHOST	Execution Host Name	Ascending
4	JOBSTS	Job Status	Ascending

OPCR JOBNBR PID VERS ...

Element	Alias	Description	Sequence
1	OPCR	UBE Option Code	Ascending
2	JOBNBR	Server Job Number	Ascending
3	PID	Program ID	Ascending
4	VERS	Version History	Ascending
5	SBMDATE	Date - Job Submitted	Ascending
6	SBMTIME	Time Job Submitted	Ascending
7	JOBSTS	Job Status	Ascending
8	ENHV	Environment Name	Ascending
9	USER	User ID	Ascending
10	ORGHOST	Origination Host Name	Ascending