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. |