customerpaymentauthorization
Tracks authorization details for customer payments, ensuring that payments are processed correctly and securely.
Columns
| Name | Type | References | Description |
| allowemptycards | Boolean | Indicates whether empty credit cards are allowed in the transaction. | |
| authcode | String | The authorization code for the credit card transaction. | |
| ccapproved | Boolean | Indicates whether the credit card transaction was approved. | |
| ccavsstreetmatch | String | The result of the address verification service (AVS) street address match. | |
| ccavszipmatch | String | The result of the AVS ZIP code match. | |
| ccexpiredate | String | The expiration date of the credit card. | |
| cchold | String | Indicates whether the credit card is on hold. | |
| ccholdetails | String | Details regarding the credit card hold. | |
| cciavsmatch | String | The result of the issuer AVS match. | |
| ccname | String | The name of the credit card holder. | |
| ccnumber | String | The credit card number. | |
| ccprocessoraccount | String | The account number associated with the credit card processor. | |
| ccsecuritycode | String | The credit card security code (CSC). | |
| ccsecuritycodematch | String | The result of the CSC match. | |
| ccstreet | String | The street address associated with the credit card. | |
| cczipcode | String | The ZIP code associated with the credit card. | |
| class | String | The class or category associated with the transaction. | |
| createddate | Datetime | The date and time when the transaction or record was created. | |
| creditcard | String | The type of credit card used in the transaction. | |
| creditcardprocessor | String | The processor handling the credit card transaction. | |
| currency | String | The currency used for the transaction. | |
| currencyname | String | The name of the currency used for the transaction. | |
| currencysymbol | String | The symbol representing the currency used in the transaction. | |
| customer | String | The customer associated with the transaction. | |
| customercode | String | The unique code assigned to the customer. | |
| customform | String | The custom form used for the transaction. | |
| debitcardissueno | String | The issue number of the debit card used for the transaction. | |
| department | String | The department associated with the transaction. | |
| exchangerate | Decimal | The exchange rate applied to the transaction. | |
| externalid | String | A unique identifier used to reference the transaction externally. | |
| getauth | Boolean | Indicates whether the transaction requires an authorization code. | |
| ignoreavs | Boolean | Indicates whether the AVS check is ignored. | |
| ignorecsc | Boolean | Indicates whether the CSC check is ignored. | |
| isbasecurrency | Boolean | Indicates whether the transaction is conducted in the base currency. | |
| isrecurringpayment | Boolean | Indicates whether the payment is part of a recurring payment plan. | |
| lastmodifieddate | Datetime | The date and time when the transaction or record was last modified. | |
| location | String | The location associated with the transaction. | |
| memo | String | A memo or note associated with the transaction. | |
| overridehold | Boolean | Indicates whether the credit hold status has been manually overridden. | |
| overrideholdchecked | Boolean | Indicates whether the override of the credit hold has been checked. | |
| payment | String | The type of payment used for the transaction. | |
| paymenteventholdreason | String | The reason for holding the payment event. | |
| paymenteventresult | String | The result of the payment event (for example, success, failure). | |
| paymentmethod | String | The method of payment used in the transaction (for example, credit card, PayPal). | |
| pnrefnum | String | The reference number associated with the payment transaction. | |
| redirecturl | String | The URL to which the user is redirected after payment. | |
| returnurl | String | The URL to which the user returns after completing the payment process. | |
| salesorder | String | The sales order associated with the transaction. | |
| subsidiary | String | The subsidiary associated with the transaction. | |
| threedstatuscode | String | The 3D Secure status code for the transaction. | |
| trandate | Date | The date on which the transaction occurred. | |
| tranid | String | The unique identifier for the transaction. | |
| transactionnumber | String | The number associated with the transaction. | |
| updatecurrency | String | The currency to be used for the transaction update. | |
| validfrom | String | The date from which the transaction or record is valid. |