OpenPickLinesitemLotsitemLotSerialslotSerialAttributeDFFs
Customizes descriptive flexfields for serial attributes in lot-controlled items, enhancing data definition.
Columns
Name | Type | Description |
OpenPickLinesTransactionId [KEY] | Long | The unique identifier for the transaction in the OpenPickLines table. This value associates the line item with a specific picking process in Oracle SCM. |
ItemlotsLot [KEY] | String | The identifier for the lot associated with the item in the OpenPickLines table. This value links the item to a specific lot during the picking process. |
ItemlotserialsFromSerialNumber [KEY] | String | The starting serial number for the lot in the OpenPickLines table, indicating the range of serial numbers involved in the picking process. |
TransactionTempId [KEY] | Long | A temporary identifier for the transaction in the OpenPickLines table, often used for intermediate processing or staging before the final transaction ID is assigned. |
FmSerialNumber [KEY] | String | The serial number used for the picking process in OpenPickLines. This could represent a specific unit of the item being processed. |
_FLEX_Context | String | The context for the flex field in OpenPickLines, typically used for capturing additional user-defined information related to the transaction or item. |
_FLEX_Context_DisplayValue | String | The display value for the flex field context in OpenPickLines. This value provides a user-friendly representation of the context field. |
Finder | String | A value used in OpenPickLines to locate or search for specific records based on certain criteria, potentially linked to a lookup or filter. |
PItem | String | The identifier for the item being processed in OpenPickLines. This value links the line item to the specific product in the system. |
PMovementRequest | String | The movement request associated with the item in OpenPickLines, which could represent a request for inventory transfer or picking. |
POrder | String | The order number associated with the item in OpenPickLines, typically linking the transaction to a specific sales or purchase order. |
POrganization | String | The organization identifier for the item in OpenPickLines, representing the business unit responsible for the transaction. |
POrganizationId | String | The ID associated with the organization in OpenPickLines, linking the transaction to a specific organizational entity. |
PPickSlip | String | The pick slip number associated with the item in OpenPickLines, which is used to track and validate the picking process. |
PPickWave | String | The pick wave identifier in OpenPickLines, used to group and process items together for picking in the system. |
PSourceSubinventory | String | The source subinventory for the transaction in OpenPickLines, indicating the inventory location from where the items are being picked. |
PTransactionType | String | The transaction type in OpenPickLines, indicating the nature of the operation (for example, picking, shipping, receiving). |
TransactionId | Long | The unique identifier for the transaction in OpenPickLines, representing a specific event or action in the inventory process. |