Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| COUPON_USAGE_ID | int | 4 | √ | null |
|
|
Coupon usage ID |
||||
| COUPON_ID | int | 4 | √ | null |
|
|
Coupon ID |
||||
| TRANSACTION_ID | int | 4 | √ | null |
|
|
ID of the transaction where the coupon was applied |
||||
| RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
ID of the receipt detail where the coupon was applied |
||||
| IS_REFUNDED | varchar | 5 | √ | null |
|
|
Whether the transaction was subsequently refunded (Yes/No) |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
Customer ID |
||||
| CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
Customer name |
||||
| CUSTOMER_NAME_LAST_FIRST | varchar | 512 | √ | null |
|
|
Customer name (last name, first name) |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
Company ID |
||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
Company name |
||||
| USAGE_QUANTITY | int | 4 | null |
|
|
The number of uses that this counts as, refunded or voided transactions will count as zero |
|||||
| USAGE_AMOUNT | money | 21,4 | null |
|
|
The amount that was discounted for this coupon, refunded or voided transactions will count as zero |
|||||
| LAST_SYNC_TIME | datetime | 16,3 | null |
|
|
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 |