Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ACTIVE_HUB_KEY | int identity | 4 | √ | null |
|
|
The Hub record ID |
|||||||||||||||||||
| RECEIPT_PAYMENT_ID | int | 4 | √ | null |
|
|
Receipt payment ID |
|||||||||||||||||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
ID of the receipt header that the payment belongs to |
|||||||||||||||||||
| SITE_ID | int | 4 | √ | null |
|
|
ID of the site where the payment was created |
|||||||||||||||||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID of the workstation where the payment was created |
|||||||||||||||||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the user who created the payment |
|||||||||||||||||||
| CASH_SUMMARY_SHEET_ID | int | 4 | √ | null |
|
|
ID of the cash summary sheet that was active on the workstation when the payment was created |
|||||||||||||||||||
| CREATION_DATE_TIME | datetime | 16,3 | √ | null |
|
|
Date and time that the payment was created |
|||||||||||||||||||
| COMPANY_ID | int | 4 | √ | null |
|
|
ID of the company who made the payment |
|||||||||||||||||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the customer who made the payment |
|||||||||||||||||||
| PAYMENT_AMOUNT | money | 21,4 | √ | null |
|
|
The amount of the payment processed or of the payment plan created |
|||||||||||||||||||
| PAYMENT_TYPE | varchar | 30 | √ | null |
|
|
The type of payment (Cash / Cash Refund / Check / Check Refund / Credit Card / Credit Card Refund / Credit Memo / Debit Card / Debit Card Refund / ECP / ECP Refund / Financial Aid / Financial Aid Payment Plan / Gift Card / Gift Card Refund / Journal Entry / Manual Deduction / No Payment / Non-Monetary / Payment From Account / Payment Plan / Refund To Account) |
|||||||||||||||||||
| CARD_TYPE_ID | int | 4 | √ | null |
|
|
ID of the credit card type |
|||||||||||||||||||
| CARD_NUMBER | varchar | 100 | √ | null |
|
|
Masked card number |
|||||||||||||||||||
| CARD_EXPIRATION | varchar | 20 | √ | null |
|
|
Credit card expiration date (mm/yyyy) |
|||||||||||||||||||
| SAVED_CREDIT_CARD_ID | int | 4 | √ | null |
|
|
ID of the saved credit card used for the payment or refund |
|||||||||||||||||||
| DEVICE_INPUT_TYPE | varchar | 20 | √ | null |
|
|
Type of card swiped or tapped on a physical device (Credit Card / Debit Card) |
|||||||||||||||||||
| BANK_ROUTING_NUMBER | varchar | 100 | √ | null |
|
|
Bank routing number for electronic check processing |
|||||||||||||||||||
| BANK_ACCOUNT_TYPE | varchar | 4 | √ | null |
|
|
Bank account type for electronic check processing |
|||||||||||||||||||
| BANK_ACCOUNT_NUMBER | varchar | 50 | √ | null |
|
|
Bank account number for electronic check processing |
|||||||||||||||||||
| ECP_STATUS | varchar | 20 | √ | null |
|
|
The current electronic check processing status of the payment |
|||||||||||||||||||
| CHECK_NUMBER | varchar | 100 | √ | null |
|
|
Check number entered |
|||||||||||||||||||
| GIFT_CARD_ID | int | 4 | √ | null |
|
|
ID of the gift certificate for the payment or refund |
|||||||||||||||||||
| PAYMENT_CANCELLED | varchar | 5 | √ | null |
|
|
Whether the payment has been cancelled (Yes/No) |
|||||||||||||||||||
| CANCELLATION_REASON | varchar | 200 | √ | null |
|
|
The reason for the payment cancellation |
|||||||||||||||||||
| REVERSED_RECEIPT_PAYMENT_ID | int | 4 | √ | null |
|
|
ID of the receipt payment that is a reversal of this payment |
|||||||||||||||||||
| REPLACED_RECEIPT_PAYMENT_ID | int | 4 | √ | null |
|
|
ID of the receipt payment that this payment replaces |
|||||||||||||||||||
| RECEIPT_DETAIL_ID | int | 4 | √ | null |
|
|
ID of an associated receipt detail record if applicable |
|||||||||||||||||||
| PAYMENT_GL_ACCOUNT_ID | int | 4 | √ | null |
|
|
ID of the GL account posted to, for specific payment types |
|||||||||||||||||||
| CREDIT_CARD_FEE_SURCHARGE_AMOUNT | money | 21,4 | √ | null |
|
|
Amount of credit card surcharge fee for this payment |
|||||||||||||||||||
| CONVENIENCE_FEE_AMOUNT | money | 21,4 | √ | null |
|
|
Amount of convenience fee for this payment |
|||||||||||||||||||
| ROW_VERSION | binary | 8 | √ | null |
|
|
System timestamp (for internal use) |
|||||||||||||||||||
| 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 |
|||||||||||||||||||
| VOIDED | bit | 1 | ((0)) |
|
|
Whether the receipt header has been voided (1 = voided / 0 = not voided) |
||||||||||||||||||||
| VOIDED_BY | int | 4 | √ | null |
|
|
The ID of the system user who voided the receipt header |
|||||||||||||||||||
| VOIDED_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the receipt header was voided |
|||||||||||||||||||
| AUTHORIZATION_NUMBER | varchar | 200 | √ | null |
|
|
The authorization number received for the payment |
|||||||||||||||||||
| MANUAL_AUTHORIZATION_USER_ID | int | 4 | √ | null |
|
|
The ID of the user who manually authorized the payment |
|||||||||||||||||||
| CASH_CHANGE_AMOUNT | money | 21,4 | √ | null |
|
|
The amount of change given for the payment |
|||||||||||||||||||
| COMPANY_AUTHORIZED_AGENT_ID | int | 4 | √ | null |
|
|
The ID of the company authorized agent who made the payment |
|||||||||||||||||||
| CUSTOM_PAYMENT_TYPE_ID | int | 4 | √ | null |
|
|
The ID of the custom payment type selected for the payment |
|||||||||||||||||||
| CLIENT_TRANSACTION_ID | varchar | 50 | √ | null |
|
|
The client transaction ID generated by the payment authorization process |
|||||||||||||||||||
| SUBSIDY_USAGE_ID | int | 4 | √ | null |
|
|
Subsidy usage id is the reference of subsidy table. |
|||||||||||||||||||
| SUBSIDY_USAGE_TRANSACTION_ID | int | 4 | √ | null |
|
|
Subsidy usage transaction id is the reference of the transactions which is paid by subsidy. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| RECEIPT_PAYMENTS_ACTIVE_HUB_KEY_PK | Primary key | Asc | ACTIVE_HUB_KEY |
| RECEIPT_PAYMENTS_CARD_TYPE_ID_IX | Performance | Asc | CARD_TYPE_ID |
| RECEIPT_PAYMENTS_CASH_SUMMARY_SHEET_ID_IX | Performance | Asc | CASH_SUMMARY_SHEET_ID |
| RECEIPT_PAYMENTS_COMPANY_ID_IX | Performance | Asc | COMPANY_ID |
| RECEIPT_PAYMENTS_CREATION_DATE_TIME_IX | Performance | Asc | CREATION_DATE_TIME |
| RECEIPT_PAYMENTS_CREATION_DATE_TIME_ORG_ID_VOIDED_WORKSTATION_ID_IX | Performance | Asc/Asc/Asc/Asc | CREATION_DATE_TIME + ORG_ID + VOIDED + WORKSTATION_ID |
| RECEIPT_PAYMENTS_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| RECEIPT_PAYMENTS_nc_cs_ix | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | CARD_TYPE_ID + CASH_SUMMARY_SHEET_ID + COMPANY_ID + CREATION_DATE_TIME + CUSTOMER_ID + PAYMENT_GL_ACCOUNT_ID + RECEIPT_HEADER_ID + RECEIPT_PAYMENT_ID + SITE_ID + SYSTEMUSER_ID + VOIDED + VOIDED_BY + VOIDED_DATE_TIME + WORKSTATION_ID |
| RECEIPT_PAYMENTS_PAYMENT_GL_ACCOUNT_ID_IX | Performance | Asc | PAYMENT_GL_ACCOUNT_ID |
| RECEIPT_PAYMENTS_RECEIPT_HEADER_ID_IX | Performance | Asc | RECEIPT_HEADER_ID |
| RECEIPT_PAYMENTS_RECEIPT_PAYMENT_ID_ORG_ID_UQ | Must be unique | Asc/Asc | RECEIPT_PAYMENT_ID + ORG_ID |
| RECEIPT_PAYMENTS_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| RECEIPT_PAYMENTS_SITE_ID_IX | Performance | Asc | SITE_ID |
| RECEIPT_PAYMENTS_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| RECEIPT_PAYMENTS_VOIDED_IX | Performance | Asc/Asc | VOIDED + VOIDED_DATE_TIME |
| RECEIPT_PAYMENTS_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |