SVOrder

PX.Objects.SVRelease 2026.1

No summary is documented for this DAC in the release source.

Select a row for its description 96 of 96 fields

	Field Name	Type	Display Name	Foreign Key
	`ActualsExtCost`	`decimal`		-
Description:The actuals ext. cost balance of the work order.
	`ActualsLineCntr`	`int`		-
Description:No description available
	`ActualsTotal`	`decimal`		-
Description:The actuals balance of the work order.
	`AppliedPaymentTotal`	`decimal`		-
Description:No description available
	`AvalaraCustomerUsageType`	`char(1)`	Entity Usage Type	-
Description:The customer entity type 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. The field can have one of the values described in . Defaults to the customer entity type that is specified for the location of the customer.
	`Billed`	`bit`	Billed	-
Description:No description available
	`BilledOrderTotal`	`decimal`		-
Description:The billed balance of the work order.
	`BilledPaymentTotal`	`decimal`		-
Description:No description available
	`BranchID`Default Navigation	`int`	Branch	-
Description:The identifier of the branch to which the document belongs. Corresponds to the Branch.BranchID field.
	`CallerContactEmail`	`nvarchar`	Email	-
Description:No description available
	`CallerContactID`Default Navigation	`int`	Name	Contact
Description:No description available
	`CallerContactPhone`	`nvarchar(50)`	Phone	-
Description:No description available
	`Canceled`	`bit`	Canceled	-
Description:No description available
	`Closed`	`bit`	Closed	-
Description:No description available
	`Completed`	`bit`	Completed	-
Description:No description available
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CreditHold`	`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.
	`CuryActualsExtCost`	`decimal`	Cost Total	-
Description:The total actuals ext. cost balance of the work order.
	`CuryActualsTotal`	`decimal`	Price Total	-
Description:The total actuals balance of the work order.
	`CuryAppliedPaymentTotal`	`decimal`	Applied to Work Order	-
Description:No description available
	`CuryBilledOrderTotal`	`decimal`	Billed to Date	-
Description:The billed balance of the work order.
	`CuryBilledPaymentTotal`	`decimal`	Applied to Invoice	-
Description:No description available
	`CuryDiscTotal`	`decimal`	Discount Total	-
Description:Total discount associated with the document in the currency of the document. (See CuryID)
	`CuryDocBal`Nonexistent 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.
	`CuryDocumentDiscountTotal`Nonexistent in DB	`decimal?`	Document Discount Total	-
Description:No description available
	`CuryExtPriceTotal`	`decimal`	Price Total	-
Description:No description available
	`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`Default Navigation	`nvarchar(5)`	Currency	Currency
Description:No description available
	`CuryInfoID`	`bigint`		CurrencyInfo
Description:No description available
	`CuryLineDiscTotal`	`decimal`	Line Discount Total	-
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:No description available
	`CuryOrderTotal`	`decimal`	Order Total	-
Description:The open balance of the document. Given in the currency of the document.
	`CuryProfitMargin`	`decimal`	Profit Margin	-
Description:The profit margin made on the item.
	`CuryTaxTotal`	`decimal`	Tax Total	-
Description:The total amount of taxes associated with the document. (Presented in the currency of the document, see CuryID)
	`CuryUnbilledOrderTotal`	`decimal`	Remaining to Bill	-
Description:The unbilled balance of the work order.
	`CuryVatExemptTotal`	`decimal`	Tax Exempt Total	-
Description:The document total that is exempt from VAT in the selected currency. This total is calculated as the taxable amount for the tax with the Tax.ExemptTax field set to "true" (that is, the Include in VAT Exempt Total check box selected on the Taxes (TX205000) form).
	`CuryVatTaxableTotal`	`decimal`	Taxable Total	-
Description:The document total that is subjected to VAT in the selected currency. The field is displayed only if the Tax.IncludeInTaxable field is set to "true" (that is, the Include in VAT Exempt Total check box is selected on the Taxes (TX205000) form).
	`CustomerID`Default Navigation	`int`	Customer	Customer
Description:No description available
	`CustomerLocationID`Default Navigation	`int`	Location	Location
Description:Identifier of the Location of the Customer. Defaults to the Default Location of the Customer if it is specified, or to the first found Location, associated with the Customer. Corresponds to the Location.LocationID field.
	`CustomerOrderNbr`	`nvarchar`	Customer Order Nbr.	-
Description:No description available
	`DefaultSiteID`Default Navigation	`int`	Preferred Warehouse ID	INSite
Description:The identifier of the warehouse from which the goods should be shipped.
	`Description`	`nvarchar`	Description	-
Description:No description available
	`DisableAutomaticDiscountCalculation`	`bit`	Disable Automatic Discount Update	-
Description:No description available
	`DiscTotal`	`decimal`		-
Description:Total discount associated with the document in the base currency of the company. (See Company.BaseCuryID)
	`DocBal`Nonexistent in DB	`decimal?`		-
Description:No description available
	`DocDate`	`datetime`	Date	-
Description:The date of the document. Defaults to the current Business Date.
	`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.
	`ExpectedDate`	`datetime`	Expected Date	-
Description:No description available
	`ExpenseAcctDefault`	`char(1)`	Use Expense Account From	-
Description:No description available
	`ExpenseSubMask`	`nvarchar(30)`	Combine Expense Sub. From	-
Description:No description available
	`ExtPriceTotal`	`decimal`		-
Description:No description available
	`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.
	`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`	`bit`	On Hold	-
Description:No description available
	`IsExpanded`Nonexistent in DB	`bool?`		-
Description:No description available
	`IsTaxValid`	`bit`	Tax Is Up to Date	-
Description:Indicates whether the tax amount calculated with the External Tax Provider is actual and does not require recalculation.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime`	`datetime`	Last Modified	-
Description:No description available
	`LineCntr`	`int`		-
Description:No description available
	`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:No description available
	`LocationAddress`Nonexistent in DB	`string`	Address	-
Description:No description available
	`LocationContactEmail`	`nvarchar`	Email	-
Description:No description available
	`LocationContactID`Default Navigation	`int`	Contact at Location	Contact
Description:No description available
	`LocationContactPhone`	`nvarchar(50)`	Phone	-
Description:No description available
	`MaterialListLineCntr`	`int`		-
Description:No description available
	`NoteID`	`uniqueidentifier`		-
Description:No description available
	`OpenDoc`	`bit`	Open	-
Description:No description available
	`OrderNbr`Default Navigation	`nvarchar(15)`	Order Nbr.	-
Description:No description available
	`OrderTotal`	`decimal`		-
Description:The open balance of the document. Given in the base currency of the company.
	`OrderType`Default Navigation	`nvarchar(4)`	Order Type	SVOrderType
Description:No description available
	`OrderedQty`	`decimal`	Ordered Qty.	-
Description:No description available
	`Priority`	`char(1)`	Priority	-
Description:No description available
	`ProfitMargin`	`decimal`		-
Description:Profit made on the item.
	`ProfitMarginPercent`	`decimal`	Profit Margin (%)	-
Description:No description available
	`ProjectID`Default Navigation	`int`	Project	PMProject
Description:No description available
	`ReplaceTasksAfterSave`Nonexistent in DB	`bool?`		-
Description:No description available
	`SalesAcctDefault`	`char(1)`	Use Sales Account From	-
Description:No description available
	`SalesSubMask`	`nvarchar(30)`	Combine Sales Sub. From	-
Description:No description available
	`ServiceLocationComment`	`nvarchar(256)`	Comment	-
Description:No description available
	`ServiceLocationID`Default Navigation	`nvarchar(15)`	Service Location	SVServiceLocation
Description:No description available
	`Severity`	`char(1)`	Severity	-
Description:No description available
	`Status`	`char(1)`	Status	-
Description:No description available
	`Summary`	`nvarchar`	Summary	-
Description:No description available
	`SuppressCompleteValidation`Nonexistent in DB	`bool?`		-
Description:No description available
	`TaxTotal`	`decimal`		-
Description:The total amount of taxes associated with the document. (Presented in the base currency of the company, see Company.BaseCuryID)
	`TaxZoneID`Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:The identifier of the TaxZone associated with the document. Corresponds to the TaxZone.TaxZoneID field.
	`TermsID`Default Navigation	`nvarchar(10)`	Credit Terms	Terms
Description:The identifier of the default terms, which are applied to the documents of the customer.
	`UnbilledOrderTotal`	`decimal`		-
Description:The unbilled balance of the work order.
	`VatExemptTotal`	`decimal`		-
Description:The document total that is exempt from VAT in the base currency.
	`VatTaxableTotal`	`decimal`		-
Description:The document total that is subjected to VAT in the base currency.
	`tstamp`	`timestamp`		-
Description:No description available