SOLine

PX.Objects.SORelease 2025.2

Represents sales order details.

View API Entity: SalesOrderDetail/entity/Default/25.200.001/SalesOrderDetail

Select a row for its description 238 of 238 fields

	Field Name	Type	Display Name	Foreign Key
	`AMCTPAccepted`	`bit`	CTP Accepted	-
Description:No description available
	`AMConfigKeyID`Default Navigation	`nvarchar(120)`	Config. Key	AMConfigurationKeys
Description:Configuration key ID which represents the key used/generated from the results of a finished configuration
	`AMConfigurationID`	`nvarchar`	Configuration ID	-
Description:No description available
	`AMEstimateID`Default Navigation	`nvarchar(15)`	Estimate ID	AMEstimateItem
Description:No description available
	`AMEstimateRevisionID`Default Navigation	`nvarchar(10)`	Est. Revision	AMEstimateItem
Description:No description available
	`AMIsSupplemental`	`bit`	Is Supplemental	-
Description:No description available
	`AMOrderType`Default Navigation	`char(2)`	Prod. Order Type	AMOrderType
Description:No description available
	`AMOrigParentLineNbr`	`int`	Orig Parent Line Nbr.	-
Description:No description available
	`AMOrigRequestDate`	`datetime`	Original Request Date	-
Description:No description available
	`AMParentLineNbr`	`int`	Parent Line Nbr.	-
Description:No description available
	`AMProdBaseQtyComplete`	`decimal`	Production Base Qty Complete	-
Description:No description available
	`AMProdCreate`	`bit`	Mark for Production	-
Description:No description available
	`AMProdOrdID`Default Navigation	`nvarchar(19)`	Production Nbr.	SOLineExt
Description:No description available
	`AMProdQtyComplete`	`decimal`	Production Qty Complete	-
Description:No description available
	`AMProdStatusID`	`char(1)`	Status	-
Description:No description available
	`AMQtyReadOnly`Nonexistent in DB	`decimal?`	Quantity	-
Description:Read only sales order line quantity
	`AMSchdNoteID`	`uniqueidentifier`		-
Description:No description available
	`AMSelected`Nonexistent in DB	`bool?`	Selected	-
Description:No description available
	`AMUOMReadOnly`Nonexistent in DB	`string`	UOM	-
Description:Read only sales order line UOM
	`AlternateID` API	`nvarchar(50)`	Alternate ID	-
Description:The alternate ID for the item, such as the barcode or the inventory ID used by the customer.
	`AppointmentLineNbr`	`int`	Appointment Line Nbr.	-
Description:No description available
	`AppointmentRefNbr`	`nvarchar(20)`	Appointment Nbr.	-
Description:No description available
	`AssociatedOrderLineNbr` API	`int`	Associated Order Line Nbr.	-
Description:An optional associated order line number.
	`AutoCreateIssueLine` API	`bit`	Auto Create Issue	-
Description:A Boolean value that indicates whether the line of the Issue type will be created automatically for each order line of the Receipt type if the order is of the RR type.
	`AutomaticDiscountsDisabled`	`bit`	Automatic Discounts Disabled	-
Description:A Boolean value that indicates whether the system does not need to calculate discounts, because they are already calculated.
	`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 inserts the entity usage type. 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.
	`AvgCost` API Nonexistent in DB	`decimal?`	Average Cost	-
Description:Average cost of the Inventory Item of the line.
	`BaseBilledQty`	`decimal`		-
Description:The quantity of stock and non-stock items that were billed, expressed in the base unit of measure.
	`BaseClosedQty`Nonexistent in DB	`decimal?`		-
Description:The closed quantity of the item, expressed in the base unit of measure.
	`BaseOpenQty`	`decimal`	Base Open Qty.	-
Description:The quantity of the item to be shipped, expressed in the base unit of measure.
	`BaseOrderQty`	`decimal`	Base Order Qty.	-
Description:The quantity of the item sold, expressed in the base unit of measure. This quantity is used for calculating discounts if the Base UOM field is true.
	`BaseQtyOnOrders`	`decimal`		-
Description:The quantity of the item sold, expressed in the base unit of measure in a blanket sales order line, distributed among child orders that are generated for this line.
	`BaseShippedQty`	`decimal`		-
Description:The quantity of the stock item being prepared for shipment and already shipped for this order, expressed in the base unit of measure.
	`BaseUnbilledQty`	`decimal`		-
Description:The quantity of stock and non-stock items that were not yet billed, expressed in the base unit of measure.
	`Behavior`	`char(2)`		-
Description:The behavior which is defined by the OrderType of the sales order in which this line item is listed.
	`BilledAmt`	`decimal`		-
Description:The sum of amounts of the payments or prepayments that have been applied to the AR invoice generated for the line of the order.
	`BilledQty`	`decimal`	Billed Quantity	-
Description:The quantity of stock and non-stock items that were billed.
	`BlanketLineNbr`	`int`		BlanketSOLine
Description:The blanket line number of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys: - FK.BlanketLine. The field is a part of the identifier of the blanket sales order line BlanketSOLine.BlanketSOLine.lineNbr - FK.BlanketSplit. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.lineNbr
	`BlanketNbr`Default Navigation	`nvarchar(15)`	Blanket SO Ref. Nbr.	BlanketSOOrder
Description:The reference number of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys: - FK.BlanketOrder. The field is a part of the identifier of the blanket sales order BlanketSOOrder.BlanketSOOrder.orderNbr - FK.BlanketLine. The field is a part of the identifier of the blanket sales order line BlanketSOLine.BlanketSOLine.orderNbr - FK.BlanketSplit. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.orderNbr - FK.BlanketOrderLink. The field is a part of the identifier of the blanket sales order link SOBlanketOrderLink.SOBlanketOrderLink.blanketNbr
	`BlanketOpenQty`Nonexistent in DB	`decimal?`	Blanket Open Qty.	-
Description:The quantity of a stock or non-stock item in a blanket sales order line that has not been transferred to child orders. This value is calculated as the difference between the line quantity and the quantity on child orders. This field is available only for blanket sales orders.
	`BlanketSplitLineNbr`	`int`		BlanketSOLineSplit
Description:The blanket split line number of the blanket sales order from which the child order has been generated. The field is included in the FK.BlanketSplit foreign key. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.lineNbr.
	`BlanketType`	`char(2)`		BlanketSOOrder
Description:The order type of the blanket sales order from which the child order has been generated. The field is included in the following foreign keys: - FK.BlanketOrder. The field is a part of the identifier of the blanket sales order BlanketSOOrder.BlanketSOOrder.orderType - FK.BlanketLine. The field is a part of the identifier of the blanket sales order line BlanketSOLine.BlanketSOLine.orderType - FK.BlanketSplit. The field is a part of the identifier of the blanket sales order split line BlanketSOLineSplit.BlanketSOLineSplit.orderType - FK.BlanketOrderLink. The field is a part of the identifier of the blanket sales order link SOBlanketOrderLink.SOBlanketOrderLink.blanketType
	`BranchID` API Default Navigation	`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.
	`CalculateDiscountsOnImport` API Nonexistent in DB	`bool?`	Calculate automatic discounts on import	-
