PACKAGE_FEES

The Hub record ID

Package fee ID

Package ID which this fee belongs to

Package name which this fee belongs to

Charge ID

Charge name

The type of charge (Fee / Discount / Scholarship)

The default GL account ID to post this charge to

GL account name

GL account number

The default discount percentage

The type of discount (Amount / Percent)

The default fee or discount amount

The order in which the fee should be applied

Whether this charge can be overridden (Always / Never / By Password)

The prefill condition for this fee (Never / Always / If Resident / If Non-resident / If Minor / If Senior / If Internet / If Member / If Non-member)

Whether this charge is a primary fee (Yes / No)

Whether tax 1 applies to this fee (Yes / No)

Whether tax 2 applies to this fee (Yes / No)

Whether tax 3 applies to this fee (Yes / No)

Whether tax 4 applies to this fee (Yes / No)

Whether tax 5 applies to this fee (Yes / No)

Whether tax 6 applies to this fee (Yes / No)

Whether tax 7 applies to this fee (Yes / No)

Whether tax 8 applies to this fee (Yes / No)

Whether this charge can be discounted (Yes / No)

The first available date for this fee

The last available date for this fee

The date that the fee amount is scheduled to automatically change

The amount that the fee is scheduled to automatically change to

Whether this fee can be prorated (Yes / No)

Whether this fee is calculated on a per use basis (Yes / No)

The minimum number of passes purchased for this fee to be applied

The maximum number of passes purchased for this fee to be applied

Whether this fee is calculated on a per pass basis (Yes / No)

The customer type ID that this charge applies to

The customer type that this fee applies to

The minimum age for this fee to be applied

The maximum age for this fee to be applied

Whether this fee is applied only to renewals (Yes / No)

The minimum number of time periods purchased for this discount to apply

Whether refunds of this fee can be prorated (Yes / No)

The minimum number of uses purchased for this fee to be applied

The maximum number of uses purchased for this fee to be applied

Whether this charge should be excluded from any payment plan (Yes / No)

The minimum date that the fee can be prorated during purchase

The minimum date that the fee can be prorated during renewal

System GL account package ID

System GL account package name

The order in which the discount should be applied

Whether the fee should only apply to suspended cycle of auto-renewal (Yes / No)

Whether this fee splits GL postings across multiple GL accounts (Yes / No)

The description of this fee

Date and time Hub record was last modified

The Hub sync process ID

Your organization’s unique identifier in the Active Net system