ValueSets
Stores definitions for standardized lookups or data validation sets, ensuring consistent entries across the procurement module.
Columns
| Name | Type | Description |
| ValueSetId [KEY] | Long | The unique identifier of the value set. This ID is used to uniquely reference the value set within the system. |
| ModuleId | String | The module ID associated with the value set. It helps identify which module the value set belongs to (for example, 'Financials', 'Purchasing'). |
| ValueSetCode | String | The code used to identify the value set. This code is used for referencing the value set within the system, ensuring uniqueness and easy identification. |
| Description | String | A description of the value set, explaining its purpose and what values it holds, providing context for its usage. |
| ValidationType | String | The type of validation applied to the values within the value set. Examples could include 'Format' or 'Range,' and it ensures that only valid data can be entered. |
| ValueDataType | String | The data type of the values in the value set. It specifies what type of data is allowed, such as 'String,' 'Integer,' or 'Decimal'. |
| ValueSubtype | String | The subtype of the value set, which provides further categorization. It could be something like 'Account Types' or 'Product Codes,' helping to define its role more specifically. |
| ProtectedFlag | String | Indicates whether the value set is protected against updates. A 'Yes' value means that no changes can be made to the value set once it is created. |
| MaximumLength | Int | The maximum length of a value that can be stored in the value set. This ensures that values do not exceed predefined limits, like a maximum of 255 characters. |
| Precision | Int | The maximum number of digits that can be used for a value in the value set, ensuring consistency in numeric values. |
| Scale | Int | The maximum number of digits that can appear to the right of the decimal point for values in the value set. This ensures proper formatting for decimal values. |
| UppercaseOnlyFlag | String | Indicates whether the values in the set must be entered in uppercase only. A 'Yes' value restricts the value entry to uppercase letters. |
| ZeroFillFlag | String | Indicates whether values must be left-padded with zeros. For example, if set to 'Yes,' a value like '5' would be represented as '0005'. |
| SecurityEnabledFlag | String | Indicates if data security is enabled for the value set. A 'Yes' value means that access to the value set is restricted based on security policies. |
| DataSecurityObjectName | String | The name of the data security object used to secure the value set, if applicable. This can be linked to specific security protocols or roles. |
| MinimumValue | String | The minimum permitted value that can be entered for the value set. It defines the lower bound for valid values. |
| MinimumValueNumber | Decimal | The minimum numeric value allowed for this value set. This is used for value sets that store numerical data, ensuring they stay within limits. |
| MinimumValueDate | Date | The minimum allowed date for the value set. This ensures that only dates equal to or greater than this value can be entered. |
| MinimumValueTimestamp | Datetime | The minimum allowed timestamp for the value set, specifying the earliest valid date and time for entries. |
| MaximumValue | String | The maximum permitted value that can be entered for the value set. It defines the upper bound for valid values. |
| MaximumValueNumber | Decimal | The maximum numeric value allowed for the value set, defining the upper bound for numbers stored in this value set. |
| MaximumValueDate | Date | The maximum allowed date for the value set. This ensures that only dates equal to or less than this value can be entered. |
| MaximumValueTimestamp | Datetime | The maximum allowed timestamp for the value set, specifying the latest valid date and time for entries. |
| IndependentValueSetId | Long | The ID of the independent value set, if applicable. This is used when the value set is dependent on another value set for validation or categorization. |
| IndependentValueSetCode | String | The code of the independent value set, if applicable. This code helps identify and link dependent value sets to their parent value sets. |
| CreationDate | Datetime | The date when the value set record was created. This helps track the history and lifecycle of the value set. |
| CreatedBy | String | The user who created the value set record. This provides traceability and accountability for the creation of the value set. |
| LastUpdateDate | Datetime | The date when the value set record was last updated. This helps track changes and updates to the value set over time. |
| LastUpdatedBy | String | The user who last updated the value set record. This provides accountability and traceability for changes made to the record. |
| Finder | String | A text field used for searching or filtering the value set records. This can be used for quick lookups and references when managing value sets. |