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