tables_fields:main_tables:item_line

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision		 Previous revision
tables_fields:main_tables:item_line [2022/03/11 13:15] – Gary Willettstables_fields:main_tables:item_line [2026/01/21 10:49] (current) – raksha
Line 1: Line 1:
 ====== item_line ====== ====== item_line ======
-[[tables:main_tables:|Back to list of main tables]]+[[..:|Back to list of main tables]]
  
 An item_line record represents a line of stock. An item_line record represents a line of stock.
  
-^ Field name ^ Description ^ Type ^ Length ^ Indexed ^ +^ Field name ^ Description       ^ mSupply Use     ^ Reference link   ^ Type    ^ Indexed ^ 
-| available | The number of packs available for issue | Real |  |  | +|**store_ID** | The store id of the stock line | Not use in UI | | Alpha | * | 
-| **batch** | The batch number of the line | Alpha |   14 |  | +|**item_ID** | The item id of the stock line | Not use in UI | | Alpha | * | 
-| cost_price | The cost price of the stock line, per pack | Real |  |  | +| 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 | | 
-| donor_id | The donor id for the stock line | Long |  |  *  | +| expiry_date | The expiry date of the line | Item detail window>>Stock tab>>open Item stock line detail window>>General tab>>Expiry date | | Date | | 
-| expiry_date | The expiry date of the line | Date |  |  | +|**batch** | The batch number of the line | Item detail window>>Stock tab>>open Item stock line detail window>>General tab>>Batch |  | Text | | 
-| hold | Puts the stock line into hold (No issuing) | Boolean |  |  | +| available | The number of packs available for issue | Item detail window>>Stock tab>>open Item stock line detail window>>General tab>>Available | | Real | | 
-| **ID** | Unique id for a stock line. Visible on stock line input window | Long |  |  *   | +| program_ID | | | | Alpha | | 
-| **item_ID** | The item id of the stock line | Long |  |  *  | +| 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 | | 
-| initial_quan | The initial quantity for a stock line. Mainly used to handle the stock that have been imported without ledger  | 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 | | 
-| **location_ID** | The ID of the location record denoting where this batch is stored | long |   |  *  | +| 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 | | 
-| **manufacturer_ID** | The manufacturer 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 | Item detail window>>Stock tab>>open Item stock line detail window>>General tab>>Initial quantity | | Real | | 
-| **name_ID** | The name id (Customer/supplier) of the stock line | Long |    |  *  | +|**ID** | Unique id for a stock line. Visible on stock line input window | | | Alpha | * | 
-| note | The note information for a stock line | Text |    |  | +| quantity | Total number of packs on hand | Item detail window>>Stock tab>>open Item stock line detail window>>General tab>>Total quantity | | Real | * | 
-| pack_size | The pack size for a stock line | Real |  |  | +|**name_ID** | The name id (Customer/supplier) of the stock line | | | Alpha | * | 
-| pack_quan_per_inner | The inner pack size for a stock line (Comes from transaction line)| Long |  |  | +|**manufacturer_ID** | The manufacturer id of the stock line | | | Alpha | | 
-| pack_inners_per_outer | The outer pack size for a stock line (Comes from transaction line) | Long |  |  | +|**location_ID** | The ID of the location record denoting where this batch is stored | | | Alpha | * | 
-| quantity | Total number of packs on hand | Real |  |  *  | +| 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 | | 
-| **store_ID** | The store id of the stock line | Long |  |  *  | +| stock_on_hand_tot | Total stock on hand for a item | | | Real | | 
-| start_year_quan_tot | Start of an year quantity for a stock line | Real |  |  | +| total_volume | Total volume for a stock line | | | Real | * | 
-| sell_price | The sell price for a stock line, per pack | Real |  |  | +| user_1 | Custom field 1 for stock line | | | Alpha | | 
-| stock_on_hand_tot | Total stock on hand for a item | Real |  |  | +| user_2 | Custom field 2 for stock line | | | Alpha | | 
-| total_cost | Total cost for a stock line, i.e. cost price * quantity | Real |  |  | +| user_3 | Custom field 3 for stock line | | | Alpha | | 
-| total_volume | Total volume for a stock line | Real |  |  *  | +| user_4 | Custom field 4 for stock line | | | Alpha | | 
-| user_1 | Custom field 1 for stock line | String |  20 |  | +| 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 | | 
-| user_2 | Custom field 2 for stock line | String |  20 |  | +| 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 | |  
-| user_3 | Custom field 3 for stock line | String |  20 |  | +| note | The note information for a stock line | Item detail window>>Stock tab>>open Item stock line detail window>>General tab>>Note | | Text | | 
-| user_4 | Custom field 4 for stock line | String |  40 |  | +| 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 | | 
-| volume_per_pack | The volume of a stock line for each pack | Real |  |  | +| 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 | * | 
-| vvm_status | Vaccine Vial Monitoring for stock line | String |  15 |  | +| 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.  | Text |  |  *  | +| 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.  | Text |  |  *  | +| 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.  | Text |  |  *  | +| 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.  | Text |  |  *  | +| 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 | |
 ---- struct data ---- ---- struct data ----
 pagestatus.status    :  pagestatus.status    : 
 ---- ----
  
  • Last modified: 2022/03/11 13:15
  • by Gary Willetts