ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryItemSerialNumbersserialAttributeDFF

Customizes attributes of serial numbers using descriptive flexfields to support reporting and compliance.

Columns

Name Type Description
InventoryItemSerialNumbersInventoryItemId [KEY] Long The unique identifier for the inventory item associated with the serial number attributes. This identifier ensures traceability of serialized inventory at the attribute level.
InventoryItemSerialNumbersOrganizationId [KEY] Long The unique identifier for the organization managing the serialized inventory attributes. This identifier supports multi-organization inventory tracking and reporting.
InventoryItemSerialNumbersSerialNumber [KEY] String The unique serial number assigned to the inventory item, ensuring traceability for compliance, warranty tracking, and inventory control.
InventoryItemId [KEY] Long The unique identifier for the inventory item associated with the serial number attributes. This identifier ensures accurate linkage between item-level inventory and serial-specific attributes.
SerialNumber [KEY] String The serial number assigned to the inventory item for tracking unique items across inventory transactions and organizational transfers.
CurrentOrganizationId [KEY] Long The unique identifier for the organization currently managing the serialized inventory item. This identifier ensures accurate tracking of stock ownership and inventory transfers.
_FLEX_Context String A descriptive flexfield (DFF) context name defining the attribute structure for serial number attributes. This field enables tracking of additional custom inventory details.
_FLEX_Context_DisplayValue String The display value representing the context-specific attributes for serial numbers, ensuring user-friendly identification of additional details.
BindInventoryItemId Long The identifier linking the inventory item to system bindings for integration purposes. This identifier ensures accurate data mapping for serial number attributes in transactions.
BindItemNumber String The item number used in system bindings to ensure consistency in tracking serialized inventory across integrated platforms.
BindLotNumber String The lot number used in system bindings to ensure accurate tracking of serialized inventory within lot-controlled stock.
BindOrganizationCode String The organization code used in system bindings to ensure accurate tracking of serialized inventory across organizations.
BindSerialNumber String The serial number used in system bindings to ensure accurate tracking of serialized inventory in integrated systems.
Finder String The lookup reference used to retrieve and manage serialized inventory attribute records. This reference enables efficient searching, reporting, and system queries.
OrganizationId Long The unique identifier for the organization managing the serialized inventory attributes. This identifier supports tracking inventory ownership across different business entities.
Param_CycleCountHeaderId Long The unique identifier for the cycle count header associated with the serialized inventory attributes. This identifier ensures accurate stock reconciliation during cycle counting.
Param_InventoryItemId Long The unique identifier linking the inventory item to cycle count and transaction processes. This identifier ensures accurate tracking of serialized inventory adjustments.
Param_LocatorId Long The unique identifier for the locator where the serialized item is stored. This identifier ensures precise inventory tracking within a warehouse.
Param_LotNumber String The lot number associated with the serialized item during cycle counting or inventory adjustments. This lot number ensures consistency in lot-controlled stock management.
Param_OrganizationId Long The unique identifier for the organization conducting the cycle count or inventory transaction involving the serialized inventory attributes.
Param_Subinventory String The subinventory where the serialized item is stored. This subinventory ensures accurate tracking of inventory location within an organization for reporting and transaction processing.
Param_TransactionTypeId Long The unique identifier for the transaction type associated with the serialized inventory movement. This identifier ensures proper classification of inventory transactions.

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