Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
| tables_fields:main_tables:stock_take [2020/01/07 01:04] – ↷ Page moved from tables:main_tables:stock_take to tables_fields:main_tables:stock_take lou | tables_fields:main_tables:stock_take [2026/01/27 08:35] (current) – Raksha Khadka | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ==== Stock_take | ==== Stock_take | ||
| - | [[tables: | + | [[..:|Back to list of main tables]] |
| - | ^ Field number | + | ^Field |
| - | |11|comment| | + | |comment| |
| - | |4|created_by_ID| | + | |created_by_ID| |
| - | |10|Description| | + | |Description| Short description or title of the stock take |Open/ |
| - | |6|finalised_by_ID| | + | |finalised_by_ID| ID of the user who finalised the stock take | | | Alpha | | |
| - | |1|ID| | + | |**ID**| Unique identifier for the stock take | | | Alpha | | |
| - | |7|invad_additions_ID| | + | |invad_additions_ID| Inventory adjustment ID for stock additions | | | Alpha | | |
| - | |8|invad_reductions_ID| | + | |invad_reductions_ID| Inventory adjustment |
| - | |12|Locked| | + | |Locked| Indicates whether the stock take is locked from editing |Open/ |
| - | |15|serial_number| | + | |serial_number| System-generated sequential number |
| - | |5|status| | + | |status| Current status of the stock take (e.g. draft, finalised) |Open/ |
| - | |13|stock_take_created_date| | + | |stock_take_created_date| Date the stock take record was created |Open/ |
| - | |2|stock_take_date| | + | |stock_take_date| Date the stock take was performed |
| - | |3|stock_take_time| | + | |stock_take_time| Time the stock take was performed |
| - | |9|store_ID| | + | |**store_ID**| Identifier of the store where the stock take occurred |
| - | |14|type| | + | |type| Stock take type; “cons” used internally for consolidated stock takes | | | Alpha | | |
| + | |programID| Program or source system identifier | ||
| + | |om_created_datetime| OMS timestamp when the stock take was created | ||
| + | |om_finalised_datetime| OMS timestamp when the stock take was finalised | ||
| + | |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 | ==== Stock_take_lines | ||
| - | ^ Field number | + | ^ Field name ^ Description |
| - | |13|Batch| | + | | **ID** | Unique line identifier for this stocktake entry | | | Alpha | | |
| - | |9|Colour| | + | | **stock_take_ID** |Reference to the parent stocktake | | | Alpha | Y | |
| - | |11|cost_price| | + | | **item_line_ID** |
| - | |10|expiry| | + | | snapshot_qty | Quantity on hand at snapshot before counting |
| - | |1|ID| | + | | snapshot_packsize | Pack size recorded at time of snapshot | | | Real | | |
| - | |14|item_ID| | + | | stock_take_qty | Quantity counted during stocktake | |https:// |
| - | |3|item_line_ID| | + | | line_number | Display order of the stocktake line |Open/ |
| - | |7|line_number| | + | | **location_id** | Location where the stock is stored | | | Alpha | | |
| - | |8|location_id| | + | | Colour | UI colour indicator for the line | | | Long Integer | | |
| - | |12|sell_price| | + | | expiry | Expiry date of the stock item |Open/ |
| - | |5|snapshot_packsize| | + | | cost_price | Cost price per pack | | | Real | | |
| - | |4|snapshot_qty| | + | | sell_price |
| - | |2|stock_take_ID| | + | | Batch | Batch / lot number of the stock |Open/ |
| - | |6|stock_take_qty| | + | | **item_ID** | Reference to the item being counted | | | Alpha | | |
| + | | **donor_ID** | Donor or funding source of the stock |Open/ | ||
| + | | 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_stock_field_3 | ||
| + | | 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/ | ||
| + | | volume_per_pack | Volume per pack for storage calculations | ||
| + | | 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 | | ||
| + | | 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 | | | ||
| ---- struct data ---- | ---- struct data ---- | ||
| + | pagestatus.status | ||
| ---- | ---- | ||