Sitzungsgeld2CSV
Converts payment data from an XML file to CSV data.
Description
Payment data can be extracted from the Council Information System e.g. for meeting expenses. These are usually handed over to the ERP system for further processing.
For the purposes of interpretation, these data shall be used as input data. The XML input data are checked against an XSD schema before processing. If the data are not schematically compliant, they will be ignored.
General information on implementation will be analysed:
— Total of checks
— Number of records
— Date
— Payment Info ID
— Method
— Type (e.g. SEPA)
— Debtor name
— Debitor-IBAN
— Debit BIC
In addition, the following data shall be processed per individual dataset:
— End-to-end ID (linked to Payment Info ID)
— Amount
— BIC
— Surname, first name
— IBAN
— Intended use
— Date
Processing shall be carried out in CSV format. Separator is a semicolon (“;”).