SO
SOOrder
Represents sales order and transfer order documents.
View API Entity: SalesOrder
/entity/Default/25.200.001/SalesOrder| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMCuryEstimateTotal | decimal | Estimate Total | - | |
Description:No description available | ||||
AMEstimateQty | decimal | Estimate Qty | - | |
Description:No description available | ||||
AMEstimateTotal | decimal | Estimate Total | - | |
Description:No description available | ||||
AMUseConfigPriceNonexistent in DB | bool? | Use Config Price | - | |
Description:If the order is being updated that triggers the update of all sales line prices, we need to know so we can override and get the config line prices | ||||
ARDocTypeNonexistent in DB | string | SOInvoice | ||
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. | ||||
ActiveOperationsCntrNonexistent in DB | int? | - | ||
Description:The number of active operations (which can be an issue or receipt) of the order type. | ||||
AllowModifyingItemsNonexistent in DB | bool? | - | ||
Description:Indicates if this item is allowed to be modified. | ||||
AllowsRequiredPrepaymentNonexistent in DB | bool? | - | ||
Description:If true, the Prepayment Required functionality works in the current Sales Order | ||||
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 | - | ||
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. | ||||
ArePaymentsApplicableNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order does not have the transfer behavior and has a related cash invoice. | ||||
AssignedEmpID | int | Assigned to | BAccountStaffMember | |
Description:No description available | ||||
AuthorizedPaymentCntr | int | - | ||
Description:The counter of the applied payments in pre-authorized state. | ||||
AvalaraCustomerUsageType | char(1) | Tax Exemption Type | - | |
Description:The entity usage type of the customer location if sales to this location are tax-exempt. By default, the system copies the value of this field from the customer record. This field is available only if the External Tax Calculation Integration feature is enabled on the Enable/Disable Features (CS100000) form. This field is not available for transfer orders. | ||||
BackOrderedNonexistent in DB | bool? | 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 | SOBillingAddress | ||
Description:The identifier of the billing address. The field is included in the FK.BillingAddress foreign key. The value of this field corresponds to the value of the SOAddress.addressID field. | ||||
BillContactID | int | SOBillingContact | ||
Description:The identifier of the billing contact. The field is included in the FK.BillingContact foreign key. The value of this field corresponds to the value of the SOBillingContact.contactID field. | ||||
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. | ||||
BilledCntr | int | - | ||
Description:The counter of the shipments added to the order that have an invoice. | ||||
BilledFreightTot | decimal | - | ||
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 | - | ||
Description:The sum of amounts of the payments or prepayments that have been applied to the AR invoice generated for the order. | ||||
BlanketLineCntr | int | - | ||
Description:The counter of the sales order detail lines added to the parent blanket order. | ||||
BlanketOpenQty | decimal | 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 SOAdjust lines added to the current order and having blanket reference. | ||||
BranchBaseCuryIDNonexistent in DB | string | Base Currency | - | |
Description:No description available | ||||
BranchID API | int | Branch | Branch | |
Description:The identifier of the branch. The field is included in the FK.Branch foreign key. The value of this field corresponds to the value of the Branch.branchID field. | ||||
CCAuthorizedAmt | decimal | - | ||
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. | ||||
CancelDate | datetime | 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 true) that the order has been canceled on the date specified in CancelDate. | ||||
CashAccountID API | int | Cash Account | Account | |
Description:The identifier of the cash account associated with the customer payment method. The field is included in the FK.CashAccount foreign key. The value of this field corresponds to the value of the Account.accountID field. By default, the value is filled in with the cash account specified as the default for the selected method. | ||||
ChildLineCntr | int | - | ||
Description:The counter of the sales order details added to child orders. | ||||
CommentNonexistent in DB | string | Comment | - | |
Description:No description available | ||||
CommnPct | decimal | - | ||
Description:No description available | ||||
Completed | bit | Completed | - | |
Description:A Boolean value that specifies (if set to true) 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 | 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 | decimal | - | ||
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 true. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByIDForFilterNonexistent in DB | Guid? | - | ||
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime API | datetime | Created On | - | |
Description:No description available | ||||
CreditHold API | bit | Credit Hold | - | |
Description:A Boolean value that specifies (if set to true) 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 true for the order type. This status is available for orders of the QT, SO, SA, IN, and CM order types. | ||||
CuryBilledFreightTot | decimal | - | ||
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 | 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 | 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 API | decimal | Control Total | - | |
Description:The control total of the document (in the currency of the document). A user enters this amount manually. | ||||
CuryDetailExtPriceTotalNonexistent in DB | decimal? | Detail Total | - | |
Description:The sum of the goods and the misc. charges amount values. | ||||
CuryDiscTot | decimal | 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. | ||||
CuryDocBalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
CuryDocumentDiscTotal | decimal | 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 | Freight Price | - | |
Description:The freight amount calculated in accordance with the shipping terms (in the currency of the document). | ||||
CuryFreightCost | decimal | Freight Cost | - | |
Description:The freight cost calculated for the document (in the currency of the document). | ||||
CuryFreightTot | decimal | Freight Total | - | |
Description:The sum of the additional freight charges and the freight amount values. | ||||
CuryGoodsExtPriceTotal | decimal | 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 | 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 API | 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 | 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 | 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). | ||||
CuryManDiscObsolete | decimal | Manual Total | - | |
Description:No description available | ||||
CuryMarginAmt | decimal | 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 | 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 | 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 | - | ||
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 | - | ||
Description:The discount total of open lines (in the currency of the document). | ||||
CuryOpenLineTotal | decimal | Unshipped Line Total | - | |
Description:The sum of line open amount (in the currency of the document). | ||||
CuryOpenOrderTotal | decimal | 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 | Unshipped Tax Total | - | |
Description:The sum of tax amounts of child transactions (in the currency of the document). | ||||
CuryOrderCosts | decimal | - | ||
Description:The sum of the extended costs of the detail lines and the freight cost (in the currency of the document). | ||||
CuryOrderDiscTotalNonexistent in DB | 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 | - | ||
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 API | decimal | Order Total | - | |
Description:The total amount of the document (in the currency of the document). | ||||
CuryPaidAmt | decimal | Released | - | |
Description:The sum of all released payments that have been applied to the sales order (in the currency of the document). | ||||
CuryPaymentOverall | decimal | - | ||
Description:The sum of amounts of child payments (in the currency of the document). | ||||
CuryPaymentTotal | decimal | Total Paid | - | |
Description:The total amount that has been paid for this sales order (in the currency of the document). | ||||
CuryPremiumFreightAmt | decimal | Premium Freight Price | - | |
Description:Any additional freight charges for handling the order (in the currency of the document). | ||||
CuryPrepaymentReqAmt | decimal | Prepayment Amount | - | |
Description:The amount of funds (in the currency of the document) the customer has to pay before the user can proceed to shipping and preparing an invoice for the sales order. | ||||
CurySalesCostTotal | decimal | - | ||
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. | ||||
CuryTaxTotal API | decimal | Tax Total | - | |
Description:The total amount of tax paid on the document (in the currency of the document). | ||||
CuryTaxableFreightAmt | decimal | - | ||
Description:The sum of freight amount and additional freight charges that are subject to taxes (in the currency of the document). | ||||
CuryTermsDiscAmtNonexistent in DB | decimal? | - | ||
Description:The discount amount of the prompt payment (in the currency of the document). | ||||
CuryTransferredToChildrenPaymentTotal | decimal | 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 | - | ||
Description:The discount total for unbilled lines (in the currency of the document). | ||||
CuryUnbilledFreightTot | decimal | - | ||
Description:The unbilled part of the sales order freight total in the document currency. | ||||
CuryUnbilledLineTotal | decimal | Unbilled Line Total | - | |
Description:The sum of unbilled amounts of child lines (in the currency of the document). | ||||
CuryUnbilledMiscTot | decimal | Unbilled Misc. Total | - | |
Description:The sum of unbilled amounts of child lines (in the currency of the document). | ||||
CuryUnbilledOrderTotal | decimal | 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 | 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 | Unpaid Balance | - | |
Description:The unpaid amount of the order (in the currency of the document). | ||||
CuryUnrefundedBalance | decimal | Unrefunded Balance | - | |
Description:No description available | ||||
CuryUnreleasedPaymentAmt | decimal | 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 API | decimal | Tax Exempt Total | - | |
Description:The document total that is exempt from VAT (in the currency of the document). | ||||
CuryVatTaxableTotal API | decimal | Taxable Total | - | |
Description:The document total that is subject to VAT (in the currency of the document). | ||||
CustomerID API | int | Customer | Customer | |
Description:The identifier of the customer. The field is a part of the identifier of the customer location. The field is included in the foreign keys FK.Customer and FK.CustomerLocation. For a customer, the value of this field corresponds to the value of the Customer.bAccountID field. For a customer location, the value of this field corresponds to the value of the Location.bAccountID field. | ||||
CustomerLocationID API | int | Location | Location | |
Description:The identifier of the customer location. The field is included in the FK.CustomerLocation foreign key. The value of this field corresponds to the value of the Location.locationID field. | ||||
CustomerLocationIDListNonexistent in DB | int? | - | ||
Description:Contains list of available customer locations | ||||
CustomerOrderNbr API | 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 true for the order type. This field is available for orders of the TR type. | ||||
CustomerRefNbr API | 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. | ||||
DefaultOperationNonexistent in DB | string | SOOrderTypeOperation | ||
Description:The default operation (which can be an issue or receipt) of the order type. | ||||
DefaultSiteID API | 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. | ||||
DefaultTranTypeNonexistent in DB | string | - | ||
Description:The default transfer type. The value is the order type of the order if the order type is Inventory Transaction Type. | ||||
DeferPriceDiscountRecalculationNonexistent in DB | bool? | 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 false, 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:Payment Link delivery method (N - none, E - email). | ||||
DestinationSiteID API | 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. | ||||
DestinationSiteIdErrorMessageNonexistent in DB | string | - | ||
Description:The error message that is raised because of the setting of the shipping address or the shipping contact fields. | ||||
DetailExtPriceTotalNonexistent in DB | decimal? | - | ||
Description:The sum of the goods and the misc. charges amount values. | ||||
DisableAutomaticDiscountCalculation API | 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 false) 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 true) that the system does not need to calculate taxes, because they are already calculated. | ||||
DiscDate | datetime | 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 | 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. | ||||
DocBalNonexistent in DB | decimal? | - | ||
Description:No description available | ||||
DocumentDiscTotal | decimal | 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. | ||||
DontApproveNonexistent in DB | bool? | Don't Approve | - | |
Description:A Boolean value that specifies (if set to true) that the order does not need to be approved. | ||||
DueDate | datetime | 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. | ||||
EmployeeIDNonexistent 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 | datetime | 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. | ||||
ExtCarrierPlugInNonexistent in DB | string | - | ||
Description:No description available | ||||
ExtCarrierServiceMethodNonexistent in DB | string | - | ||
Description:No description available | ||||
ExtRefNbr API | nvarchar(40) | Payment Ref. | - | |
Description:The reference number of the payment. This field is available only for sales orders of the Cash Sales or Cash Return type. | ||||
ExternalOrderExportedNonexistent in DB | bool? | - | ||
Description:Indicates if this order has been exported. | ||||
ExternalOrderOrigin API | int | External Order Origin | BCBinding | |
Description:The external ID of the original order. | ||||
ExternalOrderOriginal API | bit | External Order Original | - | |
Description:Indicates whether original order is external. | ||||
ExternalOrderSource API | nvarchar(30) | External Order Source | - | |
Description:The name of the external source for this order. | ||||
ExternalQuoteNbr | nvarchar(20) | External Quote Nbr. | - | |
Description:Indicates External draft order number | ||||
ExternalQuoteStatus | nvarchar(20) | External Quote Status | - | |
Description:Indicates External draft order status | ||||
ExternalRefundRef API | nvarchar(50) | - | ||
Description:The external ID of any refund for this order. | ||||
ExternalTaxExemptionNumber | nvarchar(30) | Tax Exemption Number | - | |
Description:The tax exemption number for reporting purposes. The field is used if the system is integrated with External Tax Calculation and the External Tax Calculation Integration feature is enabled on the Enable/Disable Features (CS100000) form. | ||||
bool? | - | |||
Description:A Boolean value that indicates whether the taxes were calculated by an external system. | ||||
FOBPoint | 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. | ||||
FinPeriodID | string | Post Period | FinPeriod | |
Description:The period to post the transactions generated by the invoice. | ||||
ForceCompleteOrderNonexistent in DB | bool? | - | ||
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:The document from which the system extracts data to calculate the freight price in the sales order invoice created for the current sales order. The field can have one of the values listed in FreightAmountSourceAttribute. The default value is FreightAmountSourceAttribute.shipmentBased. If the shipping terms are selected in the Shipping Terms field, the system fills in this field automatically, based on the value of the Invoice Freight Price Based On. | ||||
FreightAmt | decimal | - | ||
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 | - | ||
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 false, the sales order has been modified and the rates should be updated. | ||||
FreightTaxCategoryID | nvarchar(15) | Freight Tax Category | TaxCategory | |
Description:The identifier of the tax category that applies to the total freight amount. The field is included in the FK.FreightTaxCategory foreign key. The value of this field corresponds to the value of the TaxCategory.taxCategoryID field. The default value is the tax category associated with the ship via code ship via code of the order. This field is not available for transfer orders. | ||||
FreightTot | decimal | - | ||
Description:No description available | ||||
GoodsExtPriceTotal | decimal | - | ||
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 | 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. | ||||
Installed | bit | Installed | - | |
Description:No description available | ||||
Insurance | bit | Insurance | - | |
Description:A Boolean value that indicates whether a user selects to indicate that insurance is required for this order. | ||||
IntercompanyPONbr | 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 | 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 | POOrder | |
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 true) that isIntercompany is true and a child PO.POLine exists for which the following condition is true: POLine.inventoryID is null and POLine.lineType is not equal to POLineType.Description. | ||||
InvoiceDate | datetime | Invoice Date | - | |
Description:The date of the invoice generated for the order. Date can be entered manually if the Bill Separately field is true 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. | ||||
IsCashSaleOrderNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order has a related cash invoice. | ||||
IsCreditMemoOrderNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order has a related credit memo. | ||||
IsDebitMemoOrderNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order has a related debit memo. | ||||
IsEnabledCancelOrderNonexistent in DB | bool? | Is Enabled Cancel Order | - | |
Description:No description available | ||||
IsExpired | bit | - | ||
Description:A Boolean value that indicates whether the order is expired. | ||||
IsFSIntegratedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsFreightAvailableNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order does not have the transfer behavior. | ||||
IsFullyPaidNonexistent in DB | bool? | - | ||
Description:A Boolean value that specifies (if set to true) that curyPaymentOverall is greater than 0 and curyPaymentOverall is greater than or equal to sum of curyUnbilledOrderTotal and curyBilledPaymentTotal. | ||||
IsIntercompanyNonexistent in DB | bool? | - | ||
Description:A Boolean value that specifies (if set to true) that the following condition is true: behavior is one of SOBehavior.sO, SOBehavior.iN, SOBehavior.rM, or SOBehavior.cM, BAccount.isBranch that is related to customerID is equal to true, and defaultTranType is not equal to INTranType.transfer. | ||||
IsInvoiceOrderNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order is used only for an invoice. | ||||
IsLegacyMiscBilling | bit | - | ||
Description:A boolean value that indicates (if set to true) 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 true, 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 false) that disableAutomaticTaxCalculation is true and a user changed the order. In this case, a warning is displayed. | ||||
IsMixedOrderNonexistent in DB | bool? | - | ||
Description:No description available | ||||
IsNoAROrderNonexistent in DB | bool? | - | ||
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. | ||||
IsOrchestrationAllowedNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether orchestration is allowed for the current sales order type. | ||||
IsPackageValid | bit | - | ||
Description:A Boolean value that indicates whether the packages of the orders are calculated correct. | ||||
IsPaymentInfoEnabledNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order can be paid. | ||||
IsPriceAndDiscountsValidNonexistent in DB | bool? | 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. | ||||
IsRMAOrderNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order has the RMA behavior. | ||||
IsSecondScreenNonexistent in DB | int | Is First Screen | - | |
Description:No description available | ||||
IsTaxValid | bit | Tax Is Up to Date | - | |
Description:A Boolean value that indicates whether the system needs to update taxes after saving the order. | ||||
IsTransferOrderNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order has the transfer behavior. | ||||
IsUnbilledTaxValid | bit | - | ||
Description:A Boolean value that indicates whether the system needs to update unbilled taxes after saving the order. | ||||
IsUserInvoiceNumberingNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the order type is Manual Invoice Numbering. | ||||
KeepOrchestrationStatusNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime API | datetime | Last Modified On | - | |
Description:No description available | ||||
LastShipDate | datetime | 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:A Boolean value that indicates whether the NumberOfWarehouses value can be specified. | ||||
LineCntr | int | - | ||
Description:The counter of the child lines added to the order. | ||||
LineDiscTotal | decimal | Line Discounts | - | |
Description:The total line discount of the document, which is calculated as the sum of line discounts of the order. | ||||
LineTotal | decimal | - | ||
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. | ||||
ManDiscObsolete | decimal | - | ||
Description:No description available | ||||
MarginAmt | decimal | - | ||
Description:The order's estimated margin amount. The value is not available for the transfer order. | ||||
MarginPct | decimal | Est. Margin (%) | - | |
Description:The order's estimated margin percent. The value is not available for the transfer order. | ||||
MaxRiskScore API | decimal | Max Risk Score | - | |
Description:The max risk score of this order. | ||||
MinSchedOrderDate | datetime | 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 | - | ||
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 | - | ||
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 | - | ||
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:The identifier of the Note object, associated with the document. The value corresponds to the Note.NoteID field. | ||||
NumberOfWarehouses | int | Number of Fulfillment Warehouses | - | |
Description:The maximum number of fulfillment warehouses possible for the order orchestration. | ||||
OpenDiscTotal | decimal | - | ||
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 | - | ||
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 | 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 | - | ||
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 | - | ||
Description:The sum of tax amounts of child transactions. | ||||
OrchestrationStatus | char(2) | Orchestration Status | - | |
Description:The status of the order orchestration. | ||||
OrchestrationStrategy | char(2) | Fulfillment Strategy | - | |
Description:The order orchestration fulfillment strategy for the order type. | ||||
OrderCosts | decimal | - | ||
Description:The sum of the extended costs of the detail lines and the freight cost (in the currency of the document). | ||||
OrderDate API | datetime | Date | - | |
Description:The date of the document. | ||||
OrderDesc API | nvarchar(256) | Description | - | |
Description:A brief description of the document. | ||||
OrderDiscTotalNonexistent in DB | 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. | ||||
OrderNbr API | nvarchar(15) | Order Nbr. | - | |
Description:The unique reference number of the order. When the new sales order is saved for the first time, the system automatically generates this number by using the numbering sequence assigned to orders of SOOrderType. | ||||
OrderNetSales | decimal | - | ||
Description:The sum of the line amounts without the taxes and with the applied group and document discounts and the taxable freight amount. | ||||
OrderQty API | decimal | 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 true) that order taxes are fully allocated to the invoice. | ||||
OrderTotal | decimal | - | ||
Description:The total amount of the document. | ||||
OrderType API | char(2) | Order Type | SOOrderType | |
Description:The type of the document, which is a part of the identifier of the order. The identifier of the order type. The field is included in the FK.OrderType foreign key. The value of this field corresponds to the value of the SOOrderType.orderType field. The type of the document, which is one of the predefined order types or a custom order type created by using the Order Types (SO201000) form. | ||||
OrderVolume | decimal | Order Volume | - | |
Description:The total volume of goods according to the document. | ||||
OrderWeight | decimal | Order Weight | - | |
Description:The total weight of the goods according to the document. | ||||
OrigOrderNbr | 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 true) 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 true. | ||||
OverrideShipmentNonexistent in DB | bool? | Edit Address | - | |
Description:No description available | ||||
OverrideTaxZone | bit | Override Tax Zone | - | |
Description:A Boolean value that specifies (if set to true) that the specified customer tax zone will not be overridden if any location-related information is changed for the sales order. | ||||
OwnerID | int | Owner | Contact | |
Description:The identifier of the employee in the workgroup who is responsible for the sales order. The field is included in the FK.Owner foreign key. The value of this field corresponds to the value of the EPEmployee.bAccountID field. | ||||
PMInstanceID | int | Card/Account Nbr. | CustomerPaymentMethod | |
Description:The identifier of the default card or account number for the payment method (for payment methods that require card or account numbers). The field is included in the FK.CustomerPaymentMethod foreign key. The value of this field corresponds to the value of the CustomerPaymentMethod.pMInstanceID field. If the customer has more than one card or account number, a user can select one from the list of cards or accounts available for the customer. | ||||
PackageLineCntr | int | - | ||
Description:The counter of child package lines added to the order. | ||||
PackageWeight | decimal | 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 | - | ||
Description:The sum of all released payments that have been applied to the sales order. | ||||
PayLinkID | int | - | ||
Description:Acumatica specific Payment Link Id. | ||||
PaymentCntr | int | - | ||
Description:The counter of the shipments added to the order that have a payment. | ||||
PaymentMethodID API | nvarchar(10) | Payment Method | PaymentMethod | |
Description:The identifier of the payment method to be used to pay for the sales order. The field is included in the FK.PaymentMethod foreign key. The value of this field corresponds to the value of the PaymentMethod.paymentMethodID field. By default, the value is the default payment method of the customer. | ||||
PaymentOverall | decimal | - | ||
Description:The sum of SOAdjust.curyAdjdAmt and SOAdjust.curyAdjdBilledAmt of all order's payments for which the following condition is true: SOAdjust.voided is false or SOAdjust.isCCPayment is false or SOAdjust.isCCAuthorized is true or SOAdjust.isCCCaptured is true or SOAdjust.paymentReleased is true. The field is used to calculate prepaymentReqSatisfied. | ||||
PaymentTotal | decimal | - | ||
Description:The total amount that has been paid for this sales order. This field is not available for transfer orders. | ||||
PaymentsNeedValidationCntr | int | - | ||
Description:The counter of payments added to the order for which the following condition is true: SOAdjust.isCCPayment is true, SOAdjust.syncLock is true, SOAdjust.syncLockReason is not equal to syncLockReason.newCard, and SOAdjust.curyAdjdAmt is not equal to 0. | ||||
PortalLineTotalNonexistent in DB | decimal? | Line Total | - | |
Description:No description available | ||||
PremiumFreightAmt | decimal | - | ||
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 | - | ||
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 true and becomes available only for sales orders with the Sales Orders automation behavior when the Override Prepayment field is true. | ||||
PrepaymentReqPct | decimal | Prepayment Percent | - | |
Description:The percent of the total amount of this sales order that the customer has to make before the user can proceed to shipping the ordered items and preparing an invoice for the sales order. If the Prepayment Amount changed, than this amount is updated automatically, and if this value changed, the system automatically updates the Prepayment Amount to the appropriate percent based on the amount. This field is available when the Prepayment Required field is true and becomes available only for sales orders with the Sales Orders automation behavior when the Override Prepayment field is true. | ||||
PrepaymentReqPctToRestore | decimal | - | ||
Description:The value that the Prepayment Percent field had before the Prepayment Percent was automatically reset to zero. | ||||
PrepaymentReqSatisfied | bit | Prepayment Requirements Satisfied | - | |
Description:A Boolean value that specifies (if set to true) that the amount of the prepayment or repayments applied to the sales order is greater than or equal to the value specified in the Prepayment Amount field. This field is not available only for sales orders with the Sales Orders automation behavior when the Prepayment Required field is true. | ||||
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 | nvarchar(10) | Processing Center | CCProcessingCenter | |
Description:No description available | ||||
ProjectID API | 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 true. | ||||
QtyOnOrders | decimal | Qty. on Child Orders | - | |
Description:The quantity of the stock and non-stock items in a blanket sales order distributed among child orders. | ||||
RejectedNonexistent in DB | bool? | - | ||
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 API | datetime | 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. | ||||
RiskHold | bit | - | ||
Description:Indicates whether to put this order on hold due to potential risk of fraud or other issues. | ||||
RiskLineCntr | int | - | ||
Description:The number of risks of the order. | ||||
RiskStatusNonexistent in DB | string | Risk Status | - | |
Description:The current risk status of this order. Either low, medium, or high. | ||||
SDEnabled | bit | Create Service Order | - | |
Description:No description available | ||||
SLAETA | datetime | Deadline - SLA | - | |
Description:No description available | ||||
SLAETAUTC | datetime | Deadline - SLA | - | |
Description:No description available | ||||
SalesCostTotal | decimal | - | ||
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 | 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. | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:A Boolean value that indicates (if set to true) that the record is selected for processing by a user. | ||||
ServiceOrderRefNbr | nvarchar(15) | Service Order Nbr. | FSServiceOrder | |
Description:No description available | ||||
ShipAddressID | int | SOShippingAddress | ||
Description:The identifier of the shipping address. The field is included in the FK.ShippingAddress foreign key. The value of this field corresponds to the value of the SOShippingAddress.addressID field. | ||||
ShipComplete | char(1) | Ship Complete | - | |
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. | ||||
ShipCompleteCommentNonexistent in DB | string | - | ||
Description:Contains comment text for shipment complete mode. | ||||
ShipContactID | int | SOShippingContact | ||
Description:The identifier of the shipping contact. The field is included in the FK.ShippingContact foreign key. The value of this field corresponds to the value of the SOShippingContact.contactID field. | ||||
ShipDate | datetime | 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. | ||||
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 | 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 | 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 | 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. | ||||
ShipmentCntr | int | - | ||
Description:The counter of order-shipment relations added to the order. | ||||
ShipmentDeletedNonexistent in DBObsolete | bool? | - | ||
Description:No description available | ||||
ShowAdjustmentEmptyPanelNonexistent in DB | bool? | - | ||
Description:Marks that order does not have any adjustments. | ||||
ShowDiscountsTabNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the Discounts tab is shown on the Sales Orders (SO301000) form. | ||||
ShowOrdersTabNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the Child Orders tab is shown on the Sales Orders (SO301000). | ||||
ShowShipmentEmptyPanelNonexistent in DB | bool? | - | ||
Description:Marks that order does not have any shipments. | ||||
ShowShipmentsTabNonexistent in DB | bool? | - | ||
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. | ||||
SrvOrdType | char(4) | Service Order Type | FSSrvOrdType | |
Description:No description available | ||||
Status API | char(1) | Status | - | |
Description:The status of the order. The field can have one of the values listed in SOOrderStatus. | ||||
SuggestRelatedItemsNonexistent in DB | bool? | - | ||
Description:A Boolean value that indicates whether the related items can be suggested for the order. | ||||
TaxCalcMode API | char(1) | Tax Calculation Mode | - | |
Description:The tax calculation mode to be used for the sales order. The field can have one of the following values: - TaxCalculationMode.taxSetting (default): The document uses the settings of the selected customer, or of the location of the customer if the Business Account Locations feature is enabled on the Enable/Disable Features (CS100000) form. - TaxCalculationMode.gross: The tax amount is included in the item price. - TaxCalculationMode.net: The tax amount is not included in the item price. This field is available only if the Net/Gross Entry Mode feature has been enabled on the Enable/Disable Features (CS100000) form. | ||||
TaxTotal | decimal | - | ||
Description:The total amount of tax paid on the document. | ||||
TaxZoneID | 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. | ||||
TaxableFreightAmt | decimal | - | ||
Description:The sum of freight amount and additional freight charges that are subject to taxes. | ||||
TermsDiscAmtNonexistent in DB | decimal? | - | ||
Description:The discount amount of the prompt payment. | ||||
TermsID | 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 | - | ||
Description:The sum of amounts of the payments or prepayments that have been applied to the child orders generated for the blanket order. | ||||
UnbilledDiscTotal | decimal | - | ||
Description:The discount total for unbilled lines. | ||||
UnbilledFreightTot | decimal | - | ||
Description:The unbilled part of the sales order freight total in the base currency. | ||||
UnbilledLineTotal | decimal | - | ||
Description:The sum of unbilled amount of child lines for which the following condition is true: BlanketSOLine.lineType is not equal to SOLineType.miscCharge. | ||||
UnbilledMiscTot | decimal | - | ||
Description:The sum of unbilled amounts of child lines for which the following condition is true: BlanketSOLine.lineType is equal to SOLineType.miscCharge. | ||||
UnbilledOrderQty | decimal | 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 | - | ||
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 | - | ||
Description:The total amount of tax paid on the unbilled part of the document. | ||||
UnpaidBalance | decimal | - | ||
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 | - | ||
Description:No description available | ||||
UnreleasedPaymentAmt | decimal | - | ||
Description:The sum of the payments that have been applied to the sales order and that have not been released yet. | ||||
UpdateNextNumberNonexistent in DB | bool? | 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 true) 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 | decimal | - | ||
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 true. This field is available only if the VAT Reporting feature is enabled on the Enable/Disable Features (CS100000) form. | ||||
VatTaxableTotal | decimal | - | ||
Description:The document total that is subject to VAT. This field is available only if the Include in VAT Exempt Total field is true. If the document contains multiple transactions with different taxes applied and for each of the applied taxes Include in VAT Exempt Total field is true, 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. | ||||
bool? | Will Call | - | ||
Description:A Boolean value that indicates whether the customer picks the goods from the warehouse (will call). If the value is false, the common carrier is to be used for shipping goods. If shipVia is null, the value of this field is true. If shipVia is not null, the value of this field directly corresponds to the state of the Common Carrier field for the selected ship via code. | ||||
WorkgroupID | 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. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||