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 | Unique code for the store | Create/open any store»General tab»Store code | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#store_code | Alpha | |
| name_ID | ID of the name record associated with this store (used for internal stock transfers) | Alpha | |||
| mwks_export_mode | Alpha | ||||
| IS_HIS | Deprecated: see store_mode | Boolean | |||
| sort_issues_by_status_spare | If true, issues are sorted by status | Boolean | |||
| disabled | If true, the store is disabled and cannot be used | Create/open any store»General tab»Disable this store(Admin settings) | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#disable_this_store | Boolean | |
| responsible_user_ID | ID of the user responsible for this store | Alpha | |||
| organisation_name | Organisation name printed on invoices | Create/open any store»General tab»Organization name | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#organisation_name | Alpha | |
| address_1 | Address line 1 | Create/open any store»General tab»Address line 1(Store details) | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#address_details | Alpha | |
| address_2 | Address line 2 | Create/open any store»General tab»Address line 2(Store details) | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#address_details | Alpha | |
| address_3 | Address line 3 | Create/open any store»General tab»Address line 3(Store details) | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#address_details | Alpha | |
| address_4 | Address line 4 | Create/open any store»General tab»Address line 4(Store details) | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#address_details | Alpha | |
| address_5 | Address line 5 | Create/open any store»General tab»Address line 5(Store details) | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#address_details | Alpha | |
| postal_zip_code | Postal / ZIP code | Create/open any store»General tab»Postal/ZIP code | Alpha | ||
| phone | Phone number of the store | Create/open any store»General tab»Phone | Text | ||
| logo | Store logo (JPG/PNG, used on invoices etc.) | Create/open any store»Logo tab»Copy and paste, or drag and drop, a jpg file image into the box below(See the logo) | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#logo_tab | Picture | |
| sync_id_remote_site | Remote site ID used for synchronisation | Long | |||
| store_mode | Store operating mode (0=store, 1=dispensary, 2=his, 3=drug_registration) | Create/open any store»General tab»(choose from dropdown on side of Store code) | Text | ||
| tags | Space-delimited list of tags assigned to the store | Create/open any store»General tab»Tags | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#tags | Text | |
| spare_user_1 | User-defined field 1(Custom usage) | Text | |||
| spare_user_2 | User-defined field 2(Custom usage) | Text | |||
| spare_user_3 | User-defined field 3(Custom usage) | Text | |||
| spare_user_4 | User-defined field 4(Custom usage) | Text | |||
| spare_user_5 | User-defined field 5(Custom usage) | Text | |||
| spare_user_6 | User-defined field 6(Custom usage) | Text | |||
| spare_user_7 | User-defined field 7(Custom usage) | Text | |||
| spare_user_8 | User-defined field 8(Custom usage) | Text | |||
| spare_user_9 | User-defined field 9(Custom usage) | Text | |||
| spare_user_10 | User-defined field 10(Custom usage) | Text | |||
| spare_user_11 | User-defined field 11(Custom usage) | Text | |||
| spare_user_12 | User-defined field 12(Custom usage) | Text | |||
| spare_user_13 | User-defined field 13(Custom usage) | Text | |||
| spare_user_14 | User-defined field 14(Custom usage) | Text | |||
| spare_user_15 | User-defined field 15(Custom usage) | Text | |||
| spare_user_16 | User-defined field 16(Custom usage) | Text | |||
| custom_data | Custom or extended data (JSON/object structure) | Create/open any store»Custom fields tab | https://docs.msupply.org.nz/other_stuff:virtual_stores?s[]=store#custom_data | Object | |
| created_date | Record creation date | Date |