Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AR_SCHEDULED_HEADER_ID | Unknown | 0 | null |
|
|
||||||
| CREDIT_CARD_PROCESSING_LOG_ID | int | 4 | null |
|
|
The credit card processing log ID |
|||||
| CUSTOMER_ID | int | 4 | √ | null |
|
|
The ID of the customer that the payment or refund authorization request was for |
||||
| CUSTOMER_NAME | varchar | 511 | √ | null |
|
|
The name of the customer that the payment or refund authorization request was for |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The ID of the company that the payment or refund authorization request was for |
||||
| COMPANY_NAME | varchar | 255 | √ | null |
|
|
The name of the company that the payment or refund authorization request was for |
||||
| WORKSTATION_ID | int | 4 | √ | null |
|
|
The ID of the workstation that the payment or refund authorization request was submitted from |
||||
| WORKSTATION_NAME | varchar | 45 | √ | null |
|
|
The name of the workstation that the payment or refund authorization request was submitted from |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID of the system user who submitted the payment or refund authorization request |
||||
| SYSTEM_USER_NAME | varchar | 511 | √ | null |
|
|
The name of the system user who submitted the payment or refund authorization request |
||||
| SITE_ID | int | 4 | √ | null |
|
|
The ID of the site that the payment or refund authorization request was submitted from |
||||
| SITE_NAME | varchar | 255 | √ | null |
|
|
The name of the site that the payment or refund authorization request was submitted from |
||||
| AUTHORIZATION_REQUEST_TYPE | varchar | 20 | √ | null |
|
|
The type of authorization request (Sale / Void / Authorization / Capture / ECP status change / Credit / Unknown) |
||||
| PAYMENT_AMOUNT | money | 21,4 | √ | null |
|
|
The amount of the payment or refund authorization request |
||||
| CARD_NUMBER | varchar | 20 | √ | null |
|
|
The masked credit card account number |
||||
| CARD_EXPIRATION | varchar | 10 | √ | null |
|
|
The credit card expiration date |
||||
| BANK_ROUTING_NUMBER | varchar | 50 | √ | null |
|
|
The masked bank routing number for ECP payments |
||||
| BANK_ACCOUNT_NUMBER | varchar | 50 | √ | null |
|
|
The masked bank account number for ECP payments |
||||
| BANK_ACCOUNT_TYPE | varchar | 4 | √ | null |
|
|
The bank account type for ECP payments |
||||
| START_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the payment or refund authorization request was submitted |
||||
| START_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the payment or refund authorization request was submitted (date only) |
||||
| LAST_MODIFY_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the authorization request was last updated |
||||
| LAST_MODIFY_DATE_ONLY | date | 20 | √ | null |
|
|
The date that the authorization request was last updated (date only) |
||||
| CLIENT_TRANSACTION_ID | varchar | 50 | √ | null |
|
|
The client transaction ID generated for the authorization request |
||||
| REFERENCE_NUMBER | varchar | 50 | √ | null |
|
|
The reference ID generated for the authorization request |
||||
| RELATED_REFERENCE_NUMBER | varchar | 50 | √ | null |
|
|
The reference ID the is related to the authorization request |
||||
| ORIGINAL_REFERENCE_NUMBER | varchar | 50 | √ | null |
|
|
The reference ID for the original authorization request that this authorization request is refunding |
||||
| IS_AUTHORIZED | varchar | 5 | √ | null |
|
|
Whether this payment or refund authorization has been successfully processed (Yes/No) |
||||
| PAYMENT_PROCESSOR_ID | int | 4 | √ | null |
|
|
The ID of the payment processor for this payment or refund authorization request |
||||
| PAYMENT_PROCESSOR | varchar | 200 | √ | null |
|
|
The name of the payment processor for this payment or refund authorization request |
||||
| SUBMISSION_STATUS_ID | int | 4 | √ | null |
|
|
The ID of the submission status of this payment or refund authorization request |
||||
| SUBMISSION_STATUS | varchar | 200 | √ | null |
|
|
The name of the submission status of this payment or refund authorization request |
||||
| RESULT_CODE | int | 4 | √ | null |
|
|
The result code returned for this payment or refund authorization request |
||||
| RESULT_MESSAGE | varchar | 300 | √ | null |
|
|
The result message returned for this payment or refund authorization request |
||||
| PINPAD_INPUT_TYPE | varchar | 15 | √ | null |
|
|
The type of card that was scanned through the pin pad device (Credit Card / Debit Card) |
||||
| PINPAD_DEVICE_TYPE_ID | int | 4 | √ | null |
|
|
The ID of the pin pad device type that the card was scanned through |
||||
| PINPAD_DEVICE_TYPE | varchar | 200 | √ | null |
|
|
The name of the pin pad device type that the card was scanned through |
||||
| RECEIPT_HEADER_ID | int | 4 | √ | null |
|
|
The ID of the receipt that this payment or refund belongs to |
||||
| RECEIPT_NUMBER | nvarchar | 8000 | √ | null |
|
|
The ID of the receipt that this payment or refund belongs to |
||||
| MEMBERSHIP_ID | int | 4 | √ | null |
|
|
The ID of the membership that this payment or refund is related to |
||||
| MEMBERSHIP_RUN_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time the membership renewal process generated this payment |
||||
| MEMBERSHIP_RUN_DATE_ONLY | date | 20 | √ | null |
|
|
The date the membership renewal process generated this payment (date only) |
||||
| AR_SCHEDULE_HEADER_ID | int | 4 | √ | null |
|
|
The ID of the payment plan that this payment or refund is related to |
||||
| CAMPAIGN_DONATION_ID | int | 4 | √ | null |
|
|
The ID of the scheduled campaign donation that this payment or refund is related to |
||||
| IS_VOIDED | varchar | 5 | √ | null |
|
|
Whether this payment or refund authorization has been voided (Yes/No) |
||||
| 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 |
|||||
| source_id | int | 4 | null |
|
|
The ID value from the Active Net system |
|||||
| AUTO_RETRY_COUNT | int | 4 | √ | null |
|
|