SupplierRegistrationAddressGeographies
Tracks geographic data (country, region) for supplier addresses, enforcing location-based validations during registration.
Columns
| Name | Type | Description |
| GeographyIdentifierId [KEY] | Long | Unique identifier for the geography record. This identifier is used to reference and distinguish different geographical records within the supplier registration system. |
| CountryCode | String | The country code associated with the geographical area. This code should follow the ISO 3166-1 alpha-2 standard, which consists of two-letter country codes. For example, 'US' for the United States or 'IN' for India. |
| GeographyType | String | The type of geography associated with the supplier's address. Accepted values can include 'Region', 'District', 'Country', 'State', and 'City', depending on the structure of the address system. Review the values in the setup. |
| IdentifierType | String | The type of identifier used to categorize the geography. Common values include 'ZIP Code', 'Postal Code', and 'Region ID', depending on the classification system used for geographies. |
| GeographyValue | String | The actual value of the geography, such as the ZIP code, state name, or region name. This field contains the specific data for the geography in question. |
| StartDate | Date | The start date for the validity of the geography. This field defines the beginning of the period during which the geographical area is considered applicable to the supplier's registration. |
| EndDate | Date | The end date for the validity of the geography. This field indicates the expiration or conclusion date of the geographical area’s relevance to the supplier's registration. |
| GeographyLevel2Value | String | A more specific geographical value within level 2 of the geography hierarchy. This might refer to a province, state, or region depending on the country's address structure. |
| GeographyLevel3Value | String | A more specific geographical value within level 3 of the geography hierarchy. This might refer to a district, city, or neighborhood. |
| GeographyLevel4Value | String | A more specific geographical value within level 4 of the geography hierarchy. This might refer to a sub-district, locality, or zone. |
| GeographyLevel5Value | String | A more specific geographical value within level 5 of the geography hierarchy. This might refer to a specific block or sector within a city or area. |
| PrimaryGeographyFlag | Bool | Indicates whether this geography is the primary one for the supplier's address. Acceptable values: true (primary) or false (not primary). This flag marks the most important geography level for the supplier. |
| PrimaryGeographyLevel2Flag | Bool | Indicates whether this geography is the primary geography for level 2 (for example, state or region). Acceptable values: true (primary) or false (not primary). |
| PrimaryGeographyLevel3Flag | Bool | Indicates whether this geography is the primary geography for level 3 (for example, district or city). Acceptable values: true (primary) or false (not primary). |
| PrimaryGeographyLevel4Flag | Bool | Indicates whether this geography is the primary geography for level 4 (for example, sub-district or locality). Acceptable values: true (primary) or false (not primary). |
| PrimaryGeographyLevel5Flag | Bool | Indicates whether this geography is the primary geography for level 5 (for example, block or sector). Acceptable values: true (primary) or false (not primary). |
| Finder | String | Search term used to locate the geography record in the system. This keyword is helpful for users to easily find the specific geographical record when querying the database. |
| GeographyValueParam | String | Additional parameter or custom value associated with the geography. This can be used for custom filtering or querying based on specific geographical criteria. |