https://docs.msupply.org.nz/docs/ 2026-04-06T18:19:00+00:00 https://docs.msupply.org.nz/docs/ https://docs.msupply.org.nz/docs/_media/wiki:logo.png text/html 2026-01-28T04:42:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:aggregator Aggregator table The aggregator table is refreshed daily, and allows quick access to important metrics that are otherwise slow to calculate. Field name Description mSupply Use Reference link Type Indexed ID UUID of the Aggregator Not use is UI text/html 2020-01-07T01:04:56+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:drug_register Drug_register Back to list of main tables Field number Field Name Description Type Length Index 7application_dateThe date of application Date 8application_numberA unique number assigned to track the application Long Integer 9approval_dateThe date the application was approved (blank if never approved) text/html 2026-01-06T10:39:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:goods_received_lines Goods received line Back to list of main tables Table name is goods_received_line. Contains the lines that belong to goods received. Field name Description mSupply use Report reference link Type Indexed text/html 2026-01-06T10:42:40+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:goods_received Goods received Back to list of main tables Table name is Goods received. Goods received are created only after purchase order from supplier. Field name Description mSupply use Report reference link text/html 2026-01-20T10:41:37+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:health_supply_hub <https://docs.msupply.foundation/health-supply-hub/introduction/> text/html 2026-01-21T10:49:09+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:item_line item_line Back to list of main tables An item_line record represents a line of stock. Field name Description mSupply Use Reference link Type Indexed store_ID The store id of the stock line Not use in UI Alpha * item_ID The item id of the stock line text/html 2026-01-12T09:41:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:item Item Back to list of main tables * The item table stores one record for each item you supply. * Stock on hand of an item is not stored here - look in the “item_line” table Field name Description mSupply Use Reference link Type Indexed ID UUID of the Item Not use is UI text/html 2026-01-07T05:28:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:list_master_item_join List master line Back to list of main tables Table name is list_master_line. Contains the lines that belong to master list. Field name Description mSupply Use Reference link Type Indexed ID UUID of the list_master_line (not usually visible to the user Not use in UI text/html 2026-01-06T12:22:15+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:list_master_name_join List master name join Back to list of main tables Table name is list_master_name_join. Master list table that are link with name, such as a customer, supplier, manufacturer, benchmark, or donor. Field name Description mSupply Use Reference link Type Indexed text/html 2026-01-06T12:06:21+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:list_master List master Back to list of main tables Table name is list_master. Master lists are standard lists of items you would supply to wards, clinics, etc. on a regular basis. Field name Description mSupply Use Reference link Type Indexed ID UUID of the list_master (not usually visible to the user text/html 2026-01-20T10:41:51+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:name Name Back to list of main tables A name is a customer, supplier, patient, manufacturer or donor, or maybe a combination of these. Field name Description mSupply Use Reference link Type Indexed ID The unique ID given to this name Not used in UI text/html 2020-01-07T01:04:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:pref_blob Preferences (Prefs) Field name Description Type Length Ind item The name of the preference. Does not have to be unique if unique user_key or network_id is supplied Alpha 40 * type The type of data in the blob: blob s string text/html 2026-01-23T06:11:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/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 text/html 2026-01-22T11:09:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:purchase_order Purchase Orders Back to list of main tables Field name Description mSupply Use Reference link Type Index additional_instructionsAny extra instructions to the supplierPurchase order>>Details tab>>Additional Instruction(Info for purchase order)<https://docs.msupply.org.nz/purchasing:ordering_from_suppliers#additional_instructions> Text agent_commission text/html 2026-01-25T12:28:17+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:quote Quotes Back to list of main tables Field name Description mSupply Use Reference link Type Indexed currency_ID The currency ID for quotes Id are not shown in UI but used to display Open any supplier>>Quotes tab>>New/edit Quote>>Their quote currency text/html 2026-01-26T06:45:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:requisition Requisition Back to list of main tables * internal name: requisition * was “name_stock_history” up to & including version 3.5. “Requisition” from version 3.6 Field name Description mSupply Use Reference link Type Indexed ID The unique ID of this requisition record text/html 2026-01-27T08:35:58+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:stock_take Stock_take Back to list of main tables Field name Description mSupply Use Reference link Type Indexed comment Free-text comments or notes for the stock take Open/create any Stock take>>Comment <https://docs.msupply.org.nz/items:stocktakes#preparing_the_stocktake> Text created_by_ID ID of the user who created the stock take Alpha Description text/html 2026-01-28T04:21:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:tender Tenders Back to list of main tables Field name Description mSupply Use Reference link Type Indexed BenchMarkSupplier_ID The ID of the supplier used as a benchmark for price comparison ID are not shown in UI but used to display open/create any one tender>>goto Tender preferences tab text/html 2026-01-22T04:41:20+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:trans_line Transaction lines Back to list of main tables Table name is trans_line. Contains the lines that belong to transactions. Field name Description mSupply Use Reference link Type Indexed batch The batch of the item received or issued Supplier invoice/Inventory adjust-add stock text/html 2026-01-21T10:05:34+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables:transaction Transactions Back to list of main tables Table name is transact. Transactions are customer invoices, supplier invoices, inventory adjustments, customer credits, supplier credits, repacks etc. Field name Description mSupply Use Reference link Type Indexed