Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
||||||||
| ACTIVITY_FEE_ID | int | 4 | √ | null |
|
|
Activity fee ID |
|||||||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Activity ID which this fee belongs to |
|||||||
| ACTIVITY_NAME | varchar | 100 | √ | null |
|
|
Activity name which this fee belongs to |
|||||||
| ACTIVITY_NUMBER | varchar | 20 | √ | null |
|
|
Activity number which this fee belongs to |
|||||||
| CHARGE_ID | int | 4 | √ | null |
|
|
Charge ID |
|||||||
| CHARGE_NAME | varchar | 50 | √ | null |
|
|
Charge name |
|||||||
| CHARGE_TYPE | varchar | 20 | √ | null |
|
|
The type of charge (Fee / Discount / Scholarship) |
|||||||
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
The default GL account ID to post this charge to |
|||||||
| GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name |
|||||||
| GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number |
|||||||
| FEE_ORDER | int | 4 | √ | null |
|
|
The order in which the fee should be applied |
|||||||
| FEE_AMOUNT | money | 21,4 | √ | null |
|
|
The default fee or discount amount |
|||||||
| DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage |
|||||||
| DISCOUNT_TYPE | varchar | 10 | √ | null |
|
|
The type of discount (Amount / Percent) |
|||||||
| PRIMARY_FEE | varchar | 5 | √ | null |
|
|
Whether this charge is a primary fee (Yes / No) |
|||||||
| OVERRIDE_FLAG | varchar | 20 | √ | null |
|
|
Whether this charge can be overridden (Always / Never / By Password) |
|||||||
| PREFILL_CONDITION | varchar | 20 | √ | null |
|
|
The prefill condition for this fee (Never / Always / If Resident / If Non-resident / If Minor / If Senior / If Internet / If Member / If Non-member) |
|||||||
| PRORATE_FEES | varchar | 5 | √ | null |
|
|
Whether this fee can be prorated (Yes / No) |
|||||||
| TAXABLE_BY_TAX_1 | varchar | 5 | √ | null |
|
|
Whether tax 1 applies to this fee (Yes / No) |
|||||||
| TAXABLE_BY_TAX_2 | varchar | 5 | √ | null |
|
|
Whether tax 2 applies to this fee (Yes / No) |
|||||||
| TAXABLE_BY_TAX_3 | varchar | 5 | √ | null |
|
|
Whether tax 3 applies to this fee (Yes / No) |
|||||||
| TAXABLE_BY_TAX_4 | varchar | 5 | √ | null |
|
|
Whether tax 4 applies to this fee (Yes / No) |
|||||||
| TAXABLE_BY_TAX_5 | varchar | 5 | √ | null |
|
|
Whether tax 5 applies to this fee (Yes / No) |
|||||||
| TAXABLE_BY_TAX_6 | varchar | 5 | √ | null |
|
|
Whether tax 6 applies to this fee (Yes / No) |
|||||||
| TAXABLE_BY_TAX_7 | varchar | 5 | √ | null |
|
|
Whether tax 7 applies to this fee (Yes / No) |
|||||||
| TAXABLE_BY_TAX_8 | varchar | 5 | √ | null |
|
|
Whether tax 8 applies to this fee (Yes / No) |
|||||||
| UNIT_OF_MEASURE | varchar | 40 | √ | null |
|
|
The default unit of measure for the amount |
|||||||
| ONLINE_QUESTION | varchar | 100 | √ | null |
|
|
Online question to be asked for this charge |
|||||||
| DISCOUNTABLE | varchar | 5 | √ | null |
|
|
Whether this charge can be discounted (Yes / No) |
|||||||
| MULTI_CHILD_MIN | int | 4 | √ | null |
|
|
The minimum number of registrants for multi-person registration with this fee |
|||||||
| MULTI_CHILD_MAX | int | 4 | √ | null |
|
|
The maximum number of registrants for multi-person registration with this fee |
|||||||
| ACTIVATION_DATE | date | 20 | √ | null |
|
|
The first available date for this fee |
|||||||
| EXPIRATION_DATE | date | 20 | √ | null |
|
|
The last available date for this fee |
|||||||
| MIN_PLAYERS | int | 4 | √ | null |
|
|
The minimum number of team players for this fee to be applied |
|||||||
| MAX_PLAYERS | int | 4 | √ | null |
|
|
The maximum number of team players for this fee to be applied |
|||||||
| ACTIVATION_PASSWORD | varchar | 100 | √ | null |
|
|
The answer to the online question that must be entered to activate this fee |
|||||||
| ALLOWED_QUANTITY_CHANGED | varchar | 5 | √ | null |
|
|
Whether the quantity for this fee can be changed online (Yes / No) |
|||||||
| ALLOWED_MIN_QUANTITY | int | 4 | √ | null |
|
|
The minimum allowed quantity for this fee to be applied |
|||||||
| ALLOWED_MAX_QUANTITY | int | 4 | √ | null |
|
|
The maximum allowed quantity for this fee to be applied |
|||||||
| AGES_MIN | int | 4 | √ | null |
|
|
The minimum age for this fee to be applied |
|||||||
| AGES_MAX | int | 4 | √ | null |
|
|
The maximum age for this fee to be applied |
|||||||
| CUSTOMER_TYPE_ID | int | 4 | √ | null |
|
|
The customer type ID that this charge applies to |
|||||||
| CUSTOMER_TYPE | varchar | 60 | √ | null |
|
|
The customer type that this fee applies to |
|||||||
| PRORATE_REFUND_FEES | varchar | 5 | √ | null |
|
|
Whether a refund of this fee can be prorated (Yes / No) |
|||||||
| ACTIVITY_TEAM_CATEGORY_ID | int | 4 | √ | null |
|
|
Activity team category ID |
|||||||
| TEAM_PREFILL_CONDITION | varchar | 20 | √ | null |
|
|
The team prefill condition for this fee (No Teams or Groups / Teams and Groups / Teams Only / Groups Only) |
|||||||
| USE_REGIONAL_PRICING | varchar | 5 | √ | null |
|
|
Whether regional pricing should be used (Yes / No) |
|||||||
| MULTI_ACTIVITY_MIN | int | 4 | √ | null |
|
|
The minimum number of activities for multi-activity registration with this fee |
|||||||
| MULTI_ACTIVITY_MAX | int | 4 | √ | null |
|
|
The maximum number of activities for multi-activity registration with this fee |
|||||||
| MULTI_CHILD_APPLIES_TO_ALL | varchar | 5 | √ | null |
|
|
Whether multi-person registration with this fee applies to all registrants up to the max number entered |
|||||||
| MULTI_ACTIVITY_APPLIES_TO_ALL | varchar | 5 | √ | null |
|
|
Whether multi-activity registration with this fee applies to all activities up to the max number entered |
|||||||
| TRIAL_CLASS_FEE | varchar | 5 | √ | null |
|
|
Whether this charge can be a trial class fee (Yes / No) |
|||||||
| ACTIVATE_QUALIFYING_ACTIVITIES | varchar | 5 | √ | null |
|
|
Whether this charge has qualifying activity criteria (Yes / No) |
|||||||
| APPLIES_TO_ALL_ACTIVITIES | varchar | 5 | √ | null |
|
|
Whether this charge applies to all activities (Yes / No) |
|||||||
| ACTIVITY_GROUP_NUMBER | varchar | 50 | √ | null |
|
|
The specific group number that his charge applies to |
|||||||
| QUALIFYING_TIME_PERIOD | int | 4 | √ | null |
|
|
This charge will be valid only within the last this number of months of the selected season and/or child season |
|||||||
| PER_BOOKING | varchar | 5 | √ | null |
|
|
Whether this fee is charged per booking (Yes / No) |
|||||||
| EXCLUDE_FROM_PAYMENT_PLAN | varchar | 5 | √ | null |
|
|
Whether this charge should be excluded from any payment plan (Yes / No) |
|||||||
| PER_BOOKING_PER_HOUR | varchar | 5 | √ | null |
|
|
Whether this fee is charged per booking per hour (Yes / No) |
|||||||
| QUALIFYING_MIN_REGISTRATIONS | int | 4 | √ | null |
|
|
This charge will apply if the customer has had at least this number of registrations |
|||||||
| QUALIFYING_MAX_REGISTRATIONS | int | 4 | √ | null |
|
|
This charge will apply if the customer has had at most this number of registrations |
|||||||
| VOLUME_PRICING_PLAN_ID | int | 4 | √ | null |
|
|
Volume pricing plan ID |
|||||||
| MULTI_PERSON_QUALIFYING_TIME_PERIOD | int | 4 | √ | null |
|
|
This multi-person registration fee will only consider prior registrations within this last number of months |
|||||||
| PER_BOOKING_PER_HOUR_MIN | int | 4 | √ | null |
|
|
The minimum per booking per hour units to be charged |
|||||||
| PER_BOOKING_PER_HOUR_MAX | int | 4 | √ | null |
|
|
The maximum per booking per hour units to be charged |
|||||||
| PER_BOOKING_PER_HOUR_DURATION | int | 4 | √ | null |
|
|
The number of minutes that each unit of a per booking per hour fee will be charged for |
|||||||
| SYSTEM_GL_ACCOUNT_PACKAGE_ID | int | 4 | √ | null |
|
|
System GL account package ID |
|||||||
| SYSTEM_GL_ACCOUNT_PACKAGE | varchar | 50 | √ | null |
|
|
System GL account package name |
|||||||
| 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) |
|||||||
| MULTI_REGISTRATION_COUNT_ALL_ENROLLMENTS | varchar | 5 | √ | null |
|
|
Whether multi-person registration will include later enrollments in its count |
|||||||
| DISCOUNT_CHEAPEST | varchar | 5 | √ | null |
|
|
Whether the discount should be applied to the lowest cost enrollment in a multi-person registration |
|||||||
| IS_MULTI_GL | varchar | 5 | √ | null |
|
|
Whether this fee splits GL postings across multiple GL accounts (Yes / No) |
|||||||
| PRORATED_EARLIEST_TO_LATEST | varchar | 5 | √ | null |
|
|
Whether the amount should be prorated from earlies to latest (Yes / No) |
|||||||
| DROP_IN_FEE | varchar | 5 | √ | null |
|
|
Whether this fee is a drop-in fee (Yes / No) |
|||||||
| FEE_DESCRIPTION | varchar | 8000 | √ | null |
|
|
The description of this fee |
|||||||
| 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 |