|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Schedules
Table Name: TSCD
Table Description: Schedules
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| SrvcName | Service application name | nVarChar | 20 | - | Â | Â | Â |
| SchedType | Type of schedule | VarChar | 1 | - | P | P | Suspended / Paused |
| Â | Â | Â | Â | Â | Â | O | Once |
| Â | Â | Â | Â | Â | Â | S | Every X seconds |
| Â | Â | Â | Â | Â | Â | M | Every X minutes |
| Â | Â | Â | Â | Â | Â | D | Daily |
| Â | Â | Â | Â | Â | Â | W | Weekly |
| Â | Â | Â | Â | Â | Â | T | Monthly |
| SchedDate | Scheduled date | Date | 8 | - | Â | Â | Â |
| SchedDay | Scheduled day | nVarChar | 2 | - | 1 | Â | Â |
| Interval | Interval | Int | 11 | - | Â | Â | Â |
| LastExDate | Last execution date | Date | 8 | - | Â | Â | Â |
| AutoStart | Auto run when OS starts | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | NO |
| Key | Unique | Field |
| PRIMARY | Yes | SrvcName |
| NAME_SCHED | Yes | SrvcName |
| Â | Â | LastExDate |