Geocode
Stores geographic coordinate data that is derived from address fields. This table supports mapping, territory management, and proximity-based analytics.
Columns
| Name | Type | ReadOnly | Description |
| Address | String | False |
The full address that is being geocoded. This value typically represents a physical location entered for a parent record, such as an account, lead, or contact. |
| Country | String | False |
The country that is associated with the address being geocoded. This value supports location standardization and mapping services. |
| Date_Entered | Datetime | True |
The date and time when this geocode record was created. This timestamp is used for audit tracking and historical review. |
| Date_Modified | Datetime | True |
The date and time when this geocode record was last updated. This timestamp supports change tracking. |
| Deleted | Bool | False |
A Boolean field that returns a value of 'true' when this geocode record is marked as deleted. It returns a value of 'false' when the record is active. |
| Error_Message | String | False |
The error message that is returned when a geocoding request fails. This value provides troubleshooting details for resolution. |
| Geocoded | Bool | False |
A Boolean field that returns a value of 'true' when the address has been successfully geocoded. It returns a value of 'false' when coordinates have not yet been generated or geocoding has failed. |
| Id [KEY] | String | True |
The unique identifier (Id) of this geocode record. The system uses this Id to reference and manage the record. |
| Latitude | Decimal | True |
The latitude coordinate that is assigned to the geocoded address. This value supports mapping and spatial analysis. |
| Longitude | Decimal | True |
The longitude coordinate that is assigned to the geocoded address. This value pairs with latitude for location plotting. |
| Parent_Id | String | False |
The Id of the parent record that is associated with this geocode entry (for example, an account, contact, or lead). |
| Parent_Name | String | False |
The display name of the parent record that is associated with this geocode entry. This value appears in UI elements that show location relationships. |
| Parent_Type | String | False |
The type of SugarCRM object that is associated with this geocode entry (for example, 'Accounts', 'Contacts', or 'Leads'). |
| Parent_User_Name | String | False |
The display name of the user who is associated with the parent record. This value supports assignment visibility and geographic context. |
| Postalcode | String | False |
The postal code that is associated with the address that is being geocoded. |
| Status | String | False |
The processing status of the geocode request (for example, 'Pending', 'Successful', or 'Failed'). |