List master name join

Back to list of main tables

Table name is list_master_name_join. Master list table that are link with name, such as a customer, supplier, manufacturer, benchmark, or donor.

Field name	Description	mSupply Use	Reference link	Type	Indexed
ID	UUID of the List_master_name_join (not usually visible to the user	Alpha
description	Alpha
name_ID	The ID of the entity the list is linked to, such as a customer, supplier, manufacturer, benchmark, or donor	Alpha
list_master_ID	The ID of the master list being linked to the selected name	Alpha
include_web	When set to true, this list is available for online web orders placed by the linked customer or facility	name(customer/supplier/manufacture/Benchmark/donor) goto item list tab»double click on list » Ordering list for web	https://docs.msupply.org.nz/names:adding_and_editing#item_lists_tab	Boolean
include_imprest	When set to true, this list is used for imprest (top-up) ordering, meaning stock is replenished based on predefined levels	name(customer/supplier/manufacture/Benchmark/donor) goto item list tab»double click on list »Imprest	Boolean
include_stock_hist	Is true the basis for requisitions (any type: Request, Customer Stock history or Response requisition	name(customer/supplier/manufacture/Benchmark/donor) goto item list tab»double click on list »Requisition	Boolean
price_list	When set to true, the prices defined on this list are used as the selling prices for items sold to the linked customer	name(customer/supplier/manufacture/Benchmark/donor) goto item list tab»double click on list »Price list	Boolean