File format for Single Entries
The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
Each line import one single ticket. If an existing order contains several ticket with the same seat category, same tarif, same contingent, they have to be duplicated.
Examples
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Text 15 | Yes | Institution code owning the data to be imported. |
| ORGANIZATION | Text 15 | Yes | Organization code owning the data to be imported. By default, the organization code is the same as the institution code. |
| ORDER_NR | Number | Yes | Order number. |
| ORDER_DATE | Date | Yes | Order date. |
| OPERATION_TYPE | Text 50 | Yes | Operation type. Possible values: SALE or RESERVATION |
| REMARK | Text | Order remark. | |
| SEASON_CODE | Code | Yes | Code of season |
| EVENT_CODE | Code | Yes | Code of event. |
| START_TIME | Date | Yes | Performance start time |
| SEAT_NUMBER | SeatNumber | Seat number. If the seat number is not specified, the single entry will be imported in a non-numbered zone according to the seat category. | |
BUYING_CONTACT_NR | Number | Buying contact number. If it is empty, the sale is anonymous. | |
| ORIGIN_COUNTRY | Text 50 | Country of buying contact (only if Buying contact is not specified) | |
| ORIGIN_REGION | Text 50 | Region of buying contact (only if Buying contact is not specified) | |
| ORIGIN_ZIPCODE | Text 50 | Zip code of buying contact (only if Buying contact is not specified) | |
| CULTURAL_CONTACT_NR | Number | Cultural contact number. If left empty and first/last name are empty, the buying contact number is used. | |
| FIRST_NAME | Text 50 | First name of cultural contact (only if Cultural contact number is not specified) | |
| LAST_NAME | Text 50 | Last name of cultural contact (only if Cultural contact number is not specified) | |
| SEATCAT_CODE | Code | Yes | Seat category |
| TARIFF | Code | Yes | Tariff code. It is looked up first in a mapping table and if not found, it will checked against a code of the tarifs in SecuTix. |
| CONTINGENT | Code | Contingent code | |
| PRICE | Amount | Yes | Price of ticket. |
| CHARGE | Amount | Yes | Charge of ticket. |
| VAT | Percentage | VAT in percent | |
| PAYMENT_DATE | Date | Payment date is null when operation type = 'SALE' and price = 0 or operation type = 'RESERVATION'. | |
| TICKET_STATE | Text 50 | Yes | Ticket state. Possible value: NOT_PRINTED, PRINTED, CONTROLLED |
| GENERATION_DATE | Timestamp | Generation date is null when ticket state is NOT_PRINTED. | |
| BARCODE | Text 50 | Bar code of the ticket. Mandatory if the ticket has been printed. | |
| TAX_NUMBER | Text 50 | The tax number of the ticket. | |
| SHIPMENT_DATE | Date | Shipment date. If not input: Shipment date = Order date. | |
| SHIPMENT_MODE | Text 50 | Shipment date is null when ticket state is NOT_PRINTED. |