Installation of Venezuela's Demography
It starts from the BD Adempiere_pg.dmp version 2.0.
Once the Database is installed.
The GeographyVenezolanaCompleta.sql Procedure is executed
The zip pack is incorporated
The processes are: 'Synchronize Terminology' and 'Sequence Check'
We use the DB:
The Complete Demography contains:
Country Regions (c_community * NEW)
States or Provinces (c_region)
Municipalities (c_municipality * NEW)
Parishes (c_parish * NEW)
Postal Zones (c_zipcode * NEW)
Modification of the Location table to include the variables:
In addition to (c_country_id, c_region_id, c_city_id)
The variables (c_municipality_id, c_parish_id and c_zipcode_id)
To relate them to the corresponding tables.
Additional Consideration for Address Formats:
Define the Default Address of 'System'
Define Capture Order of Address Fields
For the default Address enter the System as user 'System' in English preferably. Then locate the 'Location' screen:
System -> Data -> Utilities -> Location
Place the main address, especially the Region and the Country. See figure 1.4.1.
For the order of capture of the address data, the system validates it for each country. In the case of Venezuela we locate the es_VE Language. Using the menu option:
For the order of capture of the address fields, it must be modified in the country register, according to the menu:
System -> General Rules -> System Rules -> Country Region and Cities
Modify the Capture Sequence field according to the following rules:
The Capture Sequence defines the fields to be used when capturing an address on this country. The following notations are used: @ CO @ = Country, @ C @ = City, @ P @ = Postal, @ A @ = PostalAdd, @ R @ = Region, @ A1 @ = Address 1 to @ A4 @ = Address 4. Country is always mandatory, add a bang! To make another field mandatory, for example @C! @ Makes city mandatory, @ A1! @ Makes Address 1 mandatory.
The sequence that best uses the combos suggested:
@CO@ @R@ @C@ @A1@ @A2@ @A3@ @A4@, @P@