Description:A Boolean value that indicates whether the line discounts will be calculated automaticly.
	`CancelDate`	`datetime`	Cancel By	-
Description:The expiration date of the order in which this line item is listed.
	`Cancelled`	`bit`		-
Description:A Boolean value that indicates whether the order was cancelled.
	`ChildLineCntr`	`int`		-
Description:The identifier of the detail line of the parent order.
	`ClosedQty`Nonexistent in DB	`decimal?`		-
Description:The closed quantity of the item, calculated as the subtraction of the quantity of the item to be shipped from the quantity of the item sold.
	`Comment`	`nvarchar(MAX)`	Equipment Action Comment	-
Description:No description available
	`Commissionable` API	`bit`	Commissionable	-
Description:A Boolean value that indicates whether the line is subjected to a sales commission. This field is available only if the Commissions feature is enabled on the Enable/Disable Features (CS100000) form. This field is not available for orders of the TR type.
	`CommnAmt`	`decimal`		-
Description:The default commission amount of the salesperson.
	`CommnPct`	`decimal`		-
Description:The default commission percentage of the salesperson.
	`CompleteQtyMax` API	`decimal`	Overship Threshold (%)	-
Description:The maximum percentage of goods shipped (with respect to the ordered quantity) allowed by the customer.
	`CompleteQtyMin` API	`decimal`	Undership Threshold (%)	-
Description:The minimum percentage of goods shipped (with respect to the ordered quantity) for the system to mark the order as completely shipped.
	`Completed` API	`bit`	Completed	-
Description:A Boolean value that indicates whether the line is completed.
	`ComponentID`Default Navigation	`int`	Component ID	FSModelTemplateComponent
Description:No description available
	`CostCenterID`	`int`		INSiteStatusByCostCenter
Description:No description available
	`CostCodeID` API Default Navigation	`int`	Cost Code	PMCostCode
Description:The cost code with which this document is associated to track project costs and revenue. The field is included in the FK.CostCode foreign key. The field is the identifier of the cost code PMCostCode.PMCostCode.costCodeID. This field is available only if the Cost Codes feature is enabled on the Enable/Disable Features (CS100000) form in addition to the integration of the Projects submodule with Sales Orders.
	`CreateSubAssemblyOrders`Nonexistent in DB	`bool?`	Generate Orders for Subassemblies	-
Description:Indicate whether it need to create sub assemblies related to current production order while creating it.
	`CreatedByID`Default Navigation	`uniqueidentifier`	Created By	Users
Description:No description available
	`CreatedByScreenID`	`char(8)`		-
Description:No description available
	`CreatedDateTime`	`datetime`		-
Description:No description available
	`CuryBilledAmt`	`decimal`		-
Description:The sum of amounts of the payments or prepayments that have been applied to the AR invoice generated for the line of the order (in the currency of the document).
	`CuryCommnAmt`	`decimal`		-
Description:The default commission amount of the salesperson (in the currency of the document).
	`CuryDiscAmt` API	`decimal`	Discount Amount	-
Description:The amount of the line-level discount of the line (in the currency of the document).
	`CuryDiscPrice` API Nonexistent in DB	`decimal?`	Disc. Unit Price	-
Description:The unit price, which has been recalculated after the application of discounts (in the currency of the document).
	`CuryExtCost`	`decimal`	Extended Cost	-
Description:The extended cost of the item line (in the currency of the document).
	`CuryExtPrice` API	`decimal`	Ext. Price	-
