ExpenseLocations
Manages standard expense location data (cities, countries, regions) used to categorize and validate expense submissions.
Columns
| Name | Type | Description |
| GeographyId [KEY] | Long | The unique identifier for the geographical region associated with the expense location. This ID links the location to a specific region or area within the database. |
| EndDate | Date | The date on which the expense location became inactive or was terminated. This marks the end of the period during which the location was considered active. |
| Country | String | The country in which the expense location is situated. This value helps categorize locations by their national association for financial and reporting purposes. |
| State | String | The state or province in which the expense location is situated. It is used to refine location categorization within a country. |
| County | String | The county or administrative region associated with the expense location. This level of detail is useful for more granular reporting and analysis. |
| City | String | The specific city where the expense location is situated. This helps pinpoint the exact location for regional financial analysis. |
| Location | String | A descriptive name or identifier for the expense location, often including a building or office name, to help distinguish it from other locations. |
| StartDate | Date | The date on which the expense location became active or operational. This marks the beginning of the period during which the location was available for use. |
| EffectiveDate | Date | The date when the details of the expense location became effective. This may differ from the StartDate if adjustments or changes occurred after the location was first active. |
| Finder | String | A user-defined field that may represent the person or tool responsible for identifying or assigning the expense location within the system. |