...
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
| Attachments |
|---|
| 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) |
Cultural contact number.
If left empty and first/last name are empty, the buying contact number is used.
| 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. |