Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
||||||||||
| AR_SCHEDULED_HEADER_ID | int | 4 | √ | null |
|
|
The AR schedule header ID identifying the payment plan |
||||||||||
| CARD_TYPE_ID | Unknown | 0 | null |
|
|
||||||||||||
| RECEIPT_PAYMENT_ID | int | 4 | √ | null |
|
|
The receipt payment ID that generated the payment plan |
||||||||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The ID receipt that generated the payment plan |
||||||||||
| RECEIPT_DATE | date | 20 | √ | null |
|
|
The date of the receipt that generated the payment plan |
||||||||||
| RECEIPT_NUMBER | varchar | 20 | √ | null |
|
|
The number of the receipt that generated the payment plan |
||||||||||
| PAYER_CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer that is the payer of the payment plan |
||||||||||
| PAYER_COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company that is the payer of the payment plan |
||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
The site ID where the payment plan was generated |
||||||||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
The workstation ID where the payment plan was generated |
||||||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The user ID who generated the payment plan |
||||||||||
| CREATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the payment plan was generated |
||||||||||
| ORIGINAL_AMOUNT | money | 21,4 | √ | null |
|
|
The original total of the payment plan |
||||||||||
| BILLING_TYPE | varchar | 20 | √ | null |
|
|
The billing type used to generate the payment plan (None / Weekly / Every other week / Twice a month / Monthly / Quarterly / Every four weeks / Custom / Per Session) |
||||||||||
| FIRST_PAYMENT_DATE | date | 20 | √ | null |
|
|
The first payment due date for the payment plan |
||||||||||
| NUMBER_OF_PAYMENTS | int | 4 | √ | null |
|
|
The number of scheduled payments for the payment plan |
||||||||||
| AVERAGE_AMOUNT | money | 21,4 | √ | null |
|
|
The average scheduled amount for the payment plan |
||||||||||
| AUTO_PAYMENT_TYPE | varchar | 20 | √ | null |
|
|
The automatic payment type for the payment plan (None / Credit Card / ECP / Manual Deduction) |
||||||||||
| AUTO_PAYMENT_SUSPENDED | varchar | 5 | √ | null |
|
|
Whether automatic payments are suspended for the payment plan (Yes/No) |
||||||||||
| PERMIT_ID | int | 4 | √ | null |
|
|
The permit ID that the payment plan was generated for |
||||||||||
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
The membership ID that the payment plan was generated for, but only if no other charge types or other memberships are included in the payment plan |
||||||||||
| CURRENT_DUE_AMOUNT | money | 21,4 | √ | null |
|
|
The current amount due total of the payment plan |
||||||||||
| FUTURE_DUE_AMOUNT | money | 21,4 | √ | null |
|
|
The future amount due total of the payment plan |
||||||||||
| 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) |
||||||||||
| SAVED_CREDIT_CARD_ID | int | 4 | √ | null |
|
|
ID of the saved credit card or electronic check to be used for scheduled automatic payments |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| AR_SCHEDULED_HEADERS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| AR_SCHEDULED_HEADERS_AR_SCHEDULED_HEADER_ID_ORG_ID_UQ | Must be unique | Asc/Asc | AR_SCHEDULED_HEADER_ID + ORG_ID |
| AR_SCHEDULED_HEADERS_MEMBERSHIP_ID_IX | Performance | Asc | MEMBERSHIP_ID |
| AR_SCHEDULED_HEADERS_PAYER_COMPANY_ID_IX | Performance | Asc | PAYER_COMPANY_ID |
| AR_SCHEDULED_HEADERS_PAYER_CUSTOMER_ID_IX | Performance | Asc | PAYER_CUSTOMER_ID |
| AR_SCHEDULED_HEADERS_PERMIT_ID_IX | Performance | Asc | PERMIT_ID |
| AR_SCHEDULED_HEADERS_RECEIPT_HEADER_ID_IX | Performance | Asc | RECEIPT_HEADER_ID |
| AR_SCHEDULED_HEADERS_RECEIPT_PAYMENT_ID_IX | Performance | Asc | RECEIPT_PAYMENT_ID |
| AR_SCHEDULED_HEADERS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| AR_SCHEDULED_HEADERS_SAVED_CREDIT_CARD_ID_IX | Performance | Asc | SAVED_CREDIT_CARD_ID |
| AR_SCHEDULED_HEADERS_SITE_ID_IX | Performance | Asc | SITE_ID |
| AR_SCHEDULED_HEADERS_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| AR_SCHEDULED_HEADERS_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |