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 |
||||
| COMPANY_ID | int | 4 | √ | null |
|
|
The ID 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 |
||||
| SYSTEMUSER_ID | int | 4 | √ | null |
|
|
The ID 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 |
||||
| 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 |
||||
| LAST_MODIFY_DATE_TIME | datetime | 16,3 | √ | null |
|
|
The date and time that the authorization request was last updated |
||||
| 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 |
||||
| SUBMISSION_STATUS_ID | int | 4 | √ | null |
|
|
The ID 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 |
||||
| RECEIPT_HEADER_ID | int | 4 | √ | 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 |
||||
| 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) |
||||
| 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 |
|||||
| AUTO_RETRY_COUNT | int | 4 | √ | null |
|
|
Number of additional attempts made to draft the credit card after the initial decline |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| CREDIT_CARD_PROCESSING_LOG_CREDIT_CARD_PROCESSING_LOG_ID_ORG_ID_PK | Primary key | Asc/Asc | CREDIT_CARD_PROCESSING_LOG_ID + ORG_ID |
| CREDIT_CARD_PROCESSING_LOG_AR_SCHEDULE_HEADER_ID_IX | Performance | Asc | AR_SCHEDULE_HEADER_ID |
| CREDIT_CARD_PROCESSING_LOG_CAMPAIGN_DONATION_ID_IX | Performance | Asc | CAMPAIGN_DONATION_ID |
| CREDIT_CARD_PROCESSING_LOG_CLIENT_TRANSACTION_ID_IX | Performance | Asc | CLIENT_TRANSACTION_ID |
| CREDIT_CARD_PROCESSING_LOG_COMPANY_ID_IX | Performance | Asc | COMPANY_ID |
| CREDIT_CARD_PROCESSING_LOG_CUSTOMER_ID_IX | Performance | Asc | CUSTOMER_ID |
| CREDIT_CARD_PROCESSING_LOG_MEMBERSHIP_ID_IX | Performance | Asc | MEMBERSHIP_ID |
| CREDIT_CARD_PROCESSING_LOG_MEMBERSHIP_RUN_DATE_TIME_IX | Performance | Asc | MEMBERSHIP_RUN_DATE_TIME |
| CREDIT_CARD_PROCESSING_LOG_RECEIPT_HEADER_ID_IX | Performance | Asc | RECEIPT_HEADER_ID |
| CREDIT_CARD_PROCESSING_LOG_ROW_VERSION_IX | Performance | Asc | ROW_VERSION |
| CREDIT_CARD_PROCESSING_LOG_SITE_ID_IX | Performance | Asc | SITE_ID |
| CREDIT_CARD_PROCESSING_LOG_START_DATE_TIME_IX | Performance | Asc | START_DATE_TIME |
| CREDIT_CARD_PROCESSING_LOG_SYSTEMUSER_ID_IX | Performance | Asc | SYSTEMUSER_ID |
| CREDIT_CARD_PROCESSING_LOG_WORKSTATION_ID_IX | Performance | Asc | WORKSTATION_ID |