|
|
DTW Service
API ALR1
ALR1 - Queue of messages to be sent Table
Alerts OALR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Internal Number | Int | 11 | OALR Alerts | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row Number | Int | 11 | |||||
| NameFrom | From | nVarChar | 127 | |||||
| AddrFrom | Reply Address | nVarChar | 100 | |||||
| NameTo | To | nVarChar | 127 | |||||
| IsSMS | SMS | VarChar | Y) Yes N) No F) Fax | 1 | N | |||
| Address | Address | nVarChar | 100 | |||||
| Status KEY | Status | VarChar | U) Not Sent P) In Process S) Sent | 1 | U | STATUS | No | |
| ObjType | Object | nVarChar | 20 | |||||
| ObjCode | Object Code | nVarChar | 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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
