ItemWarehouseInfo
Retrieves Item Warehouse data.
Columns
Name | Type | ReadOnly | Description |
Recordno | Int64 | False |
The Recordno field of the Item object. |
Itemid [KEY] | String | False |
The Itemid field of the Item object. |
Warehouseid | String | False |
The Warehouseid field of the Item object. |
DefaultSubsection | String | False |
The DefaultSubsection field of the Item object. |
Cycle | String | False |
The Cycle field of the Item object. |
StandardCost | String | False |
The StandardCost field of the Item object. |
LastCost | String | False |
The LastCost field of the Item object. |
AverageCost | String | False |
The AverageCost field of the Item object. |
ReorderMethod | String | False |
The ReorderMethod field of the Item object. |
EconomicOrderQty | Int64 | False |
The EconomicOrderQty field of the Item object. |
ReorderPoint | Int64 | False |
The ReorderPoint field of the Item object. |
ReorderQty | Int64 | False |
The ReorderQty field of the Item object. |
MinOrderQty | Int64 | False |
The MinOrderQty field of the Item object. |
MaxOrderQty | Int64 | False |
The MaxOrderQty field of the Item object. |
MaxStock | Int64 | False |
The MaxStock field of the Item object. |
MinStock | Int64 | False |
The MinStock field of the Item object. |
DateLastsold | Datetime | False |
The DateLastsold field of the Item object. |
DateLastreceived | Datetime | False |
The DateLastreceived field of the Item object. |
DefaultAisle | String | False |
The DefaultAisle field of the Item object. |
DefaultRow | String | False |
The DefaultRow field of the Item object. |
DefaultBin | String | False |
The DefaultBin field of the Item object. |
Wonorder | Decimal | False |
The Wonorder field of the Item object. |
Wintransit | Decimal | False |
The Wintransit field of the Item object. |
Wonhand | Decimal | False |
The Wonhand field of the Item object. |
Wonhold | Decimal | False |
The Wonhold field of the Item object. |
Wreserved | Decimal | False |
The Wreserved field of the Item object. |
Wallocated | Decimal | False |
The Wallocated field of the Item object. |
WhseCurrency | String | False |
The WhseCurrency field of the Item object. |
SafetyStock | Int64 | False |
The SafetyStock field of the Item object. |
ReplenishmentMethod | String | False |
The ReplenishmentMethod field of the Item object. |
EnableReplenishment | Bool | False |
The EnableReplenishment field of the Item object. |
RecordUrl | String | False |
The RecordUrl field of the Item object. |