ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

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.

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