ValueSetsValues
Lists permissible values in a specific value set, enforcing consistency in data entry across modules.
Columns
| Name | Type | Description |
| ValueSetsValueSetId [KEY] | Long | The unique identifier of the value set, used to distinguish one value set from another. This ID helps in referencing and associating values with their corresponding set. |
| ValueId [KEY] | Long | The unique identifier of a value within a specific value set. This allows each value in a set to be uniquely tracked and referenced. |
| IndependentValue | String | The independent value that stands alone without any dependencies on other values within the set, typically used for values that are self-explanatory or constants. |
| IndependentValueNumber | Decimal | The numeric representation of the independent value, which is used when the value can be represented as a number (for calculations or processing). |
| IndependentValueDate | Date | The date representation of the independent value, useful when the value pertains to a specific date, such as due dates or deadlines. |
| IndependentValueTimestamp | Datetime | The timestamp representation of the independent value, used when the value is associated with a specific moment in time, including both date and time. |
| Value | String | The actual value stored within the value set. This could be any business-relevant data like a code, name, or other identifier. |
| ValueNumber | Decimal | The numeric representation of the value, used for numeric-based values that require arithmetic or financial calculations. |
| ValueDate | Date | The date representation of the value, applicable for values that are time-bound or depend on specific dates. |
| ValueTimestamp | Datetime | The timestamp representation of the value, which includes both date and time components for precise records. |
| TranslatedValue | String | The translated version of the value, typically used in multi-language environments where the value needs to be represented in different languages. |
| Description | String | A textual description of the value, providing context or additional details about what the value represents or how it is used. |
| EnabledFlag | String | Indicates whether the value is enabled ('Y' for Yes, 'N' for No). This flag determines if the value is active and can be used within the system. |
| StartDateActive | Date | The start date from which the value becomes active and valid for use in the system or business processes. |
| EndDateActive | Date | The end date until which the value remains active and valid. After this date, the value may no longer be usable. |
| SortOrder | Long | The order in which the value should appear when listed among other values in a set. Used for organizing values in a meaningful sequence. |
| SummaryFlag | String | A flag indicating whether the value is a summary value ('Y' for Yes, 'N' for No). Summary values are typically used for grouping or aggregating data. |
| DetailPostingAllowed | String | Indicates whether posting transactions using this value is permitted ('Y' for Yes, 'N' for No). This flag ensures that only valid values are used for accounting purposes. |
| DetailBudgetingAllowed | String | Indicates whether budgeting with this value is allowed ('Y' for Yes, 'N' for No). This determines if the value can be used in budget-related processes. |
| AccountType | String | The account type associated with the value (for example, asset, liability, expense). It defines the nature of the account that the value belongs to. |
| ControlAccount | String | The control account associated with the value, used for managing financial transactions and ensuring the proper allocation of entries in accounting systems. |
| ReconciliationFlag | String | Indicates whether reconciliation is required for this value ('Y' for Yes, 'N' for No). This ensures that the value is included in the reconciliation process to maintain data integrity. |
| FinancialCategory | String | The financial category under which the value falls (for example, income, expense, asset). It helps in categorizing financial entries for easier reporting and analysis. |
| ExternalDataSource | String | The location of the external data source if the value is maintained externally, indicating where the value data is sourced from outside the system. |
| CreationDate | Datetime | The date and time when the record was created in the system. This helps in tracking when the value was added. |
| CreatedBy | String | The user who created the record in the system, providing accountability for record creation. |
| LastUpdateDate | Datetime | The date and time when the record was last updated in the system. This helps track the most recent changes made to the value. |
| LastUpdatedBy | String | The user who last updated the record. This allows tracking of who made the most recent changes to the value. |
| Finder | String | A general-purpose field used for searching or filtering records in the system, aiding users in quickly locating specific values. |
| ValueSetCode | String | The code identifying the value set to which the value belongs, enabling easy reference and organization of values within sets. |
| ValueSetId | Long | The identifier of the value set associated with this value. It helps link values to their respective sets for structured management. |