One moment please...
 
 
Exact Financials   
 

Data dictionary stjobh - Job

#Field nameData typeFormatDecExtentDefaultLabel
1euseridcharacterX(12) User
2job_nrinteger>>>>>>>9 0Job
3execution_timeinteger->,>>>,>>9 0Next execution time
4execution_datedate99/99/9999 Next execution date
5euserid_crcharacterX(12) Creator
6date_crdate99/99/9999 Date created
7time_crinteger>>>>>9 0Time created
8source_crcharacterX(8) Source created
9euserid_lccharacterX(12) Modifier
10date_lcdate99/99/9999 Date last changed
11time_lcinteger>>>>>9 0Time last changed
12source_lccharacterX(8) Source last changed
13program_typeinteger>>>>>9 0Program type
14table_idinteger>>>>>>>> 0Table ID
15application_languagecharacterX(5) Language
16multi_languagecharacterX(6) Multi language
17date_formatinteger>>>>>9 0Date format
18numeric_formatinteger>>>>>9 0Numeric format
19output_tointeger>>>>>9 0Output
20frequencyinteger>>>>>9 0Frequency
21headingcharacterX(100) Heading
22printer_portraitcharacterX(8) Printer: Portrait
23printer_landscapecharacterX(8) Printer: Landscape
24mail_send_tocharacterX(200) Send to
25mail_subjectcharacterX(100) Subject
26mail_bodycharacterX(2000) Body
27email_attachment_formatinteger>>>>>9 0Attachment (Format)
28email_printercharacterX(8) Printer name
29once_start_datedate99/99/9999 Once: Start date
30once_stime_hoursinteger>9 0Once: Start time (Hours)
31once_stime_minutesinteger99 0Once: Start time (Minutes)
32daily_start_datedate99/99/9999 Daily: Start date
33daily_stime_hoursinteger>9 0Daily: Start time (Hours)
34daily_stime_minutesinteger99 0Daily: Start time (Minutes)
35daily_frequencyinteger>>>>>9 0Daily: Frequency
36daily_daysinteger>>9 0Daily: Days
37daily_repeatlogicalTRUE/FALSE FALSEDaily: Repeat
38daily_minutesinteger>>9 0Daily: Minutes
39daily_next_job_usercharacterX(12) Daily: Next job (User)
40daily_next_jobinteger>>>>>>>> 0Daily: Next job to run
41weekly_stime_hoursinteger>9 0Weekly: Start time (Hours)
42weekly_stime_minutesinteger99 0Weekly: Start time (Minutes)
43weekly_weeksinteger>>9 0Weekly: Weeks
44weekly_mondaylogicalTRUE/FALSE FALSEMonday
45weekly_tuesdaylogicalTRUE/FALSE FALSETuesday
46weekly_wednesdaylogicalTRUE/FALSE FALSEWednesday
47weekly_thursdaylogicalTRUE/FALSE FALSEThursday
48weekly_fridaylogicalTRUE/FALSE FALSEFriday
49weekly_saturdaylogicalTRUE/FALSE FALSESaturday
50weekly_sundaylogicalTRUE/FALSE FALSESunday
51weekly_repeatlogicalTRUE/FALSE FALSEWeekly: Repeat
52weekly_minutesinteger>>9 0Weekly: Minutes
53weekly_next_job_usercharacterX(12) Weekly: Next job (User)
54weekly_next_jobinteger>>>>>>>> 0Weekly: Next job to run
55monthly_stime_hoursinteger>9 0Monthly: Start time (Hours)
56monthly_stime_minutesinteger99 0Monthly: Start time (Minutes)
57monthly_day_in_monthinteger>9 0Day of month
58monthly_weekday_in_monthinteger>>>>>9 0Weekday of month
59monthly_weekdayinteger>>>>>9 0Weekday
60monthly_januarylogicalTRUE/FALSE FALSEJanuary
61monthly_februarylogicalTRUE/FALSE FALSEFebruary
62monthly_marchlogicalTRUE/FALSE FALSEMarch
63monthly_aprillogicalTRUE/FALSE FALSEApril
64monthly_maylogicalTRUE/FALSE FALSEMay
65monthly_junelogicalTRUE/FALSE FALSEJune
66monthly_julylogicalTRUE/FALSE FALSEJuly
67monthly_augustlogicalTRUE/FALSE FALSEAugust
68monthly_septemberlogicalTRUE/FALSE FALSESeptember
69monthly_octoberlogicalTRUE/FALSE FALSEOctober
70monthly_novemberlogicalTRUE/FALSE FALSENovember
71monthly_decemberlogicalTRUE/FALSE FALSEDecember
72monthly_repeatlogicalTRUE/FALSE FALSEMonthly: Repeat
73monthly_minutesinteger>>9 0Monthly: Minutes
74monthly_next_job_usercharacterX(12) Monthly: Next job (User)
75monthly_next_jobinteger>>>>>>>> 0Monthly: Next job to run
76linked_next_job_usercharacterX(12) Linked: Next job (User)
77linked_next_jobinteger>>>>>>>> 0Linked: Next job to run
78latest_execution_datedate99/99/9999 Start date (Latest)
79latest_execution_timeinteger>>>>>>>> 0Start time (Latest)
80job_stateinteger>>>>>9 0Status
81reference_datedate99/99/9999 Reference date

Indexes

stjobh01ix - primary - unique

#Field nameData typeFormatDescription
1euseridcharacterX(12)User
2job_nrinteger>>>>>>>9Job

stjobh02ix

#Field nameData typeFormatDescription
1execution_datedate99/99/9999Next execution date
2execution_timeinteger->,>>>,>>9Next execution time

Contents > stjobh

     
 Main Category: Support Product Know How  Document Type: Support - On-line help
 Category: On-line help files  Security  level: All - 0
 Sub category: Details  Document ID: 25.809.696
 Assortment:  Date: 01-05-2014
 Release:  Attachment:
 Disclaimer