salesorder
Stores details of sales orders, including order status, customer, and line items. DEPRECATED. To be removed in v26. Use the SalesOrder table in the SuiteTalk schema instead.
Columns
| Name | Type | References | Description |
| allowemptycards | Boolean | If the value is 'true', the system permits submission of payment forms without credit card details, which can be useful in deferred payment workflows or test environments. | |
| althandlingcost | Decimal | Represents an alternate handling fee calculated outside the standard shipping logic, often used in custom pricing scenarios or third-party integrations. | |
| altsalestotal | Decimal | Indicates an alternate version of the total sales amount, such as a promotional price total or a calculated value in a different currency context. | |
| altshippingcost | Decimal | Represents a modified shipping cost calculated based on custom rules, promotions, or external rate calculations instead of the standard shipping logic. | |
| aomautomated | Boolean | If the value is 'true', this order is automatically processed using Advanced Order Management (AOM) rules, including automated approval, fulfillment, and billing steps. | |
| authcode | String | The authorization code received from the payment processor confirming that the credit card transaction was approved. | |
| balance | Decimal | The outstanding amount remaining on the sales order that has not yet been billed or paid, used for accounts receivable tracking. | |
| billaddress | String | The full, formatted billing address associated with the sales order, typically used for display and reporting purposes. | |
| billaddresslist | String | A reference ID pointing to one of the customer's saved billing addresses selected during order entry. | |
| billingaddress | String | The raw or structured billing address data entered or stored directly on the sales order. | |
| billingschedule | String | The billing schedule template that governs how and when the customer is invoiced, such as milestone or time-based billing. | |
| billisresidential | String | Indicates whether the billing address is considered a residential location, which may impact tax calculations or delivery logistics. | |
| canhavestackable | Boolean | If the value is 'true', this order can support multiple, stackable promotions or discounts applied to the same transaction, depending on pricing rules. | |
| ccapproved | Boolean | If the value is 'true', the credit card transaction associated with the sales order was successfully approved by the payment gateway. | |
| ccavsstreetmatch | String | Indicates whether the street address provided matches the cardholder’s address on file, based on Address Verification System (AVS) results from the payment processor. | |
| ccavszipmatch | String | Indicates whether the ZIP or postal code provided during checkout matches the billing address on file for the credit card used. | |
| ccexpiredate | String | The expiration date of the credit card used for the transaction, typically in MM/YY format. | |
| cchold | String | Describes whether the credit card payment is currently on hold due to an issue such as insufficient funds or processor rejection. | |
| ccholdetails | String | Provides specific reasons or messages returned by the payment processor explaining why the card transaction was held. | |
| cciavsmatch | String | Summarizes the result of the AVS from the payment gateway, combining street and ZIP code match results. | |
| ccname | String | The full name printed on the credit card used for this transaction, usually required for verification and fraud prevention. | |
| ccnumber | String | The (masked) credit card number associated with the order, shown in a secure format (for example, **** **** **** 1234) for reference. | |
| ccprocessoraccount | String | Identifies which payment processor account was used for this credit card transaction, supporting multi-gateway configurations. | |
| ccsecuritycode | String | The CVV/CVC security code entered with the credit card, used for verification during transaction authorization. | |
| ccsecuritycodematch | String | Indicates whether the CVV/CVC security code provided matched the card issuer’s records, based on payment processor response. | |
| ccstreet | String | The street portion of the billing address submitted for AVS validation during credit card processing. | |
| cczipcode | String | The ZIP or postal code portion of the billing address submitted for AVS validation during credit card processing. | |
| checknumber | String | If payment was made by check, this field stores the check number for audit and reconciliation purposes. | |
| class | String | A classification used to segment the transaction by business unit, product line, or region, supporting internal reporting structures. | |
| consolidatebalance | Decimal | Reflects the customer’s total outstanding balance across all subsidiaries or related entities, used in consolidated financial reporting. | |
| couponcode | String | Promotional or marketing code applied to the sales order to trigger discounts, free shipping, or other incentives. | |
| createddate | Datetime | The timestamp when the sales order was first created in the system, used for auditing and reporting. | |
| createdfrom | String | Reference to the originating transaction, such as a quote or opportunity, from which this sales order was created. | |
| creditcard | String | Identifies the credit card record selected for payment, typically used in saved payment methods or vault references. | |
| creditcardprocessor | String | Indicates the payment gateway or credit card processor responsible for handling the transaction. | |
| currency | String | The currency in which the sales order is denominated, impacting pricing, totals, and exchange rate calculations. | |
| currencyname | String | The human-readable name of the currency (for example, US Dollar, Euro) associated with the sales order. | |
| currencysymbol | String | The symbol representing the order’s currency, such as $, €, or £, used in UI display. | |
| customercode | String | An internal or external customer identifier used for EDI, integration, or ERP reference purposes. | |
| customform | String | The custom entry form used to create or view the sales order, which may control field visibility and layout. | |
| debitcardissueno | String | Optional field for the issue number found on some debit cards, particularly used in international payment processing. | |
| deferredrevenue | Decimal | The portion of the sales total that is recognized as deferred revenue, often associated with subscription or milestone-based revenue. | |
| department | String | The department responsible for the transaction, typically used in organizational reporting and cost allocation. | |
| discountitem | String | The specific discount item applied to the sales order, which may correspond to a promotional rule or pricing strategy. | |
| discountrate | String | The rate or percentage applied to the order as a discount, either manually entered or system-generated. | |
| discounttotal | Decimal | The total monetary value of all discounts applied to the sales order, deducted from the subtotal. | |
| draccount | String | Revenue deferral account used when revenue recognition is delayed or managed separately from billing. | |
| dynamicdescriptor | String | A custom transaction descriptor sent to the customer’s credit card statement via the payment processor, used for branding or transparency. | |
| String | Email address used for sending order confirmations, receipts, or other customer-facing communication related to the order. | ||
| enddate | Date | The end date of the transaction period, typically used in recurring orders or service-related sales. | |
| entity | String | The customer entity associated with the sales order, typically linked to CRM and billing records. | |
| entitynexus | String | Nexus location used for tax calculation, based on the customer’s location and tax jurisdiction. | |
| entitytaxregnum | String | Tax registration number assigned to the customer, used for VAT or GST compliance in certain regions. | |
| estgrossprofit | Decimal | The estimated gross profit for the order, calculated as estimated revenue minus estimated costs of goods sold. | |
| estgrossprofitpercent | String | The estimated gross profit percentage, giving insight into the expected margin for the order. | |
| exchangerate | Decimal | The exchange rate used to convert the sales order’s currency to the base or reporting currency. | |
| excludecommission | Boolean | If the value is 'true', this sales order is excluded from commission calculations, typically for internal use or adjustments. | |
| externalid | String | An external system reference ID, often used in integrations or when syncing records between platforms. | |
| fob | String | Free on Board (FOB) term that defines when and where ownership of goods transfers, impacting shipping responsibilities and accounting. | |
| forinvoicegrouping | Boolean | If the value is 'true', this order is eligible to be grouped with others on a single invoice under certain billing rules. | |
| fxaccount | String | Foreign exchange account reference, used when tracking multi-currency transactions and gains/losses. | |
| getauth | Boolean | If the value is 'true', the system will attempt to obtain payment authorization automatically during order processing. | |
| giftcertapplied | Decimal | The amount of the order total that is covered by gift certificate redemption. | |
| handlingcost | Decimal | The total handling fee applied to the order, separate from shipping costs, often used for packaging, insurance, or special logistics. | |
| handlingmode | String | The method or logic used to calculate handling charges, such as flat rate, per item, or based on order total. | |
| handlingtax1rate | String | The tax rate applied to the handling fee under the primary tax rule or jurisdiction. | |
| handlingtaxcode | String | The tax code that governs how handling charges are taxed, linked to local or international compliance rules. | |
| ignoreavs | Boolean | If the value is 'true', the order will bypass AVS checks during credit card authorization, typically for internal testing or override scenarios. | |
| ignorecsc | Boolean | If the value is 'true', the system ignores CVV/CVC validation during payment processing. | |
| inputauthcode | String | The authorization code manually input for the credit card transaction, used when overriding automated processing. | |
| inputpnrefnum | String | The processor reference number manually entered for a credit card transaction, typically used in reconciliations. | |
| inputreferencecode | String | Custom reference code entered by the user for linking the transaction to an external system or internal process. | |
| intercostatus | String | The current status of intercompany processing for the order, such as pending, approved, or completed. | |
| intercotransaction | String | Reference to the related intercompany transaction generated from this order, used for cross-subsidiary processing. | |
| isbasecurrency | Boolean | If the value is 'true', this order uses the base currency of the company rather than a foreign or subsidiary-specific currency. | |
| isdefaultshippingrequest | String | Indicates whether this order follows the default shipping request profile set for the customer or location. | |
| ismultishipto | Boolean | If the value is 'true', the order contains line items shipping to multiple addresses, requiring complex fulfillment logic. | |
| ispurchasecard | String | Indicates whether a purchasing card (P-Card) is used for this transaction, often for business or government clients. | |
| isrecurringpayment | Boolean | If the value is 'true', this order is part of a recurring payment arrangement, such as a subscription or installment plan. | |
| istaxable | Boolean | If the value is 'true', taxes are applicable to the transaction based on item and customer tax status. | |
| lastmodifieddate | Datetime | The date and time of the most recent update to the sales order, used for audit trails and data sync. | |
| leadsource | String | The source of the lead that generated this order, useful for marketing attribution or sales funnel analysis. | |
| linkedtrackingnumbers | String | Comma-separated list of shipment tracking numbers associated with this order, used for fulfillment tracking. | |
| location | String | The physical location or warehouse responsible for fulfilling this sales order, impacting inventory and tax logic. | |
| memo | String | An internal note or message attached to the order, not visible to customers but used by staff for context or workflow. | |
| message | String | A customer-facing message displayed on invoices or emails, such as thank-you notes or custom terms. | |
| messagesel | String | A predefined message selection used to populate the message field quickly based on standard communication templates. | |
| muccpromocodeinstance | String | The internal reference to a Multi-Use Coupon Code (MUCC) applied to this order for discount tracking. | |
| nextbill | Date | The next billing date for recurring transactions associated with this sales order. | |
| nexus | String | Represents the tax jurisdiction for the order based on the shipping or selling location, critical for compliance. | |
| onetime | Decimal | One-time charge amount applied to the order, separate from recurring fees or standard items. | |
| opportunity | String | Reference to the CRM opportunity record that led to this sales order, used for pipeline and conversion tracking. | |
| orderstatus | String | Current status of the order in the workflow, such as Pending Approval, Partially Fulfilled, or Billed. | |
| ordertype | String | The classification of the order type, such as Standard, Drop Ship, or Intercompany Transfer. | |
| otherrefnum | String | An external reference number (such as PO Number) provided by the customer to help identify this transaction. | |
| outputauthcode | String | The authorization code returned by the payment processor after a credit card transaction is processed, stored for reference. | |
| outputreferencecode | String | Custom code returned or generated after payment processing, used for linking to external payment systems. | |
| overridehold | Boolean | If the value is 'true', manually overrides any hold placed on the order due to credit, fraud, or payment validation issues. | |
| overrideholdchecked | Boolean | If the value is 'true', indicates that the override hold checkbox was manually selected in the UI to release the order from hold. | |
| overrideshippingcost | Double | A manually entered shipping amount that overrides calculated shipping costs, often used for special arrangements or adjustments. | |
| partner | String | The partner record linked to the order, typically used for partner commission calculations or sales channel tracking. | |
| paymentcardcsc | String | The CVV/CVC security code value submitted with the card payment, used to help verify card ownership. | |
| paymenteventdate | Datetime | The date and time of the most recent payment-related event on the order, such as authorization, capture, or decline. | |
| paymenteventholdreason | String | Explains why the payment is currently on hold, such as address mismatch, insufficient funds, or processor rules. | |
| paymenteventpurchasedatasent | String | Indicates whether purchase data (such as item breakdown or tax) was successfully sent to the payment gateway for Level 2/3 processing. | |
| paymenteventresult | String | Describes the outcome of the latest payment attempt, such as Approved, Declined, or Error. | |
| paymenteventtype | String | Type of payment event processed, such as Authorization, Capture, Refund, or Void. | |
| paymenteventupdatedby | String | Identifies the user or system process that last updated the payment event on the sales order. | |
| paymentmethod | String | The method used for payment, such as Credit Card, PayPal, Invoice, or Wire Transfer. | |
| paymentoperation | String | Describes the type of payment operation performed, such as 'Sale', 'Authorization Only', or 'Capture'. | |
| paymentoption | String | Specifies a predefined or customer-specific payment option selected for this sales order. | |
| paymentprocessingprofile | String | References the payment processing configuration profile that controls rules, gateway, and behavior for the order. | |
| paypalauthid | String | The authorization ID returned from PayPal for this transaction, used for status tracking and potential refunds. | |
| paypalprocess | Boolean | If the value is 'true', the order is being processed through PayPal rather than a traditional credit card gateway. | |
| paypalstatus | String | Current status of the PayPal transaction, such as Authorized, Captured, or Canceled. | |
| paypaltranid | String | The transaction ID assigned by PayPal for this payment, used for reconciliation and refund purposes. | |
| pnrefnum | String | Reference number generated by the payment processor to uniquely identify the transaction for tracking and audit. | |
| promocode | String | Promotional code applied by the customer or system to trigger discounts, free items, or loyalty rewards. | |
| promocodepluginimpl | String | Internal reference to the plugin implementation logic that handles the application of promotion codes. | |
| recognizedrevenue | Decimal | Revenue that has already been recognized from this sales order under the revenue recognition rules or schedule. | |
| recurannually | Decimal | The amount that recurs annually as part of a recurring billing setup related to this order. | |
| recurmonthly | Decimal | The monthly recurring charge associated with this sales order, typical for subscriptions or service plans. | |
| recurquarterly | Decimal | The quarterly recurring billing amount if the sales order involves installment or subscription plans billed every 3 months. | |
| recurweekly | Decimal | Amount that recurs weekly under a recurring billing arrangement linked to this order. | |
| returntrackingnumbers | String | Tracking numbers provided for returned shipments associated with this order, separated by commas if multiple. | |
| revcommitstatus | String | Revenue commitment status for the order, indicating whether revenue is recognized, pending, or deferred. | |
| revenuestatus | String | Displays the current revenue status, such as Not Recognized, In Progress, or Fully Recognized. | |
| revreconrevcommitment | Boolean | If the value is 'true', revenue recognition is based on committed revenue events rather than billing or fulfillment. | |
| saleseffectivedate | Date | The effective sales date, which may differ from the order creation date, and is used for reporting, forecasting, or revenue recognition. | |
| salesgroup | String | The sales group or team responsible for this order, often used for internal sales reporting and commission tracking. | |
| salesrep | String | The individual sales representative assigned to the order, used for sales performance metrics and commission calculation. | |
| shipaddress | String | The formatted shipping address for the sales order, typically displayed on printed or emailed documents. | |
| shipaddresslist | String | References the customer's saved list of shipping addresses, indicating which one was selected for this order. | |
| shipcomplete | Boolean | If the value is 'true', all items on the order must be shipped together; if 'false', partial shipments are allowed. | |
| shipdate | Date | The scheduled or actual ship date for the order, used in fulfillment planning and delivery tracking. | |
| shipisresidential | String | Indicates whether the shipping destination is a residential address, which may affect delivery method or surcharge. | |
| shipmethod | String | The selected shipping method (for example, FedEx Ground, UPS Next Day) used to fulfill the order. | |
| shipoverride | String | If present, indicates that standard shipping rules have been manually overridden for this transaction. | |
| shippingaddress | String | The full shipping address associated with the order, including all formatted fields. | |
| shippingcost | Decimal | Total cost of shipping charged on the sales order, before any discounts or overrides are applied. | |
| shippingcostoverridden | String | Indicates whether the calculated shipping cost was manually overridden, and if so, how. | |
| shippingtax1rate | String | The primary tax rate applied to the shipping portion of the sales order, based on applicable tax rules. | |
| shippingtaxcode | String | The tax code used to determine the taxable status and calculation method for the shipping charge. | |
| softdescriptor | String | A short custom description that appears on the customer’s credit card statement, typically identifying the business or product. | |
| source | String | The origin of the order, such as web, phone, in-store, or API, useful for marketing attribution and operational routing. | |
| startdate | Date | The start date of the order cycle, used for recurring billing or service fulfillment timelines. | |
| status | String | The current lifecycle status of the sales order, such as Pending Approval, Fulfilled, or Billed. | |
| statusRef | String | Internal system reference to the sales order's status, often used in scripting or integrations. | |
| subsidiary | String | The subsidiary responsible for the transaction, relevant in multi-entity NetSuite environments for accounting and compliance. | |
| subsidiarytaxregnum | String | Tax registration number specific to the subsidiary involved in the order, used for regional tax reporting. | |
| subtotal | Decimal | The total cost of all line items before taxes, discounts, shipping, and other charges are applied. | |
| syncpartnerteams | Boolean | If the value is 'true', partner team records are synchronized with this order for accurate reporting and commission tracking. | |
| syncsalesteams | Boolean | If the value is 'true', the sales team assigned to the order is synchronized with CRM or reporting tools. | |
| taxdetailsoverride | Boolean | If the value is 'true', tax details on the order have been manually modified instead of being auto-calculated. | |
| taxitem | String | The tax item or tax code applied to the order, determining how taxes are calculated and posted. | |
| taxpointdate | Date | The date used to determine when tax becomes applicable, which may differ from the order or invoice date depending on jurisdiction. | |
| taxpointdateoverride | Boolean | If the value is 'true', the standard tax point date has been manually overridden to support specific compliance needs. | |
| taxrate | Double | The total effective tax rate applied to the order, calculated based on item and location-level tax rules. | |
| taxregoverride | Boolean | If the value is 'true', the standard tax registration rules have been bypassed or overridden for this transaction. | |
| taxtotal | Decimal | The total amount of tax charged on the order, calculated based on tax codes, items, shipping, and jurisdiction. | |
| terms | String | The payment terms assigned to the sales order, such as Net 30 or Due on Receipt, affecting billing and collections. | |
| threedstatuscode | String | The 3D Secure status code returned from the card issuer during payment authentication, used for fraud prevention tracking. | |
| tobeemailed | Boolean | If the value is 'true', the sales order is flagged to be emailed to the customer during order processing or billing. | |
| tobefaxed | Boolean | If the value is 'true', the sales order is flagged to be faxed to the customer using integrated communication tools. | |
| tobeprinted | Boolean | If the value is 'true', the order is marked for printing, typically as part of a batch print or fulfillment process. | |
| total | Decimal | The grand total amount for the sales order, including all items, taxes, discounts, handling, and shipping. | |
| totalcostestimate | Decimal | The total estimated cost associated with fulfilling the sales order, used for profit margin analysis. | |
| trandate | Date | The transaction date assigned to the order, which may be used in accounting periods and revenue recognition schedules. | |
| tranid | String | The unique identifier for the sales order, typically displayed as the order number in the user interface. | |
| tranisvsoebundle | Boolean | If the value is 'true', the transaction involves a Vendor-Specific Objective Evidence (VSOE) bundle, affecting revenue recognition rules. | |
| unbilledorders | Decimal | Represents the portion of the order total that has not yet been billed, useful for tracking open revenue. | |
| validfrom | String | The date from which the sales order or pricing becomes valid, often used in price agreements or promotions. | |
| vsoeautocalc | Boolean | If the value is 'true', VSOE amounts and allocations are automatically calculated for this transaction. |