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

SQL Administration / Dynamic message data cells

DTW Business Partners / Deduction Tax Hierarchies

API Message Data Lines / Message Data Line

SBO SQL database table details

Field	Description	Type	Size	Related	Primary_Key	Unique
Code ^KEY ^UNIQUE	Internal Number	Int	11	OALR Alerts	PRIMARY	Yes
Location	Number of Column in Message	Int	11
Line	Number of Column in Message	Int	11
Value	The column/row value	nVarChar	127
ObjType	The linked object	nVarChar	20
KeyStr	Key string in linked object	nVarChar	127

SELECT statement

SELECT
   ALR3.Code AS 'Internal Number', 
   ALR3.Location AS 'Number of Column in Message', 
   ALR3.Line AS 'Number of Column in Message', 
   ALR3.Value AS 'The column/row value', 
   ALR3.ObjType AS 'The linked object', 
   ALR3.KeyStr AS 'Key string in linked object'
FROM ALR3 AS ALR3

Related information

MessageDataLine Object· Table: ALR3

The MessageDataLine is a child data structure related to the MessageDataColumn. It contains the value of a specified cell in the Data table, which is defined by its column number (vtIndex of Item of MessageDataColumns) and row number (vtIndex...

Parent: Message Data Lines MessageDataLines Collection
OALR SQL Table

biuan SAP® BUSINESS ONE

Collection
MessageDataLines

Object
MessageDataLine

Method

FromXMLFile

FromXMLString

GetXMLSchema

ToXMLFile

ToXMLString

Property

Object

ObjectKey

Value

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