...
| Data type | Format and values | Example |
|---|---|---|
| Date | DD.MM.YYYY | 01.08.1965 |
| Timestamp | DD.MM.YYYY HH24:MI:SS | 01.08.1965 11:34:56 |
| Amount | The amount must be defined in 100ths of units. No decimal separator No thousands separator | 12000 means 120.00€ |
| Percentage | The percentage must be given in 100ths of percents | 1960 means 19.6% |
| Text | Free text. The optionally indicated number is the maximum length of the text. By default, the maximum length is 2'000 characters. | |
| Boolean | TRUE/FALSE | TRUE/FALSE |
| Code | Text, max length 8 characters | PERFO123 |
| Number | Digits only. No decimal separator. No thousands separator. | 1234582 |
| CodeValue | Code=Value couple. | SOURCE=MYFILE |
| SeatNumber | String describing uniquely a seat: Area / Block / Row / Number
| Orchestre//P/17 Loges/Cour/B/64 2emeBalcon//A/45B |