ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryStagedTransactionslotslotSerialsserialAttributeDFFs

Offers customization for serial attributes through descriptive flexfields to support specific operational needs for serial-controlled items.

Columns

Name Type Description
InventoryStagedTransactionsTransactionInterfaceId [KEY] Long The unique identifier for the transaction interface record associated with the staged inventory transaction. This identifier ensures that serial attribute descriptive flexfields (DFFs) are properly linked to the inventory transaction.
LotsLotNumber [KEY] String The lot number associated with the inventory item in the staged transaction. This lot number ensures traceability and accurate tracking of lot-controlled inventory with serial attributes.
LotsTransactionInterfaceId [KEY] Long The unique identifier for the transaction interface record associated with the lot. This identifier ensures that lot and serial attributes are properly linked to the staged inventory transaction.
LotserialsFmSerialNumber [KEY] String The starting serial number in a range of serial numbers assigned to items within the lot. This serial number ensures proper traceability for serialized inventory within lot-controlled transactions.
LotserialsTransactionInterfaceId [KEY] Long The unique identifier for the transaction interface record associated with the serialized lot transaction. This identifier links serial attributes to the corresponding staged inventory transaction.
TransactionInterfaceId [KEY] Long The unique identifier for the staged inventory transaction. This identifier helps track and manage serial-controlled inventory movements within the system.
FromSerialNumber [KEY] String The initial serial number assigned to an item in the staged inventory transaction. This serial number ensures accurate tracking and traceability of serialized inventory.
_FLEX_Context String A DFF context name used for storing additional serial attributes. This context name allows organizations to extend standard serial tracking with customized business-specific data.
_FLEX_Context_DisplayValue String A display value of the DFF context, providing a user-friendly representation of extended serial attributes used in the transaction.
Finder String A reference attribute used for searching and retrieving specific serial attribute records for staged inventory transactions. This attribtue enhances system usability by allowing users to locate serial attributes based on predefined criteria.

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