SMS Messages

Ring2All Platform — SMS Message History

Parent Module: SMS Messaging

---

Overview

SMS Messages displays the complete history of sent and received text messages, including delivery status, encoding analysis, and conversation threading.

Admin Panel → SMS → Messages

---

Message Fields

Field	Description	Example
Message UUID	Unique identifier for the message	`550e8400-e29b-41d4-a716-446655440000`
Direction	Inbound or outbound	`outbound`
From Number	Sender phone number (E.164)	`+15551234567`
To Number	Recipient phone number (E.164)	`+15559876543`
Extension	Associated extension (if any)	`2001`
Body	Message text content	`Hello, this is a test message`
Encoding	Character encoding used	`GSM7` or `UCS2`
Segments	Number of SMS parts	`1`
Status	Current delivery status	`delivered`
Provider Name	Which provider handled	`Twilio US`
Created At	When message was queued	`2026-01-15 10:30:00`
Sent At	When sent to carrier	`2026-01-15 10:30:01`
Delivered At	When carrier confirmed	`2026-01-15 10:30:03`

---

Message Status Values

Status	Description	Icon Color	Final?
`queued`	Waiting in queue to be sent	🟡 Yellow	No
`sending`	Currently being sent to carrier	🔵 Blue	No
`sent`	Sent to carrier, awaiting confirmation	🔵 Blue	No
`delivered`	Carrier confirmed delivery	🟢 Green	Yes
`failed`	Carrier rejected the message	🔴 Red	Yes
`undelivered`	Could not be delivered	🔴 Red	Yes
`rejected`	Blocked by opt-out or settings	🔴 Red	Yes

Status Flow

Plaintext

queued → sending → sent → delivered
                       ↘
                         failed/undelivered

---

Message Encoding

SMS messages use different character encodings:

GSM-7 Encoding

Character limit: 160 per segment (153 for multipart)
Supported: Basic Latin letters, numbers, common punctuation
Example characters: A-Z, a-z, 0-9, @, $, _, etc.

UCS-2 Encoding

Character limit: 70 per segment (67 for multipart)
Required for: Unicode, emojis, non-Latin scripts
Example characters: 中文, العربية, 😀, ñ, ü, etc.

Encoding Detection

The system automatically detects encoding based on message content:

Plaintext

Message: "Hello World!"
  → All GSM-7 chars
  → Encoding: GSM7
  → Max per segment: 160

Message: "Hello 🌍!"
  → Contains emoji
  → Encoding: UCS2
  → Max per segment: 70

---

Multipart Messages (Segments)

Long messages are split into segments:

GSM-7 Segmentation

Message Length	Segments
1-160 chars	1
161-306 chars	2
307-459 chars	3
460-612 chars	4

UCS-2 Segmentation

Message Length	Segments
1-70 chars	1
71-134 chars	2
135-201 chars	3
202-268 chars	4

> ⚠️ Cost Note: Each segment is billed as a separate message by carriers.

---

Filtering Messages

The Messages page supports filtering by:

Filter	Options
Direction	All, Inbound, Outbound
Status	All, Delivered, Failed, Pending
Date Range	Start date to End date
Phone Number	Search by from/to number
Extension	Filter by extension number

---

Message Details View

Clicking a message shows full details:

Plaintext

┌─────────────────────────────────────────┐
│ MESSAGE DETAILS                         │
├─────────────────────────────────────────┤
│ Direction:    Outbound                  │
│ From:         +15551234567              │
│ To:           +15559876543              │
│ Extension:    2001                      │
│ Status:       ✓ Delivered               │
├─────────────────────────────────────────┤
│ Body:                                   │
│ "Hello! Your appointment is confirmed  │
│  for tomorrow at 3 PM."                 │
├─────────────────────────────────────────┤
│ Encoding:     GSM7                      │
│ Characters:   67                        │
│ Segments:     1                         │
├─────────────────────────────────────────┤
│ Provider:     Twilio US                 │
│ Provider ID:  SM123456789...            │
├─────────────────────────────────────────┤
│ Timeline:                               │
│ • Queued:     10:30:00                  │
│ • Sent:       10:30:01                  │
│ • Delivered:  10:30:03                  │
└─────────────────────────────────────────┘

---

Error Messages

Common failure reasons:

Error Code	Description	Solution
`30001`	Queue error	Check queue worker status
`30003`	Unreachable	Invalid phone number
`30004`	Message blocked	Carrier filtering
`30005`	Unknown destination	Number doesn't exist
`30006`	Landline	Cannot SMS to landlines
`30007`	Carrier violation	Content flagged as spam
`30008`	Unknown error	Check provider dashboard
`21610`	Opt-out	Recipient opted out

---

User Portal Messages

Extension users can view their messages in the User Portal:

Portal SMS Page

Only shows messages for their assigned SMS number
Can filter by direction and search
Can compose and send new messages
Real-time status updates

Sending from Portal

Plaintext

┌─────────────────────────────────────────┐
│ SEND NEW SMS                            │
├─────────────────────────────────────────┤
│ From: +15551234567 (read-only)          │
│ To:   [+15559876543          ]          │
│ Message:                                │
│ [                                    ]  │
│ [                                    ]  │
│                                         │
│ GSM7 | 45 chars | 1 segment             │
│                                         │
│           [Cancel]  [Send]              │
└─────────────────────────────────────────┘

---

Database Schema

Sql

-- Located in ss_cdr database
CREATE TABLE sms_messages (
    id              BIGSERIAL PRIMARY KEY,
    message_uuid    UUID DEFAULT gen_random_uuid(),
    domain_id       INTEGER NOT NULL,
    provider_name   VARCHAR(255),
    provider_message_id VARCHAR(255),
    direction       VARCHAR(10) NOT NULL,  -- 'inbound' or 'outbound'
    from_number     VARCHAR(20) NOT NULL,
    to_number       VARCHAR(20) NOT NULL,
    extension       VARCHAR(20),
    body            TEXT,
    encoding        VARCHAR(10),           -- 'GSM7' or 'UCS2'
    segments        INTEGER DEFAULT 1,
    status          VARCHAR(20) DEFAULT 'queued',
    error_code      VARCHAR(20),
    error_message   TEXT,
    price           DECIMAL(10,6),
    price_currency  VARCHAR(3),
    user_id         INTEGER,
    queued_at       TIMESTAMP DEFAULT NOW(),
    sent_at         TIMESTAMP,
    delivered_at    TIMESTAMP,
    failed_at       TIMESTAMP,
    created_at      TIMESTAMP DEFAULT NOW()
);

CREATE INDEX idx_sms_messages_domain ON sms_messages(domain_id);
CREATE INDEX idx_sms_messages_from ON sms_messages(from_number);
CREATE INDEX idx_sms_messages_to ON sms_messages(to_number);
CREATE INDEX idx_sms_messages_created ON sms_messages(created_at);

---

See also: SMS Settings | SMS Opt-outs | SMS Numbers

Glossary

Term	Definition
SMS	Short Message Service (text messaging)
SMS Message Logs	History of inbound and outbound messages

---

Lua Script Status ℹ️

Integration Module

Component	Status	Notes
SMS Messages	ℹ️ Configuration module	Messages are processed by the main SMS handler script

SMS Messages

Overview

Navigation

Message Fields

Message Status Values

Status Flow

Message Encoding

GSM-7 Encoding

UCS-2 Encoding

Encoding Detection

Multipart Messages (Segments)

GSM-7 Segmentation

UCS-2 Segmentation

Filtering Messages

Message Details View

Error Messages

User Portal Messages

Portal SMS Page

Sending from Portal

Database Schema

Glossary

Lua Script Status ℹ️

Integration Module