The file format adheres to the following rules which enable easy processing on the client's side with the client's software as well as table processors such as Excel:
The files are text files with variable data record lengths.
Each data record is concluded with the digraph for the end of a line (CR+LF, i.e. 0x0D+0x0A).
The individual items in a data record are separated by the TAB character (i.e. 0x09).
Non-defined values of any type can be represented by spaces.
Supported encoding: ANSI – CharsetWindows1250.
The following rules are adhered to for the individual types of item formatting:
| Code | Item Type | Feature | NULL Value | Example |
|---|---|---|---|---|
|
N |
Numerical |
They are aligned to the right and supplemented with zeros on the left. |
Space sequence |
000000666 or 0000000 |
|
A |
Text |
They are aligned to the left and supplemented with spaces on the right. |
Space sequence | "ABC " or " " |
|
D |
Date |
They are eight characters long in the YYYYMMDD format |
Space sequence |
20071231 |
|
M |
Financial |
They are sixteen characters long, specified in hellers without a decimal separator; they begin with a sign and are followed by 15 digits (supplemented with zeros from the left) |
+000000000000000 |
+000000000010000 or +000000000010000 |
The files to be downloaded that are created according to the system settings are displayed in the overview of BBS Exports. It is possible to generate exports of defined overviews on the individual agendas; they however do not have to correspond to the structure of the data records described below (e.g. the specific code default value is null).
Copyright © ARBES, 2019