Description:The extended price of the item line (in the currency of the document).
	`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.
	`CuryLineAmt` API	`decimal`	Amount	-
Description:The amount of the line, which the system calculates as the extended price minus the line-level discount (in the currency of the document).
	`CuryMarginAmt`	`decimal`	Est. Margin Amount	-
Description:The line's estimated margin amount (in the currency of the document). The value is not available for the transfer order. The value is empty for the line with zero extended cost and for the line marked for drop-ship or blanket for drop-ship.
	`CuryNetSales`	`decimal`		-
Description:The line amount without the tax and with the applied group and document discounts (in the currency of the document). The value has the negative sign for the receipt lines.
	`CuryOpenAmt`	`decimal`	Open Amount	-
Description:The amount of the stock items not yet shipped according to the sales order (in the currency of the document).
	`CuryTaxableAmt`	`decimal`		-
Description:The line amount that is subject to tax (in the currency of the document).
	`CuryUnbilledAmt` API	`decimal`	Unbilled Amount	-
Description:The unbilled amount for a stock item with the Goods for Inventory line type or a non-stock item with the Non-Inventory Goods line type (in the currency of the document).
	`CuryUnitCost` API	`decimal`	Unit Cost	-
Description:The unit cost at which the item being returned was issued from inventory when it was sold (in the currency of the document).
	`CuryUnitPrice` API	`decimal`	Unit Price	-
Description:The unit price of the item (in the currency of the document).
	`CuryUnitPriceDR`	`decimal`	Unit Price for DR	-
Description:No description available
	`CustomerID`	`int`		Customer
Description:The identifier of the customer of the original sales order. The field is included in the FK.Customer foreign key. The field is a part of the identifier of the reason code AR.Customer.Customer.bAccountID.
	`CustomerLocationID` API Default Navigation	`int`	Ship-To Location	Location
Description:The customer location. By default, the system copies to it the value of the Location field. This field is available only for blanket sales orders. This field cannot be empty.
	`CustomerOrderNbr` API	`nvarchar(40)`	Customer Order Nbr.	-
Description:The customer order number that the system inserts into the Customer Order Nbr. field for a generated child order. This field is available only for blanket sales orders.
	`DRTermEndDate`	`datetime`	Term End Date	-
Description:The date when the process of deferred revenue recognition should finish for the selected item. This field is available only if the Deferred Revenue Management feature is enabled on the Enable/Disable Features (CS100000) form.
	`DRTermStartDate`	`datetime`	Term Start Date	-
Description:The date when the process of deferred revenue recognition should start for the selected item. This field is available only if the Deferred Revenue Management feature is enabled on the Enable/Disable Features (CS100000) form.
	`DefScheduleID`	`int`		DRSchedule
Description:The identifier of the deferred revenue or deferred expense schedule of the sales order. The field is included in the FK.DefaultShedule foreign key. The field is a part of the identifier of the deferred revenue or deferred expense schedule DRSchedule.DRSchedule.scheduleID.
	`DefaultOperation`Default Navigation	`char(1)`		SOOrderTypeOperation
Description:No description available
	`DisableAutomaticTaxCalculation`	`bit`	Disable Automatic Tax Calculation	-
Description:A Boolean value that indicates whether the system does not need to calculate taxes, because they are already calculated.
	`DiscAmt`	`decimal`		-
Description:The amount of the line-level discount of the line. If the Manual Discount field value is true, it indicates that the amount of the discount is specified by the line discount that has been applied manually, or has been entered manually or calculated based on the discount percent of the line.
	`DiscPct` API	`decimal`	Discount Percent	-
Description:The percent of the line-level discount. If the Manual Discount field value is true, it indicates that the percent of the discount is specified by the line discount that has been applied manually, or has been entered manually or calculated based on the discount amount of the line.
	`DiscPctDR`	`decimal`	Discount Percent for DR	-
Description:No description available
	`DiscPrice`Nonexistent in DB	`decimal?`		-
Description:The unit price that has been recalculated after the application of discounts.
	`DiscountID` API Default Navigation	`nvarchar(10)`	Discount Code	ARDiscount
Description:The code of the discount of the line. The field is included in the following foreign keys: - FK.Discount. The field is the identifier of the Discount ARDiscount.ARDiscount.discountID - FK.DiscountSequence. The field is a part of the identifier of the Discount Sequence AR.DiscountSequence.DiscountSequence.discountID This field is available only if the Customer Discounts feature is enabled on the Enable/Disable Features (CS100000) form.
	`DiscountSequenceID`	`nvarchar(10)`	Discount Sequence	DiscountSequence
Description:The identifier of the discount sequence of the line. The field is included in the FK.DiscountSequence foreign key. The field is a part of the identifier of the Discount Sequence AR.DiscountSequence.DiscountSequence.discountSequenceID. This field is available only if the Customer Discounts feature is enabled on the Enable/Disable Features (CS100000) form.
	`DiscountsAppliedToLine`	`varbinary`		-
Description:Array of line numbers of discounts applied to the line.
	`DocumentDiscountRate`	`decimal`		-
Description:The rate of all discounts of the document type applied to the line.
	`EquipmentAction`	`char(2)`	Equipment Action	-
Description:No description available
	`EquipmentComponentLineNbr`Default Navigation	`int`	Component Line Nbr.	FSEquipmentComponent
Description:No description available
	`EquipmentItemClass`	`char(2)`		-
Description:No description available
	`ExcludedFromExport`Nonexistent in DB	`bool?`	Excluded from Export	-
Description:Indicates if this sales order line should be excluded from export.
	`ExpireDate`	`datetime`	Expiration Date	-
Description:The expiration date for the item with the specified lot number. This field is available only for only orders of the RR type.
	`ExtCost`	`decimal`		-
Description:The extended cost, which the system calculates as the unit cost multiplied by the quantity.
	`ExtPrice`	`decimal`		-
Description:The extended price, which the system calculates as the unit price multiplied by the quantity.
	`ExtVolume`	`decimal`	Ext. Volume	-
Description:The extended volume, which the system calculates as the unit volume multiplied by the quantity.
	`ExtWeight`	`decimal`	Ext. Weight	-
Description:The extended weight, which the system calculates as the unit weight multiplied by the quantity.
	`ExternalRef` API	`nvarchar(64)`	External Ref.	-
Description:The external reference number for this sales order line.
	`FOBPoint`Default Navigation	`nvarchar(15)`	FOB	FOBPoint
Description:The point at which the ownership of the goods passes to the customer. This field is available only for blanket sales orders. This field cannot be empty.
	`FreezeManualDisc`Nonexistent in DB	`bool?`		-
Description:A Boolean value that indicates whether the system will not recalculate the discount of the line type.
	`GiftMessage` API	`nvarchar(200)`	Gift Message	-
Description:A gift message associated with this sales order line.
	`GroupDiscountRate`	`decimal`		-
Description:The rate of all discounts of the group type applied to the line.
	`HistoryLineID`Nonexistent in DB	`int?`		-
Description:No description available
	`IntercompanyPOLineNbr`	`int`		-
Description:The number of the Intercompany purchase order line to which the sales order line is linked. This field is available only if the Inter-Branch Transactions feature is enabled on the Enable/Disable Features (CS100000) form.
	`InventoryID` API Default Navigation	`int`	Inventory ID	InventoryItem
Description:The inventory ID of the Inventory Item to be sold or returned. The field is included in the following foreign keys: - FK.InventoryItem. The field is the identifier of the Stock Item or Non-Stock Item InventoryItem.InventoryItem.inventoryID - FK.SiteStatus. The field is a part of the identifier of the warehouse container INSiteStatus.INSiteStatus.inventoryID - FK.LocationStatus. The field is a part of the identifier of the Location inventory item status INSiteStatus.INLocationStatus.inventoryID - FK.LotSerialStatus. The field is a part of the identifier of the Location inventory item status by Lot Serial numbers INLotSerialStatus.INLotSerialStatus.inventoryID
	`InventorySource`	`char(1)`	Inventory Source	-
Description:The source of material for a transaction line.
	`InvoiceDate`	`datetime`	Original Sale Date	-
Description:Date of the Invoice line to which the return SO line is applied.
	`InvoiceLineNbr` API	`int`	Invoice Line Nbr.	ARTran
Description:Number of the Invoice line to which the return SO line is applied. The field is included in the FK.InvoiceLine foreign key. The field is a part of the identifier of the Invoice Line ARTran.ARTran.lineNbr.
	`InvoiceNbr` API	`nvarchar(15)`	Invoice Nbr.	SOInvoice
Description:Number of the Invoice to which the return SO line is applied. The field is included in the following foreign keys: - FK.Invoice. The field is a part of the identifier of the Invoice SOInvoice.SOInvoice.refNbr - FK.InvoiceLine. The field is a part of the identifier of the Invoice Line ARTran.ARTran.refNbr
	`InvoiceType` API	`char(3)`	Invoice Type	SOInvoice
Description:Type of the Invoice to which the return SO line is applied. The field is included in the following foreign keys: - FK.Invoice. The field is a part of the identifier of the Invoice SOInvoice.SOInvoice.docType - FK.InvoiceLine. The field is a part of the identifier of the Invoice Line ARTran.ARTran.tranType
	`InvoiceUOM`	`nvarchar(6)`		-
Description:The unit of measure (UOM) of the original line of the invoice.
	`InvtMult`	`smallint`	Inventory Multiplier	-
Description:The Inventory Multiplier of the operation of the line.
	`IsBeingCopied`Nonexistent in DB	`bool?`		-
Description:A Boolean value that indicates whether a SOLine was created by copying. This flag can be used to mark copied sales order lines if they need to be distinguished from the lines that are not created by copying.
	`IsConfigurable`Nonexistent in DB	`bool?`	Configurable	-
Description:No description available
	`IsCostUpdatedOnPO`	`bit`	Update Cost On PO	-
Description:No description available
	`IsCut`Nonexistent in DBObsolete	`bool?`		-
Description:No description available
	`IsFree` API	`bit`	Free Item	-
Description:A Boolean value that indicates whether the inventory item specified in the row is a free item. If the field value is true then the system updates the Unit Price, Discount Percent, Discount Amount, and Ext. Price amounts with 0 and set Manual Discount field to true.
	`IsKit`Nonexistent in DB	`bool?`	Is a Kit	-
Description:A Boolean value that indicates whether the item is a kit.
	`IsLegacyDropShip`	`bit`		-
Description:A Boolean value that indicates whether the line is a drop-ship which was created by the previous realization version.
	`IsOrchestratedLine`	`bit`	Orchestrated	-
Description:A Boolean value that indicates whether the SOLine record was orchestrated.
	`IsPOLinkAllowed`Nonexistent in DB	`bool?`		-
Description:A Boolean value that indicates whether the Mark for PO field is true and the Operation field is equal to the SOOperation.issue value of the line.
	`IsPromotionalPrice`	`bit`	Promotional Price	-
Description:No description available
	`IsSpecialOrder`	`bit`	Special Order	-
Description:A Boolean value that indicates whether the line is a part of the special order. A special order is a customer order for goods that a company does not normally keep in stock (due to their nature, specific components, dimensions, attributes, etc.) or for goods that have been acquired for a specific job only at a special purchase cost from a vendor. The special-ordered items must maintain their cost from purchase to sale and are not included in inventory cost calculations.
	`IsStockItem`	`bit`	Is stock	-
Description:A Boolean value that indicates whether the Inventory Item of the line is a stock item.
	`ItemHasResidual`Nonexistent in DB	`bool?`		-
Description:No description available
	`ItemRequiresTerms`Nonexistent in DB	`bool?`		-
Description:When set to "true", indicates that the DRTermStartDate and DRTermEndDate fields are enabled for the line. The value of this field is set by the SOOrderEntry graph based on the settings of the item selected for the line. In other contexts it is not populated. See the attribute on the SOOrderEntry.SOLine_ItemRequiresTerms_CacheAttached handler for details.
	`LastModifiedByID`Default Navigation	`uniqueidentifier`	Last Modified By	Users
Description:No description available
	`LastModifiedByScreenID`	`char(8)`		-
Description:No description available
	`LastModifiedDateTime` API	`datetime`		-
Description:No description available
	`LineAmt`	`decimal`		-
Description:The amount of the line, which the system calculates as the extended price minus the line-level discount.
	`LineNbr` API	`int`	Line Nbr.	-
Description:The line number of the document.
	`LineQtyAvail`Nonexistent in DB	`decimal?`		-
Description:The Quantity Available of the item of the line.
	`LineQtyHardAvail`Nonexistent in DB	`decimal?`		-
Description:The Quantity Hard Available of the item of the line.
	`LineSign`	`smallint`		-
Description:No description available
	`LineType` API	`char(2)`	Line Type	-
Description:The type of the line. The field can have one of the values listed in SOLineType.
	`LocationID` API Default Navigation	`int`	Location	INLocation
Description:The identifier of the location of the original sales order. The field is included in the following foreign keys: - FK.Location. The field is the identifier of the Location INLocation.INLocation.locationID - FK.LocationStatus. The field is a part of the identifier of the Location inventory item status SOOrder.INLocationStatus.locationID - FK.LotSerialStatus. The field is a part of the identifier of the Location inventory item status by Lot Serial numbers FK.LotSerialStatus.INLotSerialStatus.locationID
	`LotSerialNbr` API Default Navigation	`nvarchar(100)`	Lot/Serial Nbr.	INLotSerialStatus
Description:The lot or serial number of the item for returns. The field is included in the FK.LotSerialStatus foreign key. The field is a part of the identifier of the Location inventory item status by Lot Serial numbers SOLine.SOLine.locationID. This field is available only if the Lot and Serial Tracking feature is enabled on the Enable/Disable Features (CS100000) form.
	`ManualDisc` API	`bit`	Manual Discount	-
Description:A Boolean value that indicates whether the discount has been applied manually.
	`ManualPrice` API	`bit`	Manual Price	-
Description:A Boolean value that indicates whether the unit price in this line has been corrected or specified manually. If the field value is false then the system updates the unit price in the document line with the current price (if one is specified). If the field value is true then customer ID is changed in the sales order or return order, the system does not update unit prices in the line.
	`MarginAmt`	`decimal`		-
Description:The line's estimated margin amount. The value is not available for the transfer order. The value is empty for the line with zero extended cost and for the line marked for drop-ship or blanket for drop-ship.
	`MarginPct`	`decimal`	Est. Margin (%)	-
Description:The line's estimated margin percent. The value is not available for the transfer order. The value is empty for the line with zero extended cost and for the line marked for drop-ship or blanket for drop-ship.
	`Mem_PreviousPostID`Nonexistent in DB	`int?`		-
Description:No description available
	`Mem_TableSource`Nonexistent in DB	`string`		-
Description:No description available
	`NetSales`	`decimal`		-
Description:The line amount without the tax and with the applied group and document discounts. The value has the negative sign for the receipt lines.
	`NewEquipmentLineNbr`Default Navigation	`int`	Model Equipment Line Nbr.	PXBqlTable
Description:No description available
	`NoteID` API	`uniqueidentifier`		-
Description:No description available
	`OpenAmt`	`decimal`		-
Description:The amount of the stock items not yet shipped according to the line.
	`OpenChildLineCntr`	`int`		-
Description:The identifier of the unshipped detail line of the parent order.
	`OpenLine`	`bit`	Open Line	-
Description:The identifier of the open detail line of the parent order.
	`OpenQty` API	`decimal`	Open Qty.	-
Description:The quantity of the item to be shipped. That is, the total quantity minus the quantity shipped according to closed shipment documents.
	`Operation` API Default Navigation	`char(1)`	Operation	SOOrderTypeOperation
Description:The part of the identifier of the operation to be performed in inventory to fulfill the order. The field is included in the FK.OrderTypeOperation foreign key. The value of this field corresponds to the value of the SOOrderTypeOperation.operation field. An order of the RR or RM type includes lines with the Receipt operation and lines with the Issue operation. Orders of other return types include only lines with the Receipt operation.
	`OrchestrationOriginalLineNbr`	`int`		-
Description:The original number of the SOLine record that it had before the orchestration.
	`OrchestrationOriginalSiteID`	`int`		-
Description:The identifier of the original warehouse, which the line had before the order orchestration.
	`OrchestrationPlanID`Default Navigation	`nvarchar(15)`	Orchestration Plan	SOOrchestrationPlan
Description:The ID of the orchestration plan (see SOOrchestrationPlan) associated with this SOLine record.
	`OrderDate`	`datetime`		-
Description:The date of the sales order in which this line item is listed.
	`OrderNbr`	`nvarchar(15)`	Order Nbr.	SOOrder
Description:The reference number of the sales order in which this line item is listed. The field is included in the following foreign keys: - FK.Order. The field is a part of the identifier of the sales order SOOrder.SOOrder.orderNbr - FK.BlanketOrderLink. The field is a part of the identifier of the linked blanket sales order SOBlanketOrderLink.SOBlanketOrderLink.orderNbr
	`OrderQty` API	`decimal`	Quantity	-
Description:The quantity of the item sold in the unit of measure.
	`OrderType`Default Navigation	`char(2)`	Order Type	SOOrderType
Description:The type of the sales order in which this line item is listed. The field is included in the following foreign keys: - FK.Order. The field is a part of the identifier of the sales order SOOrder.SOOrder.orderType - FK.OrderType. The field is a part of the identifier of the parent order type SOOrderType.SOOrderType.orderType - FK.OrderTypeOperation. The field is a part of the identifier of the operation (issues, receipts) of a particular order types SOOrderTypeOperation.SOOrderTypeOperation.orderType - FK.BlanketOrderLink. The field is a part of the identifier of the linked blanket sales order SOBlanketOrderLink.SOBlanketOrderLink.orderType
	`OrigIsSpecialOrder`Nonexistent in DB	`bool?`		-
Description:No description available
	`OrigLineNbr`	`int`		SOLine
Description:The part of the identifier of the original line. The value of this field corresponds to the value of the SOLine.lineNbr field. The field is included in the FK.OriginalOrderLine foreign key.
	`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 following foreign keys: - FK.OriginalOrder. The field is a part of the identifier of the Sales order SOOrder.SOOrder.orderNbr - FK.OriginalOrderLine. The field is a part of the identifier of the Sales order line SOLine.SOLine.orderNbr
	`OrigOrderType`	`char(2)`	Orig. Order Type	SOOrderType
