CSV export file description formatted in BMD format.
Export File: CSV
Delimiter: Semicolumn
Headlines: No
Download here a CSV sample file:
CSV Description:
| Column # | Name in German | Allowed Format | Length | Format | Description |
| 1 payroll: month | Abrechnungsmonat | 0 – 12 | 2 | Integer | Month of the exported payroll => 1 for January, 2 for February, 3 for March ... 12 for December |
| 2 client: id | Mandanten ID | 1 – 999999 | 6 | Integer | Matching "Export ID 1" from company settings |
| 3 employee: id | Personalnummer | 1 – 999999 | 6 | Integer | "Employmee ID" from user employment settings |
| 4 employee: sub_id | Unternummer | 0 – 999999 | 6 | Integer | "Employment ID" from user employment settings |
| 5 wage_type: id | Lohnart ID | 0 – 650 | 3 | Integer | "Export ID 1" from wage type settings |
| 6 wage_type: quantity | Menge | 0,00 – 99999,99 | 7 | Decimal | Calculated wage type quantity |
| 7 wage_type: value | Satz | 0,00 – 99999,99 | 7 | Decimal | Result of wage type value with an before number => Example: 123 (no space between * and the number) |
| 8 wage_type: amount | Betrag | 0,00 – 99999,99 | 7 | Decimal | Total amount |
| 9 employee: cost_center | Kostenstelle ID | 0 – 999999 | 9 | Integer | Hardcoded number 0 |
| 10 client: cost_account | Kostenrechnung | 0 – 999999 | 9 | Integer | Blank |
| 11 wage_type: recalculation_month | Aufrollmonat | 0 – 12 | 2 | Integer | This is also a month value like in column 1 but for recalculated items from previous months. Example: Payroll month is May (Column 1 = 5) but in the export results we have some compensation and new items, which were recalculated for March. Then column 11 will be 3. If there is no recalculation and no items from previous month, column 11 will be blank. |
| 12 | Blank | ||||
| 13 reports: unproductive: id | Fehlzeit Export ID | 0 – 99 | 3 | Integer | Check is done for the User and for the payroll month if there are approved unproductive time entries stored. If yes, results are written as an ID in columns 13. Check "Unproductive Time Entry IDs" from this List. |
| 14 reports: unproductive: start | Fehlzeit von | YYYYMMDD | Date | Start date of the unproductive time entry. Listed day by day and writen as start date. Example: Employee has vacation from 02.05.2019 – 06.05.2019, then… Column 13 = 301; Column 14 = 20190502 Column 13 = 301; Column 14 = 20190503 Column 13 = 301; Column 14 = 20190504 Column 13 = 301; Column 14 = 20190505 Column 13 = 301; Column 14 = 20190506 Important: Sorted by User (Column 3) AND by this date (Column 14) ascending. Example: Column 3 = 123; Column 14 = 20190506 Column 3 = 123; Column 14 = 20190509 Column 3 = 456; Column 14 = 20190507 Column 3 = 456; Column 14 = 20190508 | |
| 15 reports: unproductive: end | Fehlzeit bis | YYYYMMDD | Date | End date of the unproductive time entry. Because each day is listed separately end date = start date. So Column 15 = Column 14. This is true even for Overnight time entries. | |
| 16 reports: unproductive: days | Abwesenheitstage | 0 – 999999,99 | 8 | Decimal | Amount of days from unproductive time entry. In this column unproductive time entry hours are compared with the working time model. Example: WTM = 8hrs Unproductive Time Entry = 4hrs Column 16 = 4 / 8 = 0,5 Important: If unproductive time entry type is “Unpaid Leave”, Column 13 = 101, then result is multiplied with -1. Example for Column 13 = 101: WTM = 12hrs Unpaid Leave Time Entry = 7hrs Column 16 = 7 / 12 * -1 = -0,58 |