InventoryMovementRequestslines
Provides detailed management of individual lines within movement requests, supporting granular inventory movement control.
Columns
| Name | Type | Description |
| InventoryMovementRequestsHeaderId [KEY] | Long | The unique identifier for the movement request header. This identifier groups related line items under a single movement request for better tracking and processing. |
| HeaderId | Long | The unique identifier for the movement request header. This identifier ensures accurate linkage between movement request lines and the request header. |
| LineId [KEY] | Long | The unique identifier for the movement request line. This identifier ensures precise tracking of individual inventory movement lines within a request. |
| LineNumber | Long | The sequential number assigned to the movement request line. This sequential number helps in ordering and referencing line items in a structured format. |
| InventoryItemId | Long | The unique identifier for the inventory item being moved. This identifier ensures accurate tracking of item movements across warehouse and organization locations. |
| ItemNumber | String | The unique identifier assigned to the inventory item. This identifier supports clear identification of stock items within the inventory movement request. |
| ItemDescription | String | A detailed description of the inventory item being moved. This description provides a user-friendly reference for inventory transactions. |
| ItemRevision | String | The revision number of the inventory item, indicating design or specification changes for tracking purposes. |
| TransactionTypeId | Long | The unique identifier for the type of inventory transaction associated with the movement request. This identifier ensures accurate classification of inventory movements. |
| TransactionType | String | A description of the transaction type associated with the movement request (for example, 'Transfer Order' or 'Replenishment'). |
| RequiredDate | Datetime | The date by which the inventory movement is required. This date ensures timely fulfillment of stock transfer requests. |
| RequesterName | String | The name of the person who submitted the movement request. This name supports accountability and tracking of request initiators. |
| RequesterId | Long | The unique identifier for the requester. This identifier ensures accurate linkage between movement requests and user records in the system. |
| Reason | String | The reason for initiating the movement request (for example, 'Stock Replenishment' or 'Production Use'). |
| ReasonId | Long | The unique identifier for the movement request reason. This identifier ensures accurate classification of movement purposes. |
| Order | String | The order reference associated with the movement request line. This reference provides traceability to purchase, sales, or work orders driving inventory movements. |
| Reference | String | An additional reference for tracking the movement request, such as an external document or transaction identifier. |
| RequestedQuantity | Decimal | The quantity of the inventory item requested for movement. This quantity ensures clear documentation of demand and supply requirements. |
| QuantityDelivered | Decimal | The actual quantity of the inventory item delivered against the movement request. This quantity supports reconciliation of requested versus fulfilled inventory movements. |
| UOMCode | String | The abbreviation representing the unit of measure (UOM) for the requested quantity (for example, 'EA' for each or 'KG' for kilograms). |
| UOMName | String | The full name of the UOM for the requested quantity. This name provides clarity on measurement standards. |
| SecondaryRequestedQuantity | Decimal | The quantity requested for movement in the secondary UOM. This quantity ensures dual UOM tracking for items measured in multiple units. |
| SecondaryQuantityDelivered | Decimal | The actual quantity delivered in the secondary UOM. This quantity supports reconciliation in dual UOM environments. |
| SecondaryUOMCode | String | An abbreviation representing the secondary UOM used in the transaction. This abbreviation ensures accurate measurement conversions. |
| SecondaryUOMName | String | The full name of the secondary UOM. This name ensures clarity in inventory tracking and movement transactions. |
| StatusDate | Date | The date when the status of the movement request line was last updated. This date ensures accurate tracking of processing timelines. |
| StatusCode | Int | The unique identifier for the movement request line status. Accepted values are defined in the lookup type INV_TXN_REQUEST_STATUS, ensuring standardized tracking. |
| Status | String | The description of the status (for example,'Pending Approval', 'Completed', or 'Canceled') for the movement request line. |
| CreatedBy | String | The username of the individual who created the movement request line. This username supports audit tracking and accountability in inventory movements. |
| SourceSubinventory | String | An abbreviation representing the subinventory from which the inventory item is being moved. This abbreviation ensures proper stock tracking and control. |
| SourceLocatorId | Long | The unique identifier for the stock locator within the source subinventory. This identifier ensures precise tracking of item location before movement. |
| SourceLocator | String | A description of the stock locator within the source subinventory. This description supports warehouse location-based tracking of inventory movements. |
| ReferenceTypeCode | Int | The unique code representing the reference type associated with the movement request line. This code ensures classification of external references. |
| ReferenceSourceType | String | A description of the reference source type for the movement request line, supporting integration with external systems. |
| DestinationSubinventory | String | An abbreviation representing the subinventory where the inventory item is being moved. This abbreviation ensures accurate tracking of stock receipt locations. |
| DestinationLocatorId | Long | The unique identifier for the stock locator within the destination subinventory. This identifier ensures proper placement tracking of moved items. |
| DestinationLocator | String | A description of the stock locator within the destination subinventory, supporting warehouse and inventory management. |
| DestinationAccountId | Long | The unique identifier for the financial account associated with the destination subinventory. This identifier ensures accurate financial tracking and reconciliation of inventory movements. |
| DestinationAccount | String | The account number that specifies the financial destination for the inventory movement request. This account number helps track where inventory costs are allocated. |
| ShipToLocationId | Long | The unique identifier for the destination location where the inventory is being moved. This identifier links to the location master data. |
| ShipToLocation | String | The name or code of the destination location where the inventory is being shipped as part of the movement request. |
| LotNumber | String | The lot number assigned to the inventory item. This lot number is used for tracking and control in lot-managed warehouses. |
| Grade | String | The quality or classification of the inventory item being moved. This informaton is often used in industries with quality grading requirements. |
| ToSerialNumber | String | The ending serial number in a sequential range for serial-controlled items. This serial number is used to track specific inventory units. |
| TransactionSourceId | Long | The unique identifier of the source transaction that initiated this inventory movement request. This identifier links it to external or internal processes. |
| TransactionSourceLineId | Long | The unique identifier for the specific line item within the source transaction. This identifier allows detailed tracking at the line level. |
| ExternalSystemGroupId | Long | A system-generated identifier that groups related transactions within an external system integration. |
| WorkCenterCode | String | The code representing the work center responsible for processing or handling the inventory movement request. |
| FromSerialNumber | String | The starting serial number in a sequential range for serial-controlled items. This serial number enables precise tracking of inventory units. |
| PrimaryUOMQuantity | Decimal | The quantity of the inventory item in its primary UOM. This value ensures consistency across transactions and reports. |
| ExternalSystemAllocatedQuantity | Decimal | The quantity of inventory allocated to this request by an external system. This value reflects committed stock levels. |
| ExternalSystemCancelledQuantity | Decimal | The quantity of inventory that was initially requested but later canceled in the external system. |
| ExternalSystemRequestedQuantityInPUOM | Decimal | The quantity of inventory requested in the primary UOM as specified by an external system. |
| ExternalSystemRequestedQuantity | Decimal | The total quantity of inventory requested through an external system, regardless of UOM. |
| IntegrationStatus | String | The current status of the inventory movement request within the integration process. This status indicates whether the request processed successfully, is pending, or has errors. |
| BindItemNumber | String | The item number associated with the inventory movement request. This item number is used to identify the specific product being moved. |
| BindLineStatus | String | The status of the movement request line. This status indicates its current state (for example, 'Pending', 'Approved', or 'Completed'). |
| BindMovementRequestNumber | String | The reference number assigned to the inventory movement request for tracking and auditing purposes. |
| BindMovementRequestType | String | The classification of the movement request (for example, 'Transfer', 'Issue', or 'Return'). This classification defines the nature of the transaction. |
| BindOrganizationCode | String | The organization code that specifies the business unit or division responsible for the inventory movement request. |
| BindUserName | String | The username of the individual or system that initiated or processed the inventory movement request. |
| Finder | String | A reference or key used for searching and retrieving specific inventory movement request records within the system. |