Description:The identifier of the type of the original order. The field is included in the following foreign keys: - FK.OriginalOrderType. The field is the identifier of the Order type SOOrderType.SOOrderType.orderType - FK.OriginalOrder. The field is a part of the identifier of the Sales order SOOrder.SOOrder.orderType - FK.OriginalOrderLine. The field is a part of the identifier of the Sales order line SOLine.SOLine.orderType
	`OrigPlanType`Default NavigationObsolete	`char(2)`		INPlanType
Description:No description available
	`OrigShipmentType`	`char(1)`		-
Description:The Shipment Type of the original line of the Accounts Receivable invoice or memo.
	`POCreate` API	`bit`	Mark for PO	-
Description:A Boolean value that indicates whether the order line was marked for purchasing (if it has not been shipped completely) and the line will be available for adding to a purchase order.
	`POCreateDate`	`datetime`	PO Creation Date	-
Description:The planned date for creation of a purchase order. By default, the system inserts the current business date to this field. This field is available only for blanket sales orders.
	`POCreated`	`bit`		-
Description:A Boolean value that indicates whether the line was added to a purchase order.
	`POLineNbr`Nonexistent in DB	`int?`	Drop-Ship PO Line Nbr.	-
Description:The number of the drop-ship purchase order line to which the sales order line is linked.
	`POLinkActive`Nonexistent in DB	`bool?`	PO Linked	-
