biuan SAP® BUSINESS ONE SDK
DTW Service
API ALR1
ALR1 - Queue of messages to be sent Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Code KEY UNIQUEInternal NumberInt
11OALR
Alerts
PRIMARYYes
LineIdRow NumberInt
11
NameFromFromnVarChar
127
AddrFromReply AddressnVarChar
100
NameToTonVarChar
127
IsSMSSMSVarChar
Y) Yes
N) No
F) Fax
1
N
AddressAddressnVarChar
100
Status KEYStatusVarChar
U) Not Sent
P) In Process
S) Sent
1
USTATUSNo
ObjTypeObjectnVarChar
20
ObjCodeObject CodenVarChar
50

SELECT statement

SELECT ALR1.Code AS 'Internal Number', ALR1.LineId AS 'Row Number', ALR1.NameFrom AS 'From', ALR1.AddrFrom AS 'Reply Address', ALR1.NameTo AS 'To', ALR1.IsSMS AS 'SMS', ALR1.Address AS 'Address', ALR1.Status AS 'Status', ALR1.ObjType AS 'Object', ALR1.ObjCode AS 'Object Code' FROM ALR1 AS ALR1

Related information


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