AMForecastSalesDetail

PX.Objects.AMRelease 2025.2

Forecast Sales Details Class

Select a row for its description 27 of 27 fields

	Field Name	Type	Display Name	Foreign Key
	`AMIncludeSupplyPlan`	`bit`		-
Description:Will RMA supply lines be included in MRP
	`AcctCD`	`nvarchar`	Customer	-
Description:The human-readable identifier of the business account that is specified by the user or defined by the auto-numbering sequence during the creation of the account. This field is a natural key, as opposed to the surrogate key BAccountID.
	`AcctName`	`nvarchar`	Customer Name	-
Description:The full business account name (as opposed to the short identifier AcctCD).
	`ActualOrderQtyForecastUOM`Nonexistent in DB	`decimal?`		-
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.
	`BaseActualOrdersQty`Nonexistent in DB	`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.
	`BaseBlanketOpenQty`Nonexistent in DB	`decimal?`		-
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.
	`BaseOrderQty`	`decimal`		-
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.
	`Behavior`	`nvarchar`		-
Description:No description available
	`BlanketOpenQtyForecastUOM`Nonexistent in DB	`decimal?`	Blanket Open Quantity	-
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.
	`Completed`	`bit`		-
Description:A Boolean value that indicates whether the line is completed.
	`ForecastBaseQty`	`decimal`		-
Description:No description available
	`ForecastID`	`nvarchar`	Forecast ID	-
Description:No description available
	`ForecastQty`	`decimal`		-
Description:No description available
	`INDocType`	`nvarchar`		-
Description:No description available
	`InventoryID`Default Navigation	`int`	Inventory ID	-
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
	`LineNbr`	`int`	Line Nbr.	-
Description:The line number of the document.
	`LineType`	`nvarchar`		-
Description:The type of the line. The field can have one of the values listed in SOLineType.
	`Operation`	`nvarchar`		-
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.
	`OrderNbr`	`nvarchar`	Order Nbr	-
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
	`OrderQtyForecastUOM`Nonexistent in DB	`decimal?`	Ordered Qty	-
Description:Order qty forecast u o m
	`OrderType`	`nvarchar`	Order Type	-
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
	`RequestDate`	`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.
	`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.
	`ShipDate`	`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.
	`SiteID`Default Navigation	`int`	Warehouse	-
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.
	`TimePeriod`	`nvarchar`	Time Period	-
Description:Natural key to select a forecast period