customer_phone_entity - Customer Phone Entity

This holds information concerning customer phone numbers, such as the number, carrier, and whether or not it is subscribed for text messages.

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

entity_id

int(11)

ID of the associated entity

entity_type

char(100)

Type of the associated entity

phone

char(20)

Phone number

type

char(100)

Phone type code

customer.phoneType.*

is_primary

tinyint(4)

Whether or not this is a primary phone number

1 - yes, 0 - no

is_secondary

tinyint(4)

Whether or not this is a secondary phone number

1 - yes, 0 - no

sbt_act_verify_pending

tinyint(1)

Whether or not a Solutions by Text (SBT) verification is pending for account texts

1 - yes, 0 - no

sbt_act_verify_pin

char(20)

PIN for SBT verification for account texts

sbt_act_verified

tinyint(1)

Whether or not the phone number has been verified with SBT for account texts

1 - yes, 0 - no

sbt_mkt_verify_pending

tinyint(1)

Whether or not a Solutions by Text (SBT) verification is pending for marketing texts

1 - yes, 0 - no

sbt_mkt_verify_pin

char(20)

PIN for SBT verification for marketing texts

sbt_mkt_verified

tinyint(1)

Whether or not the phone number has been verified with SBT for marketing texts

1 - yes, 0 - no

carrier_name

varchar(255)

Name of phone carrier

carrier_verified

tinyint(1)

Whether or not the carrier has been verified

1 - yes, 0 - no

landline

tinyint(1)

Whether or not the phone is a landline

1 - yes, 0 - no

dnd_enabled

tinyint(1)

Whether or not Do not Disturb settings are enabled

1 - yes, 0 - no

active

tinyint(1)

Whether or not the entity is active

1 - yes, 0 - no

deleted

tinyint(1)

Whether or not the entity was deleted

1 - yes, 0 - no

created

timestamp

Timestamp of when the entity was created

lastUpdated

timestamp

Timestamp of when the entity was last updated


How did we do?


Powered by HelpDocs (opens in a new tab)