OnhandQuantityDetailsInboundQuantityDetails
Tracks inbound quantity details for specified items and locations, aiding in receiving and inventory planning.
Columns
Name | Type | Description |
OnhandQuantityDetailsInventoryItemId [KEY] | Long | The unique identifier for the inventory item in the OnhandQuantityDetailsInboundQuantityDetails table, representing a specific product or item. |
OnhandQuantityDetailsLocatorId [KEY] | Long | The identifier for the storage location within the warehouse where the inventory item is stored in the OnhandQuantityDetailsInboundQuantityDetails table. |
OnhandQuantityDetailsLotNumber [KEY] | String | The lot number assigned to a batch of inventory items within the OnhandQuantityDetailsInboundQuantityDetails table. It helps track the production or receipt batch of items. |
OnhandQuantityDetailsOrganizationId [KEY] | Long | The identifier of the organization that owns the inventory items in the OnhandQuantityDetailsInboundQuantityDetails table, usually linked to a company or business unit. |
OnhandQuantityDetailsSerialNumber [KEY] | String | The unique serial number assigned to an individual inventory item within the OnhandQuantityDetailsInboundQuantityDetails table for traceability and warranty purposes. |
OnhandQuantityDetailsSubinventoryCode [KEY] | String | The code representing the subinventory where the inventory item is located within the OnhandQuantityDetailsInboundQuantityDetails table, typically linked to a specific storage area. |
InboundQuantity | Decimal | The quantity of the inventory item being received or inbound in the OnhandQuantityDetailsInboundQuantityDetails table, reflecting incoming stock or shipments. |
SecondaryInboundQuantity | Decimal | An additional quantity field for inbound items in the OnhandQuantityDetailsInboundQuantityDetails table, typically used for different units of measure or secondary tracking purposes. |
DocumentNumber [KEY] | String | The document number associated with the transaction or shipment in the OnhandQuantityDetailsInboundQuantityDetails table, used for tracking and reference purposes. |
LineNumber [KEY] | Decimal | The line number in the document or shipment for the OnhandQuantityDetailsInboundQuantityDetails table, often used for distinguishing between multiple items in a single shipment. |
Schedule | String | A schedule identifier in the OnhandQuantityDetailsInboundQuantityDetails table, potentially indicating the planned date or timing of the inbound inventory transaction. |
DocumentType | String | The type of document (for example, purchase order, transfer) associated with the transaction in the OnhandQuantityDetailsInboundQuantityDetails table, providing context for the inbound inventory. |
Finder | String | A reference to the system or tool used to search for or locate the inventory item in the OnhandQuantityDetailsInboundQuantityDetails table, potentially representing a user or software. |
InventoryItemId | Long | The identifier for the inventory item in the OnhandQuantityDetailsInboundQuantityDetails table, representing the specific product or item in the system. |
LocatorId | Long | The identifier for the location of the inventory item within the warehouse, typically a shelf or bin, in the OnhandQuantityDetailsInboundQuantityDetails table. |
LotNumber | String | The lot number or batch identifier assigned to a group of items in the OnhandQuantityDetailsInboundQuantityDetails table, useful for managing product recalls or quality control. |
OrganizationId | Long | The organization identifier representing the business or entity managing the inventory in the OnhandQuantityDetailsInboundQuantityDetails table. |
SerialNumber | String | A unique serial number used to identify individual units of inventory within the OnhandQuantityDetailsInboundQuantityDetails table, ensuring traceability and detailed management. |
SubinventoryCode | String | A code representing the subinventory where the items are located in the OnhandQuantityDetailsInboundQuantityDetails table, typically corresponding to specific areas within a warehouse. |