https://docs.msupply.org.nz/docs/ 2026-04-06T18:19:05+00:00 https://docs.msupply.org.nz/docs/ https://docs.msupply.org.nz/docs/_media/wiki:logo.png text/html 2020-01-07T01:04:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:abbreviation Abbreviation Back to the list of other tables Field name Description Type Length Ind abbreviation Alpha 20 expansion Text text/html 2020-01-07T01:04:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:account_code Account code Back to the list of other tables Field name Description Type Length Indexed key Long * code Alpha 20 description Alpha 80 account_type text/html 2020-01-07T01:04:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:authorisation authoriser Back to the list of other tables Field number Field Name Description Type Length Index 6ID The ID of the record UUID Y 4priorityIf this type of authorisation requires authorisation in a particular order, this value is > 0 and denotes this authoriser's place in the order text/html 2020-01-07T01:04:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:backorder Backorders Back to the list of other tables Field name Description Type Length Ind item_key Alpha 8 item_key Alpha 8 quantity text/html 2020-01-07T01:04:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:bill_of_materials Bill of Materials Master Back to the list of other tables Field name Description Type Length Ind item_key Alpha 8 ingredient_item_key Alpha 8 quantity Real units_key Long spare_units_v180 Alpha 60 key Long line_number Long text/html 2023-02-01T02:55:41+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:coldchain Cold chain Back to the list of other tables Tables that are used to capture cold chain data Sensor Central data Field name Description Type Indexed ID The unique identifying number assigned to this sensor Alpha * locationID The ID of the location to which this sensor belongs text/html 2020-01-07T01:04:59+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:contact Contact Back to the list of other tables * A contact belongs to a name Field name Description Type Indexed ID The unique identifying number assigned to this contact Alpha * name_ID The ID of the name to which this contact belongs Alpha * address1 Contact's address line 1 text/html 2020-01-07T01:05:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:currency Currencies Back to the list of other tables Field name Description Type Length Ind ID Long * rate Real currency Alpha 3 is_home_currency Boolean text/html 2020-01-07T01:05:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:custom_stock Custom Stock fields Back to the list of other tables Holds the details of the values that are selectable in the 5th - 8th user fields when receiving stock. custom_stock_5 Field name Description Type Length Ind ID Primary key, the record's id (a UUID). Text * description text/html 2020-01-07T01:05:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:drug_interaction Drug Interactions Back to the list of other tables Field name Description Type Length Ind key Long affected_group_key Long affecting_group_key Long notes Text alert_message Text action Alpha 2 clinical_significance Alpha 2 text/html 2023-09-02T19:49:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:item_category Item category Back to the list of other tables Field name Description Type Length Ind key Long Description Alpha 60 spare Alpha 3 summary_only Boolean text/html 2020-01-07T01:05:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:item_dept Item department Back to the list of other tables Field name Description Type Length Indexed ID Long * department Alpha 30 issue Boolean text/html 2020-01-07T01:05:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:item_direction Item directions Back to the list of other tables Field name Description Type Length Ind directions Text item_key Alpha Ind key Long priority Long text/html 2020-01-07T01:05:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:item_note Item Note Back to the list of other tables Field name Description Type Length Ind item_ID Alpha 8 date Date note Text WhenToDisplay Alpha 2 text/html 2020-01-07T01:05:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:item_warning_join Item Warning link Back to the list of other tables Field name Description Type Length Indexed ID Long * item_ID The item key for this warning Long * warning_key The key of the warning to be displayed Long priority True or False depending on the warning's priority text/html 2020-01-07T01:05:01+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:label Label Back to the list of other tables Field name Description Field properties body Main text of the label Text body_font_size Font size in pixels of the text in the body field Real description Title of the label String 80 footer_font_size Font size in pixels of the text in the text/html 2026-01-07T06:30:47+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:location Location & Location Movement Back to the list of tables Location Contains details of shelf locations in a store. Field name Description mSupply Use Reference link TypeID UUID of the record Not use in UI Alpha Colour colour of the record when displayed in lists text/html 2020-01-07T01:05:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:log Log Back to the list of other tables Field name Description Type Length Ind entry_date Date user Alpha 10 event Alpha 80 event type Alpha 60 time Time source_key Long source_type Alpha 2 text/html 2020-01-07T01:05:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:name_category Name category tables Back to the list of other tables Name category 1 internal name: name_category1 Field name Description Type Length Indexed ID Long * description Alpha 50 type Alpha 2 user_field1 Alpha 80 user_field2 Alpha 80 Name category 2 text/html 2026-01-07T05:54:14+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:period Periods Back to list of main tables Table name is period. Periods are specific time frames which exist within schedules. Field name Description mSupply Use Reference link Type Indexed ID UUID of the period (not usually visible to the user Not use in UI text/html 2026-01-07T06:00:30+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:periodschedule Periods Back to list of main tables Table name is periodSechedule. Schedules are regular time frames (e.g. monthly, fortnightly) that may be used for cyclical operations, such as program orders (special types of requisitions). There is no limit to the number of schedules. Field name text/html 2022-07-12T23:49:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:prescriber Prescribers Back to the list of other tables The table name is “clinician”. Field name Description Type Length Ind ID Long code Alpha 20 last_name Alpha 50 first_name Alpha 50 initials Alpha 10 registration_code Alpha 30 category text/html 2020-01-07T01:05:02+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:regimen Regimen Back to the list of other tables Contains the list of regimens for which data will be captured and that will be displayed in regimen records Field name Description Type Ind id Primary key. Unique ID for the regimen Longint * description The regimen's description (the text that will appear anywhere the regimen needs to be displayed) text/html 2020-01-07T01:05:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:reminder Reminders Back to the list of other tables Field name Description Type Length Ind key Long due_date Date repeat_has_been_generated Boolean message_text Text done Boolean repeats_automatically Boolean repeat_type Long repeat_interval text/html 2026-01-25T13:20:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:store Store Back to list of main tables A store is a separate silo of stock. Field name Description mSupply Use Reference link Type Indexed ID Unique ID of the store Not shown in UI Alpha name Name of the store Create/open any store>>General tab>>Name <https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#name> Alpha code text/html 2022-06-08T17:00:31+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:temperature Temperature & VVM temperature_breach Field number Field Name Description Type Length Index 4end_date Date that the breach ended Date 5end_time Time in seconds since midnight that the breach ended Time 1ID Unique ID of this record text/html 2020-01-07T01:05:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:user Users Back to the list of other tables Field name Description Type Length Ind ID Long * name Alpha 50 startup_method Alpha 50 spare_must_be_field Alpha 30 nblogins Long lastlogin Date group Integer mode Alpha 8 qdump_offset_b text/html 2020-01-07T01:05:03+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables:warning Warnings Back to the list of other tables Field name Description Type Length Ind key Long code Alpha 20 warning_text Text