Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||||||||
| STANDARD_CHARGE_ID | int | 4 | √ | null |
|
|
Standard charge ID |
||||||||||
| CHARGE_ID | int | 4 | √ | null |
|
|
The charge ID that this standard charge is based on |
||||||||||
| CHARGE_NAME | varchar | 50 | √ | null |
|
|
The charge name for the fee |
||||||||||
| CHARGE_TYPE | varchar | 20 | √ | null |
|
|
The type of charge (Fee / Discount) |
||||||||||
| 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 charge applies to |
||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
The site ID that this charge applies to |
||||||||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
Site name |
||||||||||
| CENTER_ID | int | 4 | √ | null |
|
|
Center ID that this charge applies to |
||||||||||
| CENTER_NAME | varchar | 255 | √ | null |
|
|
Center name that this charge applies to |
||||||||||
| FACILITY_ID | int | 4 | √ | null |
|
|
Facility ID that this charge applies to |
||||||||||
| FACILITY_NAME | varchar | 255 | √ | null |
|
|
Facility name that this charge applies to |
||||||||||
| FACILITY_TYPE_ID | int | 4 | √ | null |
|
|
Facility type ID that this charge applies to |
||||||||||
| FACILITY_TYPE | varchar | 80 | √ | null |
|
|
Facility type name that this charge applies to |
||||||||||
| RESOURCE_TYPE | varchar | 10 | √ | null |
|
|
The resource type that this charge applies to (Facility / Equipment) |
||||||||||
| EVENT_TYPE_ID | int | 4 | √ | null |
|
|
The event type ID that this charge applies to |
||||||||||
| EVENT_TYPE | varchar | 102 | √ | null |
|
|
The event type name that this charge applies to |
||||||||||
| 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 |
||||||||||
| ACTIVATION_DATE | date | 20 | √ | null |
|
|
The first available date for this fee |
||||||||||
| EXPIRATION_DATE | date | 20 | √ | null |
|
|
The last available date for this fee |
||||||||||
| CHARGE_ONCE | varchar | 5 | √ | null |
|
|
Whether this charge should only be charged once per permit (Yes / No) |
||||||||||
| DEPOSIT | varchar | 5 | √ | null |
|
|
Whether this charge is a deposit (Yes / No) |
||||||||||
| DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage |
||||||||||
| DISCOUNT_TYPE | varchar | 10 | √ | null |
|
|
The type of discount (Amount / Percent) |
||||||||||
| DEFAULT_QUANTITY | int | 4 | √ | null |
|
|
The default quantity |
||||||||||
| DEFAULT_FEE_AMOUNT | money | 21,4 | √ | null |
|
|
The default fee or discount amount |
||||||||||
| UNIT_OF_MEASURE | varchar | 40 | √ | null |
|
|
The default unit of measure for the amount |
||||||||||
| STAGE_SEQUENCE_ID | int | 4 | √ | null |
|
|
The stage sequence ID that this charge applies to |
||||||||||
| STAGE_SEQUENCE | varchar | 50 | √ | null |
|
|
The stage sequence name that this charge applies to |
||||||||||
| DISCOUNTABLE | varchar | 5 | √ | null |
|
|
Whether this charge can be discounted (Yes / No) |
||||||||||
| PRIMARY_FEE | varchar | 5 | √ | null |
|
|
Whether this charge is a primary fee (Yes / No) |
||||||||||
| PREFILL_CONDITION | varchar | 20 | √ | null |
|
|
The prefill condition for this charge (Never / Always / If Resident / If Non-resident / If Minor / If Senior / If Internet / If Member / If Non-member) |
||||||||||
| AGES_MIN | int | 4 | √ | null |
|
|
The maximum age for this fee to be applied |
||||||||||
| AGES_MAX | int | 4 | √ | null |
|
|
The minimum age for this fee to be applied |
||||||||||
| FEE_ORDER | int | 4 | √ | null |
|
|
The order in which the fee should be applied |
||||||||||
| ONLINE_QUESTION | varchar | 100 | √ | null |
|
|
Online question to be asked for this charge |
||||||||||
| 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 |
||||||||||
| PERMIT_LEVEL | varchar | 5 | √ | null |
|
|
Whether this fee is applied at the permit level (Yes / No) |
||||||||||
| EXCLUDE_FROM_PAYMENT_PLAN | varchar | 5 | √ | null |
|
|
Whether this charge should be excluded from any payment plan (Yes / No) |
||||||||||
| 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 |
||||||||||
| EXTRA_BOOKING_FEE | varchar | 5 | √ | null |
|
|
Whether this charge can be an extra booking fee (Yes / No) |
||||||||||
| FOR_EQUIPMENT_LENDING | varchar | 5 | √ | null |
|
|
Whether this charge is available for equipment lending fees (Yes / No) |
||||||||||
| CLAIM_CHARGE | varchar | 5 | √ | null |
|
|
Whether this charge can be a claim fee (Yes / No) |
||||||||||
| HOLIDAY_RATE_AMOUNT | money | 21,4 | √ | null |
|
|
The default fee or discount amount for holiday dates |
||||||||||
| HOLIDAY_RATE_PERCENT | money | 21,4 | √ | null |
|
|
The default percent for holiday dates |
||||||||||
| LAST_MINUTE_RATE | varchar | 5 | √ | null |
|
|
Whether this charge is a last-minute fee (Yes / No) |
||||||||||
| LAST_MINUTE_FEE_AMOUNT | money | 21,4 | √ | null |
|
|
The fee amount when applied as a last-minute fee |
||||||||||
| LAST_MINUTE_PERCENT | money | 21,4 | √ | null |
|
|
The discount percentage when applied as a last-minute fee |
||||||||||
| PRIOR_TO_BOOKING | int | 4 | √ | null |
|
|
The number of units prior to the start of the booking for this to be considered as a last-minute fee |
||||||||||
| PRIOR_TO_BOOKING_UNIT | varchar | 10 | √ | null |
|
|
The type of units prior to the start of the booking for this to be considered as a last-minute fee (Days / Hours) |
||||||||||
| 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) |
||||||||||
| 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 |
||||||||||
| source_id | int | 4 | √ | null |
|
|
The ID value from the Active Net system |
||||||||||
| IS_SCHEDULED_RATE | char | 3 | √ | null |
|
|
If it is for booking date |