Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
||
| GLOBAL_SURCHARGE_ID | int | 4 | √ | null |
|
|
Global surcharge ID |
|
| GLOBAL_SURCHARGE_NAME | varchar | 60 | √ | null |
|
|
Global surcharge name |
|
| CHARGE_ID | int | 4 | √ | null |
|
|
Charge ID |
|
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
The default GL account ID to post this surcharge to |
|
| GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
GL account name |
|
| GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number |
|
| SYSTEM_GL_ACCOUNT_PACKAGE_ID | int | 4 | √ | null |
|
|
System account package ID |
|
| SYSTEM_GL_ACCOUNT_PACKAGE | varchar | 50 | √ | null |
|
|
System GL account package name |
|
| SURCHARGE_TYPE | varchar | 10 | √ | null |
|
|
The type of surcharge (Amount / Percent) |
|
| SURCHARGE_AMOUNT | money | 21,4 | √ | null |
|
|
The default surcharge amount |
|
| SURCHARGE_PERCENT | money | 21,4 | √ | null |
|
|
The default surcharge percentage |
|
| PREFILL_CONDITION | varchar | 20 | √ | null |
|
|
The prefill condition for this global surcharge (Never / Always / If Resident / If Non-resident / If Minor / If Senior / If Internet / If Member / If Non-member) |
|
| APPLIES_TO_ALL_ACTIVITIES | varchar | 5 | √ | null |
|
|
Whether this surcharge applies to all activities (Yes / No) |
|
| ACTIVITY_GROUP_NUMBER | varchar | 10 | √ | null |
|
|
The specific activity group number that this surcharge applies to |
|
| ACTIVATION_DATE | date | 20 | √ | null |
|
|
The first available date for this surcharge |
|
| EXPIRATION_DATE | date | 20 | √ | null |
|
|
The last available date for this surcharge |
|
| APPLIES_TO_PRIMARY_FEE | varchar | 5 | √ | null |
|
|
Whether this surcharge is applied to the primary fee (Yes / No) |
|
| DISCOUNTABLE | varchar | 5 | √ | null |
|
|
Whether this surcharge can be discounted (Yes / No) |
|
| TAXABLE_BY_TAX_1 | varchar | 5 | √ | null |
|
|
Whether tax 1 applies to this surcharge (Yes / No) |
|
| TAXABLE_BY_TAX_2 | varchar | 5 | √ | null |
|
|
Whether tax 2 applies to this surcharge (Yes / No) |
|
| TAXABLE_BY_TAX_3 | varchar | 5 | √ | null |
|
|
Whether tax 3 applies to this surcharge (Yes / No) |
|
| TAXABLE_BY_TAX_4 | varchar | 5 | √ | null |
|
|
Whether tax 4 applies to this surcharge (Yes / No) |
|
| TAXABLE_BY_TAX_5 | varchar | 5 | √ | null |
|
|
Whether tax 5 applies to this surcharge (Yes / No) |
|
| TAXABLE_BY_TAX_6 | varchar | 5 | √ | null |
|
|
Whether tax 6 applies to this surcharge (Yes / No) |
|
| TAXABLE_BY_TAX_7 | varchar | 5 | √ | null |
|
|
Whether tax 7 applies to this surcharge (Yes / No) |
|
| TAXABLE_BY_TAX_8 | varchar | 5 | √ | null |
|
|
Whether tax 8 applies to this surcharge (Yes / No) |
|
| RETIRED | varchar | 5 | √ | null |
|
|
Whether this global surcharge has been retired (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 |