ExpenseReportsexpenseNotes
ExpenseReportsexpenseNotes
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Expense report identifier of the expense reports. |
| CreatedBy | String | User who created an expense note. |
| CreationDate | Datetime | Date when an expense note was created. |
| ExpenseReportId | Long | Unique identifier of an expense report for which expense notes are entered. |
| ExpenseReportProcessingId [KEY] | Long | Unique identifier of an expense report's processing detail. |
| Event | String | Event that triggered an expense report status change, such as approval or audit. |
| FullName | String | Name of the person who's associated with an expense note. |
| LastUpdatedBy | String | User who last updated the expense note. |
| LastUpdateDate | Datetime | Date when the expense note was last updated. |
| LastUpdateLogin | String | Session login that's associated with the user who last updated the expense note. |
| NoteId | Long | Unique identifier of the expense note that resulted from a change of status of the expense report. |
| NoteText | String | Text of the expense note that was entered by an approver or an auditor. |
| NoteTextTrunc | String | First 1,024 characters in an expense note that were entered by an approver or an auditor. |
| NoteTypeCode | String | Code that's associated with an expense note's category. |
| PersonId | Long | Unique identifier of the person who's associated with the expense note. |
| SourceObjectCode | String | Code that's associated with the source object as defined in OBJECTS Metadata. |
| SourceObjectUid | String | Unique identifier of the source object, such as Activities or Opportunities as defined in OBJECTS Metadata. |
| UserLastUpdateDate | Datetime | Date and time when the user last updated the row on a disconnected mobile device. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| BusinessUnit | String | BusinessUnit |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |