Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|||||||
| GIFT_CARD_ID | int | 4 | √ | null |
|
|
Gift card ID |
|||||||
| GIFT_CARD_TYPE_ID | int | 4 | √ | null |
|
|
Gift card type ID |
|||||||
| GIFT_CARD_NUMBER | varchar | 30 | √ | null |
|
|
The number of the gift card |
|||||||
| GIFT_CARD_STATUS | varchar | 10 | √ | null |
|
|
The status of the gift card (New / Pending / Active / Voided / Refunded) |
|||||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer who purchased the gift card |
|||||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company who purchased the gift card |
|||||||
| ISSUED_BY_SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who sold the gift card |
|||||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation that the gift card was sold at |
|||||||
| PURCHASED_AMOUNT | money | 21,4 | √ | null |
|
|
The original purchase amount of the gift card |
|||||||
| REDEEMED_AMOUNT | money | 21,4 | √ | null |
|
|
The amount that has been redeemed from this gift card |
|||||||
| REFILLED_AMOUNT | money | 21,4 | √ | null |
|
|
The total refill amount that has been added to this gift card |
|||||||
| AVAILABLE_AMOUNT | money | 21,4 | √ | null |
|
|
The current outstanding balance of this gift card |
|||||||
| SOLD_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the gift card was purchased |
|||||||
| LAST_USED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the gift card was last used |
|||||||
| EXPIRY_DATE | date | 20 | √ | null |
|
|
The expiry date of the gift card |
|||||||
| LIABILITY_GLACCOUNT_ID | int | 4 | √ | null |
|
|
The GL account ID that will be posted to when the gift card is redeemed |
|||||||
| NOTES | varchar | 8000 | √ | null |
|
|
Notes that are applicable to the gift card |
|||||||
| 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) |
|---|---|---|---|
| GIFT_CARDS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| GIFT_CARDS_COMPANY_ID_IX | Performance | Asc | COMPANY_ID |
| GIFT_CARDS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| GIFT_CARDS_GIFT_CARD_ID_ORG_ID_UQ | Must be unique | Asc/Asc | GIFT_CARD_ID + ORG_ID |
| GIFT_CARDS_GIFT_CARD_TYPE_ID_IX | Performance | Asc | GIFT_CARD_TYPE_ID |
| GIFT_CARDS_ISSUED_BY_SYSTEMUSER_ID_IX | Performance | Asc | ISSUED_BY_SYSTEMUSER_ID |
| GIFT_CARDS_LIABILITY_GLACCOUNT_ID_IX | Performance | Asc | LIABILITY_GLACCOUNT_ID |
| GIFT_CARDS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| GIFT_CARDS_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |