| 
															
														 | 
			
			
				
															
																
																	
																		
 
Data dictionary stjobh - Job
| 1 | euserid | character | X(12) |   |   |   | User |  | 2 | job_nr | integer | >>>>>>>9 |   |   | 0 | Job |  | 3 | execution_time | integer | ->,>>>,>>9 |   |   | 0 | Next execution time |  | 4 | execution_date | date | 99/99/9999 |   |   |   | Next execution date |  | 5 | euserid_cr | character | X(12) |   |   |   | Creator |  | 6 | date_cr | date | 99/99/9999 |   |   |   | Date created |  | 7 | time_cr | integer | >>>>>9 |   |   | 0 | Time created |  | 8 | source_cr | character | X(8) |   |   |   | Source created |  | 9 | euserid_lc | character | X(12) |   |   |   | Modifier |  | 10 | date_lc | date | 99/99/9999 |   |   |   | Date last changed |  | 11 | time_lc | integer | >>>>>9 |   |   | 0 | Time last changed |  | 12 | source_lc | character | X(8) |   |   |   | Source last changed |  | 13 | program_type | integer | >>>>>9 |   |   | 0 | Program type |  | 14 | table_id | integer | >>>>>>>> |   |   | 0 | Table ID |  | 15 | application_language | character | X(5) |   |   |   | Language |  | 16 | multi_language | character | X(6) |   |   |   | Multi language |  | 17 | date_format | integer | >>>>>9 |   |   | 0 | Date format |  | 18 | numeric_format | integer | >>>>>9 |   |   | 0 | Numeric format |  | 19 | output_to | integer | >>>>>9 |   |   | 0 | Output |  | 20 | frequency | integer | >>>>>9 |   |   | 0 | Frequency |  | 21 | heading | character | X(100) |   |   |   | Heading |  | 22 | printer_portrait | character | X(8) |   |   |   | Printer: Portrait |  | 23 | printer_landscape | character | X(8) |   |   |   | Printer: Landscape |  | 24 | mail_send_to | character | X(200) |   |   |   | Send to |  | 25 | mail_subject | character | X(100) |   |   |   | Subject |  | 26 | mail_body | character | X(2000) |   |   |   | Body |  | 27 | email_attachment_format | integer | >>>>>9 |   |   | 0 | Attachment (Format) |  | 28 | email_printer | character | X(8) |   |   |   | Printer name |  | 29 | once_start_date | date | 99/99/9999 |   |   |   | Once: Start date |  | 30 | once_stime_hours | integer | >9 |   |   | 0 | Once: Start time (Hours) |  | 31 | once_stime_minutes | integer | 99 |   |   | 0 | Once: Start time (Minutes) |  | 32 | daily_start_date | date | 99/99/9999 |   |   |   | Daily: Start date |  | 33 | daily_stime_hours | integer | >9 |   |   | 0 | Daily: Start time (Hours) |  | 34 | daily_stime_minutes | integer | 99 |   |   | 0 | Daily: Start time (Minutes) |  | 35 | daily_frequency | integer | >>>>>9 |   |   | 0 | Daily: Frequency |  | 36 | daily_days | integer | >>9 |   |   | 0 | Daily: Days |  | 37 | daily_repeat | logical | TRUE/FALSE |   |   | FALSE | Daily: Repeat |  | 38 | daily_minutes | integer | >>9 |   |   | 0 | Daily: Minutes |  | 39 | daily_next_job_user | character | X(12) |   |   |   | Daily: Next job (User) |  | 40 | daily_next_job | integer | >>>>>>>> |   |   | 0 | Daily: Next job to run |  | 41 | weekly_stime_hours | integer | >9 |   |   | 0 | Weekly: Start time (Hours) |  | 42 | weekly_stime_minutes | integer | 99 |   |   | 0 | Weekly: Start time (Minutes) |  | 43 | weekly_weeks | integer | >>9 |   |   | 0 | Weekly: Weeks |  | 44 | weekly_monday | logical | TRUE/FALSE |   |   | FALSE | Monday |  | 45 | weekly_tuesday | logical | TRUE/FALSE |   |   | FALSE | Tuesday |  | 46 | weekly_wednesday | logical | TRUE/FALSE |   |   | FALSE | Wednesday |  | 47 | weekly_thursday | logical | TRUE/FALSE |   |   | FALSE | Thursday |  | 48 | weekly_friday | logical | TRUE/FALSE |   |   | FALSE | Friday |  | 49 | weekly_saturday | logical | TRUE/FALSE |   |   | FALSE | Saturday |  | 50 | weekly_sunday | logical | TRUE/FALSE |   |   | FALSE | Sunday |  | 51 | weekly_repeat | logical | TRUE/FALSE |   |   | FALSE | Weekly: Repeat |  | 52 | weekly_minutes | integer | >>9 |   |   | 0 | Weekly: Minutes |  | 53 | weekly_next_job_user | character | X(12) |   |   |   | Weekly: Next job (User) |  | 54 | weekly_next_job | integer | >>>>>>>> |   |   | 0 | Weekly: Next job to run |  | 55 | monthly_stime_hours | integer | >9 |   |   | 0 | Monthly: Start time (Hours) |  | 56 | monthly_stime_minutes | integer | 99 |   |   | 0 | Monthly: Start time (Minutes) |  | 57 | monthly_day_in_month | integer | >9 |   |   | 0 | Day of month |  | 58 | monthly_weekday_in_month | integer | >>>>>9 |   |   | 0 | Weekday of month |  | 59 | monthly_weekday | integer | >>>>>9 |   |   | 0 | Weekday |  | 60 | monthly_january | logical | TRUE/FALSE |   |   | FALSE | January |  | 61 | monthly_february | logical | TRUE/FALSE |   |   | FALSE | February |  | 62 | monthly_march | logical | TRUE/FALSE |   |   | FALSE | March |  | 63 | monthly_april | logical | TRUE/FALSE |   |   | FALSE | April |  | 64 | monthly_may | logical | TRUE/FALSE |   |   | FALSE | May |  | 65 | monthly_june | logical | TRUE/FALSE |   |   | FALSE | June |  | 66 | monthly_july | logical | TRUE/FALSE |   |   | FALSE | July |  | 67 | monthly_august | logical | TRUE/FALSE |   |   | FALSE | August |  | 68 | monthly_september | logical | TRUE/FALSE |   |   | FALSE | September |  | 69 | monthly_october | logical | TRUE/FALSE |   |   | FALSE | October |  | 70 | monthly_november | logical | TRUE/FALSE |   |   | FALSE | November |  | 71 | monthly_december | logical | TRUE/FALSE |   |   | FALSE | December |  | 72 | monthly_repeat | logical | TRUE/FALSE |   |   | FALSE | Monthly: Repeat |  | 73 | monthly_minutes | integer | >>9 |   |   | 0 | Monthly: Minutes |  | 74 | monthly_next_job_user | character | X(12) |   |   |   | Monthly: Next job (User) |  | 75 | monthly_next_job | integer | >>>>>>>> |   |   | 0 | Monthly: Next job to run |  | 76 | linked_next_job_user | character | X(12) |   |   |   | Linked: Next job (User) |  | 77 | linked_next_job | integer | >>>>>>>> |   |   | 0 | Linked: Next job to run |  | 78 | latest_execution_date | date | 99/99/9999 |   |   |   | Start date (Latest) |  | 79 | latest_execution_time | integer | >>>>>>>> |   |   | 0 | Start time (Latest) |  | 80 | job_state | integer | >>>>>9 |   |   | 0 | Status |  | 81 | reference_date | date | 99/99/9999 |   |   |   | Reference date |  
 
 Indexesstjobh01ix - primary - unique| 1 | euserid | character | X(12) | User |  | 2 | job_nr | integer | >>>>>>>9 | Job |  
 stjobh02ix| 1 | execution_date | date | 99/99/9999 | Next execution date |  | 2 | execution_time | integer | ->,>>>,>>9 | Next 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: | 
             Exact Financials
 | 
 Date: | 
01-05-2014 | 
 
     |  Release: | 
      | 
      Attachment: | 
      | 
 
     |  Disclaimer | 
 
 
 
																	 | 
																 
															 
														 |