itemVendorItem
Extends ItemVendor with the internal ID and last modified date of the parent item record, sourced via a LEFT JOIN on the Item table.
Columns
| Name | Type | References | Description |
| item | String | The unique identifier or name of the inventory item associated with a vendor. | |
| vendor | String | The supplier providing the item, identified by name or unique vendor ID. | |
| preferredvendor | Boolean | Indicates whether this vendor is the preferred supplier for the given item. | |
| purchaseprice | Float | 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. | |
| 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). | |
| predconfidence | Double | The confidence level associated with the predicted delivery time for the item from this vendor. | |
| predicteddays | Integer | The predicted number of days required for the vendor to deliver the item, based on historical sourcing data. | |
| vendorcost | Decimal | The cost of the item as sourced from the vendor. | |
| itemvendorprice | Integer | The price of the item established for this vendor relationship. | |
| id | Integer | The internal ID of the parent item record, sourced via a LEFT JOIN on the Item table. | |
| lastmodifieddate | Datetime | The date and time the parent item record was last modified, sourced via a LEFT JOIN on the Item table. |