OpenPickLinesitemSerialsserialAttributeDFFs
Customizes descriptive flexfields for serial attributes, supporting enhanced data management for serialized items.
Columns
| Name | Type | Description |
| OpenPickLinesTransactionId [KEY] | Long | The unique identifier for the open pick line transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, used to track specific pick line activities within the system. |
| ItemserialsFromSerialNumber [KEY] | String | The serial number associated with the item in the OpenPickLinesitemSerialsserialAttributeDFFs table, indicating the origin of the item serial number in the transaction. |
| TransactionTempId [KEY] | Long | A temporary identifier used for internal processing during the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, distinct from the permanent transaction ID. |
| FmSerialNumber [KEY] | String | The serial number of the 'from' item in the OpenPickLinesitemSerialsserialAttributeDFFs table, representing the starting serial number for an item movement or transaction. |
| _FLEX_Context | String | A system-generated context value used by Oracle FLEXFIELD functionality in the OpenPickLinesitemSerialsserialAttributeDFFs table, relevant for tracking extended attribute data. |
| _FLEX_Context_DisplayValue | String | A human-readable representation of the FLEX context, used to display meaningful descriptions for the FLEX Context field in the OpenPickLinesitemSerialsserialAttributeDFFs table. |
| Finder | String | A code or key used in conjunction with the 'Finder' feature to locate or search for specific records in the OpenPickLinesitemSerialsserialAttributeDFFs table. |
| PItem | String | The identifier for the item involved in the transaction within the OpenPickLinesitemSerialsserialAttributeDFFs table, typically tied to inventory or shipping activities. |
| PMovementRequest | String | Represents the movement request related to the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, indicating the reason for item transfer or movement. |
| POrder | String | The purchase order number associated with the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, linking the item movement to a specific order. |
| POrganization | String | The organization code associated with the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, used to associate the transaction with a specific business unit or department. |
| POrganizationId | String | A unique identifier for the organization related to the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, supporting the organizational structure. |
| PPickSlip | String | The pick slip identifier associated with the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, used to guide the physical picking process in warehousing operations. |
| PPickWave | String | The pick wave identifier related to the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, associated with a batch of picking tasks within the system. |
| PSourceSubinventory | String | The source subinventory code used in the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, indicating where the item is being moved from within the warehouse. |
| PTransactionType | String | The type of transaction occurring in the OpenPickLinesitemSerialsserialAttributeDFFs table, such as a receipt, issue, or transfer, providing context for the movement of items. |
| TransactionId | Long | The permanent identifier for the transaction in the OpenPickLinesitemSerialsserialAttributeDFFs table, used to uniquely identify a completed transaction record. |