Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| LOCKER_FEE_ID | int | 4 | null |
|
|
The locker fee ID |
|||||
| FEE_DESCRIPTION | varchar | 8000 | √ | null |
|
|
The description of the fee |
||||
| CHARGE_ID | int | 4 | √ | null |
|
|
The ID of the base charge used to derive the fee |
||||
| CHARGE_NAME | varchar | 50 | √ | null |
|
|
The name of the base charge used to derive the fee |
||||
| CHARGE_TYPE | varchar | 20 | √ | null |
|
|
The type of charge (Fee / Discount) |
||||
| LOCKER_ROOM_ID | int | 4 | √ | null |
|
|
The ID of the locker room that the fee is limited to |
||||
| LOCKER_ROOM_NAME | varchar | 150 | √ | null |
|
|
The name of the locker room that the fee is limited to |
||||
| LOCKER_SIZE_ID | int | 4 | √ | null |
|
|
The ID of the locker size that the fee is limited to |
||||
| LOCKER_SIZE_NAME | varchar | 50 | √ | null |
|
|
The name of the locker size that the fee is limited to |
||||
| DISCOUNT_TYPE | varchar | 10 | √ | null |
|
|
The type of discount (Amount / Percent) |
||||
| DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The default discount percentage |
||||
| 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 fee amount |
||||
| FEE_ORDER | int | 4 | √ | null |
|
|
The order in which the fee should be applied |
||||
| 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 |
||||
| 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) |
||||
| PRIMARY_FEE | varchar | 5 | √ | null |
|
|
Whether this charge is a primary fee (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) |
||||
| DISCOUNTABLE | varchar | 5 | √ | null |
|
|
Whether this charge can be discounted (Yes / No) |
||||
| ACTIVATION_DATE | date | 20 | √ | null |
|
|
The first available date for this fee |
||||
| EXPIRATION_DATE | date | 20 | √ | null |
|
|
The last available date for this fee |
||||
| 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 |
||||
| 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 |
||||
| 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 account package ID |
||||
| SYSTEM_GL_ACCOUNT_PACKAGE | varchar | 50 | √ | null |
|
|
System GL account package name |
||||
| 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 |