Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||
| GLOBAL_DISCOUNT_ID | int | 4 | √ | null |
|
|
Global discount ID |
||||
| GLOBAL_DISCOUNT_NAME | varchar | 60 | √ | null |
|
|
Global discount name |
||||
| CHARGE_ID | int | 4 | √ | null |
|
|
Charge ID |
||||
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
The default GL account ID to post this discount to |
||||
| GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name |
||||
| GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number |
||||
| SYSTEM_GL_ACCOUNT_PACKAGE_ID | int | 4 | √ | null |
|
|
System account package ID |
||||
| SYSTEM_GL_ACCOUNT_PACKAGE | varchar | 50 | √ | null |
|
|
System GL account package name |
||||
| DISCOUNT_TYPE | varchar | 10 | √ | null |
|
|
The type of discount (Amount / Percent) |
||||
| DISCOUNT_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount |
||||
| DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage |
||||
| DISCOUNT_ORDER | int | 4 | √ | null |
|
|
The order in which the discount should be applied |
||||
| DISCOUNT_GROUP_NUMBER | int | 4 | √ | null |
|
|
Discount group number |
||||
| EXCLUDE_OTHER_DISCOUNTS_IN_GROUP | varchar | 5 | √ | null |
|
|
Whether other discounts in the same group should be excluded (Yes / No) |
||||
| PREFILL_CONDITION | varchar | 20 | √ | null |
|
|
The prefill condition for this global discount (Never / Always / If Resident / If Non-resident / If Minor / If Senior / If Internet / If Member / If Non-member) |
||||
| APPLIES_TO_ALL_ACTIVITIES | varchar | 5 | √ | null |
|
|
Whether this discount applies to all activities (Yes / No) |
||||
| ACTIVITY_GROUP_NUMBER | varchar | 10 | √ | null |
|
|
The specific activity group number that this discount applies to |
||||
| ACTIVITY_DISCOUNT_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount for activities |
||||
| ACTIVITY_DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage for activities |
||||
| APPLIES_TO_ALL_PROGRAMS | varchar | 5 | √ | null |
|
|
Whether this discount applies to all programs (Yes / No) |
||||
| PROGRAM_GROUP_NUMBER | varchar | 10 | √ | null |
|
|
The specific program group number that this discount applies to |
||||
| PROGRAM_DISCOUNT_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount for programs |
||||
| PROGRAM_DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage for programs |
||||
| APPLIES_TO_ALL_PACKAGES | varchar | 5 | √ | null |
|
|
Whether this discount applies to all membership packages (Yes / No) |
||||
| MEMBERSHIP_DISCOUNT_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount for memberships |
||||
| MEMBERSHIP_DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage for memberships |
||||
| APPLIES_TO_ALL_PRODUCTS | varchar | 5 | √ | null |
|
|
Whether this discount applies to all POS products (Yes / No) |
||||
| PRODUCT_DISCOUNT_AMOUNT | money | 21,4 | √ | null |
|
|
The default discount amount for POS products |
||||
| PRODUCT_DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage for POS products |
||||
| APPLY_TO_ORIGINAL_ENROLLMENT_ONLY | varchar | 5 | √ | null |
|
|
Whether this discount should be applied to the original program enrollment only (Yes / No) |
||||
| MULTI_PERSON_APPLIES_TO_ALL | varchar | 5 | √ | null |
|
|
Whether this multi-person discount should be applied to all registrants up to the maximum (Yes / No) |
||||
| MULTI_PERSON_MIN | int | 4 | √ | null |
|
|
The minimum number of registrants for multi-person registration with this discount |
||||
| MULTI_PERSON_MAX | int | 4 | √ | null |
|
|
The maximum number of registrants for multi-person registration with this discount |
||||
| MULTI_ACTIVITY_APPLIES_TO_ALL | varchar | 5 | √ | null |
|
|
Whether this multi-activity discount should be applied to all registrations up to the maximum (Yes / No) |
||||
| MULTI_ACTIVITY_MIN | int | 4 | √ | null |
|
|
The minimum number of activities for multi-activity registration with this discount |
||||
| MULTI_ACTIVITY_MAX | int | 4 | √ | null |
|
|
The maximum number of activities for multi-activity registration with this discount |
||||
| MULTI_SESSION_APPLIES_TO_CONCURRENT | varchar | 5 | √ | null |
|
|
Whether this multi-session discount should count each concurrent session separately (Yes / No) |
||||
| MULTI_SESSION_MIN | int | 4 | √ | null |
|
|
The minimum number of sessions booked for this discount to be applied |
||||
| MULTI_SESSION_MAX | int | 4 | √ | null |
|
|
The maximum number of sessions booked for this discount to be applied |
||||
| ACTIVATION_DATE | date | 20 | √ | null |
|
|
The first available date for this discount |
||||
| EXPIRATION_DATE | date | 20 | √ | null |
|
|
The last available date for this discount |
||||
| RETIRED | varchar | 5 | √ | null |
|
|
Whether this global discount has been retired (Yes / No) |
||||
| 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 |