https://docs.msupply.org.nz/docs/ 2026-04-06T16:51:16+00:00 https://docs.msupply.org.nz/docs/ https://docs.msupply.org.nz/docs/_media/wiki:logo.png text/html 2021-10-08T11:08:35+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:foreign_keys 24.03. Foreign keys ID Field Foreign Keys One-to-Many Many-to-One [abbreviation]ID [account]ID [item]account_income_ID - - [account]ID [item]account_purchases_ID - - [account]ID [item]account_stock_ID - - [account]ID text/html 2022-03-11T14:44:54+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:internal_tables 24.04. Internal tables These are tables that are used internally that you most likely shouldn't be interested in Internal tables * insuranceProvider * item_store_join * nameInsuranceJoin * name_store_join * name_group * numbers * number_re-use * permissions * prefs * reports * ship_method * sync_out * transaction_category * transaction_notes * units Insurance provider Field name text/html 2026-01-06T08:41:27+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:main_tables 24.01. Main tables Name of table Description of table Agreggator Stored metrics for use in reports Drug_Register Drug Registration records (for use in the Drug Registration module) Items An item record is created for each product or service purchased or supplied Item_line text/html 2026-01-07T05:43:11+00:00 Anonymous (anonymous@undisclosed.example.com) https://docs.msupply.org.nz/docs/tables_fields:other_tables 24.02. Other tables Name of table Description of table Abbreviations Stores abbreviation codes and their expansion for dispensing directions Account_code Stores account codes associated with each item Authorisations Tables that store authorisers and pending authorisations Backorders One record for