AllocatedQuantity | Allocated Quantity | Decimal | | |
Amount | Amount | Calculated (calculated) | | The net line value: BaseAmount when discounts are applied post-tax, otherwise BaseAmount less NetSchemeDiscount and NetDiscount. The document's TotalLineAmount is the sum of this field. |
ApplyPostTaxDiscount | Apply Post Tax Discount | Boolean | | Switches the whole discount calculation from pre-tax to post-tax: when true every discount percentage is applied to BaseAmount plus tax rather than BaseAmount alone, and Amount stops deducting discounts (they are taken out at GrossAmount instead). It changes the meaning of Amount, NetDiscount and GrossAmount together. |
AssetId | Asset | Lookup → Asset | | A link to a serialised Asset record for the unit being delivered. |
BaseAmount | Base Amount | Calculated (calculated) | | Calculated as Quantity multiplied by UnitPrice2 when that is above zero, otherwise by UnitPrice. It is the pre-discount, pre-tax line value that every discount formula is applied to. |
BillReturnLineId | Bill Return Line | Lookup → BillReturnLine | | |
ContractDiscount | Contract Discount | Percent | | |
ContractDiscountAmount | Contract Discount Amount | Currency | | |
ConversionRatio | Conversion Ratio | Decimal | | The multiplier from the line's unit of measure to the item's base unit, stamped from the item's unit-of-measure configuration when the quantity is derived. |
ConversionRatio1 | Conversion Ratio 1 | Decimal | | |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created Date | DateAndTime | Yes | |
DeliveredInvoiceQuantity | Delivered Invoice Quantity | Decimal | | A live roll-up: the sum of InvoiceLine.Quantity over the invoice lines keyed to this delivery line, refreshed whenever those invoice lines are added, edited or deleted. PendingInvoiceQuantity is Quantity minus this value, and PerformCreateInvoice gates on it. |
DeliveredQuantity | Delivered Quantity | Decimal | | |
DeliveryOrderDiscount | Delivery Order Discount | Calculated (calculated) | | |
DeliveryOrderId | Delivery Order | Lookup → DeliveryOrder | | |
Discount | Discount | Percent | | |
Discount2 | Cash Discount | Percent | | |
DiscountAmount | Discount Amount | Currency | | |
DiscountAmount2 | Cash Discount Amount | Currency | | |
EligibleReturnQuantity | Eligible Return Quantity | Calculated (calculated) | | Calculated as Quantity minus ReturnedQuantity: how much of this delivered line can still be credited back. It is validated never to go negative, so an over-return is rejected at save time. |
ExternalId | External | Text | | |
GrossAmount | Gross Amount | Calculated (calculated) | | Amount plus TaxAmount, less scheme and net discounts when the line is flagged post-tax discount. It is the figure the document's TotalLineGrossAmount rolls up, which is what PerformGLPosting books. |
Id | Id | Guid | Yes | |
InventoryFulfilmentAllocationLineId | Inventory Fulfillment Allocation Line | Lookup → InventoryFulfilmentAllocationLine | | Set when the delivery line was generated from a fulfilment allocation line (allocation-delivery path); the picking path sets inventoryFulfilmentPickingLineId instead. Which one is filled tells you how the goods were staged. |
InventoryFulfilmentPickingLineId | Inventory Fulfillment Picking Line | Lookup → InventoryFulfilmentPickingLine | | Set when the delivery line was generated from a fulfilment picking line. It is the discriminator for the ledger rule that posts Outward and decrements the Picked bucket, as opposed to the allocation path, which decrements Allocation instead. |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | The posted marker for this line: PerformInventoryPosting only picks up lines where it is empty, and stamps the created ledger row's id here afterwards. It is set by the engine as a system-modified field, so it is not user-editable. |
InvoicedQuantity | Invoiced Quantity | Decimal | | A provenance copy taken at creation from the source invoice or order line, capped at that line's quantity. It is the quantity the invoice-sourced Outward ledger rule posts against the PendingDeliveries bucket, and it is not the same thing as DeliveredInvoiceQuantity, which is the live roll-up. |
InvoiceLineId | Sale Invoice Line | Lookup → InvoiceLine | | Set when the line was generated from an invoice line (invoice-first delivery). It selects the ledger rule that decrements the PendingDeliveries bucket using InvoicedQuantity rather than posting a plain Outward movement, so its presence changes what dispatching does to stock. |
IsGLPostingApproved | GL Posting Approved | Boolean | | |
IsILPosted | IL Posted | Boolean | | A per-line inventory-posted flag that no code writes; InventoryLedgerId is the marker the posting action actually filters and stamps. Do not use this flag to decide whether a line has moved stock. |
IsILPostingApproved | IL Posting Approved | Boolean | | A per-line approval gate for inventory posting that the posting path never consults - the line is posted purely on InventoryLedgerId being empty. Setting it grants no authorisation on its own. |
IsInspectionDone | Inspection Done | Boolean | | Intended to record that the pre-delivery inspection was completed, but no code path sets it. Actual inspection evidence lives in the checklist lines that Populate Checklist creates, not here. |
IsInspectionRequired | Inspection Required | Boolean | | |
IsInsuranceDone | Insurance Done | Boolean, unique | | |
IsRegistrationDone | Registration Done | Boolean | | |
IsRegistrationRequired | Registration Required | Boolean | | |
ItemAliasId | Item Alias | Lookup → ItemAlias | | The customer- or supplier-specific alias for the item, resolved on insert by the item alias service. It lets the printed delivery note show the counterparty's own product code while ItemId stays the internal item. |
ItemId | Item | Lookup → Item | | |
ItemLotId | Item Lot | Lookup → ItemLot | | The specific lot or serialised unit being dispatched; the lot record is where serial and registration numbers live. Inventory posting fails with 'Product Lot was not selected for the transaction' when the item tracks lots and this is empty, and posting also updates the lot's own bucket counters, not just branch stock. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The lot classification (for example new, demo or refurbished) copied from the source line. It is carried onto the inventory ledger row so stock can be analysed by lot type, but it does not itself select a lot. |
ItemName | Item Name | Text | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | |
NetDiscount | Net Discount | Calculated (calculated) | | The single blended discount figure for the line: it sums three independent legs (line discount, second discount and contract discount), each of which takes its explicit amount field when one is set and otherwise applies its percentage to BaseAmount, or to BaseAmount plus tax under post-tax discounting. |
NetSchemeDiscount | Net Scheme Discount | Calculated (calculated) | | The scheme (promotion) leg of the discount, computed the same way as NetDiscount but from SchemeDiscountAmount or the SchemeDiscount percentage. It is kept separate from NetDiscount so promotional give-away can be reported apart from commercial discount. |
OrderLineId | Sale Order Line | Lookup → OrderLine | | The sales order line being delivered. It is the key the order-side roll-up uses to decrement the order line's pending delivery quantity when this line is created, edited or deleted, and it is also the anchor for the source-populated field lock on item, lot and SKU. |
OriginalItemId | Original Item | Lookup → Item | | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | PartnerAccount | Text | | |
PendingInvoiceQuantity | Pending Invoice Quantity | Calculated (calculated) | | |
PendingShippedQuantity | Pending Shipped Quantity | Calculated (calculated) | | Calculated as Quantity minus ShippedQuantity. |
PickedQuantity | Picked Quantity | Decimal | | Its counterpart on allocation-sourced lines is AllocatedQuantity; neither is a live measure of picking progress. |
PolicyNumber | Policy Number | Text | | |
PriceAsOnDate | Price As On Date | Date | | |
PriceListId | Price List | Lookup → PriceList | | |
PriceListRuleId | Price List Rule | Lookup → PriceListRule | | |
PurchaseOrderLineId | Purchase Order Line | Lookup → PurchaseOrderLine | | |
Quantity | Quantity | Decimal | | The delivered amount for this line, and the single quantity that matters: every creation path sets it, the Outward ledger rules read it, and it feeds the roll-ups back onto the order line, allocation line and picking line. Editing it re-posts the line's inventory movement. |
RecordTypeId | Record Type | Guid, hidden | | |
RegistrationNumber | Registration Number | Text | | The registration number of the delivered unit, for vehicle-style goods. No code writes it on the delivery line - the equivalent value that the system actually maintains is on the ItemLot record, which is copied lot to lot on transfers. |
RequestedQuantity | Requested Quantity | Number | | A virtual, non-stored field used only as an argument: the selective release-shipment and selective delivery flows pass a per-line requested quantity through it, validated against the line's quantity. It is never persisted and is meaningless when read back from a saved row. |
ReturnedQuantity | Returned Quantity | Decimal | | A live roll-up of CreditNoteLine.Quantity over the credit note lines keyed to this delivery line, maintained on credit note line insert, update and delete. EligibleReturnQuantity is Quantity minus this value. |
SchemeDiscount | Scheme Discount | Percent | | |
SchemeDiscountAmount | Scheme Discount Amount | Currency | | |
SchemeLineId | Scheme Line | Lookup → SchemeLine | | |
SchemeRewardPoints | Scheme Reward Points | LargeNumber | | Reward points the scheme engine attached to this line when a points-based benefit applied. The scheme ledger reads it to post the points, so it is engine-written rather than user-entered. |
ServiceOrderLineId | Work Orde Line | Lookup → ServiceOrderLine | | |
ShippedQuantity | Shipped Quantity | Decimal | | Intended as the cumulative quantity placed on Shipments, but nothing maintains it: the roll-up that would sum shipment lines by DeliveryOrderLineId is defined and never called, and shipment lines created from a delivery are not stamped with DeliveryOrderLineId in the first place. It therefore stays at zero, which also makes the calculated PendingShippedQuantity always equal Quantity. |
SKUId | SKU | Lookup → SKU | | |
StorageLocationId | Storage Location | Lookup → StorageLocation | | The bin or storage location the goods leave from, copied from the source invoice, allocation or picking line. It is part of the key that identifies which InventoryStock row the Outward movement relieves, so a different location means a different stock bucket. |
Tax1 | Tax1 | Currency | | |
Tax1Name | Tax Name 1 | Text | | |
Tax1Rate | Tax Rate 1 | Currency | | |
Tax1Type | Tax Type 1 | Text | | |
Tax2 | Tax2 | Currency | | |
Tax2Name | Tax Name 2 | Text | | |
Tax2Rate | Tax Rate 2 | Currency | | |
Tax2Type | Tax Type 2 | Text | | |
Tax3 | Tax3 | Currency | | |
Tax3Name | Tax Name 3 | Text | | |
Tax3Rate | Tax Rate 3 | Currency | | |
Tax3Type | Tax Type 3 | Text | | |
Tax4 | Tax4 | Currency | | |
Tax4Name | Tax Name 4 | Text | | |
Tax4Rate | Tax Rate 4 | Currency | | |
Tax4Type | Tax Type 4 | Text | | |
Tax5 | Tax5 | Currency | | |
Tax5Name | Tax Name 5 | Text | | |
Tax5Rate | Tax Rate 5 | Currency | | |
Tax5Type | Tax Type 5 | Text | | |
Tax6 | Tax6 | 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 | | The cost per unit carried through from the source allocation line when the delivery raises an invoice. Inventory posting reads UnitPrice first and falls back to this value for the ledger row's unit cost. |
UnitPrice | Unit Price | Decimal | | The selling price per base unit, defaulted from the applicable price-list rule on insert and refreshed when PriceListRuleId changes. Inventory posting also stamps it onto the ledger row as the movement's unit cost when no UnitCost is present. |
UnitPrice2 | Unit Price 2 | Currency | | The second price from the applicable price-list rule, set alongside UnitPrice. |
UOM | UOM | Text | | |
UOM1 | UOM1 | Text | | |
UOMQuantity | UOM Quantity | Decimal | | The quantity as entered in the line's chosen unit of measure. It is multiplied by ConversionRatio (and the second UOM leg by ConversionRatio1) to derive the base-unit Quantity, so this is what the user types and Quantity is what the system stores and posts. |
UOMQuantity1 | UOM Quantity 1 | Decimal | | |
UpdatedDateTime | Modified Date | DateAndTime | Yes | |
