paymentevent
The table storing details of payment events, used to track the status and results of payment transactions.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | A unique internal identifier assigned to the transaction, used for tracking and referencing the record. | |
| amount | Decimal | The monetary amount associated with the transaction, representing the value being processed or charged. | |
| authcode | String | The authorization code provided by the payment gateway or processor, confirming that the transaction was authorized. | |
| avsstreetmatch | String | Indicates whether the address verification system (AVS) successfully matched the street address provided by the cardholder. | |
| avszipmatch | String | Indicates whether the AVS successfully matched the ZIP code provided by the cardholder during the transaction. | |
| cancelable | Boolean | Indicates whether the transaction can be canceled, allowing the merchant to void or reverse the transaction. | |
| cardnameoncard | String | The name of the cardholder as printed on the card, used for identity verification and authorization. | |
| cardstreet | String | The street address associated with the cardholder's billing address, used for AVS verification during the transaction. | |
| cardtokensubcard | String | A sub-card associated with the main payment card, used in tokenized transactions for enhanced security. | |
| cardzipcode | String | The zip code associated with the cardholder’s billing address, used for AVS verification to ensure the address matches. | |
| cscmatch | String | Indicates whether the card security code (CSC) provided during the transaction matched the one on file with the card issuer. | |
| doc | String | The transaction document or reference, used for linking or identifying the transaction in the system or report. | |
| eventdate | Date | The date on which the payment event or transaction occurred, used for tracking and reporting. | |
| externalid | String | A unique identifier for the transaction or payment as assigned by an external system, used for integration or synchronization. | |
| handlingmode | String | The method used to process the transaction, such as manual, automated, or recurring handling. | |
| isadjustedexpirationdate | Boolean | Indicates whether the transaction was processed with an adjusted expiration date, often used in specific payment scenarios. | |
| isodate | String | The ISO formatted date associated with the transaction, providing a standardized timestamp. | |
| isrecurringpayment | Boolean | Indicates whether the transaction is part of a recurring payment plan, such as a subscription or installment. | |
| lastevent | Boolean | Indicates whether the current event is the last action or status update in a series of transactions. | |
| maskedcard | String | A masked version of the card number, showing only the last four digits for security purposes (for example, **** 1234). | |
| merchantprintblock | String | The block of text or data that is printed by the merchant, typically for receipt printing or transaction records. | |
| mitpurpose | String | The purpose of the transaction, often used in merchant identification transactions (MIT) to classify the nature of the payment. | |
| paymentinitiator | String | The entity or individual initiating the payment, used for identifying the party responsible for starting the transaction. | |
| paymentinstrumentmask | String | The masked version of the payment instrument (such as a card number), showing only partial digits for security and privacy. | |
| paymentinstrumentstate | String | The state or condition of the payment instrument, such as active, expired, or invalid. | |
| paymentoperation | String | The type of payment operation performed, such as authorization, capture, refund, or void. | |
| paymentprocessingprofile | String | The payment processing profile used to define the parameters for handling payments, such as the gateway or payment method. | |
| paymentrequestid | String | A unique identifier for the payment request, used for tracking and referencing the specific request in the system. | |
| paymentstatus | String | The current status of the payment, such as pending, authorized, completed, or failed. | |
| pnrefnum | String | The payment reference number assigned to the transaction, used for tracking and referencing within the payment system. | |
| redirecturl | String | The URL to which the customer is redirected after completing or interacting with the payment process, such as for authentication or confirmation. | |
| request | String | The raw request data sent to the payment processor, typically used for debugging or tracking the transaction request. | |
| response | String | The raw response data received from the payment processor, often used for debugging or validating the outcome of the transaction. | |
| shopperprintblock | String | The block of text or data that is printed for the shopper, typically included in transaction receipts or printed confirmations. | |
| signaturerequired | Boolean | Indicates whether a signature is required for the transaction, often used for high-value or sensitive payments. | |
| statusreason | String | The reason for the current status of the transaction, providing context or explanation for actions like failure or delay. | |
| statusreasondetails | String | Additional details explaining the reason for the current transaction status, often used for troubleshooting or customer support. | |
| testmode | Boolean | Indicates whether the transaction is being processed in test mode, typically used for development or testing purposes without real funds being involved. |