Purchase Order Line — entity reference

One item position on a purchase order: PurchaseOrderId plus ItemId, SKUId and Quantity, carrying the resolved buy price (UnitCost, with UnitCost2 overriding it in the amount formula), the discount ladder, a per-line snapshot of up to six taxes in the Tax1..Tax6 name/rate/type/amount slots, and the counters that drive the chain. Three independent pending counters track three different downstream stages against the same ordered quantity: PendingQuantity is what is still to be received, PendingInvoiceQuantity what is still to be billed, PendingOrderQuantity what is still to be pushed out as a dealer sale order. A line can be sourced from a requisition line (RequisitionLineId) or from an auto-order proposal line (AutoPurchaseOrderLineId), and quantity edits are blocked below whatever has already been received or returned.

Fields

Field	Label	Type	Required	What it does
`Amount`	Amount	Calculated (calculated)
`ApplyPostTaxDiscount`	Apply Post Tax Discount	Boolean	Yes
`AutoPurchaseOrderLineId`	Auto Purchase Order Line	Lookup → AutoPurchaseOrderLine		Links the line back to the AutoPurchaseOrderLine proposal it was generated from. It is also the key the planner reads back through: the proposal line's PurchaseOrderQuantity is rolled up from the quantity of the purchase-order lines pointing at it, which is what makes a partly accepted suggestion show a remaining pending quantity.
`BaseAmount`	Base Amount	Calculated (calculated)
`BenefitIndex`	Benefit Index	Number
`BranchId`	Branch	Calculated (calculated)		A denormalised text copy of the parent order's branch identifier, calculated as the parent's BranchId converted to a string so the line can be filtered and grouped without a join. It is text, not a branch lookup, so it cannot be navigated.
`CancelledQuantity`	Cancelled Quantity	Decimal		Quantity struck off the line without being received or billed. It is subtracted in both the pending-receipt and pending-invoice formulas and is also deducted from the ordered quantity that the over-receipt guard compares against, so cancelling reduces how much may still be received.
`ContractDiscount`	Contract Discount	Percent
`ContractDiscountAmount`	Contract Discount Amount	Currency
`ConversionRatio`	Conversion Ratio	Number
`ConversionRatio1`	Conversion Ratio 1	Number
`CreatedById`	Created By	Lookup → UserAccount	Yes
`CreatedDateTime`	Created Date	DateAndTime	Yes
`Discount`	Discount	Percent
`Discount2`	Cash Discount	Percent
`DiscountAmount`	Discount Amount	Currency
`DiscountAmount2`	Cash Discount Amount	Currency
`ExcludeInAutoOrder`	Exclude In Auto Order	Boolean	Yes	Opts this line out of the replenishment pipeline: the procurement pipeline queries that feed the Forecasting engine skip lines carrying it, so an excluded line's outstanding quantity is not counted as inbound supply when projecting stock. The same opt-out exists on requisition and sale-order lines.
`ExternalId`	External	Text, unique
`GrossAmount`	Gross Amount	Calculated (calculated)
`Id`	Id	Guid	Yes
`InventoryFulfilmentOrderLineId`	Inventory Fulfillment Order Line	Lookup → InventoryFulfilmentOrderLine
`InventoryStockId`	Stock	Lookup → InventoryStock		An optional pointer to the specific stock bucket row (item, SKU, branch and storage location) this line is meant to replenish. Nothing in the procurement code writes or reads it; the actual stock effect of the order comes from the goods-receipt lines' ledger postings.
`InvoiceQuantity`	Invoice Quantity	Number		How much of this line has been billed, rolled up from the quantity on the linked bill lines. It drives PendingInvoiceQuantity (quantity minus billed minus cancelled), which is the gate the release-invoice actions check.
`IsSchemeGenerated`	Is Scheme Generated	Boolean	Yes	Marks a line the promotional scheme engine created as a benefit (typically a free or discounted give-away item) rather than one a buyer keyed. Resetting the document's schemes removes these lines, so do not treat them as buyer intent.
`ItemAliasId`	Item Alias	Lookup → ItemAlias
`ItemAlternateId`	Item Alternate	Lookup → ItemAlternate
`ItemComponentId`	Item Component	Lookup → ItemComponent
`ItemId`	Item	Lookup → Item
`ItemLotTypeId`	Item Lot Type	Lookup → ItemLotType
`ItemName`	ItemName	Text
`ModifiedById`	Modified By	Lookup → UserAccount	Yes
`Name`	Document Number	Text
`NetDiscount`	Net Discount	Calculated (calculated)
`NetSchemeDiscount`	Net Scheme Discount	Calculated (calculated)
`OrderQuantity`	Order Quantity	Number		How much of this line has been pushed out as a dealer sale order, rolled up from the sale order lines that point back at it. It drives PendingOrderQuantity and is unrelated to receiving or billing; do not read it as the ordered quantity, which is Quantity.
`OriginalItemId`	Original Item	Lookup → Item		The item originally requested, kept when the line was later substituted (through an alternate or alias item) so the substitution stays visible. ItemId is what is actually being bought and what everything downstream receives and bills.
`OwnerId`	Owner	Lookup → UserAccount	Yes
`PackagePurchaseOrderLineId`	Purchase Order Line	Lookup → PurchaseOrderLine		Self-reference from a component line to the package (kit) line it was expanded under, written by the apply-package-configuration action. Component lines are ordinary purchase lines and are received and billed in their own right, so summing a package line and its components double-counts.
`PartnerAccountId`	Partner Account	Calculated		Declared on the line as text rather than as a lookup to Account, unlike the header field of the same name, so it holds a stringified identifier at best and has no referential integrity. Resolve the counterparty from the parent order's PartnerAccountId instead.
`PendingInvoiceQuantity`	Pending Invoice Quantity	Calculated (calculated)
`PendingOrderQuantity`	Pending Order Quantity	Calculated (calculated)
`PendingQuantity`	Pending Quantity	Calculated (calculated)
`PriceAsOnDate`	Price As On Date	Date
`PriceListId`	Price List	Lookup → PriceList
`PriceListRuleId`	Price List Rule	Lookup → PriceListRule
`PurchaseOrderId`	Purchase Order	Lookup → PurchaseOrder
`PurchaseOrderLineNumber`	PurchaseOrderLineNumber	Number
`PurchaseRequisitionId`	Purchase Requisition	Lookup → Requisition
`Quantity`	Quantity	Number	Yes
`ReceiptQuantity`	Receipt Quantity	Number		How much of this line has been drawn into goods receipts, and the counter that closes the line down: PendingQuantity is quantity minus this minus cancelled quantity. It is rolled up from the linked goods-receipt lines' OrderedQuantity - the quantity released to the receipt - not from what was physically counted in, so a receipt that was released but not yet received still reduces the pending quantity.
`RecordTypeId`	Record Type	Guid, hidden
`RequestedQuantity`	Requested Quantity	Number
`RequisitionLineId`	Requisition Line	Lookup → RequisitionLine
`ReturnedQuantity`	Returned Quantity	Number		Quantity returned to the supplier against this line, rolled up from credit-note lines whose parent credit note is a bill return. Together with ReceiptQuantity it forms the transacted quantity that the line's ordered quantity may not be reduced below.
`SchemeBenefitId`	Scheme Benefit	Lookup → SchemeBenfit
`SchemeDiscount`	Scheme Discount	Percent
`SchemeDiscount1`	Scheme Discount	Percent
`SchemeDiscountAmount`	Scheme Discount Amount	Currency
`SchemeLineId`	Scheme Line	Lookup → SchemeLine
`SchemeRewardPoints`	Scheme Reward Points	Number
`ServiceOrderLineId`	Service Order Line	Lookup → ServiceOrderLine
`SkipScheme`	Skip Scheme	Boolean	Yes
`SKUId`	SKU	Lookup → SKU
`Tax1`	Tax 1	Currency
`Tax1Name`	Tax Name 1	Text
`Tax1Rate`	Tax Rate 1	Currency
`Tax1Type`	Tax Type 1	Text
`Tax2`	Tax 2	Currency
`Tax2Name`	Tax Name 2	Text
`Tax2Rate`	Tax Rate 2	Currency
`Tax2Type`	Tax Type 2	Text
`Tax3`	Tax 3	Currency
`Tax3Name`	Tax Name 3	Text
`Tax3Rate`	Tax Rate 3	Currency
`Tax3Type`	Tax Type 3	Text
`Tax4`	Tax 4	Currency
`Tax4Name`	Tax Name 4	Text
`Tax4Rate`	Tax Rate 4	Currency
`Tax4Type`	Tax Type 4	Text
`Tax5`	Tax 5	Currency
`Tax5Name`	Tax Name 5	Text
`Tax5Rate`	Tax Rate 5	Currency
`Tax5Type`	Tax Type 5	Text
`Tax6`	Tax 6	Currency
`Tax6Name`	Tax Name 6	Text
`Tax6Rate`	Tax Rate 6	Currency
`Tax6Type`	Tax Type 6	Text
`TaxAmount`	Tax Amount	Currency
`TaxGroupId`	Tax Group	Lookup → TaxGroup
`UIProps`	UI Props	Text
`UnitCost`	Unit Cost	Currency
`UnitCost2`	Unit Cost 2	Currency
`UOM`	UOM	PickList
`UOM1`	UOM 1	PickList		Values: Each, kWh.
`UOMQuantity`	UOM Quantity	Number
`UOMQuantity1`	UOM Quantity1	Number
`UpdatedDateTime`	Modified Date	DateAndTime	Yes

