|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Scheduled Report Recipients
Table Name: SRA3
Table Description: Scheduled Report Recipients
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| ActionCode | Action Code | Int | 11 | OSRA | Â | Â | Â |
| RecipCode | Recipient Code | Int | 11 | - | Â | Â | Â |
| ObjType | Object Type | nVarChar | 20 | - | Â | Â | Â |
| ObjCode | Object Code | nVarChar | 50 | - | Â | Â | Â |
| Name | Name | nVarChar | 155 | - | Â | Â | Â |
| SendInter | Send Internally | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SendEmail | Send as E-Mail | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| SendSMS | Send as SMS | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| E-Mail Address | nVarChar | 100 | - | Â | Â | Â | |
| Number | Telephone Number | nVarChar | 100 | - | Â | Â | Â |
| AttachDAG | Attach DAG | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AttachPDF | Attach PDF | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| AttachHTML | Attach HTML | VarChar | 1 | - | N | Â | Â |
| AttachXML | Attach XML | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ShowResult | Results Visible to User | VarChar | 1 | - | Y | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Key | Unique | Field |
| PRIMARY | Yes | ActionCode |
| Â | Â | RecipCode |
| USER | No | Name |