InsertSmppServerBind (view)
The InsertSmppServer view is used to quickly and easily inspect SMPP server bind messages.
Find out more about how to use these Insert tables here.
The table below provides an overview of all properties that are available to set or 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 or received the message |
| BillingID | nvarchar(255) | Billing ID used for accounting |
| ScheduledTime | datetime2 | Time when the message is scheduled to be sent |
| SentTime | datetime2 | Time when the message was sent |
| ReceivedTime | datetime2 | Time when the message was received |
| LastUpdate | datetime2 | Time when the message record was last updated |
| Priority | int | Message priority |
| BatchID | int | User field |
| ConversationID | int | User field |
| Hash | nvarchar(100) | Hash of the message used by some channels |
| Creator | nvarchar(32) | Creator of the message |
| Archive | bit | System field |
| CustomField1 | int | User field |
| CustomField2 | nvarchar(255) | User field |
| Trace | nvarchar(max) | Trace of the current message |
| StatusCode | int | SMPP status code |
| BindType | int | Type of bind |
| Client | nvarchar(64) | Originating client string |
| SystemId | nvarchar(32) | System ID |
| Password | nvarchar(64) | Password |
| SystemType | nvarchar(32) | System type |
| AddressRange | nvarchar(256) | Address range |
| AddressRangeNPI | int | Number Plan Indicator (NPI) for the address range |
| AddressRangeTON | int | Type of Number (TON) for the address range |
| Version | int | Version of the bind request |
| Tlvs | nvarchar(max) | Any TLVs included in the bind |