Stock_take

Back to list of main tables

Field number	Field Name	Description	Type	Length	Index
11	comment	Text
4	created_by_ID	Alpha
10	Description	Alpha
6	finalised_by_ID	Alpha
1	ID	Alpha	Y
7	invad_additions_ID	Alpha
8	invad_reductions_ID	Alpha
12	Locked	Boolean
15	serial_number	Long Integer
5	status	Alpha
13	stock_take_created_date	Date
2	stock_take_date	Date
3	stock_take_time	Time
9	store_ID	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)

Stock_take_lines

Field number	Field Name	Description	Type	Length	Index
13	Batch	Alpha
9	Colour	Long Integer
11	cost_price	Real
10	expiry	Date
1	ID	Alpha	Y
14	item_ID	Alpha
3	item_line_ID	Alpha	Y
7	line_number	Long Integer
8	location_id	Alpha	Y
12	sell_price	Real
5	snapshot_packsize	Real
4	snapshot_qty	Real
2	stock_take_ID	Alpha	Y
6	stock_take_qty	Real