tables_fields:main_tables:purchase_order_lines

Purchase Order Lines

Back to list of main tables

Field name Description mSupply Use Reference link Type Indexed
batchThe batch number associated with this purchase order line — typically used when stock is received in specific batches Alpha
commentAny free-text comment about this line; prints on the PO and is visible to users.Create/open PO»New line»General tab»Comment (will print on purchase order)https://docs.msupply.org.nz/purchasing:ordering_from_suppliers#comment1Text
cost_from_invoiceThe cost recorded from the supplier invoice (if invoice has been entered). Real
cost_localThe cost of this line expressed in the local currency. Real
delivery_date_expectedThe date you expect the supplier to deliver this line.Create/open PO»New/edit line»General tab»Expected delivery datehttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#expected_delivery_dateDate
delivery_date_requestedThe date you have requested the supplier to deliver this item; inherited from the PO by default.Create/open PO»New/edit line»General tab»Requested delivery datehttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#requested_delivery_date1Date
expiryExpiry date for this order line, used if expiry tracking is enabled. Date
IDUnique identifier for this purchase order line record. Alpha*
item_IDInternal reference to the item being ordered. Alpha*
item_nameThe descriptive name of the item being ordered (redundant text for reporting/UI).Create/open PO»New/edit line»General tab»Itemhttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#item1Alpha
line_numberThe sequence number of this line within the purchase order. Long
location_IDReference to the store or location where this line’s stock will be received.Create/open PO»New/edit line»General tab»Shelf locationhttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#shelf_locationAlpha
manufacturer_IDReference to the supplier’s manufacturer record for this item (if recorded).Create/open PO»New/edit line»General tab»Manufacture Alpha
non_stock_name_IDUsed if the line is for a non-stock item; links to the non-stock name record. Alpha
noteInternal note — like a comment, but normally doesn’t print unless specifically shown.Create/open PO»New line»General tab»Noteshttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#notesText
note_has_been_actionedBoolean flag indicating whether the note has been marked as dealt with. Boolean
note_show_on_goods_recIf set, the note will show up on goods receipt documents. Boolean
pack_unitsThe unit descriptor for the packing (e.g., “box”, “carton”).Create/open PO»New line»General tab»Units (eg, kg, ml)https://docs.msupply.org.nz/purchasing:ordering_from_suppliers#unitsAlpha
packsize_orderedThe number of units per pack ordered.Create/open PO»New/edit line»General tab»Pack sizehttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#pack_sizeReal
price_expected_after_discountThe expected price after any negotiated discount.Create/open PO»New/edit line»General tab»Price after discount (Pricing for this item) Real
price_per_pack_before_discountThe standard unit cost per pack before any discounts are applied.Create/open PO»New/edit line»General tab»Price before discount (Pricing for this item) Real
price_extension_before_discountThe extended total (quantity × price before discount). Real
price_extension_expectedThe extended total (quantity × expected price after discount).Create/open PO»New/edit line»General tab»Number of packs (Original order)https://docs.msupply.org.nz/purchasing:ordering_from_suppliers#number_of_packsReal
purchase_order_IDReference to the parent purchase order record. Alpha*
quan_adjusted_orderThe adjusted quantity ordered (after manual changes post-quoting).Create/open PO»New/existing line»General tab»Total quantityhttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#adjusted_quantityReal
quan_original_orderThe original quantity requested before adjustments. Real
quan_rec_to_dateQuantity received so far against this order line.Create/open PO»New/edit line»General tab»Received on previous deliveries (Stock) Real
quote_line_IDReference to the related quote line from which this PO line may have been created.Create/open PO»New line»Quotes tabhttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#quotes_tabAlpha
spare_estmated_costEstimated cost for spare parts or non-stock items. Real
store_IDReference to the store receiving the order; useful in multi-store setups.Create/open PO»New/edit line»General tab»Store Alpha*
supplier_codeThe supplier’s own code for this item (optional).Create/open PO»New/edit line»General tab»Supplier item codehttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#supplier_item_codeAlpha
volume_per_packVolume measure per pack, if tracking item volume.Create/open PO»New line»General tab»Volume per packhttps://docs.msupply.org.nz/purchasing:ordering_from_suppliers#volume_per_packReal
suggestedQuantitySuggested quantity to be ordered — often from order forecasting. Real
snapshotQuantitySnapshot of the quantity at a specific time during order creation or forecasting. Real
kit_dataUsed to identify and manage a group of items that are purchased together as a single unit Object
oms_fieldsUsed for OMS integration. Object
  • Last modified: 2026/01/23 06:11
  • by Raksha Khadka