UPC_REGIONAL_PREFERENCE

This table stores information related to regional preferences created by the user.

Field Type Length Null? Description
Id (Primary Key) INT 64 False Unique ID of the regional preference.
upc_preference_type_id (Foreign Key) INT 20 False Unique ID of the regional preference type. The values can be:
  • 0 - Global
  • 1 - Custom
preference_name VARCHAR 64 False A name for the regional preference.
timezone VARCHAR 200 False The time zone ID.
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.