InsertSmppServerBind (view)
The InsertSmppServer view is used to quickly and easily look at SmppServer bind messages.
Find out more on how to use these ‘Insert’ tables here.
The table below is an overview of all properties that are available to set or to select:
| Field | Type | Description |
| ID | int | Message ID |
| DirectionID | nvarchar(32) | Message Direction |
| TypeID | nvarchar(32) | SMS, EMAIL, FILE or SMPPSERVERBIND |
| StatusID | nvarchar(32) | Message Status |
| StatusDetailsID | int | User field |
| TriggerStatusID | nvarchar(32) | Trigger Status |
| TriggerDetailsID | int | User field |
| AckStatusID | nvarchar(32) | Acknowledge Status |
| ChannelID | nvarchar(32) | Channel ID of the channel that sent/received the message |
| BillingID | nvarchar(255) | Billing ID used for accounting |
| ScheduledTime | datetime2 | When to send the message |
| SentTime | datetime2 | When the message was sent |
| ReceivedTime | datetime2 | When the message was received |
| LastUpdate | datetime2 | When the message record was last updated |
| Priority | int | The message priority |
| BatchID | int | User field |
| ConversationID | int | User field |
| Hash | nvarchar(100) | The hash of the message; used by some channels |
| Creator | nvarchar(32) | The creator of the message |
| Archive | bit | System field |
| CustomField1 | int | User field |
| CustomField2 | nvarchar(255) | User field |
| Trace | nvarchar(max) | A trace of the current message |
| StatusCode | int | The SMPP Status code |
| BindType | int | Type of bind |
| Client | nvarchar(64) | The originating client string |
| SystemId | nvarchar(32) | System ID |
| Password | nvarchar(64) | The password |
| SystemType | nvarchar(32) | The system type |
| AddressRange | nvarchar(256) | Address range |
| AddressRangeNPI | int | The Number Plan Indicator (NPI) for the address range |
| AddressRangeTON | int | The Type of Number (TON) for this address range |
| Version | int | Version of the bind request |
| Tlvs | nvarchar(max) | Any TLV’s that where included in the bind |