returnauthorization
Records customer return authorizations, capturing details of returned items, approval status, and refund processing.
Columns
| Name | Type | References | Description |
| altsalestotal | Decimal | Represents the alternative sales total, which includes any adjustments, discounts, or promotions applied to the sales amount. This value is calculated separately from the standard sales total. | |
| billaddress | String | The complete billing address associated with the return authorization, including street address, city, state, postal code, and country. | |
| billaddresslist | String | A reference to the list of available billing addresses for the customer, allowing selection of a predefined address stored in the system. | |
| billingaddress | String | The formatted billing address associated with the transaction, used for invoicing and payment processing purposes. | |
| billisresidential | String | Indicates whether the billing address is a residential address as opposed to a commercial address. This can affect shipping and tax calculations. | |
| class | String | The classification category assigned to this return authorization, which can be used for financial reporting and segmentation. | |
| couponcode | String | The promotional or discount code applied to this return authorization, affecting the total amount and applicable discounts. | |
| createddate | Datetime | The date and time when this return authorization was initially created in the system. | |
| createdfrom | String | A reference to the original sales transaction from which this return authorization was generated, typically linking to an invoice or sales order. | |
| currency | String | The currency in which this transaction is recorded, determined based on the company or customer currency settings. | |
| currencyname | String | The full name of the currency used in this transaction, such as 'US Dollar' or 'Euro'. | |
| currencysymbol | String | The currency symbol representing the transaction currency, such as '$' for USD or '€' for EUR. | |
| customform | String | The custom form template used for this return authorization, determining the layout and fields available on the user interface. | |
| deferredrevenue | Decimal | The portion of revenue that has been invoiced but not yet recognized, typically used in revenue recognition processes. | |
| department | String | The department associated with this return authorization, used for financial tracking and reporting. | |
| discountitem | String | The discount item applied to the transaction, which affects the total amount by reducing the sales value. | |
| discountrate | String | The rate or percentage of discount applied to the transaction, affecting the total sales amount. | |
| discounttotal | Decimal | The total discount amount applied to this return authorization, reducing the overall transaction value. | |
| draccount | String | The debit account used for accounting transactions related to this return authorization. | |
| String | The email address associated with the customer or entity for communication and notifications. | ||
| entity | String | The customer or business entity related to this return authorization, typically representing the buyer. | |
| entitynexus | String | The tax jurisdiction or nexus associated with the entity, determining applicable tax rates and compliance requirements. | |
| entitytaxregnum | String | The tax registration number associated with the entity, used for tax reporting and compliance. | |
| estgrossprofit | Decimal | The estimated gross profit for this return authorization, calculated as the difference between revenue and cost. | |
| estgrossprofitpercent | String | The estimated gross profit percentage for the transaction, calculated as the estimated gross profit divided by total revenue. | |
| exchangerate | Decimal | The exchange rate applied to the transaction if the currency differs from the company’s base currency. | |
| excludecommission | Boolean | Indicates whether this transaction should be excluded from commission calculations for sales representatives. | |
| externalid | String | A unique identifier (Id) assigned externally to this transaction, often used for integrations and third-party system references. | |
| fxaccount | String | The foreign exchange account used for handling currency conversions and transactions in different currencies. | |
| inputpnrefnum | String | The reference number provided by the payment processor for a payment or authorization related to this return. | |
| intercostatus | String | The status of the intercompany transaction associated with this return authorization, used for internal accounting. | |
| intercotransaction | String | A reference to the related intercompany transaction, linking financial records across subsidiaries or entities. | |
| isbasecurrency | Boolean | Indicates whether the transaction is recorded in the company's base currency. If 'true,' amounts are shown in the base currency; otherwise, they are in the transaction currency. | |
| istaxable | Boolean | Specifies whether the return authorization is subject to sales tax. If 'true,' the transaction is taxable based on applicable tax rules. | |
| lastmodifieddate | Datetime | The timestamp of the most recent modification to the return authorization record, reflecting changes made by users or system processes. | |
| leadsource | String | The originating source of the return authorization, identifying the campaign, advertisement, or other marketing effort that led to the transaction. | |
| location | String | The physical or virtual location associated with this return authorization, typically representing a warehouse, store, or distribution center. | |
| memo | String | A free-text field for internal notes or comments regarding the return authorization, useful for tracking additional details or special instructions. | |
| message | String | A customer-facing message included on the return authorization, often providing return instructions or other relevant details. | |
| messagesel | String | A predefined message template selected for this return authorization, allowing standardized communication with customers. | |
| muccpromocodeinstance | String | A unique Id for a multi-use coupon code instance applied to this return authorization, used for tracking promotional discounts. | |
| nexus | String | The tax jurisdiction applicable to this return authorization, determining how sales tax is calculated based on the business's registered tax locations. | |
| orderstatus | String | The current status of the return authorization in the order workflow, such as pending approval, approved, or closed. | |
| otherrefnum | String | An optional reference number provided by the customer or external system to track the return authorization against external records. | |
| partner | String | The business partner or affiliate associated with this return authorization, typically used in partner sales or referral transactions. | |
| promocode | String | The promotional code applied to this return authorization, representing a discount or special offer that modifies the return transaction. | |
| promocodepluginimpl | String | The implementation reference for a custom promo code plugin that modifies pricing, discounts, or promotions for this return authorization. | |
| recognizedrevenue | Decimal | The amount of revenue that has been recognized from this return authorization based on the organization's revenue recognition rules. | |
| returntrackingnumbers | String | A list of tracking numbers associated with the return shipment, enabling tracking of returned goods through shipping carriers. | |
| revcommitstatus | String | The revenue commitment status for this return authorization, indicating whether revenue has been committed or deferred based on accounting rules. | |
| revenuestatus | String | The overall revenue recognition status of this return authorization, such as recognized, deferred, or in progress, based on financial reporting policies. | |
| revreconrevcommitment | Boolean | Indicates whether revenue reconciliation is required for committed revenue in this transaction. | |
| saleseffectivedate | Date | The date when the sales transaction associated with this return authorization became effective. | |
| salesgroup | String | The designated sales group responsible for overseeing this return authorization, typically assigned based on sales territories or business rules. | |
| salesrep | String | The sales representative handling this return authorization, responsible for customer communication and transaction management. | |
| shipaddress | String | The full shipping address associated with this return authorization, including street address, city, state, postal code, and country. | |
| shipaddresslist | String | A reference to the available predefined shipping addresses stored in the system, allowing selection from saved customer addresses. | |
| shipisresidential | String | Indicates whether the shipping address is classified as a residential location, which can impact shipping rates and carrier selection. | |
| shipoverride | String | Specifies whether standard shipping methods or preferences have been manually adjusted for this return authorization. | |
| shippingaddress | String | The fully formatted shipping address used for logistics, fulfillment, and invoice documentation. | |
| source | String | The originating system or process that created this return authorization, which can be an external integration, web order, or internal entry. | |
| status | String | The current processing status of this return authorization, indicating whether it is pending, approved, rejected, or completed. | |
| statusref | String | An internal reference code representing the status of this return authorization, used for system tracking and reporting. | |
| subsidiary | String | The specific business entity or subsidiary associated with this return authorization, helping in financial reporting and operational segmentation. | |
| subsidiarytaxregnum | String | The tax registration number assigned to the subsidiary, required for tax compliance and jurisdictional reporting. | |
| subtotal | Decimal | The calculated total value of the items in this return authorization before applying taxes, shipping charges, or discounts. | |
| syncpartnerteams | Boolean | Indicates whether partner team data should be synchronized across related transactions for consistency and collaboration. | |
| syncsalesteams | Boolean | Indicates whether the assigned sales teams should be updated and synchronized across related records for accurate reporting. | |
| taxdetailsoverride | Boolean | Specifies whether tax details, such as rates and calculations, have been manually adjusted instead of system-determined values. | |
| taxitem | String | The specific tax item applied to this transaction, determining applicable tax rates based on jurisdiction and tax rules. | |
| taxpointdate | Date | The official tax recognition date for this return authorization, which dictates when the tax liability is recorded. | |
| taxpointdateoverride | Boolean | Indicates whether the standard tax point date has been manually modified to align with specific business or regulatory requirements. | |
| taxrate | Double | The percentage rate of tax applied to this return authorization, used to compute the total tax amount. | |
| taxregoverride | Boolean | Indicates whether the tax registration details have been manually modified instead of using system-generated values. | |
| taxtotal | Decimal | The total calculated tax amount applied to this return authorization, based on tax rates and jurisdictional rules. | |
| tobeemailed | Boolean | Indicates whether this return authorization should be automatically sent to the customer via email upon processing. | |
| tobefaxed | Boolean | Indicates whether this return authorization should be transmitted to the customer via fax upon processing. | |
| tobeprinted | Boolean | Indicates whether this return authorization should be printed for physical documentation or record-keeping. | |
| total | Decimal | The final amount for this return authorization, including item values, taxes, shipping fees, and any applicable discounts. | |
| totalcostestimate | Decimal | The estimated total cost associated with this return authorization, often used for financial forecasting and profitability analysis. | |
| trandate | Date | The official date when this return authorization was recorded in the system, often used for reporting and auditing. | |
| tranid | String | The unique transaction Id assigned to this return authorization, ensuring traceability and reference in financial records. | |
| tranisvsoebundle | Boolean | Indicates whether this return authorization is linked to a Vendor-Specific Objective Evidence (VSOE) bundle for revenue recognition compliance. | |
| vsoeautocalc | Boolean | Indicates whether the system automatically applies VSOE calculations to determine the revenue recognition treatment for this return authorization. |