AllocatedQuantity | Allocated Quantity | Decimal | | The quantity taken from the fulfilment allocation line, set when the line is created by Allocation Delivery. Not updated afterwards. |
Amount | Amount | Calculated (calculated) | | Calculated taxable amount: Base Amount less the net scheme and net discounts, or Base Amount alone when Apply Post Tax Discount is on. |
ApplyPostTaxDiscount | Apply Post Tax Discount | Boolean | | When on, discounts are worked out on the amount including tax and taken off after tax, instead of before tax. |
AssetId | Asset | Lookup → Asset | | An asset linked to the line. None of the shipped delivery actions fill it. |
BaseAmount | Base Amount | Calculated (calculated) | | Calculated as Quantity times the unit price (Unit Price 2 when it is above zero, otherwise Unit Price). |
BillReturnLineId | Bill Return Line | Lookup → BillReturnLine | | Not filled by any shipped flow for delivery order lines. |
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 | | The total quantity of invoice lines that were created from this delivery line by Create Invoice. Recalculated whenever such an invoice line is saved or deleted. |
DeliveredQuantity | Delivered Quantity | Decimal | | Not maintained by the system for delivery order lines. |
DeliveryOrderDiscount | Delivery Order Discount | Calculated (calculated) | | Calculated from the delivery order's header Discount, so every line can see the header discount. |
DeliveryOrderId | Delivery Order | Lookup → DeliveryOrder | | The delivery order this line belongs to. The partner account and branch whose stock is relieved come from this header. |
Discount | Discount | Percent | | The line discount percentage. A new line takes the delivery order's header discount when the header has one. Typing a Discount Amount clears it. |
Discount2 | Cash Discount | Percent | | |
DiscountAmount | Discount Amount | Currency | | A fixed discount amount for the line. When it is above zero it is used instead of the percentage, and saving it sets Discount to 0. |
DiscountAmount2 | Cash Discount Amount | Currency | | |
EligibleReturnQuantity | Eligible Return Quantity | Calculated (calculated) | | Calculated as Quantity minus Returned Quantity: how much of this line can still be returned. |
ExternalId | External | Text | | |
GrossAmount | Gross Amount | Calculated (calculated) | | Calculated line total: Amount plus Tax Amount, less the discounts when Apply Post Tax Discount is on. Post General Ledger books the total of the lines' gross amounts. |
Id | Id | Guid | Yes | |
InventoryFulfilmentAllocationLineId | Inventory Fulfillment Allocation Line | Lookup → InventoryFulfilmentAllocationLine | | The fulfilment allocation line this delivery relieves. Posting releases the allocated stock as well as posting the outward movement. |
InventoryFulfilmentPickingLineId | Inventory Fulfillment Picking Line | Lookup → InventoryFulfilmentPickingLine | | The fulfilment picking line this delivery relieves. Posting releases the picked stock as well as posting the outward movement. |
InventoryLedgerId | Inventory Ledger | Lookup → InventoryLedger | | The inventory ledger entry this line posted. Empty until the line is posted. Post Inventory picks only lines where this is empty. |
InvoicedQuantity | Invoiced Quantity | Decimal | | For lines created from an invoice or an invoiced order line, the part of the delivery quantity that was already invoiced, set on creation. Invoice-sourced lines post this quantity against the stock pending delivery. |
InvoiceLineId | Sale Invoice Line | Lookup → InvoiceLine | | The invoice line this delivery relieves, set when the delivery was made from an invoice. Posting such a line reduces the stock pending delivery instead of posting a plain outward movement. |
IsGLPostingApproved | GL Posting Approved | Boolean | | |
IsILPosted | IL Posted | Boolean | | Not set for delivery order lines. Whether a line is posted shows in Inventory Ledger. |
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 | | The item being dispatched. On creation xMatix checks that the item is active and that a SKU is given where the item needs one. Locked after the first save when the line came from a sales order line. |
ItemLotId | Item Lot | Lookup → ItemLot | | The lot or serial being dispatched, copied from the allocation, picking, invoice or order line the delivery came from. The picker lists only lots of the line's item and SKU. Locked after the first save when the line came from a sales order line. Not on the Quick Add form, so a hand-added line has no lot unless you set it on the line's record page. |
ItemLotTypeId | Item Lot Type | Lookup → ItemLotType | | The lot type of the item, copied from the order or invoice line. The picker lists only lot types of the line's item. |
ItemName | Item Name | Text | | |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Document Number | Text | | The line number, given on creation from the Delivery Order Line document name setting (default series DL, a day-month-financial-year date part and six digits). Not entered by the user. |
NetDiscount | Net Discount | Calculated (calculated) | | Calculated total of the line, cash and contract discounts: each uses its amount when set, otherwise its percentage of the base amount (or of base plus tax when Apply Post Tax Discount is on). |
NetSchemeDiscount | Net Scheme Discount | Calculated (calculated) | | Calculated scheme discount: the scheme amount when set, otherwise the scheme percentage applied to the base amount (or to base plus tax when Apply Post Tax Discount is on). |
OrderLineId | Sale Order Line | Lookup → OrderLine | | The sales order line this delivery relieves. Saving, changing or deleting the line updates that order line's delivered quantity, and its presence locks Item, SKU and Item Lot. |
OriginalItemId | Original Item | Lookup → Item | | |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PartnerAccountId | PartnerAccount | Text | | |
PendingInvoiceQuantity | Pending Invoice Quantity | Calculated (calculated) | | Calculated as Quantity minus Delivered Invoice Quantity: how much of this line Create Invoice can still bill. It counts only invoices raised from this delivery, so a line that was delivered from an invoice still shows its full quantity here. |
PendingShippedQuantity | Pending Shipped Quantity | Calculated (calculated) | | Calculated as Quantity minus Shipped Quantity. Because Shipped Quantity is never updated, it always equals Quantity and does not show what has been released to shipments. |
PickedQuantity | Picked Quantity | Decimal | | The quantity taken from the fulfilment picking line, set when the line is created by Picked Delivery. Not updated afterwards. |
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 quantity being delivered. It must be at least 1: the shipped Quantity Rule Validation refuses anything lower with the message 'Quantity cannot be 0'. This is the quantity Post Inventory posts as Outward (for invoice-sourced lines the posting uses Invoiced Quantity). Changing it on a saved line posts or re-posts the line to the inventory ledger and updates the delivered quantity on the source line. |
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 working quantity used by the Selective Release Shipment dialog: the quantity of this line to put on the shipment. |
ReturnedQuantity | Returned Quantity | Decimal | | The total quantity of credit note lines that point back at this delivery line. Recalculated when such a credit note line is saved or deleted. |
SchemeDiscount | Scheme Discount | Percent | | The trade-scheme discount percentage, copied from the invoice line on deliveries made from an invoice. |
SchemeDiscountAmount | Scheme Discount Amount | Currency | | The trade-scheme discount amount, copied from the invoice line on deliveries made from an invoice. |
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 | | Meant to hold the quantity released to shipments. Nothing updates it, so it stays at 0. |
SKUId | SKU | Lookup → SKU | | The item variant being dispatched. The picker lists only SKUs of the line's item. Locked after the first save when the line came from a sales order line. |
StorageLocationId | Storage Location | Lookup → StorageLocation | | The storage location the goods leave from, copied from the allocation, picking or invoice line. It is part of the stock key the inventory ledger posts against. Not on any shipped line form, so a hand-added line has none. |
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 | | The line's total tax, worked out from the tax group when the line is created. It is not worked out again when you later change the quantity, price or tax group of a saved line. |
TaxGroupId | Tax Group | Lookup → TaxGroup | | The tax group used to work out the line's tax. Filled on creation from the tax group rules when you leave it empty. |
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 unit. Copied from the order or invoice line where the delivery came from one. A new line saved with no price is priced from the price list rules (the delivery order's price list when it has one). A price you type on a new line is kept. |
UnitPrice2 | Unit Price 2 | Currency | | An override price set from the price list rule's second price. When it is above zero, Base Amount uses it instead of Unit Price. Not on any shipped line form. |
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 | |