stock_movements_v1
Stock movements refer to the activities involving the transfer or relocation of goods or inventory within, into, or out of a specific location such as warehouse, store, or vehicle. Each stock movement typically involves a change in the quantity of a specific product or item in the inventory.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier for each stock movement record. |
| pickup_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the stock pick up. |
| pickup_quantity | NUMBER(9,3) | The count of stock units that were picked up. |
| pickup_position_longitude | FLOAT | The longitudinal geographic coordinate of the pickup location. |
| pickup_position_latitude | FLOAT | The latitudinal geographic coordinate of the pickup location. |
| drop_off_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of the stock drop off. |
| drop_off_quantity | NUMBER(9,3) | The count of stock units that were delivered. |
| drop_off_position_longitude | FLOAT | The longitudinal geographic coordinate of the drop-off location. |
| drop_off_position_latitude | FLOAT | The latitudinal geographic coordinate of the drop-off location. |
| owner_name | VARCHAR(100) | The name of the individual or entity who owns the stock movement. |
| owner_type | VARCHAR(8) | The category of the owner. Possible values: 'Resource', 'User'. |
| is_equipment_at_pickup | VARCHAR(3) | A flag indicating if the stock at the pickup location is equipment. |
| is_equipment_at_drop_off | VARCHAR(3) | A flag indicating if the stock at the drop-off location is equipment. |
| is_delivered_to_be_sold | VARCHAR(3) | A flag indicating if the delivered stock is meant for sale. |
| _job_id | NUMBER(38,0) | The identifier of the job associated with the stock usage/movement. |
| _invoice_id | NUMBER(38,0) | The identifier of the invoice associated with the stock usage/movement. |
| _asset_id | NUMBER(38,0) | The identifier of the asset (vehicle) associated with the stock movement. |
| _stock_id | NUMBER(38,0) | The identifier of the type of stock associated with the stock movement. |
| _stock_item_id | NUMBER(38,0) | The identifier of the specific stock item involved in the stock movement. |
| _pickup_stock_item_id | NUMBER(38,0) | The identifier of the stock item at the pickup location. |
| _pickup_asset_id | NUMBER(38,0) | The identifier of the asset (vehicle) at the pickup location. |
| _pickup_contact_id | NUMBER(38,0) | The identifier of the contact at the pickup location. |
| _drop_off_stock_item_id | NUMBER(38,0) | The identifier of the stock item at the drop-off location. |
| _drop_off_asset_id | NUMBER(38,0) | The identifier of the asset (vehicle) at the drop-off location. |
| _drop_off_contact_id | NUMBER(38,0) | The identifier of the contact at the drop-off location. |
| _owner_id | NUMBER(38,0) | The identifier of the owner related to the stock movement. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the stock movement record was last refreshed. |