stock_planned_usage_v1
Stock planned usage refers to the anticipated or forecasted use of inventory or stock within a specific period. The goal of planning stock usage is to maintain optimal inventory levels, prevent stockouts or overstock situations, and ensure smooth and efficient operations.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier for each planned stock usage record. |
| quantity_planned | NUMBER(9,3) | The anticipated quantity of stock units that will be used on a job. |
| quantity_actual | NUMBER(9,3) | The actual quantity of stock used on a job. |
| is_equipment_at_drop_off | VARCHAR(3) | A flag indicating whether the stock at the drop-off location is equipment. |
| is_delivered_to_be_sold | VARCHAR(3) | A flag indicating whether the stock is delivered to be sold. |
| action | VARCHAR(44) | Indicates action taken with the planned stock on a job. Possible values: 'No Movement', 'Brought And Left', 'Brought And Taken Back', 'Brought To Swap', 'On Site And Taken Back', 'On Site And Left', 'Used In Stock'. |
| _job_id | NUMBER(38,0) | The identifier of the job associated with the planned stock usage. |
| _stock_id | NUMBER(38,0) | The identifier of the type of stock associated with the planned stock usage on the job. |
| _stock_item_id | NUMBER(38,0) | The identifier of the specific stock item associated with the planned stock usage on the job. |
| _pickup_contact_id | NUMBER(38,0) | The identifier for the contact at the pickup location during the planned stock usage. |
| _drop_off_stock_item_id | NUMBER(38,0) | The identifier for the specific item of stock that is planned to be dropped off or delivered. |
| _drop_off_contact_id | NUMBER(38,0) | The identifier for contact at the drop-off location during the planned stock usage. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the planned stock record was last refreshed. |