ItemVendor
Represents vendor-specific information for items, including pricing, lead time, order quantity settings, and unit of measure details.
Columns
| Name | Type | Description |
| bestPrice | Decimal | The best price achieved for this item from the associated vendor. |
| conversionFactor | String | The unit of measure conversion factor used when purchasing this item from the vendor. |
| demandForecastDuringLeadTime | Int | The forecasted demand quantity for this item during the vendor's lead time. |
| economicalOrderQuantity | Int | The economical order quantity that minimizes total ordering and holding costs for this item. |
| href | String | The URL of the item vendor resource. |
| id | String | The unique identifier of the item vendor record. |
| isPreferredVendor | Bool | Indicates whether this vendor is the preferred supplier for this item. |
| item_Href | String | The URL of the item associated with this vendor record. |
| item_Id | String | The Id of the item associated with this vendor record. |
| item_Key | String | The system-assigned key of the item associated with this vendor record. |
| key [KEY] | String | The system-assigned key that uniquely identifies the item vendor record. |
| latestPrice | Decimal | The most recently recorded purchase price for this item from the vendor. |
| leadTime | Int | The lead time in days for this item from the vendor. |
| stockNumber | String | The vendor's stock number for this item. |
| unitOfMeasure_Href | String | The URL of the unit of measure associated with this item vendor record. |
| unitOfMeasure_Id | String | The Id of the unit of measure associated with this item vendor record. |
| unitOfMeasure_Key | String | The system-assigned key of the unit of measure associated with this item vendor record. |
| vendorMinimumOrderQuantity | Int | The minimum order quantity required by the vendor for this item. |
| vendor_Href | String | The URL of the vendor associated with this item. |
| vendor_Id | String | The Id of the vendor associated with this item. |
| vendor_Key | String | The system-assigned key of the vendor associated with this item. |