inventoryItemItemVendor
Manages the association between inventory items and their approved vendors, including supplier details and purchasing terms.
Columns
| Name | Type | References | Description |
| item | String | The unique identifier or name of the inventory item associated with a specific vendor. | |
| preferredvendor | Boolean | Indicates whether this vendor is the preferred supplier for the given inventory item. A value of 'true' means the vendor is preferred. | |
| purchaseprice | String | The cost at which the inventory item is purchased from the vendor. This value reflects the agreed-upon price before any discounts or taxes. | |
| schedule | String | The purchasing schedule or frequency with which the inventory item is ordered from the vendor. This can represent predefined procurement cycles. | |
| subsidiary | String | The specific subsidiary within the organization that is responsible for purchasing the inventory item from the vendor. Useful for multi-entity organizations. | |
| vendor | String | The name or identifier of the vendor supplying the inventory item. This links the item to its supplier in the procurement system. | |
| vendorcode | String | The internal or vendor-provided code used to identify the inventory item in the vendor’s catalog. Helps match vendor-specific product references. | |
| vendorcostentered | Decimal | The cost of the inventory item as entered in the system, which can include vendor-specific pricing considerations before conversion or adjustments. | |
| vendorcurrencyid | String | The currency in which the vendor's pricing is recorded. Ensures accurate cost tracking across international transactions. |