UPC_CHANNEL_PREFERENCE
This table stores information related to channel preferences created by the user to link to a global preference.
Field | Type | Length | Null? | Description |
---|---|---|---|---|
Id (Primary Key) |
INT | 64 | False | Unique ID of the regional preference. |
channel_preference_name |
VARCHAR | 64 | False | A name for the channel preference. |
business_days |
CLOB | False |
Stores the selected working days and working hour. For example, 1-1000:1400|2-1000:1800. The example states that the Marketer, or Customer, has set business days and working hours as:
|
|
excluded_days |
CLOB | True |
Excluded days. For example, 1640419470-1;Christmas Here 1640419470 is epoch second value for 25 Dec 2021. The example states that the Marketer, or Customer, has chosen
following days are non-working days:
|
|
createdDateEpoch |
INT | 64 | False | Created date epoch. |
lastModifiedDateEpoch |
INT | 64 | False | Last modified date epoch. |
createdby |
INT | 20 | False | Platform ID of the user who created the entry. |
modifiedby |
INT | 20 | False | Platform ID of the user modifying the entry |
version |
INT | 20 | False | Version information for optimistic locking. |