Amount | Amount | Calculated (calculated) | | The line value, quantity times unit cost, computed after the price rules have resolved the unit cost and recomputed once more if the header's budget cap scaled the quantity down. Lines that no price rule matched stay at zero and are excluded from budget trimming. |
AutoOrderId | Auto Order | Lookup → AutoOrder | | |
AverageConsumption | Average Consumption | Number | | The item's average consumption per lead-time period from its inventory attributes, averaged across matching rows and rounded to a whole number on the line. It multiplies lead time to form the reorder point, so an item with no consumption figure has a reorder point of just the minimum quantity. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DerivedQuantity | Derived Quantity | Calculated (calculated) | | |
ExternalId | External | Text, unique | | |
Id | Id | Guid | Yes | |
ItemId | Item | Lookup → Item | | |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | |
LeadTime | Lead Time | Number | | |
MaximumQuantity | Maximum Quantity | Number | | |
MinimumQuantity | Minimum Quantity | Number | | The item's minimum order quantity from its inventory attributes, averaged across matching rows. In the forecasting calculation it is a term in the reorder point (lead time times average consumption, plus this), so raising it makes replenishment trigger sooner, not just larger. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | Yes | |
OpenOrderQuantity | Open Order Quantity | Number | | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PendingPurchaseOrderQuantity | Pending Purchase Order Quantity | Number | | Inbound supply already on order that the forecasting engine added to the projection, captured only when the header's pending-purchase-order include flag is set. It is kept here for explainability but deliberately not copied into OpenOrderQuantity, because it is already netted into ProjectedQuantity and adding it again would double-count on-order supply. |
PendingQuantity | Pending Quantity | Calculated (calculated) | | |
PendingQuoteQuantity | Pending Quote Quantity | Number | | Do not read a zero here as evidence that no quotations exist. |
PendingRequisitionQuantity | Pending Requisition Quantity | Number | | Committed internal demand from open requisitions that the forecasting engine subtracted when projecting stock, captured only when the header's requisition include flag is set. Forecasting is the only engine that reacts to open requisitions at all. |
PendingSaleOrderQuantity | Pending Sale Order Quantity | Number | | Committed outbound demand from open sale orders that the forecasting engine subtracted when projecting stock, captured only when the header's sale-order include flag is set. |
PendingShipmentQuantity | Pending Shipment Quantity | Number | | Inbound supply already in transit that the forecasting engine added when projecting stock forward, captured only when the header's in-transit include flag is set; otherwise it stays at zero. Part of the frozen calculation snapshot, not a live figure. |
PriceAsOnDate | Price As On Date | Date | | |
PriceListId | Price List | Lookup → PriceList | | |
PriceListRuleId | Price List Rule | Lookup → PriceListRule | | |
ProjectedQuantity | Projected Quantity | Number | | |
PurchaseOrderQuantity | Purchase Order Quantity | Number | | How much of this proposal has actually been released into purchase orders, rolled up from the quantity of purchase-order lines that point back at this line. PendingQuantity is quantity minus this, which is what makes a partially accepted suggestion still releasable later. |
Quantity | Quantity | Number | Yes | The working order quantity for the proposal line: it starts equal to SuggestedQuantity and is then scaled down in place if the header's budget cap bites. It is what the line amount is priced from, and it is the quantity rolled up into the proposal's total. |
QuantityAvailable | Quantity Available | Number | | The on-hand available stock the forecasting engine read for this item and SKU at generation time, frozen onto the line as part of the explainability snapshot. It is the starting point of the projection, not a live figure - it does not track stock afterwards. |
RecordTypeId | Record Type | Guid, hidden | | |
ReorderQuantity | Reorder Quantity | Number | | The reorder quantity from the item's inventory attributes, averaged across the matching attribute rows. Note that the forecasting engine records it for explainability but does not order it: the quantity it proposes is the maximum order quantity minus the projected quantity. The minimum-stock engine, by contrast, does order exactly this quantity when it is set. |
RequestedQuantity | Requested Quantity | Number | | |
SKUId | SKU | Lookup → SKU | | |
SuggestedQuantity | Suggested Quantity | Number | | |
UIProps | UI Props | Text | | |
UnitCost | Unit Cost | Currency | | The purchase price resolved for the proposed line by the shared price-rule service after the lines are generated, against the header's price list and as-of date. It is copied onto the purchase-order line when the proposal is released, so an unpriced proposal produces an unpriced order line. |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |