ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

ItemTemplatesitemRevisionsDFFs

Handles descriptive flexfields for item revisions in templates, enabling contextual customization.

Columns

Name Type Description
ItemTemplatesItemId [KEY] Long Specifies the unique identifier for an item within the ItemTemplatesitemRevisionsDFFs module. This identifier links item template records to their associated revision descriptive flexfields (DFFs), allowing for the inclusion of custom attributes.
ItemTemplatesOrganizationId [KEY] Long Defines the unique identifier for the organization managing the item template. This identifier ensures that item revision descriptive flexfields (DFFs) are correctly associated with the appropriate business unit for classification and reporting.
RevisionId [KEY] Long Represents the unique identifier for a specific revision of the item. This identifier is used to track changes to the item over time, ensuring proper version control and historical tracking.
_FLEX_ValidationDate Date Specifies the date on which the descriptive flexfield (DFF) attributes for the item revision were last validated. This date helps ensure data accuracy and compliance with predefined attribute rules.
_FLEX_Context String Defines the descriptive flexfield (DFF) context name assigned to the item revision. This context name determines how additional custom attributes are structured and applied.
_FLEX_NumOfSegments Int Indicates the total number of segments within the descriptive flexfield (DFF) for the item revision. This value determines the number of attributes available for customization.
_FLEX_NumOfVisibleSegments Int Specifies the number of visible segments within the descriptive flexfield (DFF) for the item revision. This value controls which attributes are displayed to users during item management.
Finder String Defines the search mechanism or query criteria used to locate records in the ItemTemplatesitemRevisionsDFFs module. This field enhances system usability by enabling efficient data retrieval for item revisions and associated flexfields.
ItemId Long Specifies the unique identifier for the item within the item template module. This identifier ensures accurate tracking of item revisions and associations with descriptive flexfields.
OrganizationId Long Defines the unique identifier for the organization that manages the item revision. This identifier ensures proper assignment of revision-controlled items to the correct business unit, enabling accurate lifecycle management and compliance tracking.

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