Description
HR-IT: RPUCMNI0 Report.
Update of the municipality table from ASCII external file.
It allows loading the list of the Italian municipalities from anexternal file and it carries out an automatic upload of theabove-mentioned tables.
T5ITM4,T5ITM5,T5ITMX, T5ITMW, T5ITM6 and T5ITMA tables are managed bythis report.

Precondition
Detailed list of the Italian municipalities with the official codes forthe tax payer's reference number calculation (cadastral codes).
Example: Rome = H501.
This list can be displayed on the official site of the Finance Ministry(http://www.finanze.it/comuniaddirpef.htm) and it should be adaptedaccording to the following structure:
the first field (Input file - ASCII) should be filled in with the fullname of the external file. A F4 Help (search help)is available. It opensa window wherein the external file can be saved; the file should be inASCII format and comply with some rules in order to be correctly read bythe program. The file can be created with Excel as follows:
Create an Excel files with the names of all municipalities
Order columns as follows:
1st column: descriptions of municipalities (field T5ITM4-TXMUN)
2nd column: descriptions of the municipality provinces
(field T5ITM4-BLAND)
3rd column: descriptions of the municipality cadastral codes (fieldT5ITM4-MUNICCDFS)
4th column: descriptions of the (univocal) codes of municipalities(field T5ITM4-MUNIC)
5th column: descriptions of the municipality regions
(field T5ITM4-REGIO)
6th column: descriptions of the codes of municipalities for the F24 form(field T5ITM4-MUNICF24)
7th column: description of the municipal tax (field T5ITM5-CDTMU)
8th column: description of the names of municipal taxes (fieldT5ITMW-TXTMU)
9th column: description of the code of the taxation formula (fieldT5ITM6-CDFTA).
ALL the above-mentioned information is required; for each municipalityONLY one code should be mentioned.
DO NOT add any heading to the file as comments for column titles.
Save the Excel file in .csv format on the hard disk. The created filewill be an ASCII file using the ";" as column separator. This format canbe automatically obtained from an Excel file saving it as a .csv file.In this way the Excel file (binary system) will be changed into an ASCIIsystem if a ";" is entered after each value.
This file is ready to be loaded by the program.
Validity from date and validity to date fields: enter the default
values.
NOTE: the program does not automatically delimit the validity period.
The delimitation of the validity period for each record on the
table should be carried out manually.
"Delete existing values"/"Only change" pushbutton: If the existingvalues are deleted, the values that have been already entered intotables T5ITM4 and T5ITM5 are deleted and replaced with the new ones; ifthe "Only change" option is selected, the existing values which are notdeleted are updated.
"Input for transport" indicator: The entries are saved into a transportproposal.
"Only test" indicator: the running of the test to check the consistencyof the entered values excluding the presence of double keys in the inputfile is recommended. The test produces a list with results: If theoutput is the list of municipalities without error messages, the updatewithout test can be carried out.

Output
List of municipalities loaded from files
Update of the list of municipalities
The report can be run in "test" mode and the list of results will beentered into the T5ITM4 table after the program has checked theconsistency of values and the uniqueness of keys in the input file. Inthis case no change is carried out.
If the output is the list of municipalities without error messages, theupdate can be carried out without test.
If the "test" mode is not selected, the database is updated and the newlist of results is displayed.

Example
If the program is run and the following data is given as an input, 2 newresults are obtained:
ROMA;RM;H501;00100;LAZ;99
MILANO;MI;F205;20100;LOM;88
NOTE: do not change the input data sequence.
If an entry with the same zip code (ex.: 00100 or 20100) and validity todate already exists, this entry is overwritten.