...
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. | Away/Orchestre//P/17 Away/Loges/Cour/B/64 Away/2emeBalcon//A/45B |
...