ExpensePreferences

Columns


Name	Type	Description
PreferenceId	Long	The unique identifier of the expense preferences associated with the user.
PersonId [KEY]	Long	The unique identifier of the person associated with the expense preference.
CreationDate	Datetime	Date and time when the row was created.
CreatedBy	String	User who created the row.
LastUpdateDate	Datetime	Date and time when the row was last updated.
LastUpdatedBy	String	User who last updated the row.
LastUpdateLogin	String	Session login associated with the user who last updated the row.
AutoSubmitFlag	Bool	Indicates whether the Auto Submit job should pick up the user's expenses for report creation.
PersonName	String	Name of the person associated with the expense preferences.
CommuteDistance	Double	Last calculated commute distance based on addresses entered by the user.
CorpCardCount	Int	The number of corporate cards owned by the user.
OnboardingStatusCode	String	Code that indicates the user's onboarding status for the expenses work area without reports.

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