...
- Each column represents one field
- The first row of each file contains the field codes
- The values are case sensitive (upper/lower case) and accent sensitive.
- The values must be formatted as described in the table hereunder.
Field formats
| Data type | Format and values | Example |
|---|---|---|
| Date | DD.MM.YYYY or YYYY-MM-DD | 01.08.1965 or 1965-08-01 |
| Timestamp | DD.MM.YYYY HH24:MI:SS or YYYY-MM-DD HH24:MI:SS | 01.08.1965 11:34:56 or 1965-08-01 11:34:56 |
| Amount | The amount must be defined in 100ths of units. No decimal separator. No thousands separator. | 12000 means 120.00€ 3450 means 34.50$ |
| Percentage | The percentage must be given in 100ths of percents. No decimal separator. | 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. | |
| Enum | Valid value in upper case. OPERATION_TYPE: SALE/RESERVATION TICKET_STATE: NOT_PRINTED/PRINTED/CONTROLLED | |
| 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: Physical configuration/Area/Block/Row/Number. All are in code. | Have all info: Away/OrchestreLoges/Cour/PB/1764 Without block: Away/Loges/Cour/B/64 Unnumbered area: Away/ 2emeBalcon//A/45BLoges |