biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Dunning Letters
API Message Data Columns / Message Data Column
ALR2 - Dynamic message data row Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEInternal NumberInt
11OALR
Alerts
PRIMARYYes
LocationThe order of columns in messageInt
11
ColNameThe column name in messagenVarChar
30
LinkLink IndicationVarChar
N) No
Y) Yes
1
N

SELECT statement

SELECT ALR2.Code AS 'Internal Number', ALR2.Location AS 'The order of columns in message', ALR2.ColName AS 'The column name in message', ALR2.Link AS 'Link Indication' FROM ALR2 AS ALR2

Related information


Message Data Column MessageDataColumn Object· Table: ALR2
MessageDataColumn is a data structure related to the MessagesService. It enables to add one data column to the data columns collection. The MessageDataColumn object contains the title of the column and whether or not it includes a link to a...
   Parent: Message Data Columns MessageDataColumns Collection
Alerts OALR 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