Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GIFT_CARD_ID | int | 4 | √ | null |
|
|
Gift card ID |
|||||||
| GIFT_CARD_TYPE_ID | int | 4 | √ | null |
|
|
Gift card type ID |
|||||||
| GIFT_CARD_TYPE_NAME | varchar | 50 | √ | null |
|
|
Gift card type name |
|||||||
| 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 |
|||||||
| CUSTOMER_NAME | varchar | 511 | null |
|
|
The name of the customer who purchased the gift card |
||||||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company who purchased the gift card |
|||||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
The name 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 |
|||||||
| ISSUED_BY_SYSTEM_USER_NAME | varchar | 511 | null |
|
|
The name 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 |
|||||||
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
The name 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 |
|||||||
| SOLD_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the gift card was purchased (date only) |
|||||||
| LAST_USED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the gift card was last used |
|||||||
| LAST_USED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the gift card was last used (date only) |
|||||||
| 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 |
|||||||
| LIABILITY_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
The GL account ID that will be posted to when the gift card is redeemed |
|||||||
| LIABILITY_GL_ACCOUNT_NUMBER | varchar | 200 | √ | 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 |
|||||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
||||||||
| 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 |