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