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) | |
| 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 | | |