item_line

Back to list of main tables

An item_line record represents a line of stock.

Field name	Description	mSupply Use	Reference link	Type	Indexed
store_ID	The store id of the stock line	Not use in UI	Alpha	*
item_ID	The item id of the stock line	Not use in UI	Alpha	*
pack_size	The pack size for a stock line	Item detail window»Stock tab»open Item stock line detail window»General tab»Pack size	Real
expiry_date	The expiry date of the line	Item detail window»Stock tab»open Item stock line detail window»General tab»Expiry date	Date
batch	The batch number of the line	Item detail window»Stock tab»open Item stock line detail window»General tab»Batch	Text
available	The number of packs available for issue	Item detail window»Stock tab»open Item stock line detail window»General tab»Available	Real
program_ID	Alpha
cost_price	The cost price of the stock line, per pack	Item detail window»Stock tab»open Item stock line detail window»General tab»Cost price	Real
sell_price	The sell price for a stock line, per pack	Item detail window»Stock tab»open Item stock line detail window»General tab»Sell price	Real
hold	Puts the stock line into hold (No issuing)	Item detail window»Stock tab»open Item stock line detail window»General tab»Hold	https://docs.msupply.org.nz/items%3Aitem_basics%3Atab_stock#hold_checkbox	Boolean
initial_quan	The initial quantity for a stock line. Mainly used to handle the stock that have been imported without ledger	Item detail window»Stock tab»open Item stock line detail window»General tab»Initial quantity	Real
ID	Unique id for a stock line. Visible on stock line input window	Alpha	*
quantity	Total number of packs on hand	Item detail window»Stock tab»open Item stock line detail window»General tab»Total quantity	Real	*
name_ID	The name id (Customer/supplier) of the stock line	Alpha	*
manufacturer_ID	The manufacturer id of the stock line	Alpha
location_ID	The ID of the location record denoting where this batch is stored	Alpha	*
volume_per_pack	The volume of a stock line for each pack	Item detail window»Stock tab»open Item stock line detail window»General tab»Volume per pack	Real
stock_on_hand_tot	Total stock on hand for a item	Real
total_volume	Total volume for a stock line	Real	*
user_1	Custom field 1 for stock line	Alpha
user_2	Custom field 2 for stock line	Alpha
user_3	Custom field 3 for stock line	Alpha
user_4	Custom field 4 for stock line	Alpha
pack_quan_per_inner	The inner pack size for a stock line (Comes from transaction line)	Item detail window»Stock tab»open Item stock line detail window»General tab»Quan per inner	https://docs.msupply.org.nz/items%3Aitem_basics%3Atab_stock#quan_per_inner	Real
pack_inners_per_outer	The outer pack size for a stock line (Comes from transaction line)	Item detail window»Stock tab»open Item stock line detail window»General tab»Inners per outer	https://docs.msupply.org.nz/items%3Aitem_basics%3Atab_stock#inners_per_outer	Real
note	The note information for a stock line	Item detail window»Stock tab»open Item stock line detail window»General tab»Note	Text
vvm_status	Vaccine Vial Monitoring for stock line	Item detail window»Stock tab»open Item stock line detail window»Status tab»shows list of VVM status	https://docs.msupply.org.nz/items%3Aitem_basics%3Atab_stock#status_tab_vaccine_vial_monitoring	Alpha
donor_id	The donor id for the stock line	ID is not shown in UI but used to display Item detail window»Stock tab»open Item stock line detail window»General tab»Pack size	Alpha	*
total_cost	Total cost for a stock line, i.e. cost price * quantity	Real
user_5_ID	The ID of the custom field 5 record selected for this stock line.	Alpha	*
user_6_ID	The ID of the custom field 6 record selected for this stock line.	Alpha	*
user_7_ID	The ID of the custom field 7 record selected for this stock line.	Alpha	*
user_8_ID	The ID of the custom field 8 record selected for this stock line.	Alpha	*
kit_data	Object
barcodeID	Text
extraData	Object
repack_original_trans_line_ID	Alpha
weight_per_pack	the weight in kg of one reference pack	Item detail window»Stock tab»open Item stock line detail window»General tab»Weight per pack	Real
om_item_variant_id	Alpha
om_doses	Long Integer
vvm_status_id	Alpha
spare_text	Text
oms_fields	Object