SalesOrdersForOrderHublineslotSerials
Captures lot and serial number details for inventory management, especially for returns or traceable items.
Columns
| Name | Type | Description |
| SalesOrdersForOrderHubHeaderId [KEY] | Long | Unique identifier for the sales order header, linking lot and serial information to the parent order. This ensures proper tracking of item serials and lots within the order lifecycle. |
| LinesFulfillLineId [KEY] | Long | Identifier for the fulfillment line associated with the order, enabling tracking of serials and lots at the line level for accurate inventory management and fulfillment. |
| ItemRevisionNumber | String | Version or revision number of the item, used to track different versions of an item for inventory and quality control purposes. |
| ItemSerialNumberFrom | String | Starting serial number in a range, used for identifying the first serial number of a batch or set of items within an order. |
| ItemSerialNumberTo | String | Ending serial number in a range, used for identifying the last serial number of a batch or set of items within an order. |
| LocatorId | Long | Unique identifier for the locator (location in warehouse or storage area) where the item is shipped from or received into. This helps in tracking item movement within Oracle Fusion Inventory Management. |
| LotNumber | String | Identifies the lot to which the item belongs, used for batch tracking and managing inventory in Oracle Fusion or other inventory management systems. |
| LotSerialId [KEY] | Long | Unique identifier for the lot and serial combination, used to track and manage specific items and their movement in the supply chain. |
| SourceLotSerialId | String | Identifier for the lot and serial combination from the source system, ensuring consistent integration and traceability between Oracle Fusion and external systems. |
| Quantity | Decimal | Number of lots and serials associated with the order line. Used for inventory tracking and order fulfillment. |
| SecondaryQuantity | Decimal | Secondary unit of measure for quantity, used when different units of measure (like weight or volume) are involved in the transaction or fulfillment. |
| Locator | String | Concatenated segments representing the locator flexfields, indicating where the item is shipped from or received into, enabling precise location tracking in Oracle Fusion Inventory Management. |
| DeletedFlag | Bool | Indicates whether the lot and serial lines are deleted during a patch or upsert operation. This is a transient attribute used only in orders with inventory transactions. Default value is not set. |
| Finder | String | Method or tool used to locate specific lot and serial records in Oracle Fusion or other inventory systems, facilitating efficient data retrieval for reporting and operational tasks. |
| FromDate | Date | Start date indicating when the lot and serial data is valid or applicable. This ensures accurate time-based tracking and validation for order fulfillment. |
| HeaderId | Long | Unique identifier for the order header, linking the lot and serial information to the overall sales order, ensuring consistency across the order. |
| OrderKey | String | Unique key used to reference the sales order for managing the lot and serial data, ensuring all related transactions are tracked under the correct order. |
| OrderNumber | String | Unique order number assigned to the sales order, used for tracking, invoicing, and fulfillment processes. |
| SourceTransactionNumber | String | Transaction number from the source system that links the lot and serial data to its originating transaction, ensuring proper integration and traceability. |
| SourceTransactionSystem | String | Name of the source system from which the lot and serial data originated, providing context for integration with external platforms and ensuring consistency across systems. |
| ToDate | Date | End date marking when the lot and serial data is no longer valid or applicable, ensuring accurate, time-bound tracking and management. |