ExpensePersons

Columns


Name	Type	Description
PersonId [KEY]	Long	Unique identifier of the person associated with an expense profile attributes record.
UserLocation	String	Work location of a user.
DefaultExpenseAccountId	Long	Unique identifier of a person's default expense account.
BusinessUnitId	Long	Unique identifier of a person's business unit.
BUName	String	Name of a person's business unit.
OrganizationId	Long	Unique identifier of a person's organization.
JobId	Long	Unique identifier of a person's job.
GradeId	Long	Unique identifier of a person's grade.
PositionId	Long	Unique identifier of a person's position.
CurrencyCode	String	Code that's associated with the currency that's used for entering an expense.
CurrencyName	String	Name of the currency that's used for entering an expense.
ExpenseEntryFlag	Bool	Indicates whether a user can enter expenses.
ExpenseAccess	String	Indicates if a user has access to expenses.
ProjectAccess	String	Indicates if a user has access to project-related attributes.
AccountAccess	String	Indicates if a user has access to account-related attributes.

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