Store

Back to list of main tables

A store is a separate silo of stock.

Field number	Field Name	Description	Type	Length	Index
4	address_1	Address of the store- row 1	Alpha
5	address_2	Address of the store- row 2	Alpha
6	address_3	Address of the store- row 3	Alpha
7	address_4	Address of the store- row 4	Alpha
8	address_5	Address of the store- row 5	Alpha
9	Postal/Zip Code	Postal/Zip code of the store- row 6	Alpha
10	Phone	Phone Number of the store- row 6	Alpha
3	code	A unique code for the store	Alpha
12	disabled	If true, the store is disabled, and can't be logged in to or used for transfers	Boolean
1	ID	The unique ID of the store	Long Integer	Y
6	IS_HIS	Deprecated: see mode below	Boolean
13	logo	A jpg or png graphic for the logo to use for this store (can be printed on invoices etc)	Picture
19	store_type	“store” if this store runs in “store” mode “dispensary” if this store runs in dispensary mode “his” if this store runs in HIS mode “drug_registration” if this store runs in Drug Registration mode	Text
5	mwks_export_mode	Alpha
2	Name	The name of the store	Alpha
4	name_ID	The ID of the name record associated with this store. Each store has a name record associated with it for stock transfers (internal use)	Long Integer
3	Organisation_name	The name of the organisation- printed on invoices	Alpha
18	postal_zip_code	The zip or post code of the store	Alpha
9	responsible_user_ID	The ID of the user responsible for this store.	Long Integer
7	sort_issues_by_status	If true, this store sorts issues by status	Boolean
14	sync_id_remote_site	Internal use (the unique remote ID of this store for synchronisation)	Long Integer
11	Tags	Text containing space delimited list of tags assigned to the store (added: v3.17)	text	keyword
16	user fields 1 to 16	user fields 1 to 16	text