ItemStockingInquiries
ItemStockingInquiries
Columns
| Name | Type | Description |
| OrganizationId [KEY] | Long | Value that uniquely identifies the organization |
| OrganizationCode | String | Code that identifies the organization |
| InventoryItemId [KEY] | Long | Value that uniquely identifies the inventory item |
| ItemNumber | String | Number that identifies the inventory item |
| Description | String | Description of the inventory item |
| PrimaryImageURL | String | URL of the primary image for the inventory item |
| SubinventoryCode [KEY] | String | Code that identifies the subinventory location |
| LocatorId [KEY] | Long | Value that uniquely identifies the locator within the subinventory |
| LotNumber [KEY] | String | Number that identifies the lot |
| SerialNumber | String | Number that identifies the serial |
| Locator | String | Name that identifies the locator within the subinventory |
| ParLocation | Int | Par location identifier for inventory replenishment |
| PrimaryUOMCode | String | Code that identifies the primary unit of measure |
| PrimaryUnitOfMeasure | String | Name of the primary unit of measure |
| PrimaryOnhandQuantity | Decimal | On-hand quantity in the primary unit of measure |
| StockingUOMCode | String | Code that identifies the stocking unit of measure |
| StockingUnitOfMeasure | String | Name of the stocking unit of measure |
| StockingOnhandQuantity | Decimal | On-hand quantity in the stocking unit of measure |
| LastReplenishedDate | Datetime | Date when the item was last replenished at this location |
| LotControlCode | Decimal | Code that determines lot control for the inventory item |
| SerialNumberControlCode | Decimal | Code that determines serial number control for the inventory item |
| RevisionControlCode | Decimal | Code that determines revision control for the inventory item |
| PackingStatus | Decimal | Status that indicates the packing condition of the inventory |
| AvailableToTransact | Decimal | Quantity available for transaction |
| LastCountDate | Datetime | Date when the item was last counted at this location |
| BindCountryOfOriginCode | String | Bind parameter for filtering criteria |
| BindProjectId | Long | Bind parameter for filtering criteria |
| BindTaskId | Long | Bind parameter for filtering criteria |
| Finder | String | Finder method identifier for querying with specific filter criteria |