ItemWarehouseInfo
Tracks warehouse-specific details for items, such as stock levels and locations, to enable inventory management.
Columns
| Name | Type | ReadOnly | Description |
| Recordno | Int64 | False |
The unique identifier for the Item Warehouse record. |
| Itemid [KEY] | String | False |
The unique identifier for the item in the warehouse. |
| Warehouseid | String | False |
The identifier for the warehouse where the item is stored. |
| DefaultSubsection | String | False |
The default subsection within the warehouse for the item. |
| Cycle | String | False |
The cycle associated with the item in the warehouse. |
| StandardCost | String | False |
The standard cost of the item in the warehouse. |
| LastCost | String | False |
The last cost of the item recorded in the warehouse. |
| AverageCost | String | False |
The average cost of the item in the warehouse. |
| ReorderMethod | String | False |
The method for reordering the item in the warehouse. |
| EconomicOrderQty | Int64 | False |
The economic order quantity for the item in the warehouse. |
| ReorderPoint | Int64 | False |
The reorder point for the item in the warehouse. |
| ReorderQty | Int64 | False |
The reorder quantity for the item in the warehouse. |
| MinOrderQty | Int64 | False |
The minimum order quantity for the item in the warehouse. |
| MaxOrderQty | Int64 | False |
The maximum order quantity for the item in the warehouse. |
| MaxStock | Int64 | False |
The maximum stock quantity of the item in the warehouse. |
| MinStock | Int64 | False |
The minimum stock quantity of the item in the warehouse. |
| DateLastsold | Datetime | False |
The last date the item was sold from the warehouse. |
| DateLastreceived | Datetime | False |
The last date the item was received in the warehouse. |
| DefaultAisle | String | False |
The default aisle in the warehouse where the item is located. |
| DefaultRow | String | False |
The default row in the warehouse where the item is located. |
| DefaultBin | String | False |
The default bin in the warehouse where the item is located. |
| Wonorder | Decimal | False |
The amount of the item currently on order in the warehouse. |
| Wintransit | Decimal | False |
The amount of the item currently in transit to the warehouse. |
| Wonhand | Decimal | False |
The amount of the item currently on hand in the warehouse. |
| Wonhold | Decimal | False |
The amount of the item currently on hold in the warehouse. |
| Wreserved | Decimal | False |
The amount of the item currently reserved in the warehouse. |
| Wallocated | Decimal | False |
The amount of the item currently allocated in the warehouse. |
| WhseCurrency | String | False |
The currency used for the item in the warehouse. |
| SafetyStock | Int64 | False |
The safety stock level of the item in the warehouse. |
| ReplenishmentMethod | String | False |
The method used for replenishing the item in the warehouse. |
| EnableReplenishment | Bool | False |
Indicates whether replenishment is enabled for the item in the warehouse. |
| RecordUrl | String | False |
The URL for accessing the item warehouse record. |