tables_fields:other_tables:store

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
tables_fields:other_tables:store [2022/03/11 14:37] – Gary Willettstables_fields:other_tables:store [2026/01/25 13:20] (current) – raksha
Line 4: Line 4:
 A store is a separate silo of stock. A store is a separate silo of stock.
    
-^ Field number  ^  Field Name  ^   Description ^ Type  ^  Length  ^  Index ^ +^ Field name ^ Description ^ mSupply Use ^ Reference link ^ Type ^ Indexed ^ 
-|4|address_1|Address of the store- row 1     |   Alpha  |  |  | +| **ID** | Unique ID of the store | Not shown in UI |  | Alpha | | 
-|5|address_2|Address of the store- row 2     |   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 |  | 
-|6|address_3|Address of the store- row 3     |   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 |  | 
-|7|address_4|Address of the store- row 4     |   Alpha  |  |  | +| **name_ID** | ID of the name record associated with this store (used for internal stock transfers) | |  | Alpha |  | 
-|8|address_5|Address of the store- row 5     |   Alpha  |  |  | +| mwks_export_mode |  | |  | Alpha |  | 
-|9|Postal/Zip Code|Postal/Zip code of the store- row 6     |   Alpha  |  |  | +| IS_HIS | Deprecated: see store_mode | |  | Boolean |  | 
-|10|Phone|Phone Number of the store- row 6     |   Alpha  |  |  | +| sort_issues_by_status_spare | If true, issues are sorted by status | |  | Boolean |  | 
-|3|code|A unique code for the store     |   Alpha  |  |  | +| 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 |  | 
-|12|disabled|If true, the store is disabled, and can't be logged in to or used for transfers     |   Boolean  |  |  | +| responsible_user_ID | ID of the user responsible for this store | |  | Alpha |  | 
-|1|ID|The unique ID of the store     |   Long Integer  |  |  Y  | +| 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 |  | 
-|6|IS_HIS| Deprecated: see mode below     |   Boolean  |  |  | +| 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 |  | 
-|13|logo|  A jpg or png graphic for the logo to use for this store (can be printed on invoices etc)  |   Picture  |  |  | +| 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 |  | 
-|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  |  |  | +| 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 |  | 
-|5|mwks_export_mode|     |   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 |  | 
-|2|Name|The name of the store   |   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 |  | 
-|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  |  |  | +| postal_zip_code | Postal / ZIP code | Create/open any store>>General tab>>Postal/ZIP code |  | Alpha |  | 
-|3|Organisation_name| The name of the organisation- printed on invoices     |   Alpha  |  |  | +| phone | Phone number of the store | Create/open any store>>General tab>>Phone |  | Text |  | 
-|18|postal_zip_code| The zip or post code of the store    |   Alpha  |  |  | +| 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 |  | 
-|9|responsible_user_ID|The ID of the user responsible for this store.   |   Long Integer  |  |  | +| sync_id_remote_site | Remote site ID used for synchronisation | |  | Long |  | 
-|7|sort_issues_by_status|If true, this store sorts issues by status  |   Boolean  |  |  | +| 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 |  | 
-|14|sync_id_remote_site|Internal use (the unique remote ID of this store for synchronisation)   |   Long Integer  |  |  | +| 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 |  | 
-|11|Tags||Text containing space delimited list of tags assigned to the store (added: v3.17)  | text |  keyword  | +| spare_user_1 | User-defined field 1(Custom usage) | |  | Text |  | 
-|16|user fields 1 to 16||user fields 1 to 16  | 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 |  |
  
 ---- struct data ---- ---- struct data ----
  • Last modified: 2022/03/11 14:37
  • by Gary Willetts