Plugin: Extended Location

From iDempiere en
Jump to: navigation, search

Plugin: Extended Demography


Description

This Plugin is related to Demographic Aspects on Idempiere ERP. It is well known that on some countries there is a political division with concepts that go beyond country, region and city.

For example in Spain we talk about Communities, they are related to Group of Provinces that keeps Local Government. They also have a political division for Provinces called Municipalities (Municipality-Municipio).

Another example is Venezuela, they have a political division for Provinces (Estados) called Municipalities (Municipality-Municipio) and a Municipality is also divided on Parishes (Parish-Parroquia). Particularity Main Mail office in Venezuela has published a new rule indicating the way postal address is to be written:

Communities, Region, Municipality and Parish, can be use for statistic and BI analysis on Sales, Cost, Personnel and other type of transaction results.

Postal Codes is another concern to be covered in future on this plugin, because a default value can be obtained from Region, Provinces, Municipality and Parish. Also Street Names provides a rule for finding zip codes.

In order to accomplish what have been explained before, some tables have to be modified, and some others tables have to be added to implement the new Window and plugin.

Added Tables:
C_Municipality, C_Parish, C_Zipcode, C_Community

Modified Tables
(1) Add New Records (2) Add New Fields
C_Country (2) , AD_Message (1), C_Location (2), C_Region (2) , AD_Reference (1)

Install Procedure

Feedback

Please rate this plugin: