Available since: v1.0.0
Deprecated since: v2.6.0 (Platform release 1.12.3). Replaced by VVS Voucher
| File | Snapshot | Delta | Frequency |
|---|
| vouchers/vouchers_yyyy_MM_dd | :white_check_mark: | :no_entry: | Daily |
| Attribute | Required? | Value | Description |
|---|
| ID | Yes | NUMBER | Unique identifier of entity |
| CODE | Yes | VARCHAR2(32) | Unique voucher code |
| DESCRIPTION | | VARCHAR2(64) | Referred to as the “voucher pool name” or just “pool name” in the API and UI. |
| EXPIRES | | DATE | The date when the voucher expires |
| REGISTERED | | DATE | The latest date when the voucher was used |
| ACTIVATED | Yes | 0 or 1 | |
| AVAILABLE | Yes | 0 or 1 | |
| CAMPAIGN | Yes | NUMBER | |
| USER_ACCESS_ID | | NUMBER | The last USER ACCESS using the voucher code. This will get overwritten each time a voucher code is reused |
| PRODUCT_PROVIDER_ID | | NUMBER | Foreign key for PRODUCT PROVIDER |
| DISCOUNT | | NUMBER | |
| DISCOUNT_FRACTION | | NUMBER | |
| USAGE | | NUMBER | The number of usages available |
| STARTDATE | | DATE | |
| REMINDER | | 0 or 1 | |
| DISCOUNT_RECURRING | | NUMBER | |
| DISCOUNT_FRACTION_RECURRING | | NUMBER | |
