itemVendor
Tracks vendor relationships with items, including preferred suppliers, negotiated pricing, and sourcing details.
Columns
| Name | Type | References | Description |
| item | String | The unique identifier or name of the inventory item associated with a vendor. | |
| preferredvendor | Boolean | Indicates whether this vendor is the preferred supplier for the given item. | |
| purchaseprice | String | The cost at which the item is purchased from the vendor, typically set in the vendor's currency. | |
| schedule | String | The purchasing schedule or agreement linked to the vendor for this item, which can include reorder frequencies or contract terms. | |
| subsidiary | String | The specific subsidiary within the organization that is associated with the vendor-item relationship. | |
| vendor | String | The supplier providing the item, identified by name or unique vendor ID. | |
| vendorcode | String | A unique code assigned to the vendor for reference in procurement and inventory systems. | |
| vendorcostentered | Decimal | The cost of the item as entered into the system, reflecting the price set by the vendor before any adjustments or conversions. | |
| vendorcurrencyid | String | The currency in which the vendor's pricing is denominated, identified by its currency code (for example, USD, EUR, and GBP). |