item_line

Back to list of main tables

An item_line record represents a line of stock.

Field name	Description	Type	Length	Indexed
available	The number of packs available for issue	Real
batch	The batch number of the line	Alpha	14
cost_price	The cost price of the stock line, per pack	Real
donor_id	The donor id for the stock line	Long	*
expiry_date	The expiry date of the line	Date
hold	Puts the stock line into hold (No issuing)	Boolean
ID	Unique id for a stock line. Visible on stock line input window	Long	*
item_ID	The item id of the stock line	Long	*
initial_quan	The initial quantity for a stock line. Mainly used to handle the stock that have been imported without ledger	Real
location_ID	The ID of the location record denoting where this batch is stored	long	*
manufacturer_ID	The manufacturer id of the stock line	Long
name_ID	The name id (Customer/supplier) of the stock line	Long	*
note	The note information for a stock line	Text
pack_size	The pack size for a stock line	Real
pack_quan_per_inner	The inner pack size for a stock line (Comes from transaction line)	Long
pack_inners_per_outer	The outer pack size for a stock line (Comes from transaction line)	Long
quantity	Total number of packs on hand	Real	*
store_ID	The store id of the stock line	Long	*
start_year_quan_tot	Start of an year quantity for a stock line	Real
sell_price	The sell price for a stock line, per pack	Real
stock_on_hand_tot	Total stock on hand for a item	Real
total_cost	Total cost for a stock line, i.e. cost price * quantity	Real
total_volume	Total volume for a stock line	Real	*
user_1	Custom field 1 for stock line	String	20
user_2	Custom field 2 for stock line	String	20
user_3	Custom field 3 for stock line	String	20
user_4	Custom field 4 for stock line	String	40
volume_per_pack	The volume of a stock line for each pack	Real
vvm_status	Vaccine Vial Monitoring for stock line	String	15
user_5_ID	The ID of the custom field 5 record selected for this stock line.	Text	*
user_6_ID	The ID of the custom field 6 record selected for this stock line.	Text	*
user_7_ID	The ID of the custom field 7 record selected for this stock line.	Text	*
user_8_ID	The ID of the custom field 8 record selected for this stock line.	Text	*