Description:
Represents various voucherable items or offers within the platform (packages, promotions, subscriptions, rewards, etc.). Includes attributes such as value, pricing, redemption rules, timeframes, and applicable conditions, enabling flexible discounting, rewards, and promotional campaigns.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
dtype |
NUMBER | Single-table-inheritance discriminator: 0 (Package), 1 (Promotion), 2 (GeoFencePromotion), 3 (Subscription), 4 (Reward), 5 (CustomerCareVoucherable / SignupReferral), 6 (TriggeredVoucherable), 7 (SupportTemplate), 8 (VehiclePromotion), 9 (GeoFenceSurcharge), 10 (PricedVoucherablePromotion), 11 (RidePass). |
id |
NUMBER | Unique identifier for the voucherable. |
code |
TEXT | Code used to identify the voucherable. |
description |
TEXT | Description of the voucherable. |
name |
TEXT | Name of the voucherable. |
value |
NUMBER | Value of the voucherable. |
price |
NUMBER | Price of the voucherable. |
discount |
NUMBER | Discount value associated with the voucherable. |
rental_rebate |
NUMBER | Rebate amount for rentals associated with the voucherable. |
discounted_price |
NUMBER | Price after applying discount. |
initial_price |
NUMBER | Initial price of the voucherable. |
branch_id |
NUMBER | The branch associated with the voucherable. |
created_by |
NUMBER | User who created the voucherable. |
updated_by |
NUMBER | User who last updated the voucherable. |
max_redeem_limit |
NUMBER | Maximum number of times the voucherable can be redeemed. |
icon_url |
TEXT | URL to the icon representing the voucherable. |
invoice_description |
TEXT | Description of the voucherable for invoicing purposes. |
push_success_redirect_override_url |
TEXT | URL to redirect to after a successful push of the voucherable. |
geo_fence |
GEOMETRY | Geographical boundary for the voucherable’s use. |
state |
NUMBER | State of the voucherable: 0 (INACTIVE), 1 (ACTIVE). |
state_name |
TEXT | String label for state. |
interval |
NUMBER | Subscription interval: 0 (DAILY), 1 (WEEKLY), 2 (MONTHLY), 3 (QUARTERLY), 4 (YEARLY), 5 (FIRST_OF_YEAR). |
interval_name |
TEXT | String label for interval. |
applicable_rental_type |
NUMBER | Rental phase the voucherable applies to: 0 (START_RENTAL), 1 (END_RENTAL), 2 (RUNNING_RENTAL), 3 (RESERVATION), 4 (START_AND_END_RENTAL). |
applicable_rental_type_name |
TEXT | String label for applicable_rental_type. |
custom_properties |
VARIANT | JSON object holding custom properties related to the voucherable. |
trigger_config |
VARIANT | JSON object holding trigger configuration related to the voucherable. |
end_time |
TIMESTAMP_TZ | Timestamp when the voucherable expires. |
start_time |
TIMESTAMP_TZ | Timestamp when the voucherable becomes valid. |
created_at |
TIMESTAMP_TZ | Timestamp when the voucherable was created. |
updated_at |
TIMESTAMP_TZ | Timestamp when the voucherable was last updated. |
highlight |
BOOLEAN | Whether the voucherable is highlighted. |
signup |
BOOLEAN | Indicates if the voucherable is associated with signup. |
number_of_rentals |
NUMBER | Number of rentals for which the voucherable can be redeemed. |
show_in_user_app |
BOOLEAN | Whether the voucherable is visible in the user app. |
redeem_limit_by_user |
NUMBER | Number of times each user can redeem the voucherable. |
initial_package |
BOOLEAN | Whether the voucherable is part of an initial package. |
validity_period |
NUMBER | Validity period for the voucherable in specified time units. |
validity_time_unit |
NUMBER | Unit of time for the validity period (e.g., days, months). |
recurrence_start_time |
TIME | Start time for the voucherable’s recurrence (if applicable). |
duration_in_minutes |
NUMBER | Duration of the voucherable’s validity in minutes. |
weekdays |
ARRAY | List of weekdays during which the voucherable is valid. |
applicable_branch_ids |
ARRAY | List of branch IDs where the voucherable can be applied. |
applicable_vehicle_category_ids |
ARRAY | List of vehicle category IDs for which the voucherable is valid. |
initial_iterations |
NUMBER | Number of initial iterations for the voucherable. |
validity_date_until |
TIMESTAMP_TZ | Date until which the voucherable is valid. |
guser_required_annotation_ids |
ARRAY | Array of user annotation IDs required for the voucherable. |
guser_prohibited_annotation_ids |
ARRAY | Array of user annotation IDs prohibited for the voucherable. |
vehicle_required_annotation_ids |
ARRAY | Array of vehicle annotation IDs required for the voucherable. |
vehicle_prohibited_annotation_ids |
ARRAY | Array of vehicle annotation IDs prohibited for the voucherable. |
applicable_account_types |
NUMBER | Bitmap of eligible account types: 1 (User), 2 (Group), 3 (both). |
applicable_account_types_name |
TEXT | String label for applicable_account_types. |
rank |
NUMBER | Ranking or priority of the voucherable. |
auto_renew_if_active_rental |
BOOLEAN | Whether the voucherable should auto-renew if there is an active rental. |
applicable_price_type |
TEXT | Type of price the voucherable is applicable to (string enum). |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |