stock_reorder_levels_v1
The stock reorder level is a predetermined point, quantity, or threshold at which an order should be placed to replenish a particular inventory item. It is set to prevent stockouts and ensure that there is always sufficient stock on hand to meet demand.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the stock reorder level. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the stock reorder level creation. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the contact note deletion. |
| reorder_level_quantity | NUMBER(9,3) | The predetermined quantity at which a new order should be placed to replenish the stock of a particular item. This is set to prevent stockouts and ensure there is always sufficient stock on hand to meet demand. |
| _contact_id | NUMBER(38,0) | The identifier of the contact associated with the stock reorder level. |
| _vehicle_id | NUMBER(38,0) | The identifier of the vehicle associated with the stock reorder level. |
| _stock_id | NUMBER(38,0) | The identifier of the type of stock associated with the stock reorder level. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the stock reorder level record was last refreshed. |