	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

63 COLUMNS | 9 INDEXES | 812 | H91 | F91300 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H91: Design Tools
1	812	F91300	SJ	63	9	Schedule Job Master	Extra Features Files	H91: Design Tools	System Tables

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT SJSCHJBTYP, SJSCHJBNM, SJSCHRPTNM, SJSCHVER, SJPROCNAME, SJSCHSTTIME, SJSCHENTIME, SJNUMJOBOCC, SJCURRUNCNT, SJMAXRESUB, SJSCHJBSTAT, SJSCHENHV, SJSCHJOBSVR, SJSCHUSER, SJSCHPSWD, SJSCHROLE, SJJDELOG, SJTRACING, SJUBELOGLVL, SJSCHPI, SJPNTR, SJJOBQUE, SJRESBONERR, SJRESBTIME, SJINPRTMOTPY, SJINPRMAX, SJINPRTMOUT, SJJOBEXPIRE, SJSCHRCRTYP, SJCO, SJSCHNUMMNS, SJSCHNUMHRS, SJSCHNUMDY, SJSCHNUMWKS, SJSCHNUMMN, SJSCHDAY, SJWEEKDAY, SJWEEKEND, SJMONDAY, SJTUESDAY, SJWEDNESDAY, SJTHURSDAY, SJFRIDAY, SJSATURDAY, SJSUNDAY, SJTIMEZONES, SJDAYLIGHTSV, SJDSAVNAME, SJSCHCTCD01, SJSCHCTCD02, SJSCHCTCD03, SJSCHCTCD04, SJSCHCTCD05, SJSCHFU1, SJSCHFU2, SJSCHFU3, SJSCHFU4, SJUSER, SJPID, SJJOBN, SJUPMJ, SJUPMT, SJSCHPWD FROM F91300

TOP 812 | H91 | F91300 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	SJSCHJBTYP	Scheduled Job Type	String	UDC (H91 JT)	2	Allow NULL?
2	SJSCHJBNM	Scheduled Job Name	String	Generic Edit	30	Allow NULL?
3	SJSCHRPTNM	Scheduled Report Name	String	Generic Edit	10	Allow NULL?
4	SJSCHVER	Scheduled Version	String	Generic Edit	10	Allow NULL?
5	SJPROCNAME	Process ID	String	Generic Edit	10	Allow NULL?
6	SJSCHSTTIME	Scheduled Start ANSI C UTC Time	Numeric	Generic Edit	15	Allow NULL?
7	SJSCHENTIME	Scheduled End ANSI C UTC Time	Numeric	Generic Edit	15	Allow NULL?
8	SJNUMJOBOCC	Number Of Job Occurences	Numeric	Generic Edit	9	Allow NULL?
9	SJCURRUNCNT	Number Of Runs	Numeric	Generic Edit	9	Allow NULL?
10	SJMAXRESUB	Max Number of Job re-submissions	Integer	Generic Edit	9	Allow NULL?
11	SJSCHJBSTAT	Scheduled Job Status	String	UDC (H91 JS)	2	Allow NULL?
12	SJSCHENHV	Environment job will be launched in	String	Generic Edit	10	Allow NULL?
13	SJSCHJOBSVR	Server scheduled job will be launched on	String	Generic Edit	30	Allow NULL?
14	SJSCHUSER	User the job will be launched with	String	Generic Edit	10	Allow NULL?
15	SJSCHPSWD	Password to be used to launch job	String	Generic Edit	10	Allow NULL?
16	SJSCHROLE	Scheduled User Role	String	Generic Edit	15	Allow NULL?
17	SJJDELOG	Logging (JDE.log)	Character	Generic Edit	1	Allow NULL?
18	SJTRACING	Tracing	Character	Generic Edit	1	Allow NULL?
19	SJUBELOGLVL	UBE Logging Level	Character	UDC (H93 LL)	1	Allow NULL?
20	SJSCHPI	Scheduler - Print Immediate Flag	Character	Generic Edit	1	Allow NULL?
21	SJPNTR	Printer Name	String	Generic Edit	30	Allow NULL?
22	SJJOBQUE	Job Queue	String	UDC (98 JQ)	10	Allow NULL?
23	SJRESBONERR	Policy to resubmit on job error	String	UDC (H91 RE)	2	Allow NULL?
24	SJRESBTIME	Time delay before resubmitting error job	Numeric	Generic Edit	15	Allow NULL?
25	SJINPRTMOTPY	In Process Time Out Policy	String	UDC (H91 TO)	2	Allow NULL?
26	SJINPRMAX	Maximum time a job should be in process	Numeric	Generic Edit	15	Allow NULL?
27	SJINPRTMOUT	Delay until resubmitting a time out job	Numeric	Generic Edit	15	Allow NULL?
28	SJJOBEXPIRE	Job expires this many minutes after strt	Numeric	Generic Edit	15	Allow NULL?
29	SJSCHRCRTYP	Recurrenc Type	String	UDC (H91 RC)	2	Allow NULL?
30	SJCO	Company	String	Generic Edit	5	Allow NULL?
31	SJSCHNUMMNS	Scheduled Minutes	Numeric	Generic Edit	5	Allow NULL?
32	SJSCHNUMHRS	Scheduled Hours	Numeric	Generic Edit	5	Allow NULL?
33	SJSCHNUMDY	Scheduled Days	Numeric	Generic Edit	9	Allow NULL?
34	SJSCHNUMWKS	Scheduled Weeks	Numeric	UDC	5	Allow NULL?
35	SJSCHNUMMN	Scheduled Month	Numeric	Generic Edit	5	Allow NULL?
36	SJSCHDAY	Day	Character	Generic Edit	1	Allow NULL?
37	SJWEEKDAY	Weekday	Character	Generic Edit	1	Allow NULL?
38	SJWEEKEND	Weekend	Character	Generic Edit	1	Allow NULL?
39	SJMONDAY	Monday	Character	Generic Edit	1	Allow NULL?
40	SJTUESDAY	Tuesday	Character	Generic Edit	1	Allow NULL?
41	SJWEDNESDAY	Wednesday	Character	Generic Edit	1	Allow NULL?
42	SJTHURSDAY	Thursday	Character	Generic Edit	1	Allow NULL?
43	SJFRIDAY	Friday	Character	Generic Edit	1	Allow NULL?
44	SJSATURDAY	Saturday	Character	Generic Edit	1	Allow NULL?
45	SJSUNDAY	Sunday	Character	Generic Edit	1	Allow NULL?
46	SJTIMEZONES	Time Zone List	String	UDC (H91 TZ)	2	Allow NULL?
47	SJDAYLIGHTSV	Adjust local time for daylight savings	Character	Generic Edit	1	Allow NULL?
48	SJDSAVNAME	Daylight Savings Rule Name	String	UDC	10	Allow NULL?
49	SJSCHCTCD01	Scheduler Category Code 1	String	UDC (H91 1S)	6	Allow NULL?
50	SJSCHCTCD02	Scheduler Category Code 2	String	UDC (H91 2S)	6	Allow NULL?
51	SJSCHCTCD03	Scheduler Category Code 3	String	UDC (H91 3S)	6	Allow NULL?
52	SJSCHCTCD04	Scheduler Category Code 4	String	UDC (H91 4S)	6	Allow NULL?
53	SJSCHCTCD05	Scheduler Category Code 5	String	UDC (H91 5S)	6	Allow NULL?
54	SJSCHFU1	Numeric Future Use 1	Numeric	Generic Edit	15	Allow NULL?
55	SJSCHFU2	Numeric Future Use 2	Numeric	Generic Edit	15	Allow NULL?
56	SJSCHFU3	String Future Use 3	String	Generic Edit	30	Allow NULL?
57	SJSCHFU4	String Future Use 4	String	Generic Edit	30	Allow NULL?
58	SJUSER	User ID	String	Generic Edit	10	Allow NULL?
59	SJPID	Program ID	String	Generic Edit	10	Allow NULL?
60	SJJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
61	SJUPMJ	Date - Updated	Date	Generic Edit	6
62	SJUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
63	SJSCHPWD	User Password for Scheduled Job	Binary (Blob)	Generic Edit	4196

TOP 812 | H91 | F91300 INDEXES

Number

Description

Job Name (Primary/Unique)

Element	Alias	Description	Sequence
1	SCHJBNM	Scheduled Job Name	Ascending

Report Name Version

Element	Alias	Description	Sequence
1	SCHRPTNM	Scheduled Report Name	Ascending
2	SCHVER	Scheduled Version	Ascending

WorkFlow Process

Element	Alias	Description	Sequence
1	PROCNAME	Process ID	Ascending

Job Type

Element	Alias	Description	Sequence
1	SCHJBTYP	Scheduled Job Type	Ascending

StartDateTime

Element	Alias	Description	Sequence
1	SCHSTTIME	Scheduled Start ANSI C UTC Time	Ascending

Category Codes

Element	Alias	Description	Sequence
1	SCHCTCD01	Scheduler Category Code 1	Ascending
2	SCHCTCD02	Scheduler Category Code 2	Ascending
3	SCHCTCD03	Scheduler Category Code 3	Ascending
4	SCHCTCD04	Scheduler Category Code 4	Ascending
5	SCHCTCD05	Scheduler Category Code 5	Ascending

User Server Env

Element	Alias	Description	Sequence
1	SCHUSER	User the job will be launched with	Ascending
2	SCHJOBSVR	Server scheduled job will be launched on	Ascending
3	SCHENHV	Environment job will be launched in	Ascending

Error Policy

Element	Alias	Description	Sequence
1	RESBONERR	Policy to resubmit on job error	Ascending

Time Out Policy

Element	Alias	Description	Sequence
1	INPRTMOTPY	In Process Time Out Policy	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

63 COLUMNS | 9 INDEXES | 812 | H91 | F91300 TABLE

TOP 812 | H91 | F91300 COLUMNS

TOP 812 | H91 | F91300 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

63 COLUMNS | 9 INDEXES | 812 | H91 | F91300 TABLE

TOP812 | H91 | F91300 COLUMNS

TOP812 | H91 | F91300 INDEXES

TOP 812 | H91 | F91300 COLUMNS

TOP 812 | H91 | F91300 INDEXES