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