ExpenseDelegations

Columns


Name	Type	Description
PersonName	String	PersonName of ExpenseDelegations
PersonId	Long	Value that uniquely identifies the individual who delegates expense entry.
DelegatePersonId	Long	Value that uniquely identifies the individual who is authorized to enter expense reports for another individual.
DelegateName	String	DelegateName of ExpenseDelegations
Comments	String	Text field in which the manager can enter comments regarding the delegation.
CreatedBy	String	CreatedBy of ExpenseDelegations
CreationDate	Datetime	CreationDate of ExpenseDelegations
DelegationId [KEY]	Long	Value that uniquely identifies a delegation authorization.
EnableAccountsFlag	Bool	Indicates whether the individual who delegates expense entry can charge expenses to cost centers other than the default cost center.
EnableProjectsFlag	Bool	Indicates whether the individual who delegated expense entry can charge expenses to projects.
EndDate	Date	Date when the delegate can no longer enter expense reports for another individual.
InactiveEmployeeFlag	Bool	Indicates whether an individual is an inactive employee.
LastUpdateDate	Datetime	LastUpdateDate of ExpenseDelegations
LastUpdateLogin	String	LastUpdateLogin of ExpenseDelegations
LastUpdatedBy	String	LastUpdatedBy of ExpenseDelegations

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