ExpenseReportsExpenseExpenseAttendee
ExpenseReportsExpenseExpenseAttendee
Columns
Name | Type | Description |
ExpenseReportsExpenseReportId [KEY] | Long | Expense report identifier of the expense reports. |
ExpenseExpenseId [KEY] | Long | Expense identifier of the expense record. |
Amount | Double | Amount spent on the event attendee. |
AttendeeType | String | Type of event attendee. Possible values are EMPLOYEE and NONEMPLOYEE. |
CreatedBy | String | User who created the row. |
CreationDate | Datetime | Date and time when the row was created. |
EmployeeFlag | Bool | Indicates whether an event attendee is an employee. |
EmployerAddress | String | Employer address of the event attendee. |
EmployerName | String | Employer name of the event attendee. |
EmployerPartyId | Long | Value that uniquely identifies an employer. |
ExpenseAttendeeId [KEY] | Long | Value that uniquely identifies the event attendee. |
ExpenseId | Long | Value that uniquely identifies an expense item. |
LastUpdateDate | Datetime | Date and time when the row was last updated. |
LastUpdateLogin | String | User who last updated the row. |
LastUpdatedBy | String | Session login associated with the user who last updated the row. |
Name | String | Name of the employee or nonemployee expense attendee. |
TaxIdentifier | String | Tax identifier of the employee or nonemployee event attendee. |
Title | String | Title of the employee or nonemployee event attendee. |
AttendeeEmail | String | Email address of the attendee. |
AttendeePhoneNumber | String | Phone number of the attendee. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
BusinessUnit | String | BusinessUnit |
ExpenseReportId | Long | ExpenseReportId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |