customerrefund
Records customer refunds, including refund amounts and reasons, to ensure proper accounting for returned goods or overpayments.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the transaction or record. | |
| allowemptycards | Boolean | Indicates whether empty credit cards are allowed in the transaction. | |
| aracct | String | The accounts receivable account associated with the transaction. | |
| balance | Decimal | The current balance of the account or transaction. | |
| ccapproved | Boolean | Indicates whether the credit card transaction was approved. | |
| 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. | |
| ccispurchasecardbin | Boolean | Indicates whether the card is identified as a purchase card. | |
| ccname | String | The name of the cardholder associated with the credit card. | |
| ccnumber | String | The credit card number. | |
| ccprocessoraccount | String | The account number used by the credit card processor. | |
| 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. | |
| checknumber | String | The check number associated with the 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 for the transaction. | |
| currencyname | String | The name of the currency used for 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 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. | |
| 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 | A unique identifier used to reference the transaction externally. | |
| handlingmode | String | The handling mode for the transaction (for example, manual or automatic). | |
| 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. | |
| 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 received after processing. | |
| outputreferencecode | String | The output reference code received 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. | |
| payeeaddress | String | The address of the payee in the transaction. | |
| payeeaddresslist | String | The list of payee addresses associated with the transaction. | |
| paymentcardcsc | String | The credit card security code (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 (for example, 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 payment option chosen for the transaction. | |
| paymentprocessingprofile | String | The profile used for processing the payment. | |
| pnrefnum | String | The reference number associated with the payment transaction. | |
| postingperiod | String | The posting period for the transaction. | |
| softdescriptor | String | A soft descriptor used in 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. | |
| tobeprinted | Boolean | Indicates whether the transaction is flagged to be printed. | |
| total | Decimal | The total amount for the transaction. | |
| trandate | Date | The date when the transaction occurred. | |
| tranid | String | The unique identifier for the transaction. | |
| transactionnumber | String | The number associated with the transaction. | |
| validfrom | String | The date from which the transaction or record is valid. |