Table of Contents

Stock_take

Back to list of main tables

Field name Description mSupply Use Reference link Type Indexed
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
created_by_ID ID of the user who created the stock take 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
finalised_by_ID ID of the user who finalised the stock take Alpha
ID Unique identifier for the stock take Alpha
invad_additions_ID Inventory adjustment ID for stock additions Alpha
invad_reductions_ID Inventory adjustment ID for stock reductions Alpha
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
serial_number System-generated sequential number Open/create any Stock take»Stocktake number Long Integer
status Current status of the stock take (e.g. draft, finalised) Open/create any Stock take»Status Alpha
stock_take_created_date Date the stock take record was created Open/create any Stock take»Stocktake entered date Date
stock_take_date Date the stock take was performed Open/create any Stock take»Stocktake date Date
stock_take_time Time the stock take was performed Time
store_ID Identifier of the store where the stock take occurred Alpha
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

Field name Description mSupply Use Reference link Type Indexed
ID Unique line identifier for this stocktake entry Alpha
stock_take_ID Reference to the parent stocktake Alpha Y
item_line_ID Link to original stock line for this item Alpha
snapshot_qty Quantity on hand at snapshot before counting Real
snapshot_packsize Pack size recorded at time of snapshot Real
stock_take_qty Quantity counted during stocktake https://docs.msupply.org.nz/items:stocktakes#adding_items_not_in_the_stocktake_list Real
line_number Display order of the stocktake line Open/create any one Stocktake»See column Line Long Integer
location_id Location where the stock is stored Alpha
Colour UI colour indicator for the line Long Integer
expiry Expiry date of the stock item Open/create any one Stocktake»See column Expiry Date
cost_price Cost price per pack Real
sell_price Sell price per pack Real
Batch Batch / lot number of the stock Open/create any one Stocktake»See column Batch Alpha
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