paymentevent
The paymentevent table.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Internal ID | |
| amount | Decimal | Amount | |
| authcode | String | Auth. Code | |
| avsstreetmatch | String | AVS Street Match | |
| avszipmatch | String | AVS Zip Match | |
| cancelable | Boolean | Cancelable | |
| cardnameoncard | String | Cardholder Name | |
| cardstreet | String | Card Street | |
| cardtokensubcard | String | Card Street | |
| cardzipcode | String | Card Zip Code | |
| cscmatch | String | CSC Match | |
| doc | String | Transaction | |
| eventdate | Date | Date | |
| externalid | String | External ID | |
| handlingmode | String | Handling Mode | |
| isadjustedexpirationdate | Boolean | Processed with Adjusted Expiration Date | |
| isodate | String | ISO Date | |
| isrecurringpayment | Boolean | Recurring Payment | |
| lastevent | Boolean | Last event | |
| maskedcard | String | Masked Card | |
| merchantprintblock | String | Merchant Print Block | |
| mitpurpose | String | Mit Purpose | |
| paymentinitiator | String | Payment Initiator | |
| paymentinstrumentmask | String | Mask | |
| paymentinstrumentstate | String | State | |
| paymentoperation | String | Payment Operation | |
| paymentprocessingprofile | String | Payment processing profile | |
| paymentrequestid | String | Payment Request ID | |
| paymentstatus | String | Payment Status | |
| pnrefnum | String | P/N Ref. | |
| redirecturl | String | Redirect URL | |
| request | String | Raw Request | |
| response | String | Raw Response | |
| shopperprintblock | String | Shopper Print Block | |
| signaturerequired | Boolean | Signature Required | |
| statusreason | String | Reason | |
| statusreasondetails | String | Details | |
| testmode | Boolean | Test Mode |