|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Alerts
Table Name: OALR
Table Description: Alerts
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| Code | Internal Number | Int | 11 | - | Â | Â | Â |
| Type | Type | VarChar | 1 | - | A | A | Alert |
| Â | Â | Â | Â | Â | Â | M | Message |
| Priority | Priority | VarChar | 1 | - | 1 | 0 | - |
| Â | Â | Â | Â | Â | Â | 1 | Â |
| Â | Â | Â | Â | Â | Â | 2 | mHighPriority |
| TCode | Template Code | Int | 11 | OALT | Â | Â | Â |
| Subject | Subject | nVarChar | 254 | - | Â | Â | Â |
| UserText | MEMO | Text | 16 | - | Â | Â | Â |
| DataCols | No. of Columns | Int | 11 | - | Â | Â | Â |
| DataParams | Data | Text | 16 | - | Â | Â | Â |
| MsgData | Data | Text | 16 | - | Â | Â | Â |
| UserSign | User Signature | Int | 6 | OUSR | Â | Â | Â |
| Attachment | Attached File | Text | 16 | - | Â | Â | Â |
| DataSource | Data Source | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | I | Interface |
| Â | Â | Â | Â | Â | Â | U | Update |
| Â | Â | Â | Â | Â | Â | M | Import |
| Â | Â | Â | Â | Â | Â | O | DI API |
| Â | Â | Â | Â | Â | Â | S | Service Layer |
| Â | Â | Â | Â | Â | Â | W | Web Client |
| Â | Â | Â | Â | Â | Â | A | Doc. Generation Wizard |
| Â | Â | Â | Â | Â | Â | D | Restore Wizard |
| Â | Â | Â | Â | Â | Â | P | Partner Implementation |
| Â | Â | Â | Â | Â | Â | T | Year Transfer |
| AtcEntry | Attachment Entry | Int | 11 | - | Â | Â | Â |
| AltType | Alert Type | VarChar | 1 | - | N | N | Unknown |
| Â | Â | Â | Â | Â | Â | C | Inventory Cycle |
| WddData | Data of Approval Process | nVarChar | 254 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | Code |
| USER | No | UserSign |