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. Will be set by import package while importing if this isn't provided. |
| ORDER_DATE | Date | Yes | Order date. By default, order date is importing date. |
| OPERATION_TYPE | Text 50 | Yes | Operation type. Possible values: SALE or RESERVATION |
| REMARK | Text | Order remark. | |
BUYING_CONTACT_NR | Number | Buying contact number. If it is empty, the sale is anonymous. | |
| 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) | |
| 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) | |
| 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. | |
| CONTINGENT | Code | Contingent code | |
| 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. |
| 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. |