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	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