Description:A Boolean value that indicates whether the line has an active link to a line of the drop-ship purchase order.
	`POOrderNbr`Default NavigationNonexistent in DB	`string`	Drop-Ship PO Nbr.	POOrder
Description:The number of the drop-ship purchase order to which the sales order line is linked.
	`POOrderStatus`Nonexistent in DB	`string`	Drop-Ship PO Status	-
Description:The status of the drop-ship purchase order to which the sales order line is linked. The field can have one of the values listed in PO.POOrderStatus.
	`POOrderType`Nonexistent in DB	`string`		-
Description:The type of the drop-ship purchase order to which the sales order line is linked. The field can have one of the values listed in PO.POOrderType.
	`POSiteID` API Default Navigation	`int`	Purchase Warehouse	INSite
Description:The identifier of the destination warehouse for the items to be purchased. The field is included in the FK.POSite foreign key. The value of this field corresponds to the value of the INSite.siteID field.
	`POSource` API	`nvarchar`	PO Source	-
Description:The purchase order source to be used to fulfill this line. The field can have one of the values listed in INReplenishmentSource.
	`PlanType`Nonexistent in DB	`string`		-
Description:The Order Plan Type of the operation of the line.
	`PriceType`	`char(1)`	Price Type	-
Description:The type of the item price of the line. The field can have one of the values listed in PriceTypes.
	`ProjectID`	`int`		PMProject
