xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField SalesCRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Auto Purchase Order Line — entity reference
REFERENCE · Last reviewed

Auto Purchase Order Line — entity reference

One proposed purchase line inside an AutoOrder, together with the frozen explainability snapshot of how that proposal was reached. On the Forecasting path each line records the exact inputs to its own calculation - QuantityAvailable, PendingShipmentQuantity, PendingPurchaseOrderQuantity, PendingRequisitionQuantity, PendingSaleOrderQuantity and the resulting ProjectedQuantity - alongside the planning parameters (LeadTime, AverageConsumption, MinimumQuantity, MaximumQuantity, ReorderQuantity) averaged across the item's inventory-attribute rows. SuggestedQuantity is the engine's recommendation, DerivedQuantity is what may actually be released, PurchaseOrderQuantity accumulates what has been released, and PendingQuantity is the remainder. Order generation reads DerivedQuantity and PendingQuantity, so a line whose suggestion netted to nothing is skipped.

Fields

FieldLabelTypeRequiredWhat it does
AmountAmountCalculated (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.
AutoOrderIdAuto OrderLookup → AutoOrder
AverageConsumptionAverage ConsumptionNumberThe 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.
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated DateDateAndTimeYes
DerivedQuantityDerived QuantityCalculated (calculated)
ExternalIdExternalText, unique
IdIdGuidYes
ItemIdItemLookup → Item
ItemLotTypeIdItem Lot TypeLookup → ItemLotType
LeadTimeLead TimeNumber
MaximumQuantityMaximum QuantityNumber
MinimumQuantityMinimum QuantityNumberThe 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.
ModifiedByIdModified ByLookup → UserAccountYes
NameDocument NumberTextYes
OpenOrderQuantityOpen Order QuantityNumber
OwnerIdOwnerLookup → UserAccountYes
PendingPurchaseOrderQuantityPending Purchase Order QuantityNumberInbound 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.
PendingQuantityPending QuantityCalculated (calculated)
PendingQuoteQuantityPending Quote QuantityNumberDo not read a zero here as evidence that no quotations exist.
PendingRequisitionQuantityPending Requisition QuantityNumberCommitted 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.
PendingSaleOrderQuantityPending Sale Order QuantityNumberCommitted 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.
PendingShipmentQuantityPending Shipment QuantityNumberInbound 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.
PriceAsOnDatePrice As On DateDate
PriceListIdPrice ListLookup → PriceList
PriceListRuleIdPrice List RuleLookup → PriceListRule
ProjectedQuantityProjected QuantityNumber
PurchaseOrderQuantityPurchase Order QuantityNumberHow 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.
QuantityQuantityNumberYesThe 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.
QuantityAvailableQuantity AvailableNumberThe 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.
RecordTypeIdRecord TypeGuid, hidden
ReorderQuantityReorder QuantityNumberThe 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.
RequestedQuantityRequested QuantityNumber
SKUIdSKULookup → SKU
SuggestedQuantitySuggested QuantityNumber
UIPropsUI PropsText
UnitCostUnit CostCurrencyThe 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.
UpdatedDateTimeModified DateDateAndTimeYes

Actions

ActionLabelTypeWhat it does
BulkDeleteDeleteDeleteDelete
CloneCloneServerAction (Clone)Create a copy of this record
DeleteDeleteDeleteDelete
DeleteInListDeleteDeleteDelete
DeleteinRowDeleteDeleteDelete
EditEditEditEdit
EditinLineEditEditInlineEdit
EditPopUpEditEditEdit
NewNewNewNew
NewInLineQuick AddNewInlineNew

Validations

ValidationApplies toError messageNotes
Quantity Rule ValidationQuantity, ErrorQuantity cannot be less than 1.Quantity cannot be less than 1.
Unit Cost Rule ValidationUnitCost, Error, inactiveUnit cost cannot be negativeUnit cost cannot be negative