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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
BusinessUnit | String | BusinessUnit |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |