|
|
SQL Administration / Alerts
DTW Administration / Setup / Business Partners / BPFiscalRegistryID
API Messages Service / Message
OALR - Alerts Table
Message Message Object· Table: OALR
Parent: Messages Service MessagesService Service
Messages Messages Object· Table: OALR
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Type | Type | VarChar | A) Alert M) Message | 1 | A | |||
| Priority | Priority | VarChar | 0 1) 2) mHighPriority | 1 | 1 | |||
| TCode | Template Code | Int | 11 | OALT Alerts Template | ||||
| Subject | Subject | nVarChar | 127 | |||||
| UserText | MEMO | Text | 16 | |||||
| DataCols | No. of Columns | Int | 11 | |||||
| DataParams | Data | Text | 16 | |||||
| MsgData | Data | Text | 16 | |||||
| UserSign KEY | User Signature | Int | 6 | OUSR Users | USER | No | ||
| Attachment | Attached File | Text | 16 | |||||
| DataSource | Data Source | VarChar | 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 | |||
| AtcEntry | Attachment Entry | Int | 11 | |||||
| AltType | Alert Type | VarChar | 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 ServiceMessages 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
OALR SQL Table
Alerts Template OALT SQL Table
Users OUSR SQL Table
MessagesService
Object
Message
Collection
Method
Property
Attachment
DB
Priority
DB
Subject
DB
Text
DB
User
DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
