Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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_CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the customer that is the payer of the payment plan |
||||||||||
| PAYER_CUSTOMER_NAME_LAST_FIRST | varchar | 512 | √ | null |
|
|
The name of the customer that is the payer of the payment plan (last name, first name) |
||||||||||
| PAYER_COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company that is the payer of the payment plan |
||||||||||
| PAYER_COMPANY_NAME | varchar | 255 | √ | null |
|
|
The name 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 |
||||||||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
The site name where the payment plan was generated |
||||||||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
The workstation ID where the payment plan was generated |
||||||||||
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
The workstation name where the payment plan was generated |
||||||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The user ID who generated the payment plan |
||||||||||
| SYSTEM_USER_NAME | varchar | 511 | √ | null |
|
|
The name of the user who generated the payment plan |
||||||||||
| CREATED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the payment plan was generated |
||||||||||
| CREATED_DATE_ONLY | date | 20 | √ | null |
|
|
The date 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) |
||||||||||
| SAVED_CREDIT_CARD_ID | int | 4 | √ | null |
|
|
ID of the saved credit card or electronic check to be used for scheduled automatic payments |
||||||||||
| CARD_TYPE | varchar | 50 | √ | null |
|
|
Name of the credit card type to be used for scheduled automatic payments |
||||||||||
| CARD_NUMBER | varchar | 20 | √ | null |
|
|
Masked credit card number to be used for scheduled automatic payments |
||||||||||
| CARD_EXPIRATION | varchar | 10 | √ | null |
|
|
Credit card expiration date (mm/yyyy) to be used for scheduled automatic payments |
||||||||||
| BANK_ROUTING_NUMBER | varchar | 50 | √ | null |
|
|
Bank routing number to be used for scheduled automatic payments |
||||||||||
| BANK_ACCOUNT_TYPE | varchar | 1 | √ | null |
|
|
Bank account type to be used for scheduled automatic payments |
||||||||||
| BANK_ACCOUNT_NUMBER | varchar | 50 | √ | null |
|
|
Bank account number to be used for scheduled automatic payments |
||||||||||
| 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 |
||||||||||
| PERMIT_NUMBER | int | 4 | √ | null |
|
|
The permit number 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 |
||||||||||
| ACTIVE_HUB_KEY | int | 4 | null |
|
|
The Hub record ID |
|||||||||||
| 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 |