|
|
SAP Business One SDK 10.0 - Database Tables Reference |
Sent Messages - User History
Table Name: AOB1
Table Description: Sent Messages - User History
| Field | Description | Type | Size | Related | Default Value | Constraints | |
| AlertCode | Alert Code | Int | 11 | OALR | Â | Â | Â |
| ObjType | Object | nVarChar | 20 | - | 12 | -1 | Random |
| Â | Â | Â | Â | Â | Â | 12 | User |
| Â | Â | Â | Â | Â | Â | 11 | Contact Person |
| ObjCode | Object Code | nVarChar | 50 | - | Â | Â | Â |
| ObjName | Name | nVarChar | 155 | - | Â | Â | Â |
| SendIntrnl | Sent Internally | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Confirmed1 | Confirmation 1 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| ConfDate1 | Approval Time 1 | Date | 8 | - | Â | Â | Â |
| ConfTime1 | Approval Time 1 | Int | 6 | - | Â | Â | Â |
| SendEMail | Sent E-mail | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| E_Mail | nVarChar | 100 | - | Â | Â | Â | |
| Info2 | Information 2 | Text | 16 | - | Â | Â | Â |
| Confirmed2 | Confirmation 2 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | E | Error |
| ConfDate2 | Authorization Period 2 | Date | 8 | - | Â | Â | Â |
| ConfTime2 | Authorization Period 2 | Int | 6 | - | Â | Â | Â |
| SendSMS | Sent SMS | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| PortNum | Mobile Phone Number | nVarChar | 50 | - | Â | Â | Â |
| Confirmed3 | Confirmation 3 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | E | Error |
| ConfDate3 | Approval Time 3 | Date | 8 | - | Â | Â | Â |
| ConfTime3 | Approval Time 3 | Int | 6 | - | Â | Â | Â |
| SendFax | Sent Fax | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Fax | Fax Number | nVarChar | 50 | - | Â | Â | Â |
| Confirmed4 | Confirmation 4 | VarChar | 1 | - | N | Y | Yes |
| Â | Â | Â | Â | Â | Â | N | No |
| Â | Â | Â | Â | Â | Â | E | Error |
| ConfDate4 | Confirmation Date 4 | Date | 8 | - | Â | Â | Â |
| ConfTime4 | Confirmation Time 4 | Int | 6 | - | Â | Â | Â |
| Key | Unique | Field |
| PRIMARY | Yes | AlertCode |
| Â | Â | ObjType |
| Â | Â | ObjCode |
| SEND_EM | No | SendEMail |
| CONFIRMED2 | No | Confirmed2 |