OAIB - biuan.com SDK Developer - SAP® Business ONE (SBO)

SQL Administration / Received Alerts

DTW User Defined Data

API Message Header / Read

SBO SQL database table details

Field	Description	Type	Constraints	Size	Related	Default	Primary_Key	Unique
AlertCode ^KEY ^UNIQUE	Alert Code	Int		11	OALR Alerts		PRIMARY	Yes
UserSign ^KEY	User Signature	Int		6	OUSR Users		USER	No
Opened	Opened	VarChar	Y) Yes N) No	1		N
RecDate	Receipt Date	Date		8
RecTime	Time Received	Int		6
WasRead ^KEY	Read	VarChar	Y) Yes N) No	1		N	READ	No
Deleted ^KEY	Deleted	VarChar	Y) Yes N) No	1		N	DELETED	No
Failed	Failed	VarChar	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 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

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
OALR SQL Table

OUSR SQL Table

biuan SAP® BUSINESS ONE

Object
MessageHeader

Property
Read

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

Code

Read

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