InterfacedPickTransactions
Facilitates data exchange for pick transactions with warehouse and logistics systems after pick confirmation.
Columns
| Name | Type | Description |
| ProcessingFlag | Bool | Indicates whether the input data undergoes validation before processing. If set to 'true', the data is validated for accuracy and completeness before being processed. If set to 'false', the data is inserted directly into the table without further validation. |
| TransactionInterfaceId [KEY] | Long | A system-generated identifier for the transaction interface record. This identifier links pick transactions to interfacing processes between inventory and warehouse management systems. |
| OrganizationId | Long | A system-generated identifier for the inventory organization associated with the transaction. This identifier ensures accurate tracking of inventory movements within the organization. |
| OrganizationCode | String | The unique identifier for the inventory organization. This identifier is represented by an alphanumeric code that corresponds to a specific business unit or warehouse. |
| InventoryItemId | Long | A system-generated identifier for the inventory item involved in the pick transaction. This identifier is used for tracking product movement and stock reconciliation. |
| ItemNumber | String | The unique identifier for the product or material by its designated item number. This identifier is used to identify and manage inventory within the warehouse system. |
| Revision | String | The revision number of the item, applicable when revision control is enabled. This number helps track different versions of an inventory item. |
| SourceSubinventoryCode | String | The code representing the subinventory from which the item is being picked. This subinventory serves as the origin point for the transaction. |
| SourceLocatorId | Long | A system-generated identifier for the source locator. This identifier specifies the exact storage location within the warehouse where the item is picked from. |
| SourceLocatorName | String | The name of the source locator, providing a human-readable reference for the warehouse location where the item is stored before being picked. |
| DestinationSubinventoryCode | String | The code representing the subinventory to which the picked item is transferred. This code indicates the final storage or staging location for the transaction. |
| DestinationLocatorId | Long | A system-generated identifier for the destination locator. This identifier specifies the exact storage location within the warehouse where the item is being moved to. |
| DestinationLocatorName | String | The name of the destination locator, providing a human-readable reference for the warehouse location where the picked item is placed. |
| PrimaryTransactionQuantity | Decimal | The quantity of the item being transacted in its primary unit of measure (UOM). This quantity is used for inventory adjustments and stock updates. |
| TransactionQuantity | Decimal | The quantity of the item being transacted in the user’s preferred UOM. This quantity is used for reporting and operational consistency. |
| TransactionUOMCode | String | The UOM code for the transaction, specifying how the quantity is measured (for example, 'EA' for each or 'KG' for kilograms). |
| TransactionUOMName | String | The name of the UOM associated with the transaction, providing a descriptive label for the measurement unit. |
| SecondaryTransactionQuantity | Decimal | The quantity of the item being transacted in an alternate unit of measure for the pick-confirm transaction. This quantity is used when dual units of measure are required. |
| SecondaryUOMCode | String | The secondary UOM code used for the pick-confirm transaction, providing an alternative measurement for inventory control. |
| SecondaryUOMName | String | The name of the secondary UOM used for the pick-confirm transaction, ensuring clarity in unit conversions. |
| AllocatedQuantity | Decimal | The quantity allocated by the Warehouse Management System (WMS) or third-party logistics (3PL) system for the pick transaction. This quantity is reserved for fulfillment. |
| ShortQuantity | Decimal | The quantity short-picked by the Warehouse Management System (WMS) or third-party logistics (3PL) system, indicating a discrepancy between allocated and picked quantities. |
| TransactionDate | Date | The date when the pick transaction was created, providing a timestamp for tracking inventory movements. |
| TransactionTypeId | Long | A system-generated identifier for the transaction type. This identifier categorizes the nature of the pick transaction for audit and reporting purposes. |
| TransactionTypeName | String | The name of the transaction type. This name corresponds to predefined values from the inventory transaction type configuration. |
| MovementRequestHeaderId | Long | A system-generated identifier for the movement request header. This identifier links the pick transaction to an overarching inventory movement request. |
| MovementRequestHeaderNumber | String | The unique number assigned to the movement request header. This number provides a reference for tracking inventory movement requests. |
| MovementRequestLineId | Long | A system-generated identifier for the movement request line. This identifier ties the pick transaction to a specific line item in the movement request. |
| MovementRequestLineNumber | Long | The unique number assigned to the movement request line. This number provides a reference for tracking individual items in the movement request. |
| SourceCode | String | The transaction source code used for audit and process control. This code identifies the origin of the pick transaction within the system. |
| TransactionReference | String | The reference code assigned to the pick-confirm transaction. This code provides a link to related inventory or fulfillment processes. |
| ExternalSystemTransactionReference | String | The reference code for transaction data passed from an external Warehouse Management System (WMS) or third-party logistics (3PL) system, ensuring integration and tracking of externally managed inventory. |
| ExternalSystemPackingUnit | String | The license plate number assigned by an external or third-party Warehouse Management System (WMS). This identifier is used for tracking and managing inventory within an external logistics system. |
| ReasonId | Long | A system-generated identifier for the pick transaction reason. This identifier is used to classify the cause of the transaction within inventory operations. |
| ReasonName | String | The name of the reason associated with the pick transaction. The values are based on the lookup type INV_REASON_TYPES in FND_LOOKUPS and help categorize transaction adjustments. |
| StatusCode | String | The code representing the current status of the pick transaction. This code is used for system processing, workflow control, and reporting. |
| Status | String | A descriptive status of the pick transaction, providing a human-readable representation of the transaction’s progress within the inventory system. |
| ErrorCode | String | An error code generated when an issue occurs during pick transaction processing. This error code identifies the type of error encountered in the system. |
| ErrorExplanation | String | The detailed explanation of the error encountered in the pick transaction process. This explanation provides diagnostic information to assist with troubleshooting and resolution. |
| OwningOrganizationId | Long | A system-generated identifier for the organization that owns the pick transaction record. This identifier ensures traceability within multi-organization inventory structures. |
| OwningOrganizationCode | String | A unique code representing the organization that owns the pick transaction record. This code is used to differentiate between business units or warehouses. |
| OwningTradingPartnerTypeCode | String | The type code representing the trading partner that owns the pick transaction. This code is used for categorizing external business relationships. |
| OwningTradingPartnerType | String | The type of trading partner associated with the pick transaction. The values are based on the lookup type ORA_INV_OWNING_TYPES in FND_LOOKUPS and help define ownership structure. |
| ProcurementBUName | String | The name of the procuring business unit associated with the pick transaction when a consigned quantity is involved. This name ensures correct allocation of procurement responsibilities. |
| VendorName | String | The name of the vendor associated with the pick transaction when a consigned quantity is involved. This name links the transaction to supplier records for procurement tracking. |
| VendorNumber | String | The unique identifier for the vendor involved in the pick transaction when a consigned quantity is present. This identifier ensures accurate vendor management and reporting. |
| ConsignmentAgreementNumber | String | The consignment agreement number associated with the consigned material. This field is populated when 'Vendor Name', 'Vendor Number', 'Procurement Business Unit', or 'Vendor Site Code' is insufficient to derive the vendor site identifier. |
| Finder | String | The searchable reference value used for identifying specific pick transaction records in the system. This value assists in querying and retrieving transaction data quickly for operational reporting. |