Stratus Aperture

API Family:Default

Version:22.200.001

Properties

Select a row for its DAC field and description

	Property	Type	Data Type
	`Account`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.SalesAcctID` 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.
	`Allocations`	`List`	SalesOrderDetailAllocation
DAC Field:Not mapped to a DAC field Description:No description available
	`AlternateID`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.AlternateID` Description:The alternate ID for the item, such as the barcode or the inventory ID used by the customer.
	`Amount`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CuryLineAmt` 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).
	`AutoCreateIssue`	`BooleanValue`	boolean
DAC Field:`PX.Objects.SO.SOLine.AutoCreateIssueLine` 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.
	`AverageCost`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.AvgCost` Description:Average cost of the Inventory Item of the line.
	`Branch`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.BranchID` 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`	`BooleanValue`	boolean
DAC Field:`PX.Objects.SO.SOLine.CalculateDiscountsOnImport` Description:A Boolean value that indicates whether the line discounts will be calculated automaticly.
	`Commissionable`	`BooleanValue`	boolean
DAC Field:`PX.Objects.SO.SOLine.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.
	`Completed`	`BooleanValue`	boolean
DAC Field:`PX.Objects.SO.SOLine.Completed` Description:A Boolean value that indicates whether the line is completed.
	`CostCode`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.CostCodeID` 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.
	`CustomerOrderNbr`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.CustomerOrderNbr` 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.
	`DiscountAmount`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CuryDiscAmt` Description:The amount of the line-level discount of the line (in the currency of the document).
	`DiscountCode`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.DiscountID` 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.
	`DiscountedUnitPrice`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CuryDiscPrice` Description:The unit price, which has been recalculated after the application of discounts (in the currency of the document).
	`DiscountPercent`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.DiscPct` 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.
	`ExtendedPrice`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CuryExtPrice` Description:The extended price of the item line (in the currency of the document).
	`FreeItem`	`BooleanValue`	boolean
DAC Field:`PX.Objects.SO.SOLine.IsFree` 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.
	`InventoryID`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.InventoryID` 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
	`InvoiceLineNbr`	`IntValue`	int
DAC Field:`PX.Objects.SO.SOLine.InvoiceLineNbr` 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`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.InvoiceNbr` 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`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.InvoiceType` 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
	`LastModifiedDate`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.LastModifiedDateTime` Description:No description available
	`LineDescription`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.TranDesc` Description:The description provided for the stock item.
	`LineNbr`	`IntValue`	int
DAC Field:`PX.Objects.SO.SOLine.LineNbr` Description:The line number of the document.
	`LineType`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.LineType` Description:The type of the line. The field can have one of the values listed in SOLineType.
	`Location`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.LocationID` 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
	`ManualDiscount`	`BooleanValue`	boolean
DAC Field:`PX.Objects.SO.SOLine.ManualDisc` Description:A Boolean value that indicates whether the discount has been applied manually.
	`MarkForPO`	`BooleanValue`	boolean
DAC Field:`PX.Objects.SO.SOLine.POCreate` 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.
	`OpenQty`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.OpenQty` Description:The quantity of the item to be shipped. That is, the total quantity minus the quantity shipped according to closed shipment documents.
	`Operation`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.Operation` 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.
	`OrderQty`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.OrderQty` Description:The quantity of the item sold in the unit of measure.
	`OvershipThreshold`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CompleteQtyMax` Description:The maximum percentage of goods shipped (with respect to the ordered quantity) allowed by the customer.
	`POSource`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.POSource` Description:The purchase order source to be used to fulfill this line. The field can have one of the values listed in INReplenishmentSource.
	`ProjectTask`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.TaskID` 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.
	`PurchaseWarehouse`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.POSiteID` 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.
	`PurchasingDetails`	`List`	PurchasingDetail
DAC Field:Not mapped to a DAC field Description:No description available
	`VendorID`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.VendorID` 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.
	`QtyOnShipments`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.ShippedQty` Description:The quantity of the stock item being prepared for shipment and already shipped for this order.
	`ReasonCode`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.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.
	`RequestedOn`	`DateTimeValue`	DateTime
DAC Field:`PX.Objects.SO.SOLine.RequestDate` Description:The date when the customer wants to receive the goods. The default value is specified in the Requested On field of the order.
	`SalespersonID`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.SalesPersonID` 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.
	`SchedOrderDate`	`DateTimeValue`	DateTime
DAC Field:`PX.Objects.SO.SOLine.SchedOrderDate` 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.
	`ShipOn`	`DateTimeValue`	DateTime
DAC Field:`PX.Objects.SO.SOLine.ShipDate` 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.
	`ShippingRule`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.ShipComplete` Description:The way the line item should be shipped. The field can have one of the values listed in SOShipComplete.
	`ShipToLocation`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.CustomerLocationID` 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.
	`Subitem`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.SubItemID` 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
	`TaxCategory`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.TaxCategoryID` 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.
	`TaxZone`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.TaxZoneID` 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.
	`UnbilledAmount`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CuryUnbilledAmt` 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).
	`UndershipThreshold`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CompleteQtyMin` Description:The minimum percentage of goods shipped (with respect to the ordered quantity) for the system to mark the order as completely shipped.
	`UnitCost`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CuryUnitCost` Description:The unit cost at which the item being returned was issued from inventory when it was sold (in the currency of the document).
	`UnitPrice`	`DecimalValue`	decimal
DAC Field:`PX.Objects.SO.SOLine.CuryUnitPrice` Description:The unit price of the item (in the currency of the document).
	`UOM`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.UOM` Description:The unit of measure (UOM) used for the item with this inventory ID.
	`WarehouseID`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.SiteID` 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.
	`AssociatedOrderLineNbr`	`IntValue`	int
DAC Field:`PX.Objects.SO.SOLine.AssociatedOrderLineNbr` Description:An optional associated order line number.
	`GiftMessage`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.GiftMessage` Description:A gift message associated with this sales order line.
	`ManualPrice`	`BooleanValue`	boolean
DAC Field:`PX.Objects.SO.SOLine.ManualPrice` 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.
	`LotSerialNbr`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.LotSerialNbr` 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.
	`NoteID`	`GuidValue`	Guid
DAC Field:`PX.Objects.SO.SOLine.NoteID` Description:No description available
	`ExternalRef`	`StringValue`	string
DAC Field:`PX.Objects.SO.SOLine.ExternalRef` Description:The external reference number for this sales order line.

Available in Versions

25.200.001 24.200.001 23.200.001 22.200.001 20.200.001