stock_items_v1
A 'Stock Item' refers to any part, tool, or equipment that is kept in inventory and used by service technicians to perform their jobs. This could include anything from replacement parts for machinery, to tools used for repairs, or even consumable supplies like cleaning products or nuts and bolts.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the stock item. |
| product_category | VARCHAR(200) | Represents the classification or grouping of a stock item based on its characteristics, usage, or other criteria. It helps in organising the inventory and can aid in tracking, reporting, and analysing inventory data. |
| make | VARCHAR(200) | The manufacturer or brand of the stock item. |
| model | VARCHAR(200) | The specific model of the stock item. |
| model_number | VARCHAR(200) | The unique number assigned by the manufacturer to identify the model of the stock item. |
| serial_number | VARCHAR(240) | The unique number or barcode assigned to each individual stock item for identification and tracking. |
| alt_serial_number | VARCHAR(240) | The alternative serial number of the stock item. |
| supplier_serial_number | VARCHAR(240) | The unique number used by the supplier for the stock item. |
| customer_serial_number | VARCHAR(240) | The unique number assigned by the customer for the stock item. |
| is_equipment | VARCHAR(3) | Indicates whether the stock item is a piece of equipment or not. |
| is_consumable | VARCHAR(3) | Indicates whether the stock item is a consumable item or not. |
| status | VARCHAR(8) | This status determines whether the cost/selling price is brought through to the Financial Documents the item is added to a job. Possible values: 'Not sold', 'Sold'. |
| sold_at | TIMESTAMP_TZ(9) | The date when the stock item has beenwas sold. |
| condition | VARCHAR(11) | The condition of the stock item. Possible values: 'New', 'Refurbished', 'Used' 'Not set'. |
| size | NUMBER(9,5) | The dimensions or volume of the stock item (m3). |
| weight | NUMBER(10,5) | The weight of the stock item (kg). |
| quantity | NUMBER(9,3) | The number of units of the stock item available in stock. |
| selling_price | NUMBER(8,2) | The selling price of the stock item. |
| tax_percentage | NUMBER(4,2) | The tax (vat) percentage of the stock item. |
| nominal_code | VARCHAR(100) | The nominal code associated with the stock item for accounting purposes. |
| department_code | VARCHAR(50) | The department code of the stock item. |
| created_at | TIMESTAMP_TZ(9) | The date and time when the stock item record was created. |
| deleted_at | TIMESTAMP_TZ(9) | The date and time when the stock item record was deleted. |
| location_type | VARCHAR(17) | The type of location where the stock item is stored. Possible values: 'On vehicle', 'At contact', 'Allocated to item' 'Not set'. |
| _location_vehicle_id | NUMBER(38,0) | The identifier of the vehicle where the stock item is stored. |
| _location_contact_id | NUMBER(38,0) | The identifier of the contact where the stock item is stored. |
| _parent_stock_item_id | NUMBER(38,0) | The identifier of the parent stock item that this item is allocated to. |
| _stock_id | NUMBER(38,0) | The identifier of the stock associated with the stock item. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the stock item record was last refreshed. |