|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Queue of messages to be sent
Table Name: ALR1
Table Description: Queue of messages to be sent
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Internal Number | Int | 11 | OALR | Â | Â | Â |
| LineId | Row Number | Int | 11 | - | Â | Â | Â |
| NameFrom | From | nVarChar | 155 | - | Â | Â | Â |
| AddrFrom | Reply Address | nVarChar | 100 | - | Â | Â | Â |
| NameTo | To | nVarChar | 155 | - | Â | Â | Â |
| IsSMS | SMS | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | F | Fax |
| Â | Â | Â | Â | Â | Â | O | MS365 |
| Address | Address | nVarChar | 100 | - | Â | Â | Â |
| Status | Status | VarChar | 1 | - | U | U | Not Sent |
| Â | Â | Â | Â | Â | Â | P | In Process |
| Â | Â | Â | Â | Â | Â | S | Sent |
| ObjType | Object | nVarChar | 20 | - | Â | Â | Â |
| ObjCode | Object Code | nVarChar | 50 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Code |
| Â | Â | LineId |
| STATUS | No | Status |