Description:
Records each rebate or voucher application against a rental, linking a rental to the applied voucher and the granting user. Despite the plural table name, this is a full entity with its own id, not a plain join table. It is the source for promotion redemption and rebate KPI reporting.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the applied rental rebate / voucher. |
guser_id |
NUMBER | Foreign key to the customer (gusers) the rebate was applied for. |
rental_id |
NUMBER | Foreign key to the rental the rebate / voucher was applied to. |
type |
NUMBER | Type of applied rental rebate (0 => GEOFENCE_PROMOTION. 1 => PACKAGE. 2 => SUBSCRIPTION. 3 => REWARD. 4 => FREE_REWARD. 5 => SINGLE_USE_VOUCHER. 6 => SIGNUP_REFERRAL. 7 => CASHBACK. 8 => CUSTOMER_CARE. 9 => VEHICLE_PROMOTION. 10 => PROMOTION. 11 => GEOFENCE_SURCHARGE. 12 => RIDE_PASS. 13 => EARLY_RETURN_DISCOUNT. 14 => RIDE_REWARD). |
type_name |
TEXT | String label for type. |
name |
TEXT | Name of the applied rebate / voucher. |
description |
TEXT | Description of the applied rebate / voucher. |
voucherable_id |
NUMBER | Foreign key to the voucherable (rebate definition) that was applied. |
voucher_id |
NUMBER | Foreign key to the voucher instance that was redeemed. |
amount_net |
NUMBER | Net amount of the rebate applied to the rental. |
amount_gross |
NUMBER | Gross amount of the rebate applied to the rental. |
created_at |
TIMESTAMP_TZ | Creation timestamp. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | Timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | Timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |