Keywords in the SQL templates

KeywordValue Incoming (insert) Outgoing polling (select) Outgoing sending (update) Outgoing sent (update) Outgoing not sent (update) Outgoing delivered (update) Outgoing undelivered (update)
$idMessage ID + + + + + + +
$senttimeSent time in the format specified on the configuration form +     + +    
$receivedtimeReceived time in the format specified on the configuration form +       +    
$messagedataMessage text + + + + + + +
$decodedmessagedataThe decoded text for text messages and a hex string for binary messages. This is different than $messagedata since the $messagedata field will try to decode all data as text. +   + + + + +
$senderSender address + + + + + + +
$originatorSame as $sender + + + + + + +
$receiverRecipient address + + + + + + +
$recipientSame as $receiver + + + + + + +
$messagetypeOzeki message type + + + + + + +
$operatornamesThe names of the service provider connections, that can be used to send this message. The names can be separated by a semicolon or a colon.   +          
$operatorThe name of the service provider connection to use + +   +      
$subjectThe message subject (for SMS messages, the first 1024 characters of the message text) +            
$callbackidThe message submission reference number       +      
$costThe cost of a message (the number of PDUs used to submit it)       +      
$reasonThe error reason         +   +
$errormessageThe error message         +   +
$currentdatetimeCurrent date and time in the format specified on the configuration form +   + + + + +
$currentdateCurrent date in the format yyyy-MM-dd +   + + + + +
$currenttimeCurrent time in the format HH:mm:ss +   + + + + +
$1The first word in the message. You can use $2 to refer to the second word, $3 to refer to the third word, etc... +            
$U1The first word in the message in upper case format. You can use $U2 to refer to the second word in upper case format, etc... +            
SMS message related fields
$dcshexThe data coding scheme (DCS) byte of the PDU in hexadecimal format +     +      
$dcsThe data coding scheme (DCS) byte of the PDU in decimal format +     +      
$pidhexThe protocol identifier (PID) byte of the PDU in hexadecimal format +     +      
$pidThe protocol identifier (PID) byte of the PDU in decimal format +     +      
$udhplusudThe user data header and the user data in hexadecimal string format of the first pdu +     +      
$udhThe user data header in hexadecimal string format of the first pdu +     +      
$udThe user data in hexadecimal string format of the first pdu +     +      
$scaService centre address +     +      
$tp_mmsThe TP_MMS flag of the first byte of the PDU. (true or false) +     +      
$tp_mtThe TP_MT flag of the first byte of the PDU. (true or false) +     +      
$tp_rpThe TP_RP flag of the first byte of the PDU. (true or false) +     +      
$tp_srrThe TP_SRR flag of the first byte of the PDU. (true or false) +     +      
$tp_udhiThe TP_UDHI (User data header indication) flag of the first byte of the PDU. (true or false) +     +      
$messageclassThe message class value is a decimal number +     +      
Multipart SMS messages
$pducountThe number of PDUs in the message +     +      
$pdu1_udhudThe user data header and the user data in hexadecimal string format of the first pdu. For the second pdu this would be $pdu2_udhud, etc... +     +      
$pdu1_udhThe user data header in hexadecimal string format of the first pdu. For the second pdu this would be $pdu2_udh, etc... +     +      
$pdu1_udThe user data in hexadecimal string format of the first pdu. For the second pdu this would be $pdu2_ud, etc... +     +      
$pdu1_rawheaderThe pdu header in hexadecimal string format of the first pdu. For the second pdu this would be $pdu2_rawheader, etc... +     +      
$pdu1_rawbodyThe same as $pdu1_udhud. For the second pdu this would be $pdu2_rawpdu, etc... +     +      
$pdu1_rawpduThe first pdu in hexadecimal format. For the second pdu this would be $pdu2_rawpdu, etc... +     +      
$rawpdusContains all pdus separated by a semi colon; +     +      
Optional fields
$fieldnameField name is the name of a database column that was included in the select statement used to originally pick up the message. This keyword will hold the value of this column in all subsequent updates.   + + + + + +

More information