Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||||||||
| COUPON_ID | int | 4 | √ | null |
|
|
Coupon ID |
||||||||||
| COUPON_TITLE | varchar | 100 | √ | null |
|
|
Coupon title |
||||||||||
| COUPON_BATCH_ID | int | 4 | √ | null |
|
|
Coupon batch ID if created as part of a batch |
||||||||||
| COUPON_CODE | varchar | 20 | √ | null |
|
|
Coupon code |
||||||||||
| COUPON_TYPE | varchar | 30 | √ | null |
|
|
Coupon type |
||||||||||
| COUPON_CATEGORY_ID | int | 4 | √ | null |
|
|
Coupon category ID |
||||||||||
| DISCOUNT_TYPE | varchar | 10 | √ | null |
|
|
Discount type (amount / discount) |
||||||||||
| DISCOUNT_AMOUNT | int | 4 | √ | null |
|
|
Coupon discount amount |
||||||||||
| DISCOUNT_PERCENT | int | 4 | √ | null |
|
|
Coupon discount percentage |
||||||||||
| COUPON_CONTRACT_ID | int | 4 | √ | null |
|
|
Coupon contract ID |
||||||||||
| CHARGE_ID | int | 4 | √ | null |
|
|
Charge ID to be associated to the coupons |
||||||||||
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
Coupon GL account ID |
||||||||||
| DATE_FROM | date | 20 | √ | null |
|
|
Coupon effective date from |
||||||||||
| DATE_TO | date | 20 | √ | null |
|
|
Coupon effective date to |
||||||||||
| FREQUENCY_NUMBER | int | 4 | √ | null |
|
|
Coupon may be used again after this many days, weeks or months |
||||||||||
| FREQUENCY_PERIOD | varchar | 10 | √ | null |
|
|
Period for coupon reuse (Days / Weeks / Months) |
||||||||||
| DAYS_OF_WEEK | varchar | 7 | √ | null |
|
|
Whether the coupon can be used on specific days of the week |
||||||||||
| WEEKS_OF_MONTH | varchar | 5 | √ | null |
|
|
Whether the coupon can be used on specific weeks of the month |
||||||||||
| MONTHS_OF_YEAR | varchar | 12 | √ | null |
|
|
Whether the coupon can be used on specific months of the year |
||||||||||
| MAX_NUMBER_OF_USES | int | 4 | √ | null |
|
|
The total number of times that the coupon may be used |
||||||||||
| TURN_OFF_COUPON | varchar | 5 | √ | null |
|
|
Whether use of this coupon has been turned off (Yes/No) |
||||||||||
| MAX_NUMBER_OF_USES_PER_CUSTOMER | int | 4 | √ | null |
|
|
Maximum uses per customer for each coupon |
||||||||||
| TOTAL_COUPONS_USED | int | 4 | √ | null |
|
|
The total number of times that this coupon has been used |
||||||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
||||||||||
| LAST_SYNC_TIME | datetime | 16,3 | (getdate()) |
|
|
Date and time Hub record was last modified |
|||||||||||
| ACTIVE_HUB_PROCESS_ID | bigint | 8 | √ | null |
|
|
The Hub sync process ID |
||||||||||
| ORG_ID | int | 4 | √ | null |
|
|
Your organization’s unique identifier in the Active Net system |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| COUPONS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| COUPONS_CHARGE_ID_IX | Performance | Asc | CHARGE_ID |
| COUPONS_COUPON_BATCH_ID_IX | Performance | Asc | COUPON_BATCH_ID |
| COUPONS_COUPON_CATEGORY_ID_IX | Performance | Asc | COUPON_CATEGORY_ID |
| COUPONS_COUPON_CONTRACT_ID_IX | Performance | Asc | COUPON_CONTRACT_ID |
| COUPONS_COUPON_ID_ORG_ID_UQ | Must be unique | Asc/Asc | COUPON_ID + ORG_ID |
| COUPONS_GLACCOUNT_ID_IX | Performance | Asc | GLACCOUNT_ID |
| COUPONS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |