Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs

Manages descriptive flexfields for serials that control lots, supporting tailored inventory management.

Columns

Name Type Description
OpenPickLinesTransactionId [KEY] Long The unique identifier for the transaction in the OpenPickLines table, used to track pick line operations within the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs.
ItemlotsLot [KEY] String Represents the lot number of the item in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, which is used to manage inventory for that specific lot.
ItemlotserialsFromSerialNumber [KEY] String The starting serial number associated with the item lot in OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, indicating the first item in the lot to be processed.
TransactionTempId [KEY] Long A temporary transaction identifier used for processing within the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, typically used for intermediate operations before the final transaction is committed.
FmSerialNumber [KEY] String A serial number related to the item in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, used for tracking individual items within a specific lot.
_FLEX_Context String Contextual data field used in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, typically used for additional, flexible data that may be relevant depending on the transaction.
_FLEX_Context_DisplayValue String The display value of the FLEX Context in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, providing a user-readable representation of the context information.
Finder String The finder value used in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, typically for referencing or querying additional related data in the system.
PItem String The item identifier associated with the transaction in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, which identifies the specific product being processed.
PMovementRequest String A reference to the movement request in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, used to track the specific inventory movement that the transaction is related to.
POrder String The order number linked to the transaction in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, indicating the order being processed.
POrganization String The organization identifier associated with the transaction in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, identifying the entity responsible for the inventory movement.
POrganizationId String The unique identifier for the organization in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, used to track and group transactions by organization.
PPickSlip String The pick slip number related to the transaction in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, used in warehouse operations to pick items for an order.
PPickWave String The pick wave identifier in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, used to group pick operations into waves for efficiency in warehouse management.
PSourceSubinventory String The source subinventory for the transaction in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, indicating where the items are being taken from within the warehouse.
PTransactionType String The type of transaction in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, which helps categorize the movement or operation (for example, transfer, sales order processing).
TransactionId Long The unique identifier for the transaction in the OpenPickLinesitemLotsitemLotSerialslotSerialStandardDFFs, used to track and reference the specific operation within the system.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175