cashrefund
Tracks cash refunds issued to customers, including payment processing, billing, tax, and revenue details.
Columns
| Name | Type | References | Description |
| abbrevtype | String | The abbreviated transaction type code for this cash refund. | |
| account | String | The account used to process this cash refund. | |
| asofdate | Date | The as-of date for revenue recognition on this cash refund. | |
| authcode | String | The authorization code returned by the payment processor for this cash refund. | |
| basehandlingtaxamount | Decimal | The handling tax amount expressed in the base currency of the subsidiary. | |
| baseshippingtaxamount | Decimal | The shipping tax amount expressed in the base currency of the subsidiary. | |
| billingaccount | String | The billing account linked to this cash refund for consolidated billing. | |
| billingaddress | String | The internal ID of the billing address record associated with this cash refund. | |
| bulkprocsubmission | String | The bulk payment processing submission batch associated with this cash refund. | |
| ccapproved | Boolean | If the value is true, the credit card payment for this cash refund has been approved by the processor. | |
| ccavsstreetmatch | String | The AVS street address verification result returned by the payment processor. | |
| ccavszipmatch | String | The AVS ZIP code verification result returned by the payment processor. | |
| ccexpiredate | String | The expiration date of the credit card used for this cash refund. | |
| ccname | String | The cardholder name as it appears on the credit card used for this cash refund. | |
| ccsecuritycodematch | String | The CVV security code verification result returned by the payment processor. | |
| ccstreet | String | The street address of the cardholder used for AVS verification on this cash refund. | |
| cczipcode | String | The ZIP code of the cardholder used for AVS verification on this cash refund. | |
| checknumber | String | The check number associated with this cash refund when payment is made by check. | |
| class | String | The class assigned to this cash refund for financial reporting and segmentation. | |
| cleared | Boolean | If the value is true, this cash refund has cleared the bank and been reconciled. | |
| cleareddate | Date | The date on which this cash refund was cleared and reconciled in the bank. | |
| companyid | String | The identifier of the company associated with this cash refund. | |
| createdby | String | The user who created this cash refund record. | |
| createddate | Datetime | The date and time when this cash refund record was created. | |
| createdfrom | String | The source transaction from which this cash refund was created. | |
| creditcardprocessor | String | The payment processing profile used to process this cash refund. | |
| currency | String | The currency in which this cash refund is denominated. | |
| customercode | String | The customer code provided by the payment processor for this cash refund. | |
| customerpaymentauthorization | String | The customer payment authorization record linked to this cash refund. | |
| defaultcatchup | Integer | The default catch-up period used for revenue recognition on this cash refund. | |
| deferredrevenue | Decimal | The amount of revenue deferred for future recognition on this cash refund. | |
| department | String | The department associated with this cash refund for cost allocation. | |
| discountamount | Decimal | The discount amount applied to this cash refund. | |
| discountdate | Date | The date by which a discount must be applied to qualify on this cash refund. | |
| duedate | Date | The due date for this cash refund based on the payment terms. | |
| dynamicdescriptor | String | The dynamic descriptor sent to the payment processor to identify this cash refund on the customer's statement. | |
| String | The email address of the customer associated with this cash refund. | ||
| emailaddr | String | The raw email address field on this cash refund. | |
| enddate | Date | The end date of the revenue recognition schedule for this cash refund. | |
| entity | String | The customer or entity to whom this cash refund is issued. | |
| entitytaxregnum | String | The tax registration number of the customer entity associated with this cash refund. | |
| estgrossprofit | Decimal | The estimated gross profit on this cash refund based on cost estimates. | |
| estgrossprofitpercent | String | The estimated gross profit as a percentage of the refund total. | |
| exchangerate | Decimal | The exchange rate used to convert this cash refund to the base currency. | |
| excludecommission | Boolean | If the value is true, this cash refund is excluded from sales commission calculations. | |
| excludefromglnumbering | Boolean | If the value is true, this cash refund is excluded from general ledger numbering sequences. | |
| externalid | String | A unique identifier for this cash refund used by an external system. | |
| fax | String | The fax number of the customer associated with this cash refund. | |
| handlingcost | Decimal | The handling charge on this cash refund. | |
| handlingtax1rate | Double | The primary tax rate applied to the handling charge on this cash refund. | |
| handlingtax2rate | Double | The secondary tax rate applied to the handling charge on this cash refund. | |
| handlingtaxamount | Decimal | The total tax amount applied to the handling charge on this cash refund. | |
| handlingtaxcode | String | The tax code used to calculate handling taxes on this cash refund. | |
| id | Integer | The internal ID uniquely identifying this cash refund in NetSuite. | |
| integrationid | String | The integration identifier linking this cash refund to an external integration record. | |
| ipaddress | String | The IP address of the customer at the time this cash refund was processed. | |
| ipaddresscountry | String | The country associated with the customer's IP address at the time of this cash refund. | |
| isrecurringpayment | Boolean | If the value is true, this cash refund is associated with a recurring payment transaction. | |
| istaxable | Boolean | If the value is true, this cash refund is subject to sales tax. | |
| job | String | The project or job associated with this cash refund. | |
| lastmodifiedby | String | The user who last modified this cash refund record. | |
| lastmodifieddate | Datetime | The date and time when this cash refund record was last modified. | |
| leadsource | String | The lead source that generated the original sale associated with this cash refund. | |
| legacytax | Boolean | If the value is true, this cash refund uses the legacy tax engine. | |
| location | String | The location associated with this cash refund for inventory and financial reporting. | |
| memo | String | A memo or note recorded on this cash refund. | |
| message | String | A message to the customer printed on this cash refund. | |
| mosscountry | String | The EU MOSS country applied to this cash refund for VAT reporting. | |
| mosscountrydetail | String | Additional details about the EU MOSS country classification on this cash refund. | |
| nexus | String | The tax nexus associated with this cash refund for multi-jurisdiction tax compliance. | |
| number | Integer | The sequential transaction number assigned to this cash refund. | |
| otherrefnum | String | An alternate reference number for this cash refund, such as a check number or purchase order. | |
| partner | String | The partner associated with this cash refund for commission and revenue tracking. | |
| paypalauthid | String | The PayPal authorization ID returned when this cash refund was processed through PayPal. | |
| paymenteventdate | Datetime | The date and time of the most recent payment processing event on this cash refund. | |
| paymenteventholdreason | String | The reason the payment event for this cash refund is on hold. | |
| paymenteventmagiczeroused | Boolean | If the value is true, the payment was processed with an adjusted expiration date. | |
| paymenteventpurchasedatasent | String | The purchase data sent to the payment processor during the payment event for this cash refund. | |
| paymenteventresult | String | The result of the most recent payment processing event on this cash refund. | |
| paymenteventtype | String | The type of the most recent payment processing event on this cash refund. | |
| paymentinstrumentlimit | Decimal | The maximum amount allowed for the payment instrument used on this cash refund. | |
| paymentmethod | String | The payment method used to issue this cash refund, such as check, credit card, or ACH. | |
| paymentoption | String | The payment option selected for processing this cash refund. | |
| paymentprocessingprofile | String | The payment processing profile configuration used for this cash refund. | |
| paypalstatus | String | The status of the PayPal transaction associated with this cash refund. | |
| paypaltranid | String | The PayPal transaction ID for this cash refund. | |
| pendingpaypalauth | String | The pending PayPal authorization identifier for this cash refund. | |
| pnrefnum | String | The processor reference number returned by the payment processor for this cash refund. | |
| postingperiod | String | The accounting period to which this cash refund is posted. | |
| prevdate | Date | The previous transaction date for this cash refund, used in recurring billing scenarios. | |
| primarybookbasecurrency | String | The base currency of the primary accounting book for this cash refund. | |
| recognizedrevenue | Decimal | The amount of revenue recognized to date on this cash refund. | |
| recurringbill | Boolean | If the value is true, this cash refund is part of a recurring billing arrangement. | |
| revcommitstatusdescr | String | The description of the revenue commitment status for this cash refund. | |
| revenuestatus | String | The current revenue recognition status of this cash refund. | |
| revenuestatusdescr | String | The description of the revenue recognition status for this cash refund. | |
| revreconrevcommitment | Boolean | If the value is true, revenue is recognized on the revenue commitment rather than the cash refund itself. | |
| saleseffectivedate | Date | The effective date used for sales reporting and revenue recognition on this cash refund. | |
| salesrep | String | The sales representative associated with the original sale linked to this cash refund. | |
| shipaddress | String | The formatted ship-to address for this cash refund. | |
| shipdate | Date | The date on which the shipment associated with this cash refund was sent. | |
| shipmethod | String | The shipping method used for the return associated with this cash refund. | |
| shippingaddress | String | The internal ID of the shipping address record associated with this cash refund. | |
| shippingcost | Decimal | The shipping cost included in this cash refund. | |
| shippingtax1rate | Double | The primary tax rate applied to the shipping cost on this cash refund. | |
| shippingtax2rate | Double | The secondary tax rate applied to the shipping cost on this cash refund. | |
| shippingtaxamount | Decimal | The total tax amount applied to the shipping cost on this cash refund. | |
| shippingtaxcode | String | The tax code used to calculate shipping taxes on this cash refund. | |
| source | String | The source channel or origin that generated this cash refund. | |
| sourcesystem | String | The external system from which this cash refund originated. | |
| startdate | Date | The start date of the revenue recognition schedule for this cash refund. | |
| subsidiary | String | The subsidiary associated with this cash refund. | |
| subsidiarytaxregnum | String | The tax registration number of the subsidiary associated with this cash refund. | |
| tax2total | Decimal | The total secondary tax amount on this cash refund. | |
| taxdetailsoverride | Boolean | If the value is true, the tax details on this cash refund have been manually overridden. | |
| taxitem | String | The tax item applied to this cash refund for tax calculation. | |
| taxperiod | String | The tax period to which this cash refund is assigned. | |
| taxpointdate | Date | The tax point date determining when VAT liability arises for this cash refund. | |
| taxpointdateoverride | Boolean | If the value is true, the tax point date on this cash refund has been manually overridden. | |
| taxrate | Double | The tax rate applied to this cash refund. | |
| taxregoverride | Boolean | If the value is true, the tax registration details on this cash refund have been overridden. | |
| taxtotal | Decimal | The total primary tax amount on this cash refund. | |
| terms | String | The payment terms applied to this cash refund. | |
| thirdpartyacct | String | The third-party billing account number used for shipping charges on this cash refund. | |
| tobeemailed | Boolean | If the value is true, this cash refund is queued to be sent to the customer by email. | |
| tobefaxed | Boolean | If the value is true, this cash refund is queued to be sent to the customer by fax. | |
| tobeprinted | Boolean | If the value is true, this cash refund is queued to be printed. | |
| total | Decimal | The total refund amount before tax adjustments. | |
| totalaftertaxes | Decimal | The total refund amount after all taxes have been applied. | |
| totalcostestimate | Decimal | The estimated total cost of items included in this cash refund. | |
| trandate | Date | The transaction date of this cash refund. | |
| tranid | String | The transaction ID or document number assigned to this cash refund. | |
| tranisvsoebundle | Boolean | If the value is true, this cash refund contains items that are part of a VSOE bundle. | |
| transactionnumber | String | The system-generated transaction number for this cash refund. | |
| transactiontorefund | String | The original transaction being refunded by this cash refund. | |
| type | String | The transaction type identifier for this cash refund. | |
| vatregnum | String | The VAT registration number associated with this cash refund. | |
| voided | Boolean | If the value is true, this cash refund has been voided and is no longer active. | |
| website | String | The website associated with the customer on this cash refund. |