City Table and Database
The Company, Person, Person in Company, Additional Address and Property (BTB only) info areas are linked to the Country and City tables via the country and postal code.
The following fields are transferred both to and from the City table when new records are added (depending on the info area and vertical):
Info Area |
BTB |
OTC |
FS |
---|---|---|---|
Company |
Rep 1, Rep 2, County, State, Area, Jurisdiction, Pol. District, Area Code |
Rep, Block Name, Block No., Block Segment, County, Area, Office Rep, Nielsen Area, Area Code |
Rep, County, Area |
Person / Person in Company |
State, Area Code |
County, Area Code |
County, Area Code |
Additional Address |
State, Area Code |
Area Code |
Area Code |
Property |
Rep 1, Rep 2, County, State, Area, Jurisdiction, Pol. District |
- |
- |
You can add an entry to the Configuration info area which prevents fields from the city table being transferred to other info areas, see City Table.
You can prevent new cities being added from the Aurea CRM win main module by configuring the data model appropriately, see Mapping.