tables_fields:main_tables:item_line

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 *
  • Last modified: 2022/03/11 14:33
  • by Gary Willetts