Description:The identifier of the project. The field is included in the following foreign keys: - FK.Project. The field is the identifier of the Project PMProject.PMProject.contractCD - FK.Task. The field is a part of the identifier of the Project Task PMTask.PMTask.projectID
	`QtyOnOrders`	`decimal`	Qty. On Orders	-
Description:The quantity of a stock or non-stock item in a blanket sales order line distributed among child orders that are generated for this line.
	`ReasonCode` API Default Navigation	`nvarchar(20)`	Reason Code	ReasonCode
Description:The reason code to be used for creation or cancellation of the order, if applicable. The field is included in the FK.ReasonCode foreign key. The field is the identifier of the reason code CS.ReasonCode.ReasonCode.reasonCodeID.
	`RelatedDocument`Nonexistent in DB	`string`	Related Svc. Doc. Nbr.	-
Description:No description available
	`RelatedItems`Nonexistent in DB	`string`		-
Description:No description available
	`RelatedItemsRelation`Nonexistent in DB	`int?`		-
Description:No description available
	`RelatedItemsRequired`Nonexistent in DB	`int?`		-
Description:No description available
	`RequestDate` API	`datetime`	Requested On	-
Description:The date when the customer wants to receive the goods. The default value is specified in the Requested On field of the order.
	`RequireAllocation`Nonexistent in DB	`bool?`		-
