Listing (constraint) vouchers that have been redeemed (added) to a user.
|
Column |
Description |
Additional information |
|---|---|---|
|
voucher_id |
|
|
|
created_at |
|
|
|
type |
|
SIGNUP_BONUS PACKAGE REFERRAL_BONUS PROMOTION CREDIT UNDEFINED SETTLEMENT TOP_UP CORRECTION SUBSCRIPTION REWARD_BONUS UNIQUE_PROMOTION SETTLEMENT_EXTERNAL CASHBACK CUSTOMER_CARE |
|
parent_voucher_code |
Where does this voucher come from? For example, if it is a package, you can see it here and group vouchers by parent_voucher_code |
|
|
unique_voucher_code |
Usually from a unique voucher code (list generated) |
|
|
status |
|
ACTIVE EXPIRED USED_UP CANCELED NOT_REDEEMED |
|
name |
|
|
|
description |
|
|
|
invoice_id |
|
|
|
user_id |
|
|
|
group_id |
|
|
|
billable_branch_id |
|
|
|
created_by_user_id |
For unique voucher codes or customer care vouchers etc. |
|
|
valid_from |
|
|
|
valid_until |
|
|
|
rental_rebate_value |
|
|
|
rental_discount_percentage |
|
|
|
value_gross |
|
With VAT |
|
value_net |
|
|
|
number_rentals |
|
|
|
applicable_branch_ids |
|
|
|
applicable_vehicle_category_ids |
|
|
|
is_signup_voucher |
|
|