|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Backend scheduling job
Table Name: OBSJ
Table Description: Backend scheduling job
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ID | Job ID | Int | 11 | - | Â | Â | Â |
| Type | Job Type | nVarChar | 100 | - | Â | Â | Â |
| Desc | Description | nVarChar | 100 | - | Â | Â | Â |
| Status | Status | VarChar | 1 | - | S | S | Scheduled |
| Â | Â | Â | Â | Â | Â | R | Running |
| Â | Â | Â | Â | Â | Â | E | Error |
| Â | Â | Â | Â | Â | Â | F | Finished |
| Â | Â | Â | Â | Â | Â | P | Pending |
| Â | Â | Â | Â | Â | Â | C | Creating |
| Â | Â | Â | Â | Â | Â | K | Cancel |
| Schedule | Schedule Type | VarChar | 1 | - | O | O | Once |
| NextDate | Next Running Date | Date | 8 | - | Â | Â | Â |
| NextTime | Next Running Time | Int | 6 | - | Â | Â | Â |
| BFParams | Begin Function Parameters | Text | 16 | - | Â | Â | Â |
| EFParams | End Function Parameters | Text | 16 | - | Â | Â | Â |
| BFRetry | Begin Function Retry Times | Int | 11 | - | 0 | Â | Â |
| EFRetry | End Function Retry Times | Int | 11 | - | 0 | Â | Â |
| RunAs | Callback Run as User | Int | 6 | OUSR | Â | Â | Â |
| Message | Status Message | nVarChar | 200 | - | Â | Â | Â |
| RunType | Run Type | VarChar | 1 | - | M | M | Manual |
| Â | Â | Â | Â | Â | Â | A | Automatic |
| RunAt | Execution For | VarChar | 1 | - | Â | S | Scheduled Task |
| Â | Â | Â | Â | Â | Â | A | Ad-Hoc Task |
| CreateDate | Creation Date | Date | 8 | - | Â | Â | Â |
| CreateTime | Creation Time | Int | 11 | - | Â | Â | Â |
| NavParam | Navigation Target Parameters | nVarChar | 200 | - | Â | Â | Â |
| JobType | Job Type | Int | 11 | - | Â | 157 | Payment Wizard |
| Â | Â | Â | Â | Â | Â | 1730000000 | EDF Wizard |
| Â | Â | Â | Â | Â | Â | 234003336 | DATEV Export |
| Â | Â | Â | Â | Â | Â | -20000 | Test Wizard |
| RefEntry | Reference Entry | Int | 11 | - | Â | Â | Â |
| StartDate | Start Date | Date | 8 | - | Â | Â | Â |
| StartTime | Start Time | Int | 11 | - | Â | Â | Â |
| EndDate | End Date | Date | 8 | - | Â | Â | Â |
| EndTime | End Time | Int | 11 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ID |