Financial data reporting

The data to be reported is taken from the posting interface for the inventory management system, then the data is compressed and supplied to various target systems in different countries in the form of csv files. Depending on which country the target system is in, the data has to be classified and compressed in accordance with different specifications. At the same time, it must be ensured that the totals of the reported data match in the various data flows. The project also includes a global check (reconciliation) of the compressed data. The data extracts should be created and sent automatically at regular intervals. The necessary programs are therefore implemented as database scripts that can be scheduled in the batch method for a job planning environment. In addition to these regular extracts, other reports have to be created to process posting data from the past and for a one-off initialization of the land registers.