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