ExpensePersons
Contains person-centric details (business unit, currency preferences) tied to expense transactions and approvals.
Columns
| Name | Type | Description |
| PersonId [KEY] | Long | The unique identifier for an individual in the ExpensePersons table, representing the person associated with an expense record. |
| UserLocation | String | The geographical location associated with the ExpensePersons record, typically representing the person's office or primary work location. |
| DefaultExpenseAccountId | Long | The ID of the default expense account assigned to the individual for processing and categorizing expenses. |
| BusinessUnitId | Long | The ID representing the business unit to which the individual belongs, helping to categorize and assign responsibilities within the company structure. |
| BUName | String | The name of the business unit associated with the ExpensePersons record, providing context for the organizational unit they are part of. |
| OrganizationId | Long | The ID of the organization to which the individual belongs, identifying the larger entity within which the business unit operates. |
| JobId | Long | The unique identifier for the person's job position within the organization, helping to link to job-specific information and roles. |
| GradeId | Long | The identifier for the employee's grade or level within the organization, which could relate to seniority or compensation. |
| PositionId | Long | The unique identifier of the position or role the person holds within the company, providing context for their responsibilities. |
| CurrencyCode | String | The three-letter code representing the currency in which expenses are recorded for the individual, following the ISO standard. |
| CurrencyName | String | The name of the currency used for the person's expense records, such as USD or EUR. |
| ExpenseEntryFlag | Bool | A Boolean flag indicating whether the individual is authorized or eligible to enter expense data in the system. |
| ExpenseAccess | String | The level of access the person has to expense-related data, such as 'View' or 'Edit', defining their permissions for managing expense records. |
| ProjectAccess | String | The level of access the individual has to project-related information, specifying whether they can view, edit, or manage project details. |
| AccountAccess | String | The level of access the person has to financial accounts within the system, determining their permissions for interacting with financial data. |
| Finder | String | A tool or identifier that helps locate or search for specific ExpensePersons records, typically used for filtering or querying relevant data. |