|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Scheduled Report Run Output
Table Name: SRA2
Table Description: Scheduled Report Run Output
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ActionCode | Action Code | Int | 11 | - | Â | Â | Â |
| Date | Date of Run | Date | 8 | - | Â | Â | Â |
| Time | Time of Run | Int | 11 | - | Â | Â | Â |
| Status | Status | VarChar | 1 | - | 0 | S | Successful |
| Â | Â | Â | Â | Â | Â | E | In progress |
| Â | Â | Â | Â | Â | Â | F | Failure |
| Â | Â | Â | Â | Â | Â | T | Results to Be Distributed |
| Â | Â | Â | Â | Â | Â | 0 | Schedule Inactive |
| Â | Â | Â | Â | Â | Â | 1 | Report Scheduled |
| ReturnCode | Return Code | Int | 11 | - | Â | Â | Â |
| ReturnStr | Return String | nVarChar | 250 | - | Â | Â | Â |
| ResDag | Result in DAG format | Text | 16 | - | Â | Â | Â |
| ResPdf | Result in PDF format | Text | 16 | - | Â | Â | Â |
| ResHtml | Result in HTML format | Text | 16 | - | Â | Â | Â |
| ResXml | Result in XML format | Text | 16 | - | Â | Â | Â |
| Results | Result Availability | nVarChar | 10 | - | NNNN | Â | Â |
| ResLog | Report Creation Log | Text | 16 | - | Â | Â | Â |
| ErrScreen | Error Screenshot | Text | 16 | - | Â | Â | Â |
| EmailPfx | Email Subject Prefix | nVarChar | 254 | - | Â | Â | Â |
| SenderName | Sender Name | nVarChar | 100 | - | Â | Â | Â |
| SenderMail | Sender Email | nVarChar | 100 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | ActionCode |
| Â | Â | Date |
| Â | Â | Time |
| ACTIONCODE | No | ActionCode |