Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| 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 |
|
| RECEIPT_NUMBER | nvarchar | 8000 | √ | null |
|
|
The receipt number that the payment belongs to |
|
| SITE_ID | int | 4 | √ | null |
|
|
ID of the site where the payment was created |
|
| SITE_NAME | varchar | 255 | √ | null |
|
|
Name of the site where the payment was created |
|
| WORKSTATION_ID | int | 4 | √ | null |
|
|
ID of the workstation where the payment was created |
|
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
Name of the workstation where the payment was created |
|
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
ID of the user who created the payment |
|
| SYSTEM_USER_NAME | varchar | 511 | null |
|
|
Name 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 |
|
| CREATION_DATE_ONLY | date | 20 | √ | null |
|
|
Date that the payment was created (date only) |
|
| CUSTOMER_ID | int | 4 | √ | null |
|
|
ID of the customer who made the payment |
|
| CUSTOMER_NAME | varchar | 511 | null |
|
|
Name of the customer who made the payment |
||
| COMPANY_ID | int | 4 | √ | null |
|
|
ID of the company who made the payment |
|
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
Name of the company who made the payment |
|
| COMPANY_AUTHORIZED_AGENT_ID | int | 4 | √ | null |
|
|
The ID of the company authorized agent who made the payment |
|
| COMPANY_AUTHORIZED_AGENT_NAME | varchar | 511 | √ | null |
|
|
The name of the company authorized agent 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 Certificate / Gift Certificate 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_TYPE | varchar | 50 | √ | null |
|
|
Name 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 |
|
| AUTHORIZATION_NUMBER | varchar | 200 | √ | null |
|
|
The authorization number received for the payment |
|
| CLIENT_TRANSACTION_ID | varchar | 50 | √ | null |
|
|
The client transaction ID generated by the payment authorization process |
|
| IS_MANUAL_AUTHORIZATION | varchar | 3 | null |
|
|
Whether the payment was manually authorized (Yes/No) |
||
| MANUAL_AUTHORIZATION_USER_ID | int | 4 | √ | null |
|
|
The ID of the user who manually authorized the payment |
|
| MANUAL_AUTHORIZATION_USER_NAME | varchar | 511 | null |
|
|
The name of the user who manually authorized the payment |
||
| CASH_CHANGE_AMOUNT | money | 21,4 | √ | null |
|
|
The amount of change given for the payment |
|
| CUSTOM_PAYMENT_TYPE_ID | int | 4 | √ | null |
|
|
The ID of the custom payment type selected for the payment |
|
| CUSTOM_PAYMENT_TYPE_NAME | varchar | 100 | √ | null |
|
|
The name of the custom payment type selected for the payment |
|
| CHECK_NUMBER | varchar | 100 | √ | null |
|
|
Check number entered |
|
| GIFT_CARD_ID | int | 4 | √ | null |
|
|
ID of the gift card 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 |
|
| PAYMENT_GL_ACCOUNT_NAME | varchar | 200 | √ | null |
|
|
Name of the GL account posted to, for specific payment types |
|
| PAYMENT_GL_ACCOUNT_NUMBER | varchar | 200 | √ | null |
|
|
GL account number posted to, for specific payment types |
|
| VOIDED | varchar | 3 | null |
|
|
Whether the receipt header has been voided (Yes/No) |
||
| VOIDED_BY | int | 4 | √ | null |
|
|
The ID of the system user who voided the receipt header |
|
| VOIDED_BY_USER_NAME | varchar | 511 | null |
|
|
The name 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 |
|
| VOIDED_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the receipt header was voided (date only) |
|
| 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 |