biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Business Partners / BPFiscalRegistryID
API Messages Service / Message
OALR - Alerts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEInternal NumberInt
11
PRIMARYYes
TypeTypeVarChar
A) Alert
M) Message
1
A
PriorityPriorityVarChar
0
1)
2) mHighPriority
1
1
TCodeTemplate CodeInt
11OALT
Alerts Template
SubjectSubjectnVarChar
127
UserTextMEMOText
16
DataColsNo. of ColumnsInt
11
DataParamsDataText
16
MsgDataDataText
16
UserSign KEYUser SignatureInt
6OUSR
Users
USERNo
AttachmentAttached FileText
16
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
AtcEntryAttachment EntryInt
11
AltTypeAlert TypeVarChar
N) Unknown
C) Inventory Cycle
1
N

Table relationship map

SELECT statement

SELECT OALR.Code AS 'Internal Number', OALR.Type AS 'Type', OALR.Priority AS 'Priority', OALR.TCode AS 'Template Code', OALR.Subject AS 'Subject', OALR.UserText AS 'MEMO', OALR.DataCols AS 'No. of Columns', OALR.DataParams AS 'Data', OALR.MsgData AS 'Data', OALR.UserSign AS 'User Signature', OALR.Attachment AS 'Attached File', OALR.DataSource AS 'Data Source', OALR.AtcEntry AS 'Attachment Entry', OALR.AltType AS 'Alert Type' FROM OALR AS OALR

Related information


Message Message Object· Table: OALR
Message is a data structure related to the MessagesService. It includes properties related to the message content, such as subject, text, attached file, and attached data. Source table: OALR.
   Parent: Messages Service MessagesService Service

Messages Messages Object· Table: OALR
Messages is a business object that represents the messages in the Administration module. This object enables you to send messages through SAP Business One messaging service. You can use the MessagesService, which enables more functions than the
OALR SQL Table

Alerts Template OALT 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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates