Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 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 |
||||
| SYSTEM_GL_ACCOUNT_PACKAGE_ID | int | 4 | √ | null |
|
|
System account package ID |
||||
| 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) |
||||
| IS_SURCHARGE | varchar | 5 | √ | null |
|
|
Whether this record is for a surcharge rather than a discount (Yes / No) |
||||
| APPLIES_TO_PRIMARY_FEE | varchar | 5 | √ | null |
|
|
Whether this surcharge is applied to the primary fee (Yes / No) |
||||
| DISCOUNTABLE | varchar | 5 | √ | null |
|
|
Whether this surcharge can be discounted (Yes / No) |
||||
| TAXABLE_BY_TAX_1 | varchar | 5 | √ | null |
|
|
Whether tax 1 applies to this surcharge (Yes / No) |
||||
| TAXABLE_BY_TAX_2 | varchar | 5 | √ | null |
|
|
Whether tax 2 applies to this surcharge (Yes / No) |
||||
| TAXABLE_BY_TAX_3 | varchar | 5 | √ | null |
|
|
Whether tax 3 applies to this surcharge (Yes / No) |
||||
| TAXABLE_BY_TAX_4 | varchar | 5 | √ | null |
|
|
Whether tax 4 applies to this surcharge (Yes / No) |
||||
| TAXABLE_BY_TAX_5 | varchar | 5 | √ | null |
|
|
Whether tax 5 applies to this surcharge (Yes / No) |
||||
| TAXABLE_BY_TAX_6 | varchar | 5 | √ | null |
|
|
Whether tax 6 applies to this surcharge (Yes / No) |
||||
| TAXABLE_BY_TAX_7 | varchar | 5 | √ | null |
|
|
Whether tax 7 applies to this surcharge (Yes / No) |
||||
| TAXABLE_BY_TAX_8 | varchar | 5 | √ | null |
|
|
Whether tax 8 applies to this surcharge (Yes / No) |
||||
| 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 |
||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| GLOBAL_DISCOUNTS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| GLOBAL_DISCOUNTS_CHARGE_ID_IX | Performance | Asc | CHARGE_ID |
| GLOBAL_DISCOUNTS_GLACCOUNT_ID_IX | Performance | Asc | GLACCOUNT_ID |
| GLOBAL_DISCOUNTS_GLOBAL_DISCOUNT_ID_ORG_ID_UQ | Must be unique | Asc/Asc | GLOBAL_DISCOUNT_ID + ORG_ID |
| GLOBAL_DISCOUNTS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| GLOBAL_DISCOUNTS_SYSTEM_GL_ACCOUNT_PACKAGE_ID_IX | Performance | Asc | SYSTEM_GL_ACCOUNT_PACKAGE_ID |