Order Line — entity reference

One item position of a sales Order (OrderId plus ItemId and Quantity) carrying its own pricing, discount, tax and inventory context. Each processing stage keeps a cumulative counter that the platform rolls up from the child documents — FulfilmentOrderQuantity from inventory-fulfilment order lines, FulfilmentAllocatedQuantity from allocation lines, PickedQuantity and the three picking counters from picking lines, InvoiceQuantity (split into AllocatedInvoicedQuantity and OTCInvoicedQuantity) from invoice lines, DeliveryQuantity from delivery lines, ReturnedQuantity from credit-note lines — and every Pending field is calculated as Quantity minus the relevant counter minus CancelledQuantity. The money fields are calculated too, not stored input: BaseAmount, then NetDiscount and NetSchemeDiscount, then Amount and GrossAmount. RequestedQuantity is virtual and exists only as the per-line argument of the order's Selective actions.

Fields

Field	Label	Type	Required	What it does
`AllocatedInvoicedQuantity`	Allocated Invoiced Quantity	Number		The part of InvoiceQuantity that came from invoice lines carrying an InventoryFulfilmentAllocationLineId — quantity invoiced out of allocated stock. Its counterpart OTCInvoicedQuantity is the sum where that link is absent.
`Amount`	Amount	Calculated (calculated)		Calculated as BaseAmount less NetSchemeDiscount and NetDiscount — unless ApplyPostTaxDiscount is set, in which case the discounts are held back for GrossAmount and Amount is simply BaseAmount. Rolls up into Order.LineSubTotal.
`ApplyPostTaxDiscount`	Apply Post Tax Discount	Boolean		Switches the discount base for the whole line. When false, discounts come off BaseAmount before tax; when true they are computed on BaseAmount plus TaxAmount and subtracted after tax, which changes NetDiscount, NetSchemeDiscount, Amount and GrossAmount together.
`BaseAmount`	Base Amount	Calculated (calculated)		Calculated as (Quantity - CancelledQuantity) times the effective unit price, where UnitPrice2 takes precedence over UnitPrice whenever it is greater than zero. Every other money field on the line derives from it.
`BenefitIndex`	Benefit Index	Number		Positional selector for the applied benefit when a scheme line offers several; it is passed to ApplyScheme as benefitIndex and cleared again by ResetScheme.
`BillingFrequency`	Billing Frequency	Text
`BillingType`	Billing Type	PickList		Values: Advance, Arrears.
`BranchId`	Branch	Text
`CancelledQuantity`	Cancelled Quantity	Number		Cumulative cancelled quantity, increased by CancelOrder and SelectiveCancelOrder by the line's pending fulfilment quantity (or by the requested amount). It is subtracted in BaseAmount and in every Pending* formula, so cancelling both stops further processing and reduces the line's value.
`ChargeType`	Charge Type	PickList		Values: One Time, Recurring, Usage.
`ContractDiscount`	Contract Discount	Percent
`ContractDiscountAmount`	Contract Discount Amount	Currency		Explicit value of the third discount pair; it overrides the ContractDiscount percentage inside NetDiscount and is one of the fields copied across when order lines are generated from a quote or an opportunity.
`ConversionRatio`	Conversion Ratio	Number
`ConversionRatio1`	Conversion Ratio 1	Number
`CreatedById`	Created By	Lookup → UserAccount	Yes
`CreatedDateTime`	Created Date	DateAndTime	Yes
`DeliveryQuantity`	Delivery Quantity	Number		Cumulative delivered quantity, rolled up from delivery-order lines. It reduces PendingDeliveryQuantity and is also subtracted inside PendingPickingQuantity, so despatching picked stock closes the picking loop.
`Discount`	Discount	Percent		Regular discount percentage. On insert a non-zero header Order.Discount overwrites it, and on save it is forced to zero whenever DiscountAmount is supplied — the explicit amount always wins.
`Discount2`	Discount2	Decimal	Yes
`DiscountAmount`	Discount Amount	Currency		Explicit regular discount value. Supplying it zeroes the Discount percentage on save and takes precedence over it inside NetDiscount.
`DiscountAmount2`	Cash Discount Amount	Currency		Explicit value of the second, independent discount pair, labelled 'Cash Discount Amount'. Supplying it zeroes the Discount2 percentage on save and takes precedence over it inside NetDiscount, where it is added on top of the regular and contract discounts.
`DiscountGroupRuleId`	Discount Group Rule	Lookup → DiscountGroupRule
`ExcludeInAutoOrder`	Exclude In Auto Order	Boolean
`ExternalId`	External	Text, unique
`FulfilmentAllocatedQuantity`	Fulfilment Allocated Quantity	Number		Cumulative quantity reserved against specific stock lots, rolled up from InventoryFulfilmentAllocationLine.Quantity. It is the base of PendingFulfilmentAllocationQuantity, of PendingPickingQuantity and of the allocation-backed invoicing path.
`FulfilmentOrderQuantity`	Fulfilment Order Quantity	Number		Cumulative quantity placed on inventory fulfilments, rolled up automatically from InventoryFulfilmentOrderLine.Quantity — the handler treats it as a system field, so it is never entered by hand. PendingFulfilmentOrderQuantity is Quantity minus this minus CancelledQuantity.
`GrossAmount`	Gross Amount	Calculated (calculated)		Calculated line total: Amount plus TaxAmount, minus the scheme and regular discounts when ApplyPostTaxDiscount is set (they were already removed inside Amount otherwise). Rolls up into Order.TotalOrderAmount and Order.TotalLineGrossAmount.
`Id`	Id	Guid	Yes
`InventoryLedgerId`	Inventory Ledger	Lookup → InventoryLedger		Set once the line has been posted to the inventory ledger. PerformInventoryPosting selects exactly the lines where it is still empty, so it doubles as the already-posted marker and the action fails validation when no such line remains.
`InventoryStockId`	Stock	Lookup → InventoryStock		The InventoryStock bucket resolved for this line's item, SKU, lot type and storage location. It is resolved on insert and re-resolved whenever any of those four fields change, and it is what StockAvailable and StockInHand read through.
`InvoiceGroup`	Invoice Group	PickList		Values: Product, Part, Insurance.
`InvoiceQuantity`	Invoice Quantity	Decimal		Cumulative invoiced quantity, rolled up from InvoiceLine.Quantity and split in the same pass into AllocatedInvoicedQuantity and OTCInvoicedQuantity depending on whether the invoice line carries an allocation line. PendingInvoiceQuantity is Quantity minus CancelledQuantity minus this.
`IsILPosted`	IL Posted	Boolean
`IsILPostingApproved`	IL Posting Approved	Boolean
`IsPriceBundled`	Price Bundled	Boolean		Marks the line as priced inside a bundle. Validation rejects saving such a line with a UnitPrice above zero, on the update path as well as on insert.
`IsSchemeGenerated`	Scheme Generated	Boolean		True on lines the promotion engine created as a scheme benefit rather than lines a user entered. The engine excludes such lines when it aggregates the document to test scheme qualification, so generated benefit lines cannot themselves earn further benefits.
`ItemAliasId`	Item Alias	Lookup → ItemAlias
`ItemAlternateId`	Item Alternate	Lookup → ItemAlternate
`ItemComponentId`	Item Component	Lookup → ItemComponent		The package component definition this exploded line came from. It is the identifier supplied to ApplyPackageConfiguration when choosing and sizing the components of a configurable package line.
`ItemId`	Item	Lookup → Item	Yes
`ItemLotId`	Item Lot	Lookup → ItemLot		A specific stock lot named on the line. When fulfilment is released, this value is copied onto the inventory fulfilment order line that is created, alongside the line's item, SKU and storage location.
`ItemLotTypeId`	Item Lot Type	Lookup → ItemLotType
`ItemName`	Item Name	Text
`ItemServiceContractId`	Item Service Contract	Lookup → ItemServiceContract
`LimitExpiryDays`	Limit Expiry Days	LargeNumber
`ModifiedById`	Modified By	Lookup → UserAccount	Yes
`Name`	Document Number	Text
`NetDiscount`	Net Discount	Calculated (calculated)		Calculated total of the three discount pairs — regular (Discount / DiscountAmount), cash (Discount2 / DiscountAmount2) and contract (ContractDiscount / ContractDiscountAmount). Within each pair an explicit amount overrides the percentage, and a percentage is taken on BaseAmount, or on BaseAmount plus TaxAmount when ApplyPostTaxDiscount is set.
`NetSchemeDiscount`	Net Scheme Discount	Calculated (calculated)		Calculated promotion discount for the line: SchemeDiscountAmount when supplied, otherwise SchemeDiscount applied as a percentage of BaseAmount (or of BaseAmount plus TaxAmount when ApplyPostTaxDiscount is set). Held separately from NetDiscount so promotion value can be reported on its own.
`OpportunityLineId`	Opportunity Line	Lookup → OpportunityLine
`OrderDiscount`	Order Discount	Calculated (calculated)		Calculated mirror of the parent Order.Discount, refreshed whenever the header discount changes. On insert a non-zero value is copied into the line's own Discount, and it is that copy — not this field — which feeds NetDiscount.
`OrderId`	Order	Lookup → Order
`OriginalItemId`	Original Item	Lookup
`OTCInvoicedQuantity`	OTC Invoiced Quantity	Number		Over-the-counter invoiced quantity: the part of InvoiceQuantity from invoice lines with no allocation line behind them. Credit notes raised against this line add back into it alongside InvoiceQuantity.
`OwnerId`	Owner	Lookup → UserAccount	Yes
`PackageOrderLineId`	Order Line	Lookup → OrderLine		Self-reference to the parent package line: component lines exploded from a package item point back at the line that owns them. Editing the parent's quantity recalculates the children, deleting the parent cascades to them, and changing Item or SKU on either a package line or a component is rejected.
`PartnerAccountId`	Partner Account	Calculated
`PendingAllocatedInvoicedQuantity`	Pending Allocated Invoiced Quantity	Calculated (calculated)		Calculated: for an inventory-tracked item it is FulfilmentAllocatedQuantity minus AllocatedInvoicedQuantity — reserved but not yet billed; for an item that does not track inventory it falls back to PendingInvoiceQuantity.
`PendingDeliveryQuantity`	Pending Delivery Quantity	Calculated (calculated)
`PendingFulfilmentAllocationQuantity`	Pending Fulfilment Allocation Quantity	Calculated (calculated)
`PendingFulfilmentOrderQuantity`	Pending Fulfilment Order Quantity	Calculated (calculated)
`PendingInvoiceQuantity`	Pending Invoice Quantity	Calculated (calculated)
`PendingPickingQuantity`	Pending Picking Quantity	Calculated (calculated)
`PickedQuantity`	Picked Quantity	Number		Cumulative quantity picked, rolled up from InventoryFulfilmentPickingLine.Quantity together with the three other picking counters. Note that PendingPickingQuantity is built from PickingRequestedQuantity rather than from this field.
`PickingCancelQuantity`	Picking Cancel Quantity	Number
`PickingRequestedQuantity`	Picking Requested Quantity	Number		Cumulative quantity requested on picking lines, rolled up from InventoryFulfilmentPickingLine.RequestedQuantity. PendingPickingQuantity subtracts it (and DeliveryQuantity) from FulfilmentAllocatedQuantity and adds back PickingCancelQuantity and PickingReturnQuantity, so requesting a pick immediately removes that quantity from the pickable pool and cancelling or returning it puts it back.
`PickingReturnQuantity`	Picking Return Quantity	Number
`PriceAsOnDate`	Price As On Date	Date		Per-line pricing date, which takes precedence over the order's PriceAsOnDate when the engine picks the effective PriceListRule. Changing it, PriceListId or PriceListRuleId re-resolves the line's prices on save.
`PriceListId`	Price List	Lookup → PriceList
`PriceListRuleId`	Price List Rule	Lookup → PriceListRule
`PurchaseOrderLineId`	Purchase Order Line	Lookup → PurchaseOrderLine		Links the line to the purchase order line it was generated from in the dealer flow. Inserting such a line, or changing its quantity, rolls that quantity up into the purchase order line's OrderQuantity.
`Quantity`	Quantity	Number	Yes	The ordered quantity and the base for every stage counter — each Pending* field is Quantity minus what has already passed that stage minus CancelledQuantity. Reducing it below what has already been processed is rejected by the order service's quantity validation on update.
`QuoteLineId`	Quote Line	Lookup → QuoteLine		Back-reference to the quote line this order line was copied from when the order was inserted with a QuoteId; the equivalent for the opportunity path is OpportunityLineId.
`RecordTypeId`	Record Type	Guid, hidden
`RequestedQuantity`	Requested Quantity	Decimal
`ReturnedQuantity`	Returned Quantity	Number		Cumulative quantity returned through credit notes, rolled up from CreditNoteLine.Quantity against this line. It does not appear in any Pending* formula, so a return does not by itself reopen the line for fulfilment or invoicing.
`RNAExternalId`	RNA External	Text
`RNAOrderExternalId`	RNA Order External	Text
`SchemeBenefitId`	Scheme Benefit	Lookup → SchemeBenefit
`SchemeDiscount`	Scheme Discount	Percent
`SchemeDiscountAmount`	Scheme Discount Amount	Currency
`SchemeLineId`	Scheme Line	Lookup → SchemeLine		The scheme line that was applied to this order line. It is the identifier the ApplyScheme action requires in its arguments, and that action rejects an id which does not reference an existing scheme line.
`SchemeRewardPoints`	Scheme Reward Points	LargeNumber		Reward points earned on this line from an applied scheme benefit. They are stamped onto the document's non-generated lines and are what the scheme ledger reads as its RewardPoints when the benefit is recorded.
`SkipScheme`	Skip Scheme	Boolean
`SKUId`	SKU	Lookup → SKU
`StockAvailable`	Stock Available	Calculated (calculated)		Calculated pass-through of the linked InventoryStock.Available, or zero when InventoryStockId is empty. It is free-to-promise quantity at the line's item, SKU, lot type and storage location, refreshed whenever any of those change.
`StockInHand`	Stock In Hand	Calculated (calculated)		Calculated pass-through of the linked InventoryStock.InHand — the physical quantity held, which still includes stock reserved for other demand. Compare it with StockAvailable before promising a quantity.
`StorageLocationId`	Storage Location	Lookup → StorageLocation		Storage location the line draws from. It participates in resolving InventoryStockId, and it is carried onto the inventory fulfilment order line created when fulfilment is released.
`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		Total of the line's six tax slots; the handler treats it as a system field rather than user input. It feeds GrossAmount and rolls up into Order.TotalLineTaxAmount.
`TaxGroupId`	Tax Group	Lookup → TaxGroup
`UIProps`	UI Props	Text
`UnitPrice`	Unit Price	Currency	Yes
`UnitPrice2`	Unit Price 2	Currency
`UOM`	UOM	PickList		Values: Pack, Each, Box, Barrel, Litres, MB, Minutes, Messages, kWh.
`UOM1`	UOM 1	PickList		Values: Pack, Each, Box, Barrel, Litres, MB, Minutes, Messages, kWh.
`UOMQuantity`	UOM Quantity	Decimal
`UOMQuantity1`	UOM Quantity 1	Decimal
`UpdatedDateTime`	Modified Date	DateAndTime	Yes

Actions

Action	Label	Type	What it does
`BarcodeQuickAdd`	Barcode Scanner	UIAction	Scan barcodes to add order lines
`Clone`	Clone	ServerAction (`Clone`)	Create a copy of this record
`Delete`	Delete	Delete	Delete
`DeleteInList`	Delete	Delete	Delete in a list page
`Edit`	Edit	Edit	Edit
`EditHeader`	Edit	EditInline	Edit
`EditListRow`	Edit	Edit	EditListRow
`Import`	Import	UIAction	List-header action that opens the ImportSO layout to bring order lines in from a file rather than entering them one by one. It is a client-side layout action with no server action behind it; the imported rows go through the normal order-line save path.
`NewInLine`	Quick Add	NewInline	Labelled 'Quick Add': adds an order line inline in the grid rather than through the full line form. The line handler still applies all its defaults on save — item alias, unit conversion, prices, taxes, discounts, stock resolution, package explosion and scheme processing — exactly as for a full-form insert.
`ProductCatalogue`	Product Catalogue	UIAction	List-header button that opens the product catalogue layout for adding lines to the order. It names no server action, so pressing it runs nothing on the server.

Validations

Validation	Applies to	Error message	Notes
Quantity Cancelled Rule Validation	`CancelledQuantity`, Error	Quantity cancelled cannot be greater than Quantity.	Quantity cancelled cannot be greater than Quantity.
Quantity Rule Validation	`Quantity`, Error	Quantity should not be less than 0	Quantity should not be less than 0
Track Asset Quantity Validation	`Quantity`, Error, inactive	Quantity cannot be greater than 1 for asset-tracked items.	When Track Asset is enabled on the Item, quantity cannot exceed 1.
Unit Price Rule Validation	`UnitPrice`, Error	Unit Price can not be less than 0	Unit Price can not be less than 0
Validate On Incorrect Item Alias	`ItemAliasId`, Error	Item Alias is not valid.	Item Alias is not valid.

Lookup filters

Filter	Lookup field	Notes
Lot for Partner and Branch	`ItemLotId`
Lot Type for Item	`ItemLotTypeId`
Sku For Item	`SKUId`

ItemLotType — looks up via ItemLotTypeId
UserAccount — looks up via CreatedById
ItemComponent — looks up via ItemComponentId
UserAccount — looks up via OwnerId
SKU — looks up via SKUId
PriceListRule — looks up via PriceListRuleId
OpportunityLine — looks up via OpportunityLineId
PurchaseOrderLine — looks up via PurchaseOrderLineId
OrderLine — looks up via PackageOrderLineId
ItemAlternate — looks up via ItemAlternateId
DiscountGroupRule — looks up via DiscountGroupRuleId
StorageLocation — looks up via StorageLocationId
PriceList — looks up via PriceListId
Item — looks up via ItemId
TaxGroup — looks up via TaxGroupId
QuoteLine — looks up via QuoteLineId
InventoryLedger — looks up via InventoryLedgerId
InventoryStock — looks up via InventoryStockId
ItemAlias — looks up via ItemAliasId
UserAccount — looks up via ModifiedById
SchemeBenefit — looks up via SchemeBenefitId
ItemLot — looks up via ItemLotId
ItemServiceContract — looks up via ItemServiceContractId
Order — looks up via OrderId
Item — looks up via OriginalItemId
SchemeLine — looks up via SchemeLineId
InvoiceLine — referenced by via OrderLineId
InventoryFulfilmentOrderLine — referenced by via OrderLineId
CreditNoteLine — referenced by via OrderLineId
SchemeLedger — referenced by via OrderLineId
InventoryFulfilmentAllocationLine — referenced by via OrderLineId
InventoryFulfilmentPickingLine — referenced by via OrderLineId
OrderLine — referenced by via PackageOrderLineId
KYCDocument — referenced by via OrderLineId
DeliveryOrderLine — referenced by via OrderLineId
InvoiceLine — referenced by via PackageOrderLineId
Subscription — referenced by via OrderLineId

Order Line — entity reference

Fields

Actions

Validations

Lookup filters

Related entities

Related topics