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