List master

Back to list of main tables

Table name is list_master. Master lists are standard lists of items you would supply to wards, clinics, etc. on a regular basis.

Field name	Description	mSupply Use	Reference link	Type	Indexed
ID	UUID of the list_master (not usually visible to the user	Alpha
description	Name of the master list	Master list»Description	https://docs.msupply.org.nz/items:master_lists?s[]=list&s[]=master#description	Alpha
date_created	List master created date	Master list»Created date	Date
created_by_user_ID	ID of user who created the master list	Master list»Created by	Alpha
note	Any note or information that will help you and others understand what the list is for	Master list»Note	https://docs.msupply.org.nz/items:master_lists?s[]=list&s[]=master#note	Text
gets_new_items	if true, any new items created whether manually or during import will be added to the master list	Master list»Automatically add new items to this master list	https://docs.msupply.org.nz/items:master_lists?s[]=list&s[]=master#automatically_add_new_items_to_this_master_list	Boolean
tags	tags identify master list for certain configurations	Master list»Tags tab	https://docs.msupply.org.nz/items:master_lists?s[]=list&s[]=master#tags	Object
isProgram	Is true than master list convert to Programs	Master list»Programe Settings tab»This is a program	https://docs.msupply.org.nz/items:programs	Boolean
programSettings	This is used to define programs. Program settings are configured here Programs	Master list»Programe Settings tab»This is a programSetting	https://docs.msupply.org.nz/items:master_lists?s[]=list&s[]=master#program_settings	Object
code	Code for the master list	Alpha
isPatientList	If checked, this tells mSupply to use the prices on this master list for any of the items on this list on prescriptions (not customer invoices)	“Master list»This master list is a patient list	https://docs.msupply.org.nz/items:master_lists?s[]=list&s[]=master#this_master_list_is_a_patient_list	Boolean
is_hiv	Is true then this is to be an HIV program	Master list»HIV program	Boolean
isSupplierHubCatalog	If the master list is part of a Supplierhub catalogue, the allow modification. But user must have user permission add/edit master list	Boolean
inactive	Is true than it will be invisible	Boolean
is_immunisation	Is true then this is to be used as an immunization program to drive the immunization card functionality in Open mSupply	Master list»Immunisation program	https://docs.msupply.foundation/docs/programs/immunizations/	Boolean
is_default_price_list	Is true then tells mSupply to use the unit prices set on this master list as the unit sell price for those items instead of other prices. This price will be applied to prescriptions as well as customer invoices	Master list»Is Default price list	https://docs.msupply.org.nz/items:master_lists?s[]=list&s[]=master#is_default_price_list	Boolean
discount_percentage	The discount_percentage used to apply to sell prices for the items on the masterlist when they are issued on a customer invoice	Master list»Discount %	https://docs.msupply.org.nz/items:master_lists?s[]=list&s[]=master#discount	Real
is_non_program_list	Indicates that the master list is not a program list	Master list»Is nonprogram list(Only visible in Congo Republic datafile)	Boolean