ExpensePreferences
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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
Finder | String | finder |