Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| INTEREST_LIST_ID | int | 4 | √ | null |
|
|
The interest list ID |
||||
| INTEREST_LIST_NAME | varchar | 50 | √ | null |
|
|
Name of the interest list |
||||
| CATEGORY_ID | int | 4 | √ | null |
|
|
The category ID of the interest list |
||||
| CATEGORY_NAME | varchar | 80 | √ | null |
|
|
The category name of the interest list. |
||||
| SUB_CATEGORY_ID | int | 4 | √ | null |
|
|
The sub-category ID of the interest list |
||||
| SUB_CATEGORY_NAME | varchar | 40 | √ | null |
|
|
The sub-category name of the interest list. |
||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer who has signed up for the interest list |
||||
| FACILITY_ID | int | 4 | √ | null |
|
|
The ID of the facility that is assigned to the interest list |
||||
| PACKAGE_ID | int | 4 | √ | null |
|
|
The ID of the package that is assigned to the interest list |
||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
The ID of the activity that is assigned to the interest list |
||||
| PROGRAM_ID | int | 4 | √ | null |
|
|
The ID of the program that is assigned to the interest list |
||||
| CUSTOMER_MAIL_ID | int | 4 | √ | null |
|
|
Customer interest list ID (for internal synchronization) |
||||
| FACILITY_MAIL_ID | int | 4 | √ | null |
|
|
Facility interest list ID (for internal synchronization) |
||||
| PACKAGE_MAIL_ID | int | 4 | √ | null |
|
|
Package interest list ID (for internal synchronization) |
||||
| ACTIVITY_MAIL_ID | int | 4 | √ | null |
|
|
Activity interest list ID (for internal synchronization) |
||||
| PROGRAM_MAIL_ID | int | 4 | √ | null |
|
|
Program interest list ID (for internal synchronization) |
||||
| 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 |