Differences

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

Link to this comparison view

Both sides previous revision Previous revision
tables_fields:main_tables:stock_take [2020/01/07 01:04] – ↷ Page moved from tables:main_tables:stock_take to tables_fields:main_tables:stock_take loutables_fields:main_tables:stock_take [2026/01/27 08:35] (current) – raksha
Line 1: Line 1:
 ==== Stock_take  ==== ==== Stock_take  ====
  
-[[tables:main_tables:|Back to list of main tables]]+[[..:|Back to list of main tables]]
  
-^ Field number  ^  Field Name  ^   Description ^ Type  ^  Length  ^  Index ^ +^Field name ^ Description ^ mSupply Use ^ Reference link ^ Type ^ Indexed ^
 
-|11|comment|     |   Text  |  |  | +|comment| Free-text comments or notes for the stock take |Open/create any Stock take>>Comment |https://docs.msupply.org.nz/items:stocktakes#preparing_the_stocktake | Text | |
 
-|4|created_by_ID|     |   Alpha  |  |  | +|created_by_ID| ID of the user who created the stock take | | | Alpha | |
 
-|10|Description|     |   Alpha  |  |  | +|Description| Short description or title of the stock take |Open/create any Stock take>>Description |https://docs.msupply.org.nz/items:stocktakes#preparing_the_stocktake | Alpha | |
 
-|6|finalised_by_ID|     |   Alpha  |  |  | +|finalised_by_ID| ID of the user who finalised the stock take | | | Alpha | |
 
-|1|ID|     |   Alpha  |  |  Y  | +|**ID**| Unique identifier for the stock take | | | Alpha | |
 
-|7|invad_additions_ID|     |   Alpha  |  |  | +|invad_additions_ID| Inventory adjustment ID for stock additions | | | Alpha | | 
-|8|invad_reductions_ID|     |   Alpha  |  |  | +|invad_reductions_ID| Inventory adjustment ID for stock reductions| | | Alpha | |
 
-|12|Locked|     |   Boolean  |  |  | +|Locked| Indicates whether the stock take is locked from editing |Open/create any Stock take>>Locked |https://docs.msupply.org.nz/items:stocktakes#some_points_to_note | Boolean | |
 
-|15|serial_number|     |   Long Integer  |  |  | +|serial_number| System-generated sequential number |Open/create any Stock take>>Stocktake number | | Long Integer | |
 
-|5|status|     |   Alpha  |  |  | +|status| Current status of the stock take (e.g. draft, finalised) |Open/create any Stock take>>Status | | Alpha | |
 
-|13|stock_take_created_date|     |   Date  |  |  | +|stock_take_created_date| Date the stock take record was created |Open/create any Stock take>>Stocktake entered date | | Date | |
 
-|2|stock_take_date|     |   Date  |  |  | +|stock_take_date| Date the stock take was performed |Open/create any Stock take>>Stocktake date | | Date | | 
-|3|stock_take_time|     |   Time  |  |  | +|stock_take_time| Time the stock take was performed | | | Time | |
 
-|9|store_ID|     |   Alpha  |  |  | +|**store_ID**| Identifier of the store where the stock take occurred | | | Alpha | |
 
-|14|type|     |   Alpha  |"cons" - used by mSupply internally to create a stocktake from raw per-item totals submitted by a mobile store (short for consolidated)  |  |+|type| Stock take type; “cons” used internally for consolidated stock takes | | | Alpha | | 
 +|programID| Program or source system identifier | | | Alpha | | 
 +|om_created_datetime| OMS timestamp when the stock take was created | | | Alpha | | 
 +|om_finalised_datetime| OMS timestamp when the stock take was finalised | | | Alpha | |
 
 +|reference| External or integration reference value | | | Alpha | |
 
 +|custom_data| Custom structured data stored as a blob | | | BLOB | |
 
 +|om_counted_by| OMS user who performed the stock count | | | Alpha | |
 
 +|om_verified_by| OMS user who verified the stock take | | | Alpha | |
 
 +|om_is_initial_stocktake| Indicates whether this is the initial stock take | | | Boolean | |
 
 +|oms_fields| OMS-specific extended fields stored as a blob | | | BLOB | |
  
 ==== Stock_take_lines  ==== ==== Stock_take_lines  ====
-^ Field number  ^  Field Name  ^   Description ^ Type  ^  Length  ^  Index ^ +^ Field name ^ Description ^ mSupply Use ^ Reference link ^ Type ^ Indexed ^ 
-|13|Batch|     |   Alpha  |  |  | +| **ID** | Unique line identifier for this stocktake entry | | | Alpha | | 
-|9|Colour|     |   Long Integer  |  |  | +| **stock_take_ID** |Reference to the parent stocktake | | | Alpha | Y | 
-|11|cost_price|     |   Real  |  |  | +| **item_line_ID** |Link to original stock line for this item | | | Alpha | | 
-|10|expiry|     |   Date  |  |  | +| snapshot_qty | Quantity on hand at snapshot before counting | | | Real | | 
-|1|ID|     |   Alpha  |  |  Y  | +| snapshot_packsize | Pack size recorded at time of snapshot | | | Real | | 
-|14|item_ID|     |   Alpha  |  |  | +| stock_take_qty | Quantity counted during stocktake | |https://docs.msupply.org.nz/items:stocktakes#adding_items_not_in_the_stocktake_list | Real | | 
-|3|item_line_ID|     |   Alpha  |  |  Y  | +| line_number | Display order of the stocktake line |Open/create any one Stocktake>>See column Line | | Long Integer | | 
-|7|line_number|     |   Long Integer  |  |  | +| **location_id** | Location where the stock is stored | | | Alpha | | 
-|8|location_id|     |   Alpha  |  |  Y  | +| Colour | UI colour indicator for the line | | | Long Integer | | 
-|12|sell_price|     |   Real  |  |  | +| expiry | Expiry date of the stock item |Open/create any one Stocktake>>See column Expiry | | Date | | 
-|5|snapshot_packsize|     |   Real  |  |  | +| cost_price | Cost price per pack | | | Real | | 
-|4|snapshot_qty|     |   Real  |  |  | +| sell_price | Sell price per pack | | | Real | | 
-|2|stock_take_ID|     |   Alpha  |  |  Y  | +| Batch | Batch / lot number of the stock |Open/create any one Stocktake>>See column Batch | | Alpha | | 
-|6|stock_take_qty|     |   Real  |  |  |+| **item_ID** | Reference to the item being counted | | | Alpha | | 
 +| **donor_ID** | Donor or funding source of the stock |Open/create any one Stocktake>>New line/edit>>don0r | | Alpha | | 
 +| comment | Free-text notes for this stocktake line | | | Alpha | | 
 +| **optionID** | Item option or variant reference | | | Alpha | | 
 +| is_edited | Indicates the line was manually edited | | | Boolean | | 
 +| spare | Deprecated quantity adjustment field | | | Long Integer | | 
 +| vaccine_vial_monitor_status_ID | VVM status recorded during stocktake | | | Alpha | | 
 +| om_note | Operations or logistics note | | | Alpha | | 
 +| custom_stock_field_1 | Custom stock field 1 (if enabled) User-defined stock field |Is shown in Stock take input form column if it is set by pref | | Alpha | | 
 +| custom_stock_field_2 | Custom field 2 User-defined stock field |Is shown in Stock take input form column if it is set by pref | | Alpha | | 
 +| custom_stock_field_3 | Custom field 3 User-defined stock field |Is shown in Stock take input form column if it is set by pref | | Alpha | | 
 +| custom_stock_field_4 | Custom field 4 User-defined stock field |Is shown in Stock take input form column if it is set by pref | | Alpha | | 
 +| countedExpiryDate | Expiry date entered during counting | | | Date | | 
 +| hold | Stock marked as “do not issue” | | | Boolean | | 
 +| item_name | Item name snapshot at time of stocktake |Open/create any one Stocktake>>See column Item name |https://docs.msupply.org.nz/items:stocktakes#perform_the_stocktake | Alpha | | 
 +| volume_per_pack | Volume per pack for storage calculations | | | Real | | 
 +| weight_per_pack | Weight per pack for logistics | | | Real | | 
 +| **manufacturer_ID** | Manufacturer of the stock item | | | Alpha | | 
 +| snapshot_location_ID | Location recorded at snapshot time | | | Alpha | | 
 +| snapshot_batch | Batch recorded at snapshot time | | | Alpha | | 
 +| snapshot_expiry_date | Batch recorded at snapshot time |  | | Date | | 
 +| custom_stock_field_5_ID | Custom field 5 | | | Alpha | | 
 +| custom_stock_field_6_ID | Custom field 6 | | | Alpha | | 
 +| custom_stock_field_7_ID | Custom field 7 | | | Alpha | | 
 +| custom_stock_field_8_ID | Custom field 8 | | | Alpha | | 
 +| om_item_variant_id | Item variant reference | | | Alpha | | 
 +| oms_fields | OMS-specific structured data | | |Object | |
 ---- struct data ---- ---- struct data ----
 +pagestatus.status    : 
 ---- ----
  
  • Last modified: 2020/01/07 01:04
  • by lou