Description:The Require Stock Allocation of the order type of the line.
	`RequireLocation`Nonexistent in DB	`bool?`		-
Description:The Require Location of the order type of the line.
	`RequireReasonCode`Nonexistent in DB	`bool?`		-
Description:The Require Reason Code of the operation of the line.
	`RequireShipping`Nonexistent in DB	`bool?`		-
Description:The Process Shipments of the order type of the line.
	`SDPosted`	`bit`		-
Description:No description available
	`SDSelected`	`bit`	Require Appointment	-
Description:No description available
	`SMEquipmentID`Default Navigation	`int`	Target Equipment ID	SOOrder
Description:No description available
	`SalesAcctID` API Default Navigation	`int`	Account	Account
Description:The account associated with the sale of the line item. The field is included in the FK.SalesAccount foreign key. The field is the identifier of the Sales Account GL.Account.Account.accountID.
	`SalesPersonID` API Default Navigation	`int`	Salesperson ID	SalesPerson
Description:The salesperson associated with the sale of the line item. The field is included in the FK.SalesPerson foreign key. The field is a part of the identifier of the salesperson AR.SalesPerson.SalesPerson.salesPersonID. This field is available only if the Commissions feature is enabled on the Enable/Disable Features (CS100000) form. This field is not available for orders of the TR type.
	`SalesSubID`Default Navigation	`int`	Subaccount	Sub
Description:The subaccount associated with the sale of the line item. The field is included in the FK.SalesSubaccount foreign key. The field is the identifier of the Sales subaccount GL.Sub.Sub.subID.
	`SchedOrderDate` API	`datetime`	Sched. Order Date	-
Description:The date on which a child order should be generated for the line of the blanket sales order. By default, the system inserts the current business date to this field. The value in this field can be empty. The value cannot be earlier than the date of the blanket sales order and later than the expiration date of the blanket sales order. This field is available only for blanket sales orders.
	`SchedShipDate`	`datetime`	Sched. Shipment Date	-
Description:The planned date of the shipment for a child order generated from this line. The date in this field cannot be earlier than the date of the blanket sales order and the Sched. Order Date. The value in this field cannot be later than the expiration date of the blanket sales order. This field is available only for blanket sales orders.
	`ServiceContractPeriodID`	`int`	Service Contract Period	-
Description:No description available
	`ServiceContractRefNbr`	`nvarchar(15)`	Service Contract Nbr.	-
Description:No description available
	`ServiceOrderLineNbr`	`int`	Service Order Line Nbr.	-
Description:No description available
	`ServiceOrderRefNbr`	`nvarchar(15)`	Service Order Nbr.	-
Description:No description available
	`ShipComplete` API	`char(1)`	Shipping Rule	-
Description:The way the line item should be shipped. The field can have one of the values listed in SOShipComplete.
	`ShipDate` API	`datetime`	Ship On	-
Description:The date when the item should be shipped. By default, this date is calculated as a date that is earlier than the Requested On date by the number of lead days but not earlier than the current business date.
	`ShipTermsID`Default Navigation	`nvarchar(10)`	Shipping Terms	ShipTerms
Description:The shipping terms used for the customer. This field is available only for blanket sales orders. This field cannot be empty.
	`ShipVia`Default Navigation	`nvarchar(15)`	Ship Via	Carrier
Description:The ship via code that represents the carrier and its service to be used for shipping the ordered goods. This field is available only for blanket sales orders. This field cannot be empty.
	`ShipZoneID`Default Navigation	`nvarchar(15)`	Shipping Zone	ShippingZone
Description:The identification of the shipping zone of the customer to be used to calculate the freight. This field is available only for blanket sales orders. This field cannot be empty.
	`ShippedQty` API	`decimal`	Qty. On Shipments	-
Description:The quantity of the stock item being prepared for shipment and already shipped for this order.
	`SiteID` API Default Navigation	`int`	Warehouse	INSite
