ExpenseDffSegments
Details individual descriptive flexfield segments linked to expenses, supporting extended data capture and reporting.
Columns
| Name | Type | Description |
| RowIdentifier [KEY] | String | The unique identifier for each row in the ExpenseDffSegments table, ensuring each entry can be referenced individually. |
| ApplicationId | Long | The ID that links the segment to a specific application within Oracle Financials Cloud, identifying which application this segment belongs to. |
| DescriptiveFlexfieldCode | String | The code associated with the descriptive flexfield in the ExpenseDffSegments table, used to categorize the segment in the system. |
| ContextCode | String | The code representing the specific context or environment in which the ExpenseDffSegments are applied, often used for customization or filtering. |
| SegmentCode | String | A unique identifier for the segment within the ExpenseDffSegments table, used to differentiate various segments of data. |
| SegmentIdentifier | String | A distinct identifier for the segment, typically representing the specific data or segment in the financial system. |
| ColumnName | String | The name of the column within the ExpenseDffSegments table, which corresponds to a specific attribute or data point for the segment. |
| SequenceNumber | Int | The sequence number that defines the order of the segments within the ExpenseDffSegments table, helping maintain proper data structure. |
| EnabledFlag | Bool | Indicates whether the segment is enabled for use within the application. A true value means the segment is active. |
| RequiredFlag | Bool | Shows whether the segment is mandatory when inputting or processing data. A true value means the segment must be filled out. |
| ValueSetId | Long | The ID that links the segment to a specific value set, which defines the acceptable values for this segment in the system. |
| DefaultType | String | Specifies the type of default value applied to the segment, such as 'fixed', 'dynamic', or 'user-defined'. |
| DefaultValue | String | The default value assigned to the segment, which appears if no other value is provided by the user or system. |
| DefaultValueNumber | Decimal | The numeric default value for the segment, used when the default type is set to a numeric value. |
| DefaultValueDate | Date | The date default value for the segment, used when the default type is set to a date. |
| DefaultValueTimestamp | Datetime | The timestamp default value for the segment, capturing both date and time when no other input is provided. |
| DerivationValue | String | The value used to derive or calculate the segment's value, often determined by business rules or formulas. |
| RangeType | String | Defines the type of range applicable to the segment, such as 'date range', 'numeric range', or other constraints. |
| ReadOnlyFlag | Bool | Indicates whether the segment is read-only, preventing users from modifying its value if set to true. |
| DisplayType | String | The display type for the segment, defining how it appears to users, such as a text field, dropdown list, or checkbox. |
| DisplayWidth | Int | Specifies the width of the segment's display field in the user interface, determining how much space it occupies on the screen. |
| DisplayHeight | Int | Specifies the height of the segment's display field in the user interface, controlling its vertical space on the screen. |
| CheckboxCheckedValue | String | The value assigned to the segment when a checkbox is checked, representing the selected state of the checkbox. |
| CheckboxUncheckedValue | String | The value assigned to the segment when a checkbox is unchecked, representing the unselected state of the checkbox. |
| DynamicURL | String | A URL that is dynamically generated for the segment, used to link the segment to external resources or applications. |
| UOMClass | String | The unit of measure class associated with the segment, helping to define the measurement standards for financial data entry. |
| IndexedFlag | Bool | Indicates whether the segment is indexed, improving search performance and data retrieval within the system. |
| MultirowUniqueKeyFlag | Bool | Shows whether the segment is part of a multi-row unique key, ensuring that the segment value is unique across multiple rows. |
| BiEnabledFlag | Bool | Indicates whether Business Intelligence (BI) functionality is enabled for the ExpenseDffSegments table. A value of true signifies that BI features are active, while false means they are disabled. |
| BiEqualizationTag | String | The tag used to denote whether equalization adjustments are applied within the ExpenseDffSegments. This helps identify specific financial calculations related to equalization within the segments. |
| ShowValueDescription | String | Describes the value to be displayed for the ExpenseDffSegments, helping users understand the context or meaning of a given segment when viewed in the application. |
| CreationDate | Datetime | The timestamp of when the ExpenseDffSegment was initially created. This helps track when the segment was first recorded in the system. |
| CreatedBy | String | The identifier of the user or process that created the ExpenseDffSegment. This provides a way to trace the origin of the segment data. |
| LastUpdateDate | Datetime | The timestamp of the most recent update made to the ExpenseDffSegment. This helps identify when the segment was last modified. |
| LastUpdatedBy | String | The identifier of the user or process that last modified the ExpenseDffSegment. This helps track who made changes to the segment. |
| LastUpdateLogin | String | The login ID used by the user or process that last updated the ExpenseDffSegment. This can assist in auditing who accessed the segment for modifications. |
| Name | String | The name assigned to the ExpenseDffSegment, which serves as its unique identifier within the system. This name is used to differentiate between different segments. |
| Description | String | A detailed description of the ExpenseDffSegment, providing context about its purpose and use within the financial system. |
| Prompt | String | The prompt text associated with the ExpenseDffSegment. This text is typically used in user interfaces to prompt users for input when working with the segment. |
| ShortPrompt | String | A shortened version of the prompt text for the ExpenseDffSegment. It is used in places where space is limited but the essential prompt still needs to be displayed. |
| TerminologyHelpText | String | A helpful text that explains the terminology used in the ExpenseDffSegment. This assists users in understanding specialized terms or concepts associated with the segment. |
| InFieldHelpText | String | Provides guidance to users directly within the fields related to the ExpenseDffSegment. This helps users enter data correctly by providing contextual instructions. |
| Finder | String | The lookup code or identifier used for searching or retrieving the ExpenseDffSegment in the system. This is often used in query operations or to filter records. |