Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| COUPON_BATCH_QUALIFICATION_ID | int | 4 | √ | null |
|
|
Coupon batch qualification ID |
||||
| COUPON_BATCH_ID | int | 4 | √ | null |
|
|
Coupon batch ID |
||||
| COUPON_BATCH_TITLE | varchar | 100 | √ | null |
|
|
Coupon batch title |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Activity ID |
||||
| ACTIVITY_NAME | varchar | 100 | √ | null |
|
|
Activity name |
||||
| CATEGORY_ID | int | 4 | √ | null |
|
|
Activity category ID |
||||
| CATEGORY_NAME | varchar | 80 | √ | null |
|
|
Activity category name |
||||
| SEASON_ID | int | 4 | √ | null |
|
|
Activity season ID |
||||
| SEASON_NAME | varchar | 40 | √ | null |
|
|
Activity season name |
||||
| POSPRODUCT_ID | int | 4 | √ | null |
|
|
POS product ID |
||||
| PRODUCT_NAME | varchar | 100 | √ | null |
|
|
POS product name |
||||
| PRODUCT_DEPARTMENT_ID | int | 4 | √ | null |
|
|
Product department ID |
||||
| PRODUCT_DEPARTMENT_NAME | varchar | 50 | √ | null |
|
|
Product department name |
||||
| PRODUCT_CLASS_ID | int | 4 | √ | null |
|
|
Product class ID |
||||
| PRODUCT_CLASS_NAME | varchar | 50 | √ | null |
|
|
Product class name |
||||
| PRODUCT_SUBCLASS_ID | int | 4 | √ | null |
|
|
Product subclass ID |
||||
| PRODUCT_SUBCLASS_NAME | varchar | 50 | √ | null |
|
|
Product subclass name |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
Program ID |
||||
| PROGRAM_NAME | varchar | 255 | √ | null |
|
|
Program name |
||||
| PROGRAM_TYPE_ID | int | 4 | √ | null |
|
|
Program type ID |
||||
| PROGRAM_TYPE_NAME | varchar | 30 | √ | null |
|
|
Program type name |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
Package ID |
||||
| PACKAGE_NAME | varchar | 255 | √ | null |
|
|
Package name |
||||
| PACKAGE_CATEGORY_ID | int | 4 | √ | null |
|
|
Package category ID |
||||
| PACKAGE_CATEGORY_NAME | varchar | 50 | √ | null |
|
|
Package category name |
||||
| USAGE_FEE_ID | int | 4 | √ | null |
|
|
Usage fee ID |
||||
| USAGE_FEE_NAME | varchar | 50 | √ | null |
|
|
Usage fee name |
||||
| 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 |