Specifications

Chapter 6. Message Database
ScheduleTimeSecs Number Scheduled time (in seconds after 01/01/1970). Used
for outgoing messages only. 0 indicates: immediate
send.
LastUpdateSecs Number Last update time (in seconds after 01/01/1970). Each
time a record is updated by the software, this
property is updated automatically.
Sender String Sender address of the message.
Recipient String Recipient address of the message.
Subject String Subject of the message (only applicable for e-mail
messages)
Body String Body of the message. It can only contain ASCII data
(including MIME e-mail messages)
Trace String Trace of the message. This multi-line field contains
the progress of a message, including date and time.
sysLock Boolean Internal System field (used by the SMS Messaging
Service)
sysInfo String Internal System field (used by the SMS Messaging
Service)
sysHash String Internal System field (used by the SMS Messaging
Service)
sysForwarded Boolean Internal System field (used by the SMS Messaging
Service)
NOTE: All of the above fields can be used in a Trigger condition. For example, you can build a
Trigger condition like this one:
Direction=1 AND Type=2 AND ( ChannelID=1001 OR ChannelID=1002 )
Table:
Directions
The 'Directions' table contains the following fields:
Property Type Description
Direction Number Numeric value of a direction.
Description String Description of a direction.
The 'Directions' table is a static table; it contains definitions for each direction. Each direction is
described by a separate record:
Direction Description
0 Undefined
1 In
2 Out
Table:
Status
The 'Status' table contains the following fields:
Property Type Description
Status Number Numeric value of a status.
Description String Description of a status.