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 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, andBTWBedrag. The value in the header is equal to the sum of the values in the columnBedragof the corresponding lines and the sum of the values of the columnBTWCodefor the lines in which the value for the columnIncl_ExclequalsExcl.
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.