stock_suppliers_v1
The stock supplier refers to the entity, individual, or company that provides or supplies the inventory or goods to a business. Stock supplier details refer to the comprehensive information about the cost of inventory and the warranty provisions offered by the suppliers of the stock.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The unique identifier of the stock supplier. |
| cost | NUMBER(8,2) | The cost refers to the amount charged by the stock supplier for each unit of inventory. |
| currency_code | VARCHAR(3) | The currency code refers to the type of currency in which the cost of the inventory is denominated (ISO 4217 currency code). |
| warranty_period | NUMBER(38,0) | The warranty period refers to the duration (in months) for which the stock supplier guarantees the inventory's quality and performance. |
| _contact_id | NUMBER(38,0) | The identifier of the contact associated with the stock supplier. It is used for communication and relationship management with the supplier. |
| _stock_id | NUMBER(38,0) | The identifier of the type of stock associated with the stock supplier. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the stock supplier record was last refreshed. |