OnhandQuantityDetailsConsignedQuantityDetails
Provides detailed consigned quantity tracking using specified item and location data.
Columns
Name | Type | Description |
OnhandQuantityDetailsInventoryItemId [KEY] | Long | The unique identifier for the inventory item in the OnhandQuantityDetailsConsignedQuantityDetails table. |
OnhandQuantityDetailsLocatorId [KEY] | Long | The locator identifier that indicates the physical location within a warehouse or storage area for the inventory item in the OnhandQuantityDetailsConsignedQuantityDetails table. |
OnhandQuantityDetailsLotNumber [KEY] | String | The lot number associated with the inventory item in the OnhandQuantityDetailsConsignedQuantityDetails table, used for tracking purposes. |
OnhandQuantityDetailsOrganizationId [KEY] | Long | The identifier for the organization managing the inventory in the OnhandQuantityDetailsConsignedQuantityDetails table. |
OnhandQuantityDetailsSerialNumber [KEY] | String | The unique serial number for the specific instance of the inventory item in the OnhandQuantityDetailsConsignedQuantityDetails table. |
OnhandQuantityDetailsSubinventoryCode [KEY] | String | The code for the subinventory within the organization where the inventory item is stored, used for better categorization in the OnhandQuantityDetailsConsignedQuantityDetails table. |
ConsignedQuantity | Decimal | The quantity of inventory that has been consigned, meaning it is owned by a third party but held in the organization’s possession, within the OnhandQuantityDetailsConsignedQuantityDetails table. |
SecondaryConsignedQuantity | Decimal | The secondary quantity of consigned inventory, which may refer to a different party or a secondary storage location within the OnhandQuantityDetailsConsignedQuantityDetails table. |
PartyName [KEY] | String | The name of the party associated with the consigned inventory item, such as a supplier or distributor, within the OnhandQuantityDetailsConsignedQuantityDetails table. |
PartyType [KEY] | String | The type of party associated with the consigned inventory, such as a supplier, customer, or other business partner, within the OnhandQuantityDetailsConsignedQuantityDetails table. |
PartyNumber [KEY] | String | A unique identifier for the party, such as a supplier number or customer ID, linked to the consigned inventory within the OnhandQuantityDetailsConsignedQuantityDetails table. |
Finder | String | A reference or identifier for the finder, which could be a person or system responsible for locating or identifying the consigned inventory item within the OnhandQuantityDetailsConsignedQuantityDetails table. |
InventoryItemId | Long | The inventory item identifier that refers to the specific product or asset within the OnhandQuantityDetailsConsignedQuantityDetails table. |
LocatorId | Long | The identifier for the specific storage location or warehouse slot of the inventory item within the OnhandQuantityDetailsConsignedQuantityDetails table. |
LotNumber | String | The lot number associated with the batch or group of inventory items, typically used for traceability in the OnhandQuantityDetailsConsignedQuantityDetails table. |
OrganizationId | Long | The identifier for the organization that owns or manages the inventory, used in the OnhandQuantityDetailsConsignedQuantityDetails table. |
SerialNumber | String | The unique serial number identifying a specific unit of the inventory, which can be traced and tracked in the OnhandQuantityDetailsConsignedQuantityDetails table. |
SubinventoryCode | String | The code identifying the subinventory within the organization where the item is stored, providing further categorization in the OnhandQuantityDetailsConsignedQuantityDetails table. |