FlexFndPvsNumberIdCharacterValues
Tracks numeric identifiers and associated values for use in flexfields.
Columns
| Name | Type | Description |
| Id [KEY] | Decimal | The unique numeric identifier assigned to the character value within the descriptive flexfield (DFF) value set. This identifier ensures uniqueness and traceability of the value for validation and configuration purposes. |
| Value | String | The character-based value associated with the numeric ID in the DFF. This value represents a user-selectable option used in business processes for classification, categorization, or lookup purposes. |
| Description | String | A descriptive explanation of the character value, providing additional details to help users understand its meaning and usage within the DFF structure. |
| StartDateActive | Date | The date when this character value becomes available for selection within the DFF. This date helps control the validity of values over time. |
| EndDateActive | Date | The date when this character value is no longer available for use. This date helps enforce business rules by preventing outdated values from being used in new transactions. |
| EnabledFlag | String | A flag indicating whether this character value is currently active ('Y' for Yes, 'N' for No). When disabled, the value is no longer available for selection. |
| SummaryFlag | String | Indicates whether this value functions as a summary or parent value in hierarchical structures. This flag is used for grouping values in reporting and data analysis. |
| ValueSetCode | String | The identifier for the value set that this character value belongs to. Value sets define the domain of valid values available for use in DFFs. |
| Bind_DataSource | String | Defines the data source from which this character value is derived. This data source is useful when values are dynamically retrieved from external systems or database tables. |
| Bind_FinderContext | String | Defines the context used for retrieving values dynamically. This context helps optimize lookups and ensures relevant values are returned based on user selection criteria. |
| Bind_FinderDateFlag | String | A flag that determines whether date-based filtering is applied when retrieving values via the finder mechanism. This flag ensures values returned are valid for a given date. |
| Bind_ValidationDate | Date | The date used for validation when retrieving values dynamically. This date ensures compliance with effective dating requirements in business processes. |
| Finder | String | The name of the predefined finder query used for retrieving matching values based on search criteria. Finders improve efficiency by optimizing data lookups. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |
| 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 for filtering values. |