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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。