I need a simple system that meets three documents with information from a database.
The database is in. FDB and password is the default of firebird.
The interests me for this system are similar to those attached spreadsheet (the spreadsheet name is the name of the table in the database).
In the table IPTU are the values ​​to be used for completing the documents as I put on those.
The system should find only values ​​that are not paid, this means that IPTU.VALOR_PAGO is equal to 0 (zero) or is not filled.
The system should not examine [url removed, login to view] lines which is equal to 2005 or earlier (only 2006, 2007, 2008, 2009, 2010).
The system must operate offline and in Portuguese (the translation can be used via google).
The system should require the user figures for:
• IPCA (in %, like 26,7098%)
• MULTA (PENALTIES, default is 10%)
• JUROS (INTEREST, in %)
• Date da atualização (date of last update)
The values ​​of last use must be recorded and should only be changed by user action.
The three documents must refer to a single property (IPTU.COD_IMOVEL single) and if, for example, a property not have a debt in one of 5 years (2006, 2007, 2008, 2009 or 2010) must be identified this year with 0 (zero) in all fields of the row value.
It should be possible to use criteria to classify the property (single IPTU.COD_IMOVEL), as the descending order of values​​ or ascending alphabetic order.
The system must allow users to print multiple sets with the 3 files at once, and that the default file "CDA" and "Inscrição em CDA" are printed in a single track and "Ação de Execução" on 02 routes.
User can reprint any of these three files, regardless of printing too much, but this amount may be upgraded to a new date and new values ​​of IPCA, MULTA and JUROS.
The system must identify the properties for which the three documents have been printed with a check box (visible or not).
All dates is in dd/mm/YYYY format and all currency is in R$ 38.987,09
PS: The [url removed, login to view] field is intentionally blanked, the original data is filled
The IPTU table had multiple line deleted to send to project, because the original file is too big (about 65 thousands lines).
The original file is TRIBUTOSJC.fdb and uses the standard password.
All the english expressions must be removed