Actions

Action	Label	Type	What it does
`BulkDelete`	Delete	Delete	Delete
`Clone`	Clone	ServerAction (`Clone`)	Create a copy of this record
`Delete`	Delete	Delete	Delete
`DeleteInList`	Delete	Delete	Delete
`Edit`	Edit	Edit	Edit
`EditEntity`	Edit	Edit	EditEntity
`EditInLine`	Edit	EditInline	Edit
`HeaderEdit`	HeaderEdit	EditInline	Edit
`Import`	Import	UIAction	A layout-driven bulk load of order lines from a file rather than a server action; the lines it produces go through the ordinary line save pipeline, so minimum, maximum and lot-multiple order-quantity rules and price resolution all still apply to each imported row.
`MainNew`	New	New	New
`New`	Quick Add	NewInline	New
`ProductCatalogue`	Product Catalogue	UIAction	ProductCatalogue

Validations

Validation	Applies to	Error message	Notes
Item Required Validation	`ItemId`, Error	Item is Required.	Item is Required.
Tax Group Validation	Error, inactive	Tax Group Type must be "Line Level".	Ensures tax group type is 'Line Level' for purchase order lines

Lookup filters

Filter	Lookup field	Notes
Active Item	`ItemId`
Sku For Item	`SKUId`

ItemAlternate — looks up via ItemAlternateId
UserAccount — looks up via OwnerId
Item — looks up via OriginalItemId
TaxGroup — looks up via TaxGroupId
ItemComponent — looks up via ItemComponentId
ServiceOrderLine — looks up via ServiceOrderLineId
SKU — looks up via SKUId
PurchaseOrderLine — looks up via PackagePurchaseOrderLineId
InventoryStock — looks up via InventoryStockId
UserAccount — looks up via CreatedById
InventoryFulfilmentOrderLine — looks up via InventoryFulfilmentOrderLineId
RequisitionLine — looks up via RequisitionLineId
SchemeBenefit — looks up via SchemeBenefitId
ItemAlias — looks up via ItemAliasId
PriceList — looks up via PriceListId
PurchaseOrder — looks up via PurchaseOrderId
ItemLotType — looks up via ItemLotTypeId
AutoPurchaseOrderLine — looks up via AutoPurchaseOrderLineId
PriceListRule — looks up via PriceListRuleId
SchemeLine — looks up via SchemeLineId
Requisition — looks up via PurchaseRequisitionId
Item — looks up via ItemId
UserAccount — looks up via ModifiedById
SchemeLedger — referenced by via PurchaseOrderLineId
GoodsReceiptLine — referenced by via PurchaseOrderLineId
DeliveryOrderLine — referenced by via PurchaseOrderLineId
PurchaseOrderRequisition — referenced by via PurchaseOrderLineId
PurchaseOrderLine — referenced by via PackagePurchaseOrderLineId
BillLine — referenced by via PurchaseOrderLineId
OrderLine — referenced by via PurchaseOrderLineId
Requisition — referenced by via PurchaseOrderLineId
CreditNoteLine — referenced by via PurchaseOrderLineId
ServiceOrderLine — referenced by via PurchaseOrderLineId
ShipmentLine — referenced by via PurchaseOrderLineId

Purchase Order Line — entity reference

Fields

Actions

Validations

Lookup filters

Related entities

Related topics