List master name join
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 |