InterfacedPickTransactionstrackingAttributesDFF
Manages inventory tracking attributes for interfaced pick transactions with opt-in feature support.
Columns
| Name | Type | Description |
| InterfacedPickTransactionsTransactionInterfaceId [KEY] | Long | A system-generated identifier that uniquely links an interfaced pick-confirm transaction to its corresponding transaction record in the InterfacedPickTransactionsTrackingAttributesDFF table. This identifier is essential for tracking and managing interfaced transactions within Oracle SCM. |
| TransactionInterfaceId [KEY] | Long | The unique identifier assigned to a pick-confirm transaction, enabling tracking and integration across Oracle SCM modules. This identifier is associated with a feature that requires opt-in for enhanced tracking capabilities. |
| ProjectId | Long | The unique identifier assigned to a project associated with the pick-confirm transaction. This identifier enables project-based tracking of inventory movements and is linked to an opt-in feature for project-driven transactions. |
| ProjectId_Display | String | The project number displayed in user interfaces and reports, providing a readable reference for the project associated with the pick-confirm transaction. This field is linked to an opt-in feature for project tracking. |
| TaskId | Long | The unique identifier assigned to a task within a project, used to associate the pick-confirm transaction with a specific project-related task. This field is part of an opt-in feature for project and task-based tracking. |
| TaskId_Display | String | The task number displayed in user interfaces and reports, providing a readable reference for the task associated with the pick-confirm transaction. This field is linked to an opt-in feature for task-based tracking. |
| CountryOfOriginCode | String | The standard country code representing the country of origin for the item involved in the transaction. This code is critical for compliance with trade regulations and is part of an opt-in feature for country-of-origin tracking. |
| CountryOfOriginCode_Display | String | The full name of the country of origin for the item in the transaction, used for regulatory reporting and trade compliance. This field is associated with an opt-in feature for tracking country-of-origin details. |
| _FLEX_Context | String | The descriptive flexfield (DFF) context name that categorizes tracking attributes for the transaction. This field enables additional attributes to be captured dynamically and is part of an opt-in feature for extended tracking capabilities. |
| _FLEX_Context_DisplayValue | String | The user-friendly display value for the DFF context, providing a readable representation of tracking attribute categories. This field is linked to an opt-in feature for enhanced tracking. |
| Finder | String | The lookup reference used to identify and retrieve interfaced pick-confirm transactions with tracking attributes in the system. This reference facilitates efficient search and navigation for transaction records within Oracle SCM. |