cashrefund
Tracks cash refunds issued to customers, including the amount, reason for the refund, and associated transaction details.
Columns
| Name | Type | References | Description |
| account | String | The account associated with the transaction. | |
| allowemptycards | Boolean | Indicates whether empty card details are allowed for processing. | |
| althandlingcost | Decimal | Alternative handling cost applied to the transaction. | |
| altshippingcost | Decimal | Alternative shipping cost applied to the transaction. | |
| billaddress | String | The full billing address associated with the transaction. | |
| billaddresslist | String | The list of available billing addresses. | |
| billingaddress | String | The specific billing address selected for the transaction. | |
| billisresidential | String | Indicates whether the billing address is residential. | |
| ccapproved | Boolean | Indicates whether the credit card transaction was approved. | |
| ccexpiredate | String | The expiration date of the credit card used in the transaction. | |
| cchold | String | Indicates whether the credit card transaction is on hold. | |
| ccholdetails | String | Additional details regarding the credit card hold. | |
| ccispurchasecardbin | Boolean | Indicates whether the credit card is a purchase card BIN. | |
| ccname | String | The name on the credit card used in the transaction. | |
| ccnumber | String | The masked credit card number used in the transaction. | |
| ccprocessoraccount | String | The payment processor account handling the credit card transaction. | |
| ccstreet | String | The street address associated with the credit card. | |
| cczipcode | String | The ZIP code associated with the credit card billing address. | |
| chargeit | Boolean | Indicates whether the transaction is charged to the credit card. | |
| checknumber | String | The check number used for the transaction. | |
| class | String | The classification assigned to the transaction, such as department or category. | |
| cleared | Boolean | Indicates whether the transaction has been cleared. | |
| cleareddate | Date | The date when the transaction was cleared. | |
| couponcode | String | The coupon code applied to the transaction. | |
| createddate | Datetime | The date and time when the transaction was created. | |
| createdfrom | String | The original transaction that this record was created from. | |
| creditcard | String | The credit card used for the transaction. | |
| creditcardprocessor | String | The credit card processor handling the payment. | |
| currency | String | The currency used for the transaction. | |
| currencyname | String | The name of the currency used in the transaction. | |
| currencysymbol | String | The symbol of the currency used in the transaction. | |
| customercode | String | The customer code associated with the transaction. | |
| customform | String | The custom form used for the transaction. | |
| debitcardissueno | String | The issue number of the debit card used in the transaction. | |
| deferredrevenue | Decimal | The amount of revenue deferred from the transaction. | |
| department | String | The department associated with the transaction. | |
| discountitem | String | The discount item applied to the transaction. | |
| discountrate | String | The discount rate applied to the transaction. | |
| discounttotal | Decimal | The total discount amount deducted from the transaction. | |
| dynamicdescriptor | String | The dynamic descriptor used for identifying the transaction. | |
| String | The email address associated with the transaction. | ||
| entity | String | The entity or customer associated with the transaction. | |
| entitynexus | String | The nexus associated with the transaction entity. | |
| entitytaxregnum | String | The tax registration number of the entity. | |
| estgrossprofit | Decimal | The estimated gross profit from the transaction. | |
| estgrossprofitpercent | String | The estimated gross profit percentage from the transaction. | |
| exchangerate | Decimal | The exchange rate applied to the transaction. | |
| excludecommission | Boolean | Indicates whether this transaction is excluded from commission calculations. | |
| externalid | String | A unique external identifier for referencing the transaction in external systems. | |
| handlingcost | Decimal | The handling cost applied to the transaction. | |
| handlingmode | String | The handling mode applied, such as standard or express. | |
| handlingtax1rate | String | The first tax rate applied to handling costs. | |
| handlingtaxcode | String | The tax code applied to handling costs. | |
| inputauthcode | String | The authorization code entered for the transaction. | |
| inputpnrefnum | String | The reference number entered for the payment transaction. | |
| inputreferencecode | String | The reference code entered for the transaction. | |
| isbasecurrency | Boolean | Indicates whether the transaction is in the base currency. | |
| ispurchasecard | String | Indicates whether the transaction was processed using a purchase card. | |
| istaxable | Boolean | Indicates whether the transaction is taxable. | |
| lastmodifieddate | Datetime | The date and time when the transaction was last modified. | |
| leadsource | String | The lead source associated with the transaction. | |
| location | String | The location where the transaction took place. | |
| memo | String | A memo or note associated with the transaction. | |
| message | String | A message associated with the transaction. | |
| muccpromocodeinstance | String | The MUCC promo code instance applied to the transaction. | |
| nexus | String | The tax nexus applied to the transaction. | |
| otherrefnum | String | Another reference number associated with the transaction. | |
| outputauthcode | String | The authorization code returned for the transaction. | |
| outputreferencecode | String | The reference code returned for the transaction. | |
| overridehold | Boolean | Indicates whether the transaction hold is overridden. | |
| overrideholdchecked | Boolean | Indicates whether the hold override has been checked. | |
| partner | String | The partner associated with the transaction. | |
| paymentcardcsc | String | The payment card security code used for verification. | |
| paymenteventdate | Datetime | The date and time of the payment event. | |
| paymenteventholdreason | String | The reason for placing the payment on hold. | |
| paymenteventpurchasedatasent | String | Indicates whether purchase data was sent for payment processing. | |
| paymenteventresult | String | The result of the payment event. | |
| paymenteventtype | String | The type of payment event. | |
| paymenteventupdatedby | String | The user who last updated the payment event. | |
| paymentmethod | String | The method of payment used in the transaction. | |
| paymentoperation | String | The payment operation applied, such as authorization or capture. | |
| paymentoption | String | The payment option selected by the customer. | |
| paymentprocessingprofile | String | The payment processing profile used for handling the transaction. | |
| paypalauthid | String | The PayPal authorization ID for the transaction. | |
| paypalprocess | Boolean | Indicates whether the payment was processed through PayPal. | |
| paypalstatus | String | The status of the PayPal transaction. | |
| paypaltranid | String | The PayPal transaction ID. | |
| pnrefnum | String | The payment reference number. | |
| postingperiod | String | The posting period for the transaction. | |
| promocode | String | The promotion code applied to the transaction. | |
| promocodepluginimpl | String | The implementation plugin for the promotion code. | |
| recognizedrevenue | Decimal | The recognized revenue from the transaction. | |
| refundcheck | Boolean | Indicates whether a refund check was issued for the transaction. | |
| revenuestatus | String | The revenue status of the transaction. | |
| revreconrevcommitment | Boolean | Indicates whether revenue recognition was committed. | |
| saleseffectivedate | Date | The date when the sales transaction became effective. | |
| salesgroup | String | The sales group associated with the transaction. | |
| salesrep | String | The sales representative associated with the transaction. | |
| shipaddress | String | The shipping address associated with the transaction. | |
| shipaddresslist | String | The list of available shipping addresses. | |
| shipisresidential | String | Indicates whether the shipping address is residential. | |
| shipmethod | String | The shipping method selected for the transaction. | |
| shipoverride | String | Indicates whether shipping charges were overridden. | |
| shippingaddress | String | The complete shipping address used in the transaction. | |
| shippingcost | Decimal | The shipping cost applied to the transaction. | |
| shippingcostoverridden | String | Indicates whether shipping costs were manually overridden. | |
| shippingtax1rate | String | The first tax rate applied to shipping costs. | |
| shippingtaxcode | String | The tax code applied to shipping charges. | |
| softdescriptor | String | The soft descriptor used for payment processing. | |
| source | String | The source of the transaction, such as an online store or in-person sale. | |
| subsidiary | String | The subsidiary associated with the transaction. | |
| subsidiarytaxregnum | String | The tax registration number of the subsidiary. | |
| subtotal | Decimal | The subtotal amount before taxes and discounts. | |
| syncpartnerteams | Boolean | Indicates whether partner teams should be synchronized. | |
| syncsalesteams | Boolean | Indicates whether sales teams should be synchronized. | |
| taxdetailsoverride | Boolean | Indicates whether tax details were manually overridden. | |
| taxitem | String | The tax item applied to the transaction. | |
| taxpointdate | Date | The date used for determining when tax liability arises for the transaction. | |
| taxpointdateoverride | Boolean | Indicates whether the tax point date was manually overridden. | |
| taxrate | Double | The tax rate applied to the transaction. | |
| taxregoverride | Boolean | Indicates whether tax registration details were manually overridden. | |
| taxtotal | Decimal | The total tax amount applied to the transaction. | |
| tobeemailed | Boolean | Indicates whether the transaction document should be emailed. | |
| tobefaxed | Boolean | Indicates whether the transaction document should be faxed. | |
| tobeprinted | Boolean | Indicates whether the transaction document should be printed. | |
| toprint2 | Boolean | Indicates whether a second copy of the transaction document should be printed. | |
| total | Decimal | The total amount of the transaction, including taxes and fees. | |
| totalcostestimate | Decimal | The estimated total cost associated with the transaction. | |
| trandate | Date | The date when the transaction was recorded. | |
| tranid | String | The unique transaction identifier assigned to the record. | |
| tranisvsoebundle | Boolean | Indicates whether the transaction is part of a Vendor-Specific Objective Evidence (VSOE) bundle. | |
| validfrom | String | The start date from which the transaction or agreement is considered valid. | |
| vsoeautocalc | Boolean | Indicates whether VSOE calculations are automatically applied to the transaction. |