SAP Business One SDK 10.0 - Database Tables Reference
-
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 |
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 |