ItemWarehouseInventory
Represents inventory levels and replenishment settings for an item at a specific warehouse location, including quantity details, cost values, and bin assignments.
Columns
| Name | Type | ReadOnly | Description |
| allocated | Int | True |
The quantity of this item currently allocated to orders at this warehouse. |
| averageCost | String | True |
The average cost of this item at this warehouse. |
| defaultBin_Href | String | True |
The URL of the default bin assigned to this item at this warehouse. |
| defaultBin_Id | String | False |
The Id of the default bin assigned to this item at this warehouse. |
| defaultBin_Key | String | False |
The system-assigned key of the default bin assigned to this item at this warehouse. |
| economicOrderQuantity | Int | False |
The economical order quantity for this item at this warehouse. |
| enableReplenishment | Bool | False |
Indicates whether automatic replenishment is enabled for this item at this warehouse. |
| href | String | True |
The URL of the item warehouse inventory resource. |
| id | String | True |
The unique identifier of the item warehouse inventory record. |
| inTransit | Int | True |
The quantity of this item currently in transit to this warehouse. |
| inventoryCycle_Href | String | True |
The URL of the inventory cycle associated with this item at this warehouse. |
| inventoryCycle_Id | String | False |
The Id of the inventory cycle associated with this item at this warehouse. |
| inventoryCycle_Key | String | False |
The system-assigned key of the inventory cycle associated with this item at this warehouse. |
| item_Href | String | True |
The URL of the item associated with this warehouse inventory record. |
| item_Id | String | False |
The Id of the item associated with this warehouse inventory record. |
| item_Key | String | False |
The system-assigned key of the item associated with this warehouse inventory record. |
| key [KEY] | String | True |
The system-assigned key that uniquely identifies the item warehouse inventory record. |
| lastCost | String | True |
The most recent purchase cost of this item at this warehouse. |
| lastReceivedDate | Date | True |
The date on which this item was last received at this warehouse. |
| lastSoldDate | Date | True |
The date on which this item was last sold from this warehouse. |
| maxOrderQuantity | Int | False |
The maximum order quantity allowed when replenishing this item at this warehouse. |
| maximumStock | Int | False |
The maximum stock level to maintain for this item at this warehouse. |
| minOrderQuantity | Int | False |
The minimum order quantity required when replenishing this item at this warehouse. |
| minimumStock | Int | False |
The minimum stock level to maintain for this item at this warehouse. |
| onHand | Int | True |
The total quantity of this item currently on hand at this warehouse. |
| onHold | Int | True |
The quantity of this item currently on hold at this warehouse. |
| onOrder | Int | True |
The quantity of this item currently on open purchase orders for this warehouse. |
| reorderMethod | String | True |
The reorder method used to trigger replenishment for this item at this warehouse. |
| reorderPoint | Int | False |
The inventory level at which a replenishment order is triggered for this item at this warehouse. |
| reorderQuantity | Int | False |
The quantity to order when replenishing this item at this warehouse. |
| replenishmentMethod | String | False |
The replenishment method used for this item at this warehouse, such as reorder point or min/max. |
| reserved | Int | True |
The quantity of this item reserved for specific orders at this warehouse. |
| safetyStock | Int | False |
The minimum safety stock quantity to maintain for this item at this warehouse. |
| standardCost | String | False |
The standard cost of this item at this warehouse. |
| storageArea | String | False |
The storage area within the warehouse where this item is located. |
| unCommitted | Int | True |
The quantity of this item that is available and not committed to any order at this warehouse. |
| warehouseLocation_Currency | String | True |
The currency of the warehouse location associated with this inventory record. |
| warehouseLocation_Href | String | True |
The URL of the warehouse location associated with this inventory record. |
| warehouseLocation_Id | String | True |
The Id of the warehouse location associated with this inventory record. |
| warehouseLocation_Key | String | True |
The system-assigned key of the warehouse location associated with this inventory record. |
| warehouse_Href | String | True |
The URL of the warehouse associated with this inventory record. |
| warehouse_Id | String | False |
The Id of the warehouse associated with this inventory record. |
| warehouse_Key | String | False |
The system-assigned key of the warehouse associated with this inventory record. |
| ListAggregate_ItemWarehouseVendor | String | False |
The aggregate list of vendor records associated with this item at this warehouse. |
| ListAggregate_StandardCostEntries | String | False |
The aggregate list of standard cost entries for this item at this warehouse. |