OnhandQuantityDetails
Tracks detailed on-hand quantity metrics, supporting various scenarios like inbound, reserved, and consigned quantities.
Columns
| Name | Type | Description |
| OrganizationId [KEY] | Long | The unique identifier for the organization in the OnhandQuantityDetails table. |
| OrganizationCode | String | The code representing the organization in the OnhandQuantityDetails table. |
| InventoryItemId [KEY] | Long | The unique identifier for the inventory item in the OnhandQuantityDetails table. |
| ItemNumber | String | The item number associated with the inventory item in the OnhandQuantityDetails table. |
| SubinventoryCode [KEY] | String | The code representing the subinventory within the organization for the item in the OnhandQuantityDetails table. |
| LocatorId [KEY] | Long | The unique identifier for the locator where the item is stored within the subinventory in the OnhandQuantityDetails table. |
| LotNumber [KEY] | String | The lot number associated with the inventory item, which groups items for tracking purposes in the OnhandQuantityDetails table. |
| OnhandQuantity | Decimal | The quantity of the item currently available and on hand in the OnhandQuantityDetails table. |
| SecondaryOnhandQuantity | Long | The secondary unit of measure (UOM) quantity of the item currently available and on hand in the OnhandQuantityDetails table. |
| ReceivingQuantity | Decimal | The quantity of the item received but not yet fully processed or stocked in the OnhandQuantityDetails table. |
| SecondaryReceivingQuantity | Decimal | The quantity of the item received in the secondary unit of measure, not yet fully processed or stocked in the OnhandQuantityDetails table. |
| ReservedQuantity | Decimal | The quantity of the item that is reserved for future use, preventing it from being used in other transactions, in the OnhandQuantityDetails table. |
| SecondaryReservedQuantity | Decimal | The quantity of the item reserved in the secondary unit of measure, preventing it from being used in other transactions, in the OnhandQuantityDetails table. |
| InboundQuantity | Decimal | The quantity of the item in transit or expected to be received into the subinventory in the OnhandQuantityDetails table. |
| SecondaryInboundQuantity | Decimal | The quantity of the item in transit in the secondary unit of measure, expected to be received into the subinventory in the OnhandQuantityDetails table. |
| ConsignedQuantity | Decimal | The quantity of consigned inventory, which belongs to an external supplier but is stored within the organization, in the OnhandQuantityDetails table. |
| SecondaryConsignedQuantity | Decimal | The quantity of consigned inventory in the secondary unit of measure, belonging to an external supplier but stored within the organization, in the OnhandQuantityDetails table. |
| OwningOrganizationId | Long | The unique identifier for the owning organization, typically the supplier or internal department, in the OnhandQuantityDetails table. |
| OwningOrganization | String | The name or code of the organization that owns the inventory in the OnhandQuantityDetails table. |
| SerialNumber [KEY] | String | The unique serial number identifying a specific unit of the inventory item in the OnhandQuantityDetails table. |
| PrimaryUOMCode | String | The primary unit of measure used for the inventory item in the OnhandQuantityDetails table. |
| SecondaryUOMCode | String | The secondary unit of measure used for the inventory item, if applicable, in the OnhandQuantityDetails table. |
| Finder | String | An additional identifier or code used to help locate or identify the inventory item in the OnhandQuantityDetails table. |