customerpayment
Records customer payments, including payment method, amount, and related transaction details, supporting accurate account management.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the transaction. | |
| allowemptycards | Boolean | Indicates whether empty credit cards are allowed in the transaction. | |
| applied | Decimal | The amount that has been applied to the account or transaction. | |
| aracct | String | The accounts receivable account associated with the transaction. | |
| authcode | String | The authorization code for the credit card transaction. | |
| autoapply | Boolean | Indicates whether the system should automatically apply payments. | |
| balance | Decimal | The current balance of the account or transaction. | |
| ccapproved | Boolean | Indicates whether the credit card transaction is approved. | |
| ccavsstreetmatch | String | The match status for the address verification service (AVS) street verification. | |
| ccavszipmatch | String | The match status for the AVS ZIP code verification. | |
| 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 check. | |
| ccispurchasecardbin | Boolean | Indicates whether the card is identified as a purchase card. | |
| ccname | String | The cardholder's name. | |
| ccnumber | String | The credit card number used in the transaction. | |
| ccprocessoraccount | String | The account number with the credit card processor. | |
| ccsecuritycode | String | The credit card security code (CSC). | |
| ccsecuritycodematch | String | The result of the CSC verification. | |
| ccstreet | String | The street address associated with the credit card. | |
| cczipcode | String | The ZIP code associated with the credit card. | |
| chargeit | Boolean | Indicates whether the charge was successfully processed. | |
| checknum | String | The check number associated with the payment. | |
| checknumber | String | The number of the check used for payment. | |
| class | String | The class or category associated with the transaction. | |
| cleared | Boolean | Indicates whether the transaction has cleared. | |
| cleareddate | Date | The date when the transaction was cleared. | |
| consolidatebalance | Decimal | The consolidated balance from multiple accounts or transactions. | |
| 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 in the transaction. | |
| currencyname | String | The name of the currency used in the transaction. | |
| currencysymbol | String | The symbol of 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 associated with the transaction. | |
| debitcardissueno | String | The issue number of the debit card used in the transaction. | |
| department | String | The department associated with the transaction. | |
| dynamicdescriptor | String | A dynamic descriptor describing the transaction for the cardholder. | |
| entitynexus | String | The tax nexus associated with the entity in the transaction. | |
| exchangerate | Decimal | The exchange rate applied to the transaction. | |
| externalid | String | An external identifier for referencing the transaction in other systems. | |
| handlingmode | String | The handling mode for the transaction (for example, manual or automatic). | |
| ignoreavs | Boolean | Indicates whether the AVS check is ignored. | |
| ignorecsc | Boolean | Indicates whether the CSC check is ignored. | |
| inputauthcode | String | The input authorization code provided for the transaction. | |
| inputpnrefnum | String | The input reference number for the transaction. | |
| inputreferencecode | String | The input reference code for the transaction. | |
| isbasecurrency | Boolean | Indicates whether the transaction is conducted in the base currency. | |
| ispurchasecard | String | Indicates whether the transaction is processed with a purchase card. | |
| isrecurringpayment | Boolean | Indicates whether the payment is recurring. | |
| 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. | |
| nexus | String | The tax nexus information for the transaction. | |
| outputauthcode | String | The output authorization code provided after processing. | |
| outputreferencecode | String | The output reference code generated after processing. | |
| overridehold | Boolean | Indicates whether the credit hold status has been manually overridden. | |
| overrideholdchecked | Boolean | Indicates whether the override of credit hold has been checked. | |
| payment | String | The type of payment method used in the transaction. | |
| paymentcardcsc | String | The CSC used in the transaction. | |
| paymenteventdate | Datetime | The date and time when the payment event occurred. | |
| paymenteventholdreason | String | The reason for holding the payment event. | |
| paymenteventpurchasedatasent | String | Indicates whether purchase data was sent during the payment event. | |
| paymenteventresult | String | The result of the payment event, such as success or failure. | |
| paymenteventtype | String | The type of payment event (for example, authorization, capture, refund). | |
| paymenteventupdatedby | String | The user or system that updated the payment event. | |
| paymentmethod | String | The method of payment used in the transaction (for example, credit card, PayPal). | |
| paymentoperation | String | The operation type for the payment (for example, charge, refund). | |
| paymentoption | String | The specific payment option selected by the customer. | |
| paymentprocessingprofile | String | The profile used for processing the payment. | |
| pending | Decimal | The amount pending for payment or transaction. | |
| pnrefnum | String | The reference number associated with the payment. | |
| postingperiod | String | The posting period for the transaction. | |
| softdescriptor | String | A soft descriptor used for the transaction's description. | |
| status | String | The current status of the transaction. | |
| statusref | String | A reference to the status of the transaction. | |
| subsidiary | String | The subsidiary associated with the transaction. | |
| threedstatuscode | String | The 3D Secure status code for the transaction. | |
| tobeemailed | Boolean | Indicates whether the transaction is flagged to be emailed. | |
| total | Decimal | The total amount for the transaction. | |
| trandate | Date | The date the transaction occurred. | |
| tranid | String | The unique identifier for the transaction. | |
| unapplied | Decimal | The unapplied amount for the transaction. | |
| undepfunds | String | The funds that have not been deposited for the transaction. | |
| validfrom | String | The date from which the transaction or record is valid. |