SOOrder

PX.Objects.SO

View API Entity: SalesOrder/entity/Default/24.200.001/SalesOrder

281 of 281 fields

	Field Name	Type	Display Name	Foreign Key
	`OrderNbr` API Default Navigation	`nvarchar(15)`	Order Nbr.	-
Description:No description available
	`OrderType` API Default Navigation	`char(2)`	Order Type	SOOrderType
Description:No description available
	`ActiveOperationsCntr`Nonexistent in DB	`int`		-
Description:The number of active operations (which can be an issue or receipt) of the order type.
	`AllowsRequiredPrepayment`Nonexistent in DB	`bit`		-
Description:No description available
	`Approved` API	`bit`		-
Description:A Boolean value that indicates whether the sales order has been approved. This field is available only if the Approval Workflow feature is enabled on the Enable/Disable Features (CS100000) form.
	`ApprovedCredit`	`bit`		-
Description:A Boolean value that indicates whether a user approved an order that has a failed credit check.
	`ApprovedCreditAmt`	`decimal(19, 4)`		-
Description:The amount of the order that a user approved on a failed credit check.
	`ApprovedCreditByPayment`	`bit`		-
Description:A Boolean value that indicates whether a user approved an order that has a failed credit check by a payment.
	`ARDocType`Nonexistent in DB	`nchar(3)`		-
Description:The type of an accounts receivable document to be generated on release of a document of this type. The field is included in the FK.Invoice foreign key. The field can have one of the values listed in AR.ARDocType.
	`ArePaymentsApplicable`Nonexistent in DB	`bit`	ArePaymentsApplicable	-
Description:No description available
	`AuthorizedPaymentCntr`	`int`		-
Description:The counter of the applied payments in pre-authorized state.
	`AvalaraCustomerUsageType`	`char(1)`	Tax Exemption Type	-
Description:No description available
	`BackOrdered`Nonexistent in DB	`bit`	BackOrdered	-
Description:A Boolean value that indicates whether the order can not be shipped because the specified items are not available. This status can be assigned to an open order manually in the following case: When a user attempts to create a shipment, the system detects that the order cannot be shipped in full and displays a message about this. This status can be assigned to orders automatically when shipment for order is created if the shipping rules specified on the document level and on the line level do not allow shipment creation. This status is available for sales orders of the SO and SA types.
	`Behavior`	`char(2)`	Behavior	-
Description:The behavior, which is defined by OrderType (which is the link to SOOrderType). The field can have one of the values listed in SOBehavior.
	`BillAddressID`	`int`		SOAddress
Description:No description available
	`BillContactID`	`int`		SOContact
Description:No description available
	`BilledCntr`	`int`		-
Description:The counter of the shipments added to the order that have an invoice.
	`BilledFreightTot`	`decimal(19, 4)`		-
Description:The sum of amounts of the freight details that have been transferred to the SO invoice generated for the sales order (in the base currency).
	`BilledPaymentTotal`	`decimal(19, 4)`		-
Description:The sum of amounts of the payments or prepayments that have been applied to the AR invoice generated for the order.
	`BillSeparately`	`bit`	Bill Separately	-
Description:A Boolean value that indicates whether the document should be billed separately (that is, it requires a separate invoice). This field is not available for transfer orders.
	`BlanketLineCntr`	`int`		-
Description:The counter of the sales order detail lines added to the parent blanket order.
	`BlanketOpenQty`	`decimal(25, 6)`	Open Quantity	-
Description:The summarized quantity of the stock or non-stock items in the blanket sales order that has not been transferred to child orders.
	`BlanketSOAdjustCntr`	`int`		-
Description:The counter of the lines added to the current order and having blanket reference.
	`BranchID`Default Navigation	`int`	Branch	Branch
Description:No description available
	`CancelDate`	`datetime2`	Cancel By	-
Description:The expiration date of the order, by which the order can be selected for canceling on the Process Orders (SO501000) form.
	`Cancelled`	`bit`	Canceled	-
Description:A Boolean value that indicates (if set to ) that the order has been canceled on the date specified in CancelDate.
	`CashAccountID`Default Navigation	`int`	Cash Account	Account
Description:No description available
	`CCAuthorizedAmt`	`decimal(19, 4)`		-
Description:The sum of all authorized credit card payments that have been applied to the sales order. This field is available only if the Integrated Card Processing feature is enabled on the Enable/Disable Features (CS100000) form.
	`ChildLineCntr`	`int`		-
Description:The counter of the sales order details added to child orders.
	`CommnPct`	`decimal(9, 6)`		-
Description:No description available
	`Completed`	`bit`	Completed	-
Description:A Boolean value that specifies (if set to ) that all related inventory documents required for the order type have been generated and released. Completed orders of the QT order type can be opened again.
	`ContactID` API Default Navigation	`int`	Contact	Contact
Description:The identifier of the contact. The field is included in the FK.Contact foreign key. The value of this field corresponds to the value of the Contact.contactID field.
	`ControlTotal` API	`decimal(19, 4)`		-
Description:The control total of the document. A user enters this amount manually. This amount should be equal to the sum of the amounts of all detail lines of the document. The document can be released only if the value in this field is equal to the value in orderTotal. This field is available only if the Require Control Total field is .
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`	Created On	-
Description:No description available
	`CreditHold` API	`bit`	Credit Hold	-
Description:A Boolean value that specifies (if set to ) that the customer has failed the credit check, which the system performed when the order was taken off hold. An order with this status can be saved with only the Credit Hold or On Hold status if the Hold Document on Failed Credit Check field is for the order type. This status is available for orders of the QT, SO, SA, IN, and CM order types.
	`CuryBilledFreightTot`	`decimal(19, 4)`		-
Description:The sum of amounts of the freight details that have been transferred to the SO invoice generated for the sales order (in the currency of the document).
	`CuryBilledPaymentTotal`	`decimal(19, 4)`	Total Transferred to Invoices	-
Description:The sum of amounts of the payments or prepayments that have been applied to the AR invoice generated for the order (in the currency of the document).
	`CuryCCAuthorizedAmt`	`decimal(19, 4)`	Authorized	-
Description:The sum of all authorized credit card payments that have been applied to the sales order (in the currency of the document).
	`CuryControlTotal`	`decimal(19, 4)`	Control Total	-
Description:The control total of the document (in the currency of the document). A user enters this amount manually.
	`CuryDetailExtPriceTotal`	`decimal`	Detail Total	-
Description:The sum of the goods and the misc. charges amount values.
	`CuryDiscTot`	`decimal(19, 4)`	Document Discounts	-
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of all discounts of the order.
	`CuryDocBal`Nonexistent in DB	`decimal`		-
Description:No description available
	`CuryDocumentDiscTotal`	`decimal(19, 4)`	Document Discount	-
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of document discounts of the order.
	`CuryFreightAmt`	`decimal(19, 4)`	Freight Price	-
Description:The freight amount calculated in accordance with the shipping terms (in the currency of the document).
	`CuryFreightCost`	`decimal(19, 4)`	Freight Cost	-
Description:The freight cost calculated for the document (in the currency of the document).
	`CuryFreightTot`	`decimal(19, 4)`	Freight Total	-
Description:The sum of the additional freight charges and the freight amount values.
	`CuryGoodsExtPriceTotal`	`decimal(19, 4)`	Goods	-
Description:The total amount on all lines of the document, except for Misc. Charges, before Line-level discounts are applied (in the currency of the document).
	`CuryGroupDiscTotal`	`decimal(19, 4)`	Group Discounts	-
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of group discounts of the order.
	`CuryID`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:The identifier of the currency of the document. The field is included in the FK.Currency foreign key. The value of this field corresponds to the value of the Currency.curyID field. This field is available only if the Multicurrency Accounting feature is enabled on the Enable/Disable Features (CS100000) form.
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:The identifier of the currency and exchange rate information. The field is included in the FK.CurrencyInfo foreign key. The value of this field corresponds to the value of the CurrencyInfo.curyInfoID field.
	`CuryLineDiscTotal`	`decimal(19, 4)`	Line Discounts	-
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of line discounts of the order.
	`CuryLineTotal`	`decimal(19, 4)`	Line Total	-
Description:The total amount on all lines of the document, except for Misc. Charges, after Line-level discounts are applied (in the currency of the document).
	`CuryManDisc`Obsolete	`decimal(19, 4)`	Manual Total	-
Description:No description available
	`CuryMarginAmt`	`decimal(19, 4)`	Est. Margin Amount	-
Description:The order's estimated margin amount (in the currency of the document). The value is not available for the transfer order.
	`CuryMiscExtPriceTotal`	`decimal(19, 4)`	Misc. Charges	-
Description:The total amount calculated as the sum of the amounts in Ext. Price of the order non-stock items (in the currency of the document).
	`CuryMiscTot`	`decimal(19, 4)`	Misc. Charges	-
Description:The total amount calculated as the sum of the amounts in Amount of the order non-stock items (in the currency of the document).
	`CuryNetSalesTotal`	`decimal(19, 4)`		-
Description:The sum of the line amounts without the taxes and with the applied group and document discounts (in the currency of the document).
	`CuryOpenDiscTotal`	`decimal(19, 4)`		-
Description:The discount total of open lines (in the currency of the document).
	`CuryOpenLineTotal`	`decimal(19, 4)`	Unshipped Line Total	-
Description:The sum of line open amount (in the currency of the document).
	`CuryOpenOrderTotal`	`decimal(19, 4)`	Unshipped Amount	-
Description:The sum of unshipped amounts calculated for the lines with nonzero unshipped quantities of stock items (in the currency of the document).
	`CuryOpenTaxTotal`	`decimal(19, 4)`	Unshipped Tax Total	-
Description:The sum of tax amounts of child transactions (in the currency of the document).
	`CuryOrderCosts`	`decimal(19, 4)`		-
Description:The sum of the extended costs of the detail lines and the freight cost (in the currency of the document).
	`CuryOrderDiscTotal`	`decimal`	Discount Total	-
Description:The total discount of the document (in the currency of the document), which is calculated as the sum of all group, document and line discounts of the order.
	`CuryOrderNetSales`	`decimal(19, 4)`		-
Description:The sum of the line amounts without the taxes and with the applied group and document discounts and the taxable freight amount (in the currency of the document).
	`CuryOrderTotal`	`decimal(19, 4)`	Order Total	-
Description:The total amount of the document (in the currency of the document).
	`CuryPaidAmt`	`decimal(19, 4)`	Released	-
Description:The sum of all released payments that have been applied to the sales order (in the currency of the document).
	`CuryPaymentOverall`	`decimal(19, 4)`		-
Description:The sum of amounts of child payments (in the currency of the document).
	`CuryPaymentTotal`	`decimal(19, 4)`	Total Paid	-
Description:The total amount that has been paid for this sales order (in the currency of the document).
	`CuryPremiumFreightAmt`	`decimal(19, 4)`	Premium Freight Price	-
Description:Any additional freight charges for handling the order (in the currency of the document).
	`CuryPrepaymentReqAmt`	`decimal(19, 4)`	Prepayment Amount	-
Description:No description available
	`CurySalesCostTotal`	`decimal(19, 4)`		-
Description:The sum of the extended costs of the detail lines for which the margin is not empty (in the currency of the document). The line's extended cost is used with the negative sign for the receipt lines.
	`CuryTaxableFreightAmt`	`decimal(19, 4)`		-
Description:The sum of freight amount and additional freight charges that are subject to taxes (in the currency of the document).
	`CuryTaxTotal`	`decimal(19, 4)`	Tax Total	-
Description:The total amount of tax paid on the document (in the currency of the document).
	`CuryTermsDiscAmt`Nonexistent in DB	`decimal`		-
Description:The discount amount of the prompt payment (in the currency of the document).
	`CuryTransferredToChildrenPaymentTotal`	`decimal(19, 4)`	Total Transferred to Child Orders	-
Description:The sum of amounts of the payments or prepayments that have been applied to the child orders generated for the blanket order. (in the currency of the document).
	`CuryUnbilledDiscTotal`	`decimal(19, 4)`		-
Description:The discount total for unbilled lines (in the currency of the document).
	`CuryUnbilledFreightTot`	`decimal(19, 4)`		-
Description:No description available
	`CuryUnbilledLineTotal`	`decimal(19, 4)`	Unbilled Line Total	-
Description:The sum of unbilled amounts of child lines (in the currency of the document).
	`CuryUnbilledMiscTot`	`decimal(19, 4)`	Unbilled Misc. Total	-
Description:The sum of unbilled amounts of child lines (in the currency of the document).
	`CuryUnbilledOrderTotal`	`decimal(19, 4)`	Unbilled Balance	-
Description:The unbilled balance of the sales order, which is calculated as the sum of the unbilled line amounts (in the currency of the document).
	`CuryUnbilledTaxTotal`	`decimal(19, 4)`	Unbilled Tax Total	-
Description:The total amount of tax paid on the unbilled part of the document (in the currency of the document).
	`CuryUnpaidBalance`	`decimal(19, 4)`	Unpaid Balance	-
Description:No description available
	`CuryUnrefundedBalance`	`decimal(19, 4)`	Unrefunded Balance	-
Description:No description available
	`CuryUnreleasedPaymentAmt`	`decimal(19, 4)`	Not Released	-
Description:The sum of the payments that have been applied to the sales order and that have not been released yet (in the currency of the document).
	`CuryVatExemptTotal`	`decimal(19, 4)`	Tax Exempt Total	-
Description:The document total that is exempt from VAT (in the currency of the document).
	`CuryVatTaxableTotal`	`decimal(19, 4)`	Taxable Total	-
Description:The document total that is subject to VAT (in the currency of the document).
	`CustomerID` API Default Navigation	`int`	Customer	Customer
Description:No description available
	`CustomerLocationID`Default Navigation	`int`	Location	Location
Description:No description available
	`CustomerOrderNbr`	`nvarchar(40)`	Customer Order Nbr.	-
Description:The reference number of the original customer document that the sales order is based on. A reference number must be specified if the Require Customer Order Nbr field is for the order type. This field is available for orders of the TR type.
	`CustomerRefNbr`	`nvarchar(40)`	External Reference	-
Description:The reference number of the sales order in a third-party application if Acumatica ERP is integrated with such an application and imports the sales orders from it.
	`DefaultOperation`Default NavigationNonexistent in DB	`nchar(1)`		SOOrderTypeOperation
Description:The default operation (which can be an issue or receipt) of the order type.
	`DefaultSiteID`Default Navigation	`int`	Preferred Warehouse ID	INSite
Description:The identifier of the warehouse from which the goods should be shipped. The field is included in the FK.DefaultSite foreign key. The value of this field corresponds to the value of the INSite.siteID field. This field is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.
	`DefaultTranType`Nonexistent in DB	`nchar(3)`		-
Description:The default transfer type. The value is the order type of the order if the order type is Inventory Transaction Type.
	`DeferPriceDiscountRecalculation`Nonexistent in DB	`bit`	Defer Price/Discount Recalculation	-
Description:A Boolean value that indicates whether the system will update discounts, taxes and prices after saving the order, and the system will not update them before. If the value is , the system updates discounts, taxes, and prices while the order is editing. The field depends on SOOrderType.deferPriceDiscountRecalculation.
	`DeliveryConfirmation`	`nvarchar(20)`	Delivery Confirmation	-
Description:No description available
	`DeliveryMethod`	`char(1)`	Link Delivery Method	-
Description:No description available
	`DestinationSiteID`Default Navigation	`int`	Destination Warehouse	INSite
Description:The identifier of the destination warehouse for the items to be transferred. The field is included in the foreign keys FK.DestinationSite and FK.ToSite. The value of this field corresponds to the value of the INSite.siteID field. This field is available only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
	`DestinationSiteIdErrorMessage`Nonexistent in DB	`nvarchar(150)`		-
Description:The error message that is raised because of the setting of the shipping address or the shipping contact fields.
	`DetailExtPriceTotal`	`decimal`		-
Description:The sum of the goods and the misc. charges amount values.
	`DisableAutomaticDiscountCalculation`	`bit`	Disable Automatic Discount Update	-
Description:A Boolean value that indicates whether the system treats discounts that have already been applied to the selected sales order as manual. If the value is ) for the sales order, the system updates all automatic line, group, and document discounts when users run discount recalculation or add new lines to the order. The default state of this field is the same as the state of the Disable Automatic Discount Update for the applicable order type.
	`DisableAutomaticTaxCalculation` API	`bit`	Disable Automatic Tax Calculation	-
Description:A Boolean value that specifies (if set to ) that the system does not need to calculate taxes, because they are already calculated.
	`DiscDate`	`datetime2`	Cash Discount Date	-
Description:The date when the cash discount is available for the invoice based on the credit terms. This field is not available for transfer orders.
	`DiscTot`	`decimal(19, 4)`	Group and Document Discount Total	-
Description:The total group and document discount of the document, which is calculated as the sum of group and document discounts of the order.
	`DocBal`Nonexistent in DB	`decimal`		-
Description:No description available
	`DocumentDiscTotal`	`decimal(19, 4)`	Document Discount	-
Description:The total document discount of the document, which is calculated as the sum of document discounts of the order. If the Customer Discounts feature is not enabled on the Enable/Disable Features (CS100000) form, a user can enter a document-level discount manually. This manual discount has no discount code or sequence and is not recalculated by the system. If the manual discount needs to be changed, a user has to correct it manually. This field is not available for blanket sales orders.
	`DontApprove`Nonexistent in DB	`bit`	Don't Approve	-
Description:A Boolean value that specifies (if set to ) that the order does not need to be approved.
	`DueDate`	`datetime2`	Due Date	-
Description:The due date of the invoice according to the credit terms. This field is not available for transfer orders.
	`Emailed`	`bit`	Emailed	-
Description:A Boolean value that indicates whether the document has been emailed to the customer.
	`EmployeeID`Nonexistent in DB	`int`		-
Description:The identifier of the business account of the employee of the order's owner.
	`EndorsementService`	`nvarchar(30)`	Endorsement	-
Description:No description available
	`ExpireDate`	`datetime2`	Expires On	-
Description:The expiration date of a blanket sales order. When the date in this field is earlier than the current business date, the system displays a warning message about the expiration of the order, and the order cannot be changed.
	`ExtCarrierPlugIn`Nonexistent in DB	`nvarchar(MAX)`		-
Description:No description available
	`ExtCarrierServiceMethod`Nonexistent in DB	`nvarchar(MAX)`		-
Description:No description available
	`ExternalTaxesImportInProgress`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the taxes were calculated by an external system.
	`ExternalTaxExemptionNumber`	`nvarchar(30)`	Tax Exemption Number	-
Description:No description available
	`ExtRefNbr`	`nvarchar(40)`	Payment Ref.	-
Description:No description available
	`FinPeriodID`Default Navigation	`char(6)`	Post Period	-
Description:The period to post the transactions generated by the invoice.
	`FOBPoint`Default Navigation	`nvarchar(15)`	FOB Point	FOBPoint
Description:The identifier of the point where ownership of the goods is transferred to the customer. The field is included in the FK.FOBPoint foreign key. The value of this field corresponds to the value of the CS.FOBPoint field. This field is available only for blanket sales orders and cannot be empty.
	`ForceCompleteOrder`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the order is completed independently of the openLineCntr. The field is used for drop-ship processing.
	`FreightAmountSource`	`char(1)`	Invoice Freight Price Based On	-
Description:No description available
	`FreightAmt`	`decimal(19, 4)`		-
Description:The freight amount calculated in accordance with the shipping terms from the Shipping Terms field. This field is not available for transfer orders.
	`FreightClass`	`nvarchar(15)`	Freight Class	-
Description:No description available
	`FreightCost`	`decimal(19, 4)`		-
Description:The freight cost calculated for the document. This field is not available for transfer orders.
	`FreightCostIsValid`	`bit`	Freight Cost Is up-to-date	-
Description:A Boolean value that indicates whether the freight rates are up to date. If the value is set to , the sales order has been modified and the rates should be updated.
	`FreightTaxCategoryID`Default Navigation	`nvarchar(15)`	Freight Tax Category	TaxCategory
Description:No description available
	`FreightTot`	`decimal(19, 4)`		-
Description:No description available
	`GoodsExtPriceTotal`	`decimal(19, 4)`		-
Description:The total amount on all lines of the document, except for Misc. Charges, before Line-level discounts are applied. This total is calculated as the sum of the amounts in the Ext. Price for all stock items and non-stock items that require shipment. This total does not include the freight amount. This field is not available for transfer orders. This field is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.
	`GotReadyForArchiveAt`	`datetime`		-
Description:No description available
	`GroundCollect`	`bit`	Ground Collect	-
Description:A Boolean value that indicates whether a user selects to use the FedEx Ground Collect option. This field is available only if the Shipping Carrier Integration feature is enabled on the Enable/Disable Features (CS100000) form, integration with the FedEx carrier is established, and FedEx is selected in the Ship Via field.
	`GroupDiscTotal`	`decimal(19, 4)`	Group Discounts	-
Description:The total group discount of the document, which is calculated as the sum of group discounts of the order.
	`Hold` API	`bit`	Hold	-
Description:A Boolean value that indicates whether the order is on hold. If the order is on hold, additions and changes can be made and order quantities do not affect the item availability.
	`InclCustOpenOrders`	`bit`		-
Description:A Boolean value that indicates whether the sales order totals affect balances of the customer.
	`Insurance`	`bit`	Insurance	-
Description:A Boolean value that indicates whether a user selects to indicate that insurance is required for this order.
	`IntercompanyPONbr`Default Navigation	`nvarchar(15)`	Related Order Nbr.	POOrder
Description:The identifier of the purchase order for which the sales order has been created. The field is included in the FK.IntercompanyPOOrder foreign key. The value of this field corresponds to the value of the POOrder.orderNbr field. This field is available for orders with the Invoice and Sales Orders automation behavior.
	`IntercompanyPOReturnNbr`Default Navigation	`nvarchar(15)`	Related PO Return Nbr.	POReceipt
Description:The link to the purchase return for which the return order has been created. This field is available only for orders with the RMA automation behavior.
	`IntercompanyPOType`	`char(2)`	Related Order Type	-
Description:The identifier of the type of the purchase order for which the sales order has been created. The field is included in the FK.IntercompanyPOOrder foreign key. The value of this field corresponds to the value of the POOrder.orderType field. The field is visible for orders with the Invoice and Sales Orders automation behavior.
	`IntercompanyPOWithEmptyInventory`	`bit`		-
Description:A Boolean value that specifies (if set to ) that isIntercompany is and a child PO.POLine exists for which the following condition is : POLine.inventoryID is and POLine.lineType is not equal to POLineType.Description.
	`InvoiceDate`	`datetime2`	Invoice Date	-
Description:The date of the invoice generated for the order. Date can be entered manually if the Bill Separately field is for the order type. This field is not available for transfer orders.
	`InvoiceNbr`	`nvarchar(15)`	Invoice Nbr.	SOInvoice
Description:The reference number of the original invoice (which lists the goods that were ordered and later returned by the customer). The field is included in the FK.Invoice foreign key. The value of this field corresponds to the value of the SOInvoice.refNbr field. This field is available for orders of the CR, RC, RR, and RM types.
	`IsCashSaleOrder`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the order has a related cash invoice.
	`IsCreditMemoOrder`Nonexistent in DB	`bit`		-
Description:No description available
	`IsDebitMemoOrder`Nonexistent in DB	`bit`		-
Description:No description available
	`IsExpired`	`bit`		-
Description:A Boolean value that indicates whether the order is expired.
	`IsFreightAvailable`Nonexistent in DB	`bit`		-
Description:No description available
	`IsFullyPaid`Nonexistent in DB	`bit`		-
Description:No description available
	`IsIntercompany`Nonexistent in DB	`bit`		-
Description:No description available
	`IsInvoiceOrder`Nonexistent in DB	`bit`		-
Description:No description available
	`IsLegacyMiscBilling`	`bit`		-
Description:A boolean value that indicates (if set to ) that separate invoicing is allowed for the lines where SOLine.lineType equals to SOLineType.miscCharge.
	`IsManualPackage`	`bit`	Manual Packaging	-
Description:A Boolean value that indicates whether the system prevents automatic recalculation of packages on any changes to the order or on automatic creation of shipments. If field value is , the packages will not be automatically recalculated to further optimize the cost even if the order is included in a consolidated shipment. This field is available only if the Automatic Packaging feature is enabled on the Enable/Disable Features (CS100000) form.
	`IsManualTaxesValid`	`bit`	Tax Is Up to Date	-
Description:A Boolean value that specifies (if set to ) that disableAutomaticTaxCalculation is and a user changed the order. In this case, a warning is displayed.
	`IsMixedOrder`Nonexistent in DB	`bit`		-
Description:No description available
	`IsNoAROrder`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the order does not have an invoice.
	`IsOpenTaxValid`	`bit`		-
Description:A Boolean value that indicates whether the system needs to update unshipped taxes after saving the order.
	`IsOrchestrationAllowed`Nonexistent in DB	`bit`		-
Description:No description available
	`IsPackageValid`	`bit`		-
Description:A Boolean value that indicates whether the packages of the orders are calculated correct.
	`IsPaymentInfoEnabled`Nonexistent in DB	`bit`		-
Description:No description available
	`IsPriceAndDiscountsValid`Nonexistent in DB	`bit`	Prices and discounts are up to date.	-
Description:A Boolean value that indicates whether the system needs to update prices and discounts after saving the order.
	`IsRMAOrder`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the order has the RMA behavior.
	`IsTaxValid` API	`bit`	Tax Is Up to Date	-
Description:A Boolean value that indicates whether the system needs to update taxes after saving the order.
	`IsTransferOrder`Nonexistent in DB	`bit`		-
Description:No description available
	`IsUnbilledTaxValid`	`bit`		-
Description:A Boolean value that indicates whether the system needs to update unbilled taxes after saving the order.
	`IsUserInvoiceNumbering`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the order type is Manual Invoice Numbering.
	`KeepOrchestrationStatus`Nonexistent in DB	`bit`		-
Description:No description available
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified On	-
Description:No description available
	`LastShipDate`	`datetime2`	Last Shipment Date	-
Description:The date of the last confirmed shipment.
	`LastSiteID`	`int`	Last Shipment Site	INSite
Description:The identifier of the warehouse of the last confirmed shipment. The field is included in the FK.LastSite foreign key. The value of this field corresponds to the value of the INSite.siteID field.
	`LimitWarehouse`	`bit`	Limit Number of Fulfillment Warehouses	-
Description:No description available
	`LineCntr`	`int`		-
Description:The counter of the child lines added to the order.
	`LineDiscTotal`	`decimal(19, 4)`	Line Discounts	-
Description:The total line discount of the document, which is calculated as the sum of line discounts of the order.
	`LineTotal`	`decimal(19, 4)`		-
Description:The total amount on all lines of the document, except for Misc. Charges, after Line-level discounts are applied. This total is calculated as the sum of the amounts in the Amount for all stock items and non-stock items that require shipment. This total does not include the freight amount. This field is not available for transfer orders. This field is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.
	`ManDisc`Obsolete	`decimal(19, 4)`		-
Description:No description available
	`MarginAmt`	`decimal(19, 4)`		-
Description:The order's estimated margin amount. The value is not available for the transfer order.
	`MarginPct`	`decimal(19, 2)`	Est. Margin (%)	-
Description:The order's estimated margin percent. The value is not available for the transfer order.
	`MinSchedOrderDate`	`datetime2`	Sched. Order Date	-
Description:The date on which a child order should be generated for the line of the blanket sales order. This field is available only for blanket sales orders.
	`MiscExtPriceTotal`	`decimal(19, 4)`		-
Description:The total amount calculated as the sum of the amounts in Ext. Price of the order non-stock items. This field is not available for transfer orders.
	`MiscTot`	`decimal(19, 4)`		-
Description:The total amount calculated as the sum of the amounts in Amount of the order non-stock items. This field is not available for transfer orders.
	`NetSalesTotal`	`decimal(19, 4)`		-
Description:The sum of the line amounts without the taxes and with the applied group and document discounts.
	`NoMarginLineCntr`	`int`		-
Description:The number of detail lines with the empty margin. Such lines are not considered in the order margin calculation.
	`NoteID` API	`uniqueidentifier`		-
Description:No description available
	`NumberOfWarehouses`	`int`	Number of Fulfillment Warehouses	-
Description:No description available
	`OpenDiscTotal`	`decimal(19, 4)`		-
Description:The discount total of open lines, which is calculated as a sum of values for each line. The value for each line is calculated as the line open amount multiplied by the difference between SOLine4.groupDiscountRate and SOLine4.documentDiscountRate. The negative value is used for the line open amount if SOLine4.operation is not equal to SOOrder.defaultOperation.
	`OpenDoc`	`bit`		-
Description:A Boolean value that indicates whether the order has unbilled amount.
	`OpenLineCntr`	`int`		-
Description:The counter of open lines added to the order.
	`OpenLineTotal`	`decimal(19, 4)`		-
Description:The sum of child line open amounts. When SOLine4.operation is not equal SOOrder.defaultOperation, the line open amounts are with negative values.
	`OpenOrderQty`	`decimal(25, 6)`	Unshipped Quantity	-
Description:The quantity of the stock items not yet shipped according to the sales order. The unshipped quantity for each line is specified in SOLine.openQty. This field is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.
	`OpenOrderTotal`	`decimal(19, 4)`		-
Description:The sum of unshipped amounts calculated for the lines with nonzero unshipped quantities of stock items. The unshipped amount for each line is calculated as the amount in the Ext. Price field (after Line-level discounts were applied) divided by the line quantity (the Qty. field) and multiplied by the unshipped quantity (the Open Qty. field). At the moment of order creation when no item quantities are shipped, the amount is equal to the Line Total; this total does not include any freight amount. This field is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.
	`OpenShipmentCntr`	`int`		-
Description:The counter of unconfirmed shipments added to the order.
	`OpenSiteCntr`	`int`		-
Description:The number of warehouses without shipments of the order.
	`OpenTaxTotal`	`decimal(19, 4)`		-
Description:The sum of tax amounts of child transactions.
	`OrchestrationStatus`	`char(2)`	Orchestration Status	-
Description:No description available
	`OrchestrationStrategy`	`char(2)`	Fulfillment Strategy	-
Description:No description available
	`OrderCosts`	`decimal(19, 4)`		-
Description:The sum of the extended costs of the detail lines and the freight cost (in the currency of the document).
	`OrderDate`	`datetime2`	Date	-
Description:The date of the document.
	`OrderDesc`	`nvarchar(256)`	Description	-
Description:A brief description of the document.
	`OrderDiscTotal`	`decimal`	Discount Total	-
Description:The total discount of the document, which is calculated as the sum of group, document and line discounts of the order. This field is not available for blanket sales orders.
	`OrderNetSales`	`decimal(19, 4)`		-
Description:The sum of the line amounts without the taxes and with the applied group and document discounts and the taxable freight amount.
	`OrderQty`	`decimal(25, 6)`	Ordered Qty.	-
Description:The summarized quantity of all items that have been added to the child order from the blanket sales order. If any items that are not from the current blanket sales order have been added to the child order, their quantity is not summed up to the value in this field.
	`OrderTaxAllocated`	`bit`		-
Description:A Boolean value that indicates (if set to ) that order taxes are fully allocated to the invoice.
	`OrderTotal` API	`decimal(19, 4)`		-
Description:The total amount of the document.
	`OrderVolume`	`decimal(25, 6)`	Order Volume	-
Description:The total volume of goods according to the document.
	`OrderWeight`	`decimal(25, 6)`	Order Weight	-
Description:The total weight of the goods according to the document.
	`OrigOrderNbr`Default Navigation	`nvarchar(15)`	Orig. Order Nbr.	SOOrder
Description:The identifier of the reference number of the original sales order. The field is included in the FK.OriginalOrder foreign key. The value of this field corresponds to the value of the SOOrder.orderNbr field. The field is used only for returns.
	`OrigOrderType`	`char(2)`	Orig. Order Type	SOOrderType
Description:The identifier of the type of the original order. The field is included in the foreign keys FK.OriginalOrderType and FK.OriginalOrder. The value of this field corresponds to the value of the SOOrderType.orderType field. The value of this field corresponds to the value of the SOOrder.orderType field. The field is used only for returns.
	`OverrideFreightAmount`	`bit`	Override Freight Price	-
Description:A Boolean value that indicates whether the Freight Price can be changed manually. The system will preserve the manually entered Freight Price value in the sales order and will not recalculate the value if the quantity, extended price, or amount is modified in order lines.
	`OverridePrepayment`	`bit`	Override Prepayment	-
Description:A Boolean value that specifies (if set to ) that fields Prepayment Percent and Prepayment Amount will have a higher priority than the predefined values that has been specified for the credit terms of the customer. This field is available for sales orders with the Sales Orders automation behavior when the Prepayment Required field of the customer is .
	`OverrideTaxZone`	`bit`	Override Tax Zone	-
Description:A Boolean value that specifies (if set to ) that the specified customer tax zone will not be overridden if any location-related information is changed for the sales order.
	`OwnerID`Default Navigation	`int`	Owner	Contact
Description:No description available
	`PackageLineCntr`	`int`		-
Description:The counter of child package lines added to the order.
	`PackageWeight`	`decimal(25, 6)`	Package Weight	-
Description:The total (gross) weight of the packages for this sales order, including the weight of the boxes used for packages.
	`PaidAmt`	`decimal(19, 4)`		-
Description:The sum of all released payments that have been applied to the sales order.
	`PayLinkID`	`int`		-
Description:No description available
	`PaymentCntr`	`int`		-
Description:The counter of the shipments added to the order that have a payment.
	`PaymentMethodID`Default Navigation	`nvarchar(10)`	Payment Method	PaymentMethod
Description:No description available
	`PaymentOverall`	`decimal(19, 4)`		-
Description:The sum of SOAdjust.curyAdjdAmt and SOAdjust.curyAdjdBilledAmt of all order's payments for which the following condition is : SOAdjust.voided is or SOAdjust.isCCPayment is or SOAdjust.isCCAuthorized is or SOAdjust.isCCCaptured is or SOAdjust.paymentReleased is . The field is used to calculate prepaymentReqSatisfied.
	`PaymentsNeedValidationCntr`	`int`		-
Description:The counter of payments added to the order for which the following condition is : SOAdjust.isCCPayment is , SOAdjust.syncLock is , SOAdjust.syncLockReason is not equal to syncLockReason.newCard, and SOAdjust.curyAdjdAmt is not equal to 0.
	`PaymentTotal`	`decimal(19, 4)`		-
Description:The total amount that has been paid for this sales order. This field is not available for transfer orders.
	`PMInstanceID`Default Navigation	`int`	Card/Account Nbr.	CustomerPaymentMethod
Description:No description available
	`PremiumFreightAmt`	`decimal(19, 4)`		-
Description:Any additional freight charges for handling the order. This field is not available for transfer orders. To correct the excessive freight charges in a previous order of the customer, premium freight amount can be manually adjusted.
	`PrepaymentReqAmt`	`decimal(19, 4)`		-
Description:The amount of funds the customer has to pay before the user can proceed to shipping and preparing an invoice for the sales order. If the Prepayment Percent changed, than this amount is updated automatically, and if this value changed, the system automatically updates the Prepayment Percent to the appropriate percent based on the amount. This field is available when the Prepayment Required field is and becomes available only for sales orders with the Sales Orders automation behavior when the Override Prepayment field is .
	`PrepaymentReqPct`	`decimal(9, 6)`	Prepayment Percent	-
Description:No description available
	`PrepaymentReqPctToRestore`	`decimal(9, 6)`		-
Description:The value that the Prepayment Percent field had before the Prepayment Percent was automatically reset to zero.
	`PrepaymentReqSatisfied`	`bit`	Prepayment Requirements Satisfied	-
Description:No description available
	`Printed`	`bit`	Printed	-
Description:A Boolean value that indicates whether the document has been printed.
	`Priority`	`smallint`	Priority	-
Description:The level of priority for processing orders of this customer, as specified Location.cOrderPriority field for the customer.
	`ProcessingCenterID`Default Navigation	`nvarchar(10)`	Processing Center	-
Description:No description available
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:The identifier of the project. The field is included in the FK.Project foreign key. The value of this field corresponds to the value of the PMProject.contractID field. The value specifies the project with which this sales order is associated or the non-project code, which indicates that this order is not associated with any project. The non-project code is specified on the Projects Preferences (PM101000) form. This field is available only if the Project Accounting feature is enabled on the Enable/Disable Features (CS100000) form and the integration of the Projects submodule with Sales Orders has been enabled (that is, PMSetup.visibleInSO is .
	`QtyOnOrders`	`decimal(25, 6)`	Qty. on Child Orders	-
Description:The quantity of the stock and non-stock items in a blanket sales order distributed among child orders.
	`Rejected`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the order was rejected by one of the persons assigned to approve it. This status is available for orders of the SO, SA, CM, CS, TR, QT, and IN order types only if the Approval Workflowfeature is enabled on the Enable/Disable Features (CS100000) form.
	`ReleasedCntr`	`int`		-
Description:The counter of the shipments added to the order that have a released invoice.
	`RequestDate`	`datetime2`	Requested On	-
Description:The date when the customer wants to receive the goods. The default value is the current business date. This date provides the default values for the SOLine.requestDate dates for order lines.
	`Resedential`	`bit`	Residential Delivery	-
Description:A Boolean value that indicates whether the shipment should be delivered to a residential area.
	`RiskLineCntr`	`int`		-
Description:The number of risks of the order.
	`SalesCostTotal`	`decimal(19, 4)`		-
Description:The sum of the extended costs of the detail lines for which the margin is not empty. The line's extended cost is used with the negative sign for the receipt lines.
	`SalesPersonID`Default Navigation	`int`	Default Salesperson	SalesPerson
Description:The identifier of the salesperson to be used by default for each sales order line. The field is included in the FK.SalesPerson foreign key. The value of this field corresponds to the value of the SalesPerson.salesPersonID field.
	`SaturdayDelivery`	`bit`	Saturday Delivery	-
Description:A Boolean value that indicates whether the order may be delivered on Saturday.
	`Selected`Nonexistent in DB	`bit`	Selected	-
Description:A Boolean value that indicates (if set to ) that the record is selected for processing by a user.
	`ShipAddressID`	`int`		SOAddress
Description:No description available
	`ShipComplete`	`char(1)`	Shipping Rule	-
Description:An option that controls whether incomplete and partial shipments for the order are allowed. The field can have one of the following values: - SOShipComplete.shipComplete: The first shipment for the order should include all lines of the order. - SOShipComplete.backOrderAllowed: The first shipment for the order should include at least one order line. - SOShipComplete.cancelRemainder: The first shipment for the order should include at least one order line. This field is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form. form.
	`ShipContactID`	`int`		SOContact
Description:No description available
	`ShipDate`	`datetime2`	Sched. Shipment	-
Description:The date when the ordered goods are scheduled to be shipped. By default, it is the date that is specified in requestDate minus the number of lead days, but it is not earlier than the current business date.
	`ShipmentCntr`	`int`		-
Description:The counter of order-shipment relations added to the order.
	`ShipmentDeleted`Nonexistent in DBObsolete	`bit`		-
Description:No description available
	`ShipSeparately`	`bit`	Ship Separately	-
Description:A Boolean value that indicates whether the goods for the customer should be shipped separately for each sales order. This field is available only if the Inventory feature is enabled on the Enable/Disable Features (CS100000) form.
	`ShipTermsID`Default Navigation	`nvarchar(10)`	Shipping Terms	ShipTerms
Description:The identifier of the shipping terms used for this customer. The field is included in the FK.ShipTerms foreign key. The value of this field corresponds to the value of the ShipTerms.shipTermsID field.
	`ShipVia` API Default Navigation	`nvarchar(15)`	Ship Via	Carrier
Description:The identifier of the ship via code that represents the carrier and its service to be used for shipping the ordered goods. The field is included in the FK.Carrier foreign key. The value of this field corresponds to the value of the Carrier.carrierID field. For this ship via code, if Manual is specified as the freight calculation method, the freight amount must be specified in the Freight Price field. Changing the Ship Via code for an open sales order may update the customer tax zone field.
	`ShipZoneID`Default Navigation	`nvarchar(15)`	Shipping Zone	ShippingZone
Description:The identifier of the shipping zone of the customer to be used to calculate freight. The field is included in the FK.ShippingZone foreign key. The value of this field corresponds to the value of the ShippingZone.zoneID field.
	`ShowDiscountsTab`Nonexistent in DB	`bit`	ShowDiscountsTab	-
Description:A Boolean value that indicates whether the Discounts tab is shown on the Sales Orders (SO301000) form.
	`ShowOrdersTab`Nonexistent in DB	`bit`	ShowOrdersTab	-
Description:A Boolean value that indicates whether the Child Orders tab is shown on the Sales Orders (SO301000).
	`ShowShipmentsTab`Nonexistent in DB	`bit`	ShowShipmentsTab	-
Description:A Boolean value that indicates whether the Shipments tab is shown on the Sales Orders (SO301000) form.
	`SiteCntr`	`int`		-
Description:The counter of warehouses for all shipments of the order.
	`SpecialLineCntr`	`int`		-
Description:The counter of the special-ordered child lines. Corresponds to SOLine.isSpecialOrder.
	`Status` API	`char(1)`	Status	-
Description:The status of the order. The field can have one of the values listed in SOOrderStatus.
	`SuggestRelatedItems`Nonexistent in DB	`bit`		-
Description:A Boolean value that indicates whether the related items can be suggested for the order.
	`TaxableFreightAmt`	`decimal(19, 4)`		-
Description:The sum of freight amount and additional freight charges that are subject to taxes.
	`TaxCalcMode` API	`char(1)`	Tax Calculation Mode	-
Description:No description available
	`TaxTotal` API	`decimal(19, 4)`		-
Description:The total amount of tax paid on the document.
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Customer Tax Zone	TaxZone
Description:The identifier of the tax zone to be used to process customer sales orders. The field is included in the FK.TaxZone foreign key. The value of this field corresponds to the value of the TaxZone.taxZoneID field.
	`TermsDiscAmt`Nonexistent in DB	`decimal`		-
Description:The discount amount of the prompt payment.
	`TermsID`Default Navigation	`nvarchar(10)`	Terms	Terms
Description:The identifier of the credit terms used in relations with the customer. The field is included in the FK.Terms foreign key. The value of this field corresponds to the value of the Terms.termsID field. This field is not available for transfer orders.
	`TransferredToChildrenPaymentTotal`	`decimal(19, 4)`		-
Description:The sum of amounts of the payments or prepayments that have been applied to the child orders generated for the blanket order.
	`tstamp`	`timestamp`		-
Description:No description available
	`UnbilledDiscTotal`	`decimal(19, 4)`		-
Description:The discount total for unbilled lines.
	`UnbilledFreightTot`	`decimal(19, 4)`		-
Description:The unbilled part of the sales order freight total in the base currency.
	`UnbilledLineTotal`	`decimal(19, 4)`		-
Description:The sum of unbilled amount of child lines for which the following condition is : BlanketSOLine.lineType is not equal to SOLineType.miscCharge.
	`UnbilledMiscTot`	`decimal(19, 4)`		-
Description:The sum of unbilled amounts of child lines for which the following condition is : BlanketSOLine.lineType is equal to SOLineType.miscCharge.
	`UnbilledOrderQty`	`decimal(25, 6)`	Unbilled Quantity	-
Description:The quantity of stock and non-stock items that were not yet billed. This field is not available for transfer orders.
	`UnbilledOrderTotal`	`decimal(19, 4)`		-
Description:The unbilled balance of the sales order, which is calculated as the sum of the unbilled line amounts. The value is calculated as the sum of the unbilled line amounts, unbilled amount of the freight price and premium freight price, and the unbilled amount of all taxes, minus all line, group, and document discounts of the order. This field is not available for transfer orders.
	`UnbilledTaxTotal`	`decimal(19, 4)`		-
Description:The total amount of tax paid on the unbilled part of the document.
	`UnpaidBalance`	`decimal(19, 4)`		-
Description:The unpaid amount of the order. Once an invoice for the unpaid amount of the order is generated, the unpaid amount becomes 0.
	`UnrefundedBalance`	`decimal(19, 4)`		-
Description:No description available
	`UnreleasedPaymentAmt`	`decimal(19, 4)`		-
Description:The sum of the payments that have been applied to the sales order and that have not been released yet.
	`UpdateNextNumber`Nonexistent in DB	`bit`	Update Next Number	-
Description:A part of the reference number of the payment. The field is used by the SOOrderPaymentRef attribute.
	`UseCustomerAccount`	`bit`	Use Customer's Account	-
Description:A Boolean value that specifies (if set to ) that the customer account with the carrier should be billed for the shipping of this order. This field is available only if the Shipping Carrier Integration feature is enabled on the Enable/Disable Features (CS100000) form.
	`VatExemptTotal` API	`decimal(19, 4)`		-
Description:The document total that is exempt from VAT. This total is calculated as the taxable amount for the tax with the Include in VAT Exempt Total field is . This field is available only if the VAT Reporting feature is enabled on the Enable/Disable Features (CS100000) form.
	`VatTaxableTotal` API	`decimal(19, 4)`		-
Description:The document total that is subject to VAT. This field is available only if the Include in VAT Exempt Total field is . If the document contains multiple transactions with different taxes applied and for each of the applied taxes Include in VAT Exempt Total field is , the taxable amount calculated for each line of the document is added to this field. This field is available only if the VAT Reporting feature is enabled on the Enable/Disable Features (CS100000) form.
	`WillCall` API Nonexistent in DB	`bit`	Will Call	-
Description:A Boolean value that indicates whether the customer picks the goods from the warehouse (will call). If the value is , the common carrier is to be used for shipping goods. If shipVia is , the value of this field is . If shipVia is not , the value of this field directly corresponds to the state of the Common Carrier field for the selected ship via code.
	`WorkgroupID`Default Navigation	`int`	Workgroup	EPCompanyTree
Description:The identifier of the workgroup responsible for the sales order. The field is included in the FK.Workgroup foreign key. The value of this field corresponds to the value of the EPCompanyTree.workGroupID field.