biuan SAP® BUSINESS ONE SDK
DTW User Defined Data
API Message Header / Read
OAIB - Received Alerts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AlertCode KEY UNIQUEAlert CodeInt
11OALR
Alerts
PRIMARYYes
UserSign KEYUser SignatureInt
6OUSR
Users
USERNo
OpenedOpenedVarChar
Y) Yes
N) No
1
N
RecDateReceipt DateDate
8
RecTimeTime ReceivedInt
6
WasRead KEYReadVarChar
Y) Yes
N) No
1
NREADNo
Deleted KEYDeletedVarChar
Y) Yes
N) No
1
NDELETEDNo
FailedFailedVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT OAIB.AlertCode AS 'Alert Code', OAIB.UserSign AS 'User Signature', OAIB.Opened AS 'Opened', OAIB.RecDate AS 'Receipt Date', OAIB.RecTime AS 'Time Received', OAIB.WasRead AS 'Read', OAIB.Deleted AS 'Deleted', OAIB.Failed AS 'Failed' FROM OAIB AS OAIB

Related information


Read Read Property· Table: OAIB
Determines whether or not the message was read by the recipient (see OAIB table). Field name: WasRead.
   Parent: Message Header MessageHeader Object

Message Header MessageHeader Object
MessageHeader is a data structure related to the MessagesService. The data is stored temporarily in the memory in a virtual table (at a later stage, the data is stored in the OAOB and OAIB tables). Source tables: OAOB (Message Sent). OAIB...
   Parent: Message Headers MessageHeaders Collection
Alerts OALR SQL Table

Users OUSR 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