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