FlexFndPvsCharacterIdCharacterValues
Manages character values for specific flexfield character identifiers.
Columns
Name | Type | Description |
Id [KEY] | String | The unique identifier for a character value within the descriptive flexfield (DFF) value set. This identifier is used to distinguish individual values within the value set for configuration and validation. |
Value | String | The actual character value stored within the DFF value set. This value represents a selectable option that users can choose from in a DFF-enabled form or lookup. |
Description | String | A textual description providing details about the character value. This description helps users understand the meaning or purpose of the value when selecting from available options. |
StartDateActive | Date | The date when this character value becomes active and available for selection within the DFF. This date is used for controlling the validity period of selectable values. |
EndDateActive | Date | The date when this character value is no longer valid or available for use. This date ensures that deprecated values are not mistakenly selected in transactions or configurations. |
EnabledFlag | String | A flag indicating whether the character value is currently active ('Y' for Yes, 'N' for No). This flag determines if the value is available for selection in the application. |
SummaryFlag | String | A flag indicating whether this value serves as a summary or parent value within a hierarchical structure. This flag is used in reporting and data aggregation. |
ValueSetCode | String | The code identifying the value set to which this character value belongs. This code ensures that values are grouped correctly for validation and lookup purposes. |
Bind_DataSource | String | Specifies the data source associated with this value, typically used for dynamically populating values in the DFF. This data source ensures accurate and context-driven value selection. |
Bind_FinderContext | String | The finder context associated with this character value, defining the scope or criteria for retrieving relevant values in dynamic lookups. |
Bind_FinderDateFlag | String | A flag that determines whether date-based filtering is applied when retrieving values via the finder. This flag is used for time-sensitive data selection. |
Bind_ValidationDate | Date | The date used for validating the character value within the finder context. This date ensures that only values valid as of the specified date are retrieved. |
Finder | String | The name of the predefined finder query used to retrieve values dynamically. Finders improve search efficiency by providing optimized queries for data retrieval. |
Flex_vst_bind1 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind10 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind11 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind12 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind13 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind14 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind15 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind16 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind17 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind18 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind19 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind2 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind20 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind3 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind4 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind5 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind6 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind7 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind8 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |
Flex_vst_bind9 | String | A system-defined binding parameter used for dynamic value retrieval within the DFF structure. Typically, this parameter represents a contextual reference. |