biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Business Partners / Business Partner Priorities / Alerts Template
API Alert Management Service / Alert Management
OALT - Alerts Template Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEInternal NumberInt
11
PRIMARYYes
NameNamenVarChar
127
TypeTypeVarChar
S) System Alert
U) User Alert
1
U
PriorityPriorityVarChar
0
1) Normal
2) High
1
1
Active KEYActive AlertVarChar
Y) Yes
N) No
1
NACTIVENo
NumOfParamNo. of ParametersInt
11
ParamDataParametersText
16
ParamsParametersText
16
NumOfDocsDocuments NumbersInt
11
DocsDataDocumentsText
16
DocsDocumentsText
16
UserTextMEMOText
16
QueryIdQueryInt
11
FrqncyTypeFrequency TypeVarChar
S) Minutes
H) Hours
D) Days
W) Weeks
M) Months
1
H
FrqncyIntrFrequencyInt
11
1
ExecDaYDay of ExecutionInt
6
1
ExecTimeExecution HourInt
11
800
LastDateExecution DateDate
8
LastTIMEExecution TimeInt
6
NextDateNext DateDate
8
NextTimeNext HourInt
6
UserSignUser SignatureInt
6OUSR
Users
HistorySave HistoryVarChar
Y) Yes
N) No
1
N
QCategoryQuery CategoryInt
11OUQR
Queries

Table relationship map

SELECT statement

SELECT OALT.Code AS 'Internal Number', OALT.Name AS 'Name', OALT.Type AS 'Type', OALT.Priority AS 'Priority', OALT.Active AS 'Active Alert', OALT.NumOfParam AS 'No. of Parameters', OALT.ParamData AS 'Parameters', OALT.Params AS 'Parameters', OALT.NumOfDocs AS 'Documents Numbers', OALT.DocsData AS 'Documents', OALT.Docs AS 'Documents', OALT.UserText AS 'MEMO', OALT.QueryId AS 'Query', OALT.FrqncyType AS 'Frequency Type', OALT.FrqncyIntr AS 'Frequency', OALT.ExecDaY AS 'Day of Execution', OALT.ExecTime AS 'Execution Hour', OALT.LastDate AS 'Execution Date', OALT.LastTIME AS 'Execution Time', OALT.NextDate AS 'Next Date', OALT.NextTime AS 'Next Hour', OALT.UserSign AS 'User Signature', OALT.History AS 'Save History', OALT.QCategory AS 'Query Category' FROM OALT AS OALT

Related information


Alert Management AlertManagement Object· Table: OALT
AlertManagement is Data structure related to the AlertManagementService. Source table: OALT.
   Parent: Alert Management Service AlertManagementService Service· Table: OALT

Alert Management Document AlertManagementDocument Object· Table: OALT
AlertManagementDocument is a data structure related to the AlertManagementService. Source table: OALT.
   Parent: Alert Management Documents AlertManagementDocuments Collection· Table: OALT

Alert Management Documents AlertManagementDocuments Collection· Table: OALT
AlertManagementDocuments is a Data Collection of AlertManagementDocument data structures. Source table: OALT.
   Parent: Alert Management AlertManagement Object· Table: OALT

Alert Management Params AlertManagementParams Object· Table: OALT
This object specifies the identification key combination (Code, Name and Type) for which the AlertManagementService is related. Source table: OALT.
   Parent: Alert Management Params Collection AlertManagementParamsCollection Collection· Table: ALT1

Alert Management Service AlertManagementService Service· Table: OALT
AlertManagementService is a business object that manages alert system for SAP Business One application. This object enables you to: Manage system and user alerts. Manage alert's recipients. Define event driven alerts and cyclic alerts....

OALT SQL Table

Queries OUQR 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