stock_v1
A 'Stock' refers to the 'Type' or 'Make & Model' of parts, tools and equipment that a business plans to use or interact with to perform their jobs. This term should not be confused with 'Stock Item', which specifically refers to an individual, physical product that the company currently holds in its inventory.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the stock. |
| product_category | VARCHAR(200) | Represents the classification or grouping of a stock 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. |
| model | VARCHAR(200) | The specific model of the stock. |
| model_number | VARCHAR(200) | The unique number assigned by the manufacturer to identify the model of the stock. |
| stock_code | VARCHAR(200) | The unique number or barcode assigned to each individual stock for identification and tracking. |
| batch_number | VARCHAR(200) | The batch number of the stock. |
| is_consumable | VARCHAR(3) | Indicates whether the stock is a consumable item or not. |
| size | NUMBER(9,5) | The dimensions or volume of the stock (m3). |
| weight | NUMBER(10,5) | The weight of the stock (kg). |
| notes | VARCHAR(500) | Notes associated with the stock. |
| currency_code | VARCHAR(6) | The identifier of the currency (ISO 4217 currency code). |
| selling_price | NUMBER(8,2) | The selling price of the stock. |
| tax_percentage | NUMBER(4,2) | The tax (vat) percentage of the stock. |
| department_code | VARCHAR(16) | The department code of the stock. |
| nominal_code | VARCHAR(100) | The nominal code associated with the stock for accounting purposes. |
| created_at | TIMESTAMP_TZ(9) | The date and time when the stock record was created. |
| deleted_at | TIMESTAMP_TZ(9) | The date and time when the stock record was deleted. |
| _tax_id | NUMBER(38,0) | The identifier of the tax (vat) associated with the stock. |
| _owner_id | NUMBER(38,0) | The identifier of the stock owner. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the stock record was last refreshed. |