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 |