ValueSetsValues
Enumerates allowed values in a value set (codes, translations), ensuring data consistency in user inputs.
Columns
| Name | Type | Description |
| ValueSetsValueSetId [KEY] | Long | The unique identifier of the value set. This ID links the value entry to the specific value set it belongs to, ensuring proper categorization and validation within the system. |
| ValueId [KEY] | Long | The unique identifier of the value. This ID is used to uniquely reference each value in the value set, distinguishing one value from another. |
| IndependentValue | String | The independent value, representing a standalone value that is not dependent on any other data. This field holds textual data for simple entries. |
| IndependentValueNumber | Decimal | The independent number value, used when the independent value is numeric. This allows numeric validation and comparisons. |
| IndependentValueDate | Date | The independent date value, used when the independent value represents a specific date. This ensures proper date validation for entries. |
| IndependentValueTimestamp | Datetime | The independent time stamp value, which stores both the date and time as a timestamp, useful for time-based validation and record tracking. |
| Value | String | The actual value to be used in the value set. This is the primary field that contains the data entries for the value set, typically referenced during data validation. |
| ValueNumber | Decimal | The numeric value representing the value, used when the value is stored as a number. This allows for numeric operations such as addition or comparison. |
| ValueDate | Date | The date value representing the value, allowing for date-based validation and comparison. |
| ValueTimestamp | Datetime | The time stamp value representing both date and time, ensuring precise records for time-based data. |
| TranslatedValue | String | The translated value, representing the value in a different language or format. This field allows the system to store multilingual entries for the same value. |
| Description | String | A description of the value, providing context and additional details about the meaning or purpose of the value stored in the value set. |
| EnabledFlag | String | Indicates if the value is enabled. A value of 'Yes' means the value is active and can be used; 'No' means it is disabled and cannot be used in the system. |
| StartDateActive | Date | The first date on which the value is active. This defines the start of the validity period for the value, ensuring the value is only used when appropriate. |
| EndDateActive | Date | The last date on which the value is active. This defines the end of the validity period for the value, ensuring the value cannot be used after the specified date. |
| SortOrder | Long | The order in which the values should appear in the list of values. This helps control the display order of values, allowing a specific arrangement of items in user interfaces. |
| SummaryFlag | String | A summary of the value, providing a brief description or categorization of the value. This field can be used to highlight key characteristics of the value. |
| DetailPostingAllowed | String | Indicates if posting is permitted for the value. A value of 'Yes' means that financial transactions can be posted using this value, while 'No' means posting is not allowed. |
| DetailBudgetingAllowed | String | Indicates if budget entry is permitted for the value. A 'Yes' value means that the value can be used in budgeting, while 'No' indicates it is excluded from budget entries. |
| AccountType | String | The account type of the value. This helps categorize the value based on the type of financial account it is associated with (for example, asset, liability, expense). |
| ControlAccount | String | The control account of the value. This indicates the account used to manage and reconcile the balance of the value within the accounting system. |
| ReconciliationFlag | String | The reconciliation indicator of the value. A 'Yes' value means the value must be reconciled during the financial period, while 'No' means it is not subject to reconciliation. |
| FinancialCategory | String | The financial category of the value. This categorizes the value based on its role in financial reporting or accounting, such as 'Revenue,' 'Expense,' or 'Asset.' |
| ExternalDataSource | String | The location of the external data source, if the value is maintained externally. This is useful for linking external systems that update or manage the value. |
| CreationDate | Datetime | The date when the value record was created. This timestamp helps track when the value was first introduced into the system. |
| CreatedBy | String | The user who created the value record. This field helps maintain accountability and traceability for who added or modified the value. |
| LastUpdateDate | Datetime | The date when the value record was last updated. This helps track changes made to the value over time, ensuring up-to-date data. |
| LastUpdatedBy | String | The user who last updated the value record. This field helps maintain accountability and traceability for who made changes to the value. |
| Finder | String | A text field used for searching or filtering the value records. This field can help locate specific records based on keywords or attributes associated with the value. |
| ValueSetCode | String | The code that identifies the value set associated with this value. This code is used to reference the value set and its values in the system, ensuring proper validation and usage. |
| ValueSetId | Long | The unique identifier of the value set. This ID links the value entry to its specific value set, helping to organize and manage related values. |