Description:The identifier of the warehouse from which the specified quantity of the Inventory Item should be delivered. The field is included in the following foreign keys: - FK.Site. The field is identifier of the Warehouse INSite.INSite.siteID - FK.SiteStatus. The field is a part of the identifier of the Warehouse inventory item status INSiteStatus.INSiteStatus.siteID - FK.LocationStatus. The field is a part of the identifier of the Location inventory item status INLocationStatus.INLocationStatus.siteID - FK.LotSerialStatus. The field is a part of the identifier of the Location inventory item status by Lot Serial numbers INLotSerialStatus.INLotSerialStatus.siteID This field is available only if the Multiple Warehouses feature is enabled on the Enable/Disable Features (CS100000) form.
	`SkipDisc`Nonexistent in DB	`bool?`		-
Description:No description available
	`SkipLineDiscounts`	`bit`	Ignore Automatic Line Discounts	-
Description:Indicates (if selected) that the automatic line discounts are not applied to this line.
	`SortOrder`	`int`	Line Order	-
Description:The order number of the document line. The system regenerates this number automatically when lines are reordered.
	`SrvOrdType`	`char(4)`	Service Order Type	-
Description:No description available
	`SubItemID` API Default Navigation	`int`	Subitem	INSubItem
Description:Represents a Subitem (or subitem code), which is used to indicate the particular size, color, or other variation of the inventory item. The field is included in the following foreign keys: - FK.SubItem. The field is the identifier of the Subitem INSubItem.INSubItem.subItemID - FK.SiteStatus. The field is a part of the identifier of the warehouse container INSiteStatus.INSiteStatus.subItemID - FK.LocationStatus. The field is a part of the identifier of the Location inventory item status INSiteStatus.INLocationStatus.subItemID - FK.LotSerialStatus. The field is a part of the identifier of the Location inventory item status by Lot Serial numbers INLotSerialStatus.INLotSerialStatus.subItemID
	`SubstitutionRequired`	`bit`	Substitution Required	-
Description:A Boolean value that indicates whether the current item has to be replaced with the related item that is specified on the Non-Stock Items (IN202000) or Stock Items (IN202500) form. Shipment for the original item cannot be created if this field is true.
	`SuggestRelatedItems`Nonexistent in DB	`bool?`		-
Description:No description available
	`TaskID` API Default Navigation	`int`	Project Task	PMTask
Description:The task of the project with which this document is associated. The field is included in the FK.Task foreign key. The field is a part of the identifier of the Project Task PMTask.PMTask.projectID. 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.
	`TaxCategoryID` API Default Navigation	`nvarchar(15)`	Tax Category	TaxCategory
Description:The tax category of the goods mentioned in this line. The field is included in the FK.TaxCategory foreign key. The field is the identifier of the tax category TaxCategory.TaxCategory.taxCategoryID. This field is not available for orders of the TR type.
	`TaxZoneID` API Default Navigation	`nvarchar(10)`	Tax Zone	TaxZone
Description:The tax zone associated with the customer location. If no tax zone is specified for this customer location, the system inserts into this field the tax zone assigned to the selling branch. This field is available only for blanket sales orders.
	`TaxableAmt`	`decimal`		-
Description:The line amount that is subject to tax.
	`TranDesc` API	`nvarchar(256)`	Line Description	-
Description:The description provided for the stock item.
	`TranType`Nonexistent in DB	`string`		-
Description:The Inventory Transaction Type of the operation of the line.
	`UOM` API Default Navigation	`nvarchar(6)`	UOM	INUnit
Description:The unit of measure (UOM) used for the item with this inventory ID.
	`UnassignedQty`	`decimal`		-
Description:Contains the difference between the line quantity and the quantity on child split lines, for Inventory Items with lot or serial number.
	`UnbilledAmt`	`decimal`		-
Description:The unbilled amount for a stock item with the Goods for Inventory line type or a non-stock item with the Non-Inventory Goods line type. Calculated as the quantity in the sales order minus the quantity in the invoice or invoices generated for this order, multiplied by the discounted unit price in the order. The unbilled amount for a non-stock item with the Misc. Charge line type is calculated as the line amount minus the line discount (if applicable), and minus the line amount in the invoice or invoices generated for this order. This field is not available for transfer orders.
	`UnbilledQty`	`decimal`	Unbilled Quantity	-
Description:The quantity of stock and non-stock items that were not yet billed.
	`UnitCost`	`decimal`		-
Description:The unit cost at which the item being returned was issued from inventory when it was sold. For the return lines added with a link to an original invoice, this is the cost specified in the inventory issue transaction that was generated on release of the original invoice. For the return lines not linked to an invoice, the unit cost specified in this column depends on the items valuation method and the settings of the warehouse specified in the line. This field is available for orders of the CM, RC, RR, RM or CR type.
	`UnitPrice`	`decimal`	Unit Price	-
Description:The unit price of the item.
	`UnitVolume`	`decimal`		-
Description:The unit volume of the item.
	`UnitWeigth`	`decimal`	Unit Weight	-
Description:The unit weight of the item.
	`UnshippedQty`Nonexistent in DB	`decimal?`	Unshipped Qty.	-
Description:The quantity of the blanket sales order line that have not been shipped yet in child orders. This field is available only for blanket sales orders.
	`VendorID` API Default Navigation	`int`	Vendor	Vendor
Description:The identifier of the Vendor of the sales order. The field is included in the FK.Vendor foreign key. The field is a part of the identifier of the Vendor AP.Vendor.Vendor.bAccountID.
	`VerifyOrderQty`Nonexistent in DB	`decimal?`		-
Description:This will store the initial Order Qty of the SO to the verification process while updating the SOLine/SOLineSplits
	`tstamp`	`timestamp`		-
Description:No description available