FMUTA component
The FMUTA component enriches messages containing financial mutations in CSV format as exported by Abacus. This component produces messages in a format that can be imported by accounting software. It adds a header line for each group of lines present in the input.
Input requirements
The first line of CSV files used as input for this component should be a header containing the following column names:
- Regelnr
- Bedrag
- Incl_Excl
- BTWBedrag
- HeaderOmschrijving
- RegelOmschrijving
The column named "Regelnr" should be first, and the other columns can be present in any order. The columns named "Bedrag" and "BTWBedrag" should contain numerical values using a comma as decimal separator.
Additionally, the files should contain a byte order mark, and the fields should be separated by semicolons.
Output
The following table summarizes the functionality of this component.
| Column name | Header | Line |
|---|---|---|
| Regelnr | (1) | Copied |
| Dagboektype | Copied | Copied |
| Dagboeknr | Copied | Copied |
| Periode | Copied | Copied |
| Boekjaar | Copied | Copied |
| BoekstukNr | Copied | Blank |
| HeaderOmschrijving | Dropped | Dropped |
| RegelOmschrijving | Dropped | Dropped |
| Omschrijving | (2) | (3) |
| Datum | Copied | Copied |
| Tegenrekening | Blank | Copied |
| Debnr | Copied | Copied |
| Crednr | Copied | Copied |
| Factuurnr | Blank | Copied |
| Bedrag | (4) | Copied |
| Incl_Excl | Dropped | Dropped |
| Journaliseren | Copied | Copied |
| Valutacode | Copied | Copied |
| Koers | Blank | Copied |
| Krediet_bep | Copied | Copied |
| Bedrag_krediet_bep | Copied | Copied |
| Vervaldatum_Factuur | Copied | Blank |
| Vervaldatum_Bedrag_Krediet_bep | Copied | Blank |
| BTWCode | Blank | Copied |
| BTWBedrag | Blank | Copied |
| Weeknr | Copied | Copied |
| Referentie | Copied | Blank |
| Betalingswijze | Copied | Blank |
| Bedragrekening | Copied | Copied |
| Kostenplaats | Copied | Copied |
| Kostendrager | Copied | Copied |
| AantalKostendrager | Copied | Copied |
| Verschilcode | Copied | Copied |
| kolom30 | Copied | Copied |
| Stornoboeking | Copied | Copied |
The values in the table represent the following:
- Copied indicates that the value of these fields are copied from the input.
- Dropped indicates that these columns are dropped from the output.
- Blank indicates that the values of these fields is blank.
- (1) indicates that the value of these fields is equal to "0".
- (2) indicates that the value of these fields is copied from the column "HeaderOmschrijving".
- (3) indicates that the value of these fields is copied from the column "RegelOmschrijving".
- (4) indicates that the value of these fields is computed from the values in the columns "Bedrag", "Incl_Excl", and "BTWBedrag". The value in the header is equal to the sum of the values in the column "Bedrag" of the corresponding lines and the sum of the values of the column "BTWCode" for the lines in which the value for the column "Incl_Excl" equals "Excl".
Configuration
The decimal separator, field delimiter, and quoting behavior used for the output are configurable. You can use any character as decimal separator or delimiter. You can choose whether you want each field to be quoted or only those fields that require quotation marks according to the specification of the CSV format. For example, fields containing line breaks, double quotes, or commas should be quoted.