STANDARD_CHARGES

0 rows


Description

Master table showing defined standard resource charges data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ACTIVE_HUB_KEY int identity 4 √ null

The Hub record ID
STANDARD_CHARGE_ID int 4 √ null
CHARGE_QUALIFICATION_LINKS.STANDARD_CHARGE_ID Defined in XML R
RECEIPT_DETAILS.STANDARD_CHARGE_ID Defined in XML R
SCHEDULED_FEE_CHANGES.STANDARD_CHARGE_ID Defined in XML R

Standard charge ID
CHARGE_ID int 4 √ null
CHARGES.CHARGE_ID Defined in XML R

The charge ID that this standard charge is based on
CHARGE_TYPE varchar 20 √ null

The type of charge (Fee / Discount)
CUSTOMER_TYPE_ID int 4 √ null
CUSTOMER_TYPES.CUSTOMER_TYPE_ID Defined in XML R

The customer type ID that this charge applies to
SITE_ID int 4 √ null
SITES.SITE_ID Defined in XML R

The site ID that this charge applies to
CENTER_ID int 4 √ null
CENTERS.CENTER_ID Defined in XML R

Center ID that this charge applies to
FACILITY_ID int 4 √ null
FACILITIES.FACILITY_ID Defined in XML R

Facility ID that this charge applies to
FACILITY_TYPE_ID int 4 √ null
FACILITY_TYPES.FACILITY_TYPE_ID Defined in XML R

Facility type ID 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
EVENT_TYPES.EVENT_TYPE_ID Defined in XML R

The event type ID that this charge applies to
GLACCOUNT_ID int 4 √ null
GLACCOUNTS.GLACCOUNT_ID Defined in XML R

The default GL account ID to post this charge to
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
STAGE_SEQUENCES.STAGE_SEQUENCE_ID Defined in XML R

The stage sequence ID 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_PACKAGES.SYSTEM_GL_ACCOUNT_PACKAGE_ID Defined in XML R

System account package ID
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 (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)
IS_SCHEDULED_RATE char 3 √ null

If it is for booking date

Indexes

Constraint Name Type Sort Column(s)
STANDARD_CHARGES_ACTIVE_HUB_KEY_PK Primary key Asc ACTIVE_HUB_KEY
STANDARD_CHARGES_CENTER_ID_IX Performance Asc CENTER_ID
STANDARD_CHARGES_CHARGE_ID_IX Performance Asc CHARGE_ID
STANDARD_CHARGES_CUSTOMER_TYPE_ID_IX Performance Asc CUSTOMER_TYPE_ID
STANDARD_CHARGES_EVENT_TYPE_ID_IX Performance Asc EVENT_TYPE_ID
STANDARD_CHARGES_FACILITY_ID_IX Performance Asc FACILITY_ID
STANDARD_CHARGES_FACILITY_TYPE_ID_IX Performance Asc FACILITY_TYPE_ID
STANDARD_CHARGES_GLACCOUNT_ID_IX Performance Asc GLACCOUNT_ID
STANDARD_CHARGES_ROW_VERSION_IX Performance Asc ROW_VERSION
STANDARD_CHARGES_SITE_ID_IX Performance Asc SITE_ID
STANDARD_CHARGES_STAGE_SEQUENCE_ID_IX Performance Asc STAGE_SEQUENCE_ID
STANDARD_CHARGES_STANDARD_CHARGE_ID_ORG_ID_UQ Must be unique Asc/Asc STANDARD_CHARGE_ID + ORG_ID
STANDARD_CHARGES_SYSTEM_GL_ACCOUNT_PACKAGE_ID_IX Performance Asc SYSTEM_GL_ACCOUNT_PACKAGE_ID

Relationships

Close relationships within degrees of separation