ExpenseReportsexpenseNotes
Stores remarks or instructions from approvers or auditors regarding the entire expense report, aiding clarity and resolution.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for the expense report, used to track and reference specific expense reports within the system. |
| CreatedBy | String | Username of the individual who created the expense note, providing accountability and ownership of the note. |
| CreationDate | Datetime | Timestamp indicating when the expense note was created, useful for tracking and organizing notes chronologically. |
| ExpenseReportId | Long | Unique identifier for the expense report related to the expense note, establishing a relationship between the note and the report. |
| ExpenseReportProcessingId [KEY] | Long | Identifier representing the specific processing details of an expense report, often tied to workflow or approval status. |
| Event | String | Description of the event that triggered a change in the status of the expense report, such as approval or audit. |
| FullName | String | Name of the person associated with the expense note, typically the individual who either created or is referenced in the note. |
| LastUpdatedBy | String | Username of the individual who last updated the expense note, important for tracking changes and modifications. |
| LastUpdateDate | Datetime | Timestamp indicating the last time the expense note was updated, helping to maintain an accurate audit trail. |
| LastUpdateLogin | String | Session login associated with the user who last updated the expense note, used for tracking system access during updates. |
| NoteId | Long | Unique identifier for the expense note, used to track the specific note that was created after a status change of the report. |
| NoteText | String | Text content of the expense note, typically describing the context of the approval or audit action taken on the expense report. |
| NoteTextTrunc | String | The first 1,024 characters of the note, providing a preview of the full content typically displayed in the user interface. |
| NoteTypeCode | String | Code representing the category of the expense note, helping to classify and filter notes based on their type (for example, approval, audit). |
| PersonId | Long | Unique identifier for the person associated with the expense note, used for linking notes to specific individuals in the system. |
| SourceObjectCode | String | Code associated with the source object (for example, activities, opportunities) as defined in the OBJECTS Metadata, providing context for the origin of the note. |
| SourceObjectUid | String | Unique identifier for the source object, such as activities or opportunities, allowing the expense note to be linked to specific entities. |
| UserLastUpdateDate | Datetime | Date and time when the user last updated the record on a disconnected mobile device, ensuring data synchronization is tracked. |
| BusinessUnit | String | The business unit associated with the expense report, used for categorizing and organizing data based on the department or organizational unit. |
| Finder | String | Search term or filter used to locate and display specific records or entries in the system, enhancing search functionality. |
| SysEffectiveDate | String | System-defined date indicating when the record or data is considered effective within the system, ensuring accurate data reporting. |
| CUReferenceNumber | Int | Reference number used to link child aggregates with parent tables, facilitating hierarchical data relationships. |
| EffectiveDate | Date | Date used as a parameter to fetch resources that are effective as of a specified start date, important for handling time-sensitive data. |