biuan SAP® BUSINESS ONE SDK
SQL Administration / Sent Messages - User History
API Recipient Collection / Recipient
AOB1 - Sent Messages - User History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AlertCode KEY UNIQUEAlert CodeInt
11OALR
Alerts		PRIMARYYes
ObjTypeObjectnVarChar
-1) Random
12) User
11) Contact Person
20
12
ObjCodeObject CodenVarChar
50
ObjNameNamenVarChar
127
SendIntrnlSent InternallyVarChar
Y) Yes
N) No
1
N
Confirmed1Confirmation 1VarChar
Y) Yes
N) No
1
N
ConfDate1Approval Time 1Date
8
ConfTime1Approval Time 1Int
6
SendEMail KEYSent E-mailVarChar
Y) Yes
N) No
1
NSEND_EMNo
E_MailE-MailnVarChar
100
Confirmed2 KEYConfirmation 2VarChar
Y) Yes
N) No
E) Error
1
NCONFIRMED2No
ConfDate2Authorization Period 2Date
8
ConfTime2Authorization Period 2Int
6
SendSMSSent SMSVarChar
Y) Yes
N) No
1
N
PortNumMobile Phone NumbernVarChar
50
Confirmed3Confirmation 3VarChar
Y) Yes
N) No
E) Error
1
N
ConfDate3Approval Time 3Date
8
ConfTime3Approval Time 3Int
6
SendFaxSent FaxVarChar
Y) Yes
N) No
1
N
FaxFax NumbernVarChar
20
Confirmed4Confirmation 4VarChar
Y) Yes
N) No
E) Error
1
N
ConfDate4Confirmation Date 4Date
8
ConfTime4Confirmation Time 4Int
6

SELECT statement

SELECT AOB1.AlertCode AS 'Alert Code', AOB1.ObjType AS 'Object', AOB1.ObjCode AS 'Object Code', AOB1.ObjName AS 'Name', AOB1.SendIntrnl AS 'Sent Internally', AOB1.Confirmed1 AS 'Confirmation 1', AOB1.ConfDate1 AS 'Approval Time 1', AOB1.ConfTime1 AS 'Approval Time 1', AOB1.SendEMail AS 'Sent E-mail', AOB1.E_Mail AS 'E-Mail', AOB1.Confirmed2 AS 'Confirmation 2', AOB1.ConfDate2 AS 'Authorization Period 2', AOB1.ConfTime2 AS 'Authorization Period 2', AOB1.SendSMS AS 'Sent SMS', AOB1.PortNum AS 'Mobile Phone Number', AOB1.Confirmed3 AS 'Confirmation 3', AOB1.ConfDate3 AS 'Approval Time 3', AOB1.ConfTime3 AS 'Approval Time 3', AOB1.SendFax AS 'Sent Fax', AOB1.Fax AS 'Fax Number', AOB1.Confirmed4 AS 'Confirmation 4', AOB1.ConfDate4 AS 'Confirmation Date 4', AOB1.ConfTime4 AS 'Confirmation Time 4' FROM AOB1 AS AOB1

Related information


Recipient Recipient Object· Table: AOB1
Recipient is a data structure related to the MessagesService. It represents the data of a single recipient of a message or alert. Source table: AOB1.
   Parent: Recipient Collection RecipientCollection Collection

Recipients Recipients Object· Table: AOB1
Recipients is a business object that represents the recipients' list of a message or alert. This object enables you to add recipient information to the recipients list for sending messages. You can use the RecipientCollection and...
   Parent: Messages Messages Object· Table: OALR
Alerts OALR SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates