Name

Back to list of main tables

A name is a customer, supplier, patient, manufacturer or donor, or maybe a combination of these.

Field name	Description	Type	Indexed
ID	The unique ID given to this name	Long	*
Related to asset.name_id, backorder.name_id_customer, backorder.name_id_supplier, contact.name_ID, Goods_received_line.manufacturer_ID, HIS_encoutner.PATIENT_ID, item_line.name_ID, item_line.manufacturer_ID, item_store_join.non_stock_name_ID, list_group.name_id, list_name_join.name_ID, name_budget.name_ID, name_note.name_ID, name_stock_history.name_ID, name_store_join.name_ID, patient_medication.name_ID, purchase_order.name_ID, purchase_order_line.non_stock_name_ID, quote.names_ID, quote_line.manufacturer_ID, quote_line.name_ID, regimen_record.name_ID, repeat_table.name_ID, store.name_ID, transact.name_ID, web_favourite.name_ID, tender.benchmarkSupplier_ID,[goods_received]donor_id,[item_line]donor_id, [purchase_order]donor_id, [trans_line]donor_id
name	Name's name	Alpha	*
barcode	Set to the code field with an '*' at either end. Doesn't seem to be used for anything…	Alpha
Benchmark	True if name is a benchmark supplier, against which others' prices are to be compared	Boolean
bill_address1	Billing address line 1	Alpha
bill_address2	Billing address line 2	Alpha
bill_address3	Billing address line 3	Alpha
bill_address4	Billing address line 4	Alpha
bill_address5	Billing address line 5	Alpha
bill_postal_zip_code	Billing address postcode	Alpha
Blood_Group	Patients only: patient's blood group	Alpha
category1_ID	ID of the category1 level3 category this name has been assigned to	Long	*
category2_ID	ID of the category2 category the name is assigned to	Longint	*
category3_ID	ID of the category3 category the name is assigned to	Longint	*
category4_ID	ID of the category4 category the name is assigned to	Longint	*
category5_ID	ID of the category5 category the name is assigned to	Longint	*
category6_ID	ID of the category6 category the name is assigned to	Longint	*
charge code	Code to charge a name's transactions to when exporting	Alpha	*
code	This name's code	Alpha	*
comment	Comment stored against this name	Text
connection_type	The type of connection to the internet the name has: 1=low bandwidth, 2=high bandwidth	Integer
country	Billing address country	Alpha
currency_ID	Supplier only: ID of the currency this supplier uses	Alpha
custom1	Custom field 1 contents - defined by user	Alpha
custom2	Custom field 2 contents - defined by user	Alpha
custom3	Custom field 3 contents - defined by user	Alpha
custom_data	Custom data stored as values and fields. Also facility code for DHIS2 data is placed here	Object
customer	True if this name is a customer	Boolean	*
date_of_birth	Patients only: patient's date of birth	Date
default_order_days	The default number of days that this customer orders for in a customer stock history	Integer
donor	True if the name is a donor	Boolean	*
email	Name's email address. You can put multiple email addresses here separated by commas.	Alpha
ethnicity_ID	Patients only: ID of the patient's ethnicity	Longint	*
fax	Name's phone number	Alpha
female	Patients only: True if female, False if male	Boolean
first	Patients only: patient's first name	Alpha	*
flag	Comma separated list of flags assigned to this name	Alpha
freightfac	Multiplier to apply to quote lines to account for freight charges.	Real
group_ID	ID of the department this name has been assigned to	Long	*
hold	If true, you can't issue or receive items to/from this name	Boolean
is_deleted	Only used for patients in mobile. Soft delete flag i.e. patients with this set to true are not displayed or included in search results	Boolean
isDeceased	Only used for patients in mobile. Set to true if the patient has died	Boolean
last	Patients only: patient's last name	Alpha	*
latitude	The degrees latitude of the name's location	Real
longitude	The degrees longitude of the name's location	Real
manufacturer	True if this name is a manufacturer	Boolean	*
margin	The margin applied to the cost price of this supplier's goods to calculate the sell price	Real
marital_status	Patients only: patient's marital status	Alpha
Master_RTM_Supplier_Code	The code this supplier has in the RTM	Longint	*
Master_RTM_Supplier_name	The name of this supplier in the RTM	Alpha
middle	Patients only: patient's middle name	Alpha
mother_id	Patients only: ID of the patient's mother (another patient)	Longint	*
national_health_number	Patients only: patient's national health number	Alpha
NEXT_OF_KIN_ID	Patients only: ID of the patient's next of kin (another patient)	Longint	*
next_of_kin_relative	Relation that is patient's next of kin e.g. 'Parent'	Alpha
occupation_ID	Patients only: ID of the patient's occupation	Longint	*
om_created_datetime	The time a name was created. Used by Open mSupply in a sync system.	Time
om_gender	Gender, used by Open mSupply in a sync system. mSupply only has male and female as choices, Open mSupply has a much wider selection of options	Text
ordering_method	The type of customer stock history this customer uses: im=imprest, sh=stock history	Alpha
overpayment	Deprecated as of v4.11 and not used - calculated as needed Amount overpaid to a customer from a supplier	Real
PATIENT_PHOTO	Patients only: patient's photo	Picture
phone	Name's phone number	Alpha
POBOX	Patients only: the patient's PO Box, part of their address	Alpha
postal_address1	Postal address line 1	Alpha
postal_address2	Postal address line 2	Alpha
postal_address3	Postal address line 3	Alpha
postal_address4	Postal address line 4	Alpha
postal_address5	Postal address line 5	Alpha
postal_zip_code	Postal address postcode	Alpha
preferred	If true this supplier is a preferred supplier when comparing bids in a tender	Boolean
price_category	The price category (A-F) this name is assigned to	Alpha
print_invoice_alphabetical	If true, invoice lines are printed in alphabetical order for this name	Boolean
religion_ID	Patients only: ID of the patient's religion	Longint	*
sacho	The name's web login password	BLOB
ship_address1	Shipping address line 1	Alpha
ship_address2	Shipping address line 2	Alpha
ship_address3	Shipping address line 3	Alpha
ship_address4	Shipping address line 4	Alpha
ship_address5	Shipping address line 5	Alpha
ship_postal_zip_code	Shipping address postcode	Alpha
supplier	True if this name is a supplier	Boolean	*
title	Patients only: patient's title (Mr, Ms etc.)	Alpha
type (v3.5 on)	“store” - a name associated with an mSupply virtual store “invad” - a reserved name used for inventory adjustment transactions “build” - a reserved name used for build transactions “repack” - a reserved name used for repack transactions “patient” - patients “facility” - a supplier or customer who is external to your mSupply virtual store system (see booleans name.customer and name.supplier for differentiation)	Alpha	*
url	Web page of this name. Includes “http://”	Alpha
web_id	The user name used to log on to the web interface	Alpha	*
ZIP	Postal address postcode	Longint