SSIS Components for Oracle Fusion Cloud SCM

Build 26.0.9770

ReturnSerialsForLots

Handles serial numbers tied to specific lots for items eligible for return, enabling precise inventory tracking.

Columns

Name Type SupportedFinders Description
SerialNumber [KEY] String PrimaryKey This column contains the serial number associated with the ReturnSerialsForLots record, identifying the specific return transaction.
BindItemId Long FindSerials This column holds the identifier for the item associated with the return lot, helping to link the return to a specific item in the inventory system.
BindLotNumber String FindSerials This column stores the lot number that groups the serials for return, used for tracking and managing the return process for a specific batch of items.
BindOrganizationId Long FindSerials This column represents the unique identifier for the organization that is initiating the return, used for organizational tracking of return transactions.
BindParentTransactionId Long FindSerials This column indicates the identifier for the parent transaction of the return, establishing the relationship between the return and its originating transaction.
BindSerialNumber String FindSerials This column holds the serial number of the specific item being returned, which allows for precise tracking and handling of individual product returns.
BindTransactionTypeId Long FindSerials This column contains the identifier for the type of transaction associated with the return, which helps categorize and process different return types in the system.
Finder String This column stores a search keyword or identifier used to locate and filter return records for the ReturnSerialsForLots process, assisting in quick retrieval based on specific criteria.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770