	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 | 4 INDEXES | 920 | H98 | F986110 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H98: Internet
1	920	F986110	JC	20	4	Job Control Status Master	Master Files	H98: Internet	System Tables

TOP 920 | H98 | F986110 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	JCJOBQUE	Job Queue	String	UDC (98 JQ)	10	Allow NULL?
2	JCJOBPTY	Job Priority	String	Generic Edit	2	Allow NULL?
3	JCJOBSTS	Job Status	String	UDC (98 JS)	2	Allow NULL?
4	JCENHV	Environment Name	String	Generic Edit	10	Allow NULL?
5	JCUSER	User ID	String	Generic Edit	10	Allow NULL?
6	JCPSWD	Password	String	Generic Edit	10	Allow NULL?
7	JCJOBTYPE	Job Type	String	Generic Edit	2	Allow NULL?
8	JCSBMDATE	Date - Job Submitted	Date	Generic Edit	6
9	JCSBMTIME	Time Job Submitted	Numeric	Generic Edit	7	Allow NULL?
10	JCJOBNBR	Server Job Number	Numeric	Generic Edit	15	Allow NULL?
11	JCEXEHOST	Execution Host Name	String	Generic Edit	40	Allow NULL?
12	JCORGHOST	Origination Host Name	String	Generic Edit	40	Allow NULL?
13	JCPROCESSID	Server Process ID	Numeric	Generic Edit	15	Allow NULL?
14	JCACTDATE	Date - Last Task	Date	Generic Edit	6
15	JCACTTIME	Time - Last Task	Numeric	Generic Edit	7	Allow NULL?
16	JCSRVBLOBA	EnterpriseOne Foundation Blob Buffer	Binary (Blob)	Generic Edit	20000
17	JCFUNO	Object Type	String	UDC (98 OF)	4	Allow NULL?
18	JCPRTQ	Print Queue	String	Generic Edit	10	Allow NULL?
19	JCFNDFUF1	Foundation - Future Use 1	String	Generic Edit	30	Allow NULL?
20	JCFNDFUF2	Foundation - Future Use 2	String	Generic Edit	30	Allow NULL?

Number

Description

Job Control Master Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	EXEHOST	Execution Host Name	Ascending
2	JOBNBR	Server Job Number	Ascending

Job Control Status_Type

Element	Alias	Description	Sequence
1	JOBQUE	Job Queue	Ascending
2	JOBSTS	Job Status	Ascending
3	FUNO	Object Type	Ascending
4	JOBPTY	Job Priority	Ascending

Job Control Status_Priority

Element	Alias	Description	Sequence
1	JOBQUE	Job Queue	Ascending
2	JOBSTS	Job Status	Ascending
3	JOBPTY	Job Priority	Ascending

Job Conrol Status Priority+A

Element	Alias	Description	Sequence
1	EXEHOST	Execution Host Name	Ascending
2	USER	User ID	Ascending
3	JOBQUE	Job Queue	Ascending
4	JOBPTY	Job Priority	Ascending
5	JOBSTS	Job Status	Ascending