Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|
| PAYMENTPLAN_CONFIG_ID | int | 4 | null |
|
|
ID of the this table |
||
| ACTIVITY_ID | int | 4 | √ | null |
|
|
Activity ID for payment plan |
|
| INITIAL_AMOUNT | money | 21,4 | √ | null |
|
|
Initital payment amount |
|
| CHARGE_CREDIT_CARD | varchar | 5 | √ | null |
|
|
Whether the saved credit card should be charged when payments become due |
|
| ALLOW_ONLINE | varchar | 5 | √ | null |
|
|
Whether this payment plan is allowed online (Yes/No) |
|
| ALLOW_PERCENTAGE_OF_BALANCE | varchar | 5 | √ | null |
|
|
Allow percentage of balance payment |
|
| PAYMENT_PLAN_NAME | varchar | 40 | √ | null |
|
|
The name of the payment plan |
|
| IS_DEFAULT | varchar | 5 | √ | null |
|
|
Is this the default payment plan |
|
| CHARGE_ID | int | 4 | √ | null |
|
|
The ID of the base charge used to derive the payment plan |
|
| CHARGE_NAME | varchar | 50 | √ | null |
|
|
The name of the base charge used to derive the payment plan |
|
| CHARGE_TYPE | varchar | 100 | √ | null |
|
|
The type of charge (Fee/Discount) |
|
| FEE_AMOUNT | money | 21,4 | √ | null |
|
|
Payment plan price amount |
|
| GLACCOUNT_ID | int | 4 | √ | null |
|
|
The ID of the GL Account that the payment plan amount will be posted to |
|
| PREFILL_CONDITION | varchar | 50 | √ | null |
|
|
The prefill condition for this payment plan (Never / Always / If Resident / If Non-resident / If Minor / If Senior / If Internet / If Member / If Non-member) |
|
| DISCOUNTABLE | varchar | 5 | √ | null |
|
|
Whether this charge can be payment planed (Yes / No) |
|
| DISCOUNT_TYPE | varchar | 50 | √ | null |
|
|
The type of discount for payment plan (Amount / Percent) |
|
| OVERRIDE_FLAG | varchar | 50 | √ | null |
|
|
Whether this charge can be overridden |
|
| DISCOUNT_PERCENT | money | 21,4 | √ | null |
|
|
The discount percentage for the payment plan |
|
| TAXABLE_BY_TAX1 | varchar | 5 | √ | null |
|
|
Whether tax 1 applies to this payment plan (Yes/No) |
|
| TAXABLE_BY_TAX2 | varchar | 5 | √ | null |
|
|
Whether tax 2 applies to this payment plan (Yes/No) |
|
| TAXABLE_BY_TAX3 | varchar | 5 | √ | null |
|
|
Whether tax 3 applies to this payment plan (Yes/No) |
|
| TAXABLE_BY_TAX4 | varchar | 5 | √ | null |
|
|
Whether tax 4 applies to this payment plan (Yes/No) |
|
| CUSTOMERTYPE_ID | int | 4 | √ | null |
|
|
The customer type ID that this charge applies to |
|
| CUSTOMERTYPE | varchar | 100 | √ | null |
|
|
The customer type description (General/General Public) |
|
| AGES_MAX | int | 4 | √ | null |
|
|
The maximum age (years) allowed for this activity |
|
| AGES_MIN | int | 4 | √ | null |
|
|
The minimum age (years) allowed for this activity |
|
| ACTIVATION_DATE | datetime | 16,3 | √ | null |
|
|
The first available date for this payment plan |
|
| EXPIRATION_DATE | datetime | 16,3 | √ | null |
|
|
The last available date for this payment plan |
|
| EXCLUDE_FROM_PAYMENT_PLAN | varchar | 5 | √ | null |
|
|
Whether the fee amount for the target should be excluded from any payment plan (Yes/No) |
|
| ENABLE_USAGE_CHARGE | varchar | 5 | √ | null |
|
|
Enable usage charges for the payment plan |
|
| PAYMENT_PLAN_DESCRIPTION | varchar | 250 | √ | null |
|
|
The description of the payment plan |
|
| INITIAL_PERCENT | money | 21,4 | √ | null |
|
|
Initial payment percentage |
|
| SEASON_ID | int | 4 | √ | null |
|
|
The parent season ID of the activity |
|
| CHILD_SEASON_ID | int | 4 | √ | null |
|
|
The child season ID of the activity |
|
| PAYMENT_SCHEDULE_TYPE | varchar | 100 | √ | null |
|
|
Type of payment schedule for this permit(None / Weekly / Monthly / By First Booking / By Each Booking) |
|
| PAYMENT_DISTRIBUTION_TYPE | varchar | 100 | √ | null |
|
|
Distribution type for payment plan (Unknown, Even distribution, Custom percentage distribution, Based on meetings per payment cycle) |
|
| INITIAL_PAYMENT_TYPE | varchar | 100 | √ | null |
|
|
Type of initial payment (Unknown, Fixed amount, Percent of total, First payment cycle due) |
|
| PAYMENT_CYCLE | int | 4 | √ | null |
|
|
How payment plans should be billed (No Automatic Plans / Weekly / Every Other Week / Twice a Month / Monthly / Quarterly / Every Four Weeks / Per Session) |
|
| NUM_DAYS_INTO_PAYMENT_CYCLE | int | 4 | √ | null |
|
|
Number of days after start date to charge |
|
| PAYMENT_CYCLE_START_TYPE | varchar | 100 | √ | null |
|
|
Type of start of payment plan (Unknown, Payment cycle for first_meeting, Next after sale) |
|
| NUM_PAYMENT_CYCLE_EVEN_DISTRIBUTIONS | int | 4 | √ | null |
|
|
Number of payment cycles to distribute payments across |
|
| INCLUDE_PAST_MEETING_DATES | varchar | 100 | √ | null |
|
|
Include previous meeting dates in payment plan (Yes/No) |
|
| TAXABLE_BY_TAX5 | varchar | 5 | √ | null |
|
|
Whether tax 5 applies to this payment plan (Yes/No) |
|
| TAXABLE_BY_TAX6 | varchar | 5 | √ | null |
|
|
Whether tax 6 applies to this payment plan (Yes/No) |
|
| TAXABLE_BY_TAX7 | varchar | 5 | √ | null |
|
|
Whether tax 7 applies to this payment plan (Yes/No) |
|
| TAXABLE_BY_TAX8 | varchar | 5 | √ | null |
|
|
Whether tax 8 applies to this payment plan (Yes/No) |
|
| PACKAGE_ID | int | 4 | √ | null |
|
|
The package ID that the revenue applies to |
|
| DUE_DATE_LEAD_TIME_DAYS | int | 4 | √ | null |
|
|
The number of days prior to each payment cycle that payment should be due |
|
| SYSTEM_GL_ACCOUNT_PACKAGE_ID | int | 4 | √ | null |
|
|
||
| PRORATED_EARLIEST_TO_LATEST | varchar | 5 | √ | null |
|
|
Whether the amount should be prorated from earlies to latest (Yes / No) |
|
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for INTernal use) |
|
| ORG_ID | int | 4 | null |
|
|
Your organization’s unique identifier in the Active Net system |
||
| 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 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_PAYMENTPLANCONFIG | Primary key | Asc/Asc | PAYMENTPLAN_CONFIG_ID + ORG_ID |