ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

InventoryItemSerialNumbersinventoryAttributesDFF

Manages inventory attribute flexfields linked to serial numbers for detailed data tracking.

Columns

Name Type Description
InventoryItemSerialNumbersInventoryItemId [KEY] Long The unique identifier for the inventory item associated with the serialized inventory 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.
InventoryItemSerialNumbersSerialNumber [KEY] String The unique serial number assigned to the inventory item, ensuring traceability of serialized inventory attributes for compliance, warranty tracking, and reporting.
InventoryItemId [KEY] Long The unique identifier for the inventory item associated with the serialized attributes. This identifier ensures accurate linkage between item-level inventory and attribute-specific details.
SerialNumber [KEY] String The serial number associated with the inventory item for tracking unique items across transactions and organizations.
CurrentOrganizationId [KEY] Long The unique identifier for the current organization managing the serialized inventory item. This identifier ensures accurate tracking of stock ownership and operational reporting.
ProjectId Long The unique identifier for the project associated with the serialized inventory. This identifier ensures project-based tracking and cost allocation.
ProjectId_Display String The display value representing the project identifier for easier reference in inventory transactions.
TaskId Long The unique identifier for the specific task within the project linked to this serialized inventory item. This identifier ensures proper cost allocation and tracking in project-based workflows.
TaskId_Display String A display value representing the task identifier for easier reference in inventory transactions.
CountryOfOriginCode String The standardized country code representing the country of origin for the serialized inventory item. This country code ensures compliance with trade regulations and accurate documentation for international shipments.
CountryOfOriginCode_Display String The display name of the country of origin, providing a user-friendly reference for inventory tracking and regulatory compliance.
_FLEX_Context String A descriptive flexfield (DFF) context name that defines the attribute structure for serialized inventory attributes. This field ensures flexibility in tracking additional inventory details.
_FLEX_Context_DisplayValue String A display value representing the context-specific attributes for serialized inventory, 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 serialized inventory 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 lot-controlled serialized inventory.
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