...
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Code | Yes | Institution code owning the data to be imported. |
| ORGANIZATION | Code | Yes | Organization code owning the data to be imported. |
| ORDER_NR | Number | No Order number. Will be set by import package while importing if this isn't provided | If leave it empty, order number will be set while importing by default. |
| ORDER_DATE | Date | YesNo | Order Buying date. |
| OPERATION_TYPE | Enum | Yes | Operation type. Allowed values: SALE or RESERVATION. |
| CONFIRMATION_DATE | Date | No | Expiration date to confirm reservation. |
| REMARK | Text 2000 | No | Order Internal remark of order. |
BUYING_CONTACT_NR | Number | No | Buying contact number. If it is Contact number who buys the order. If leave it empty, the sale is will be anonymous by default. |
| ORIGIN_COUNTRY | Text 50 | No | Country of buying contact (only if Buying contact is not specified). |
| ORIGIN_REGION | Text 50 | No | Region of buying contact (only if Buying contact is not specified). |
| ORIGIN_ZIPCODE | Text 50 | No | Zip code of buying contact (only if Buying contact is not specified). |
| SEASON | Code | Yes | Season code of the event/competition. |
| EVENT | Code | Yes | Product code of event/competition. |
| START_TIME | Timestamp | Yes | The performance start time of the event or the match start time of the competition. |
| CULTURAL_CONTACT_NR | Number | No | Cultural contact number. If left empty and first/last name are empty, the buying contact number is used. |
| FIRST_NAME | Text 50 | No | Beneficiary first name (only if Cultural contact number is not specified). |
| LAST_NAME | Text 50 | No | Beneficiary last name (only if Cultural contact number is not specified). |
| SEASON | Code | Yes | Season code of the event/competition. |
| EVENT_CODE | Code | Yes | Product code of event/competition. |
| START_TIME | Timestamp | Yes | The performance start time of the event or the match start time of the competition. |
| SEAT_NUMBER | SeatNumber | No | 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 | No | Contingent code. |
| SEATCAT_CODE | Code | Yes | Seat category code. |
| 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 the seat * 100. |
| CHARGE | Amount | Yes | Charge of ticket * 100. |
| VAT | Percentage | Yes | Vat rate in percent *100 (so that 1% = 100). Choose the rate that active and valid following this: Valid from date of vat rate <= ORDER_DATE <= Valid to date of vat rate. |
| PAYMENT_DATE | Date | Yes if SALE | Mandatory when the operation type is SALE and price is not 0. Default value: Order date. |
| TICKET_STATE | Enum | Yes if SALE | The state of ticket. Mandatory when the operation type is SALE. Allowed values: NOT_PRINTED, PRINTED or CONTROLLED. |
| GENERATION_DATE | Timestamp | Yes if PRINTED or CONTROLLED | Generation date. Mandatory if the ticket has been printed or controlled. Default value: Order date. |
| BARCODE | Text 50 | Yes if PRINTED or CONTROLLED | Bar code of the ticket. Mandatory if the ticket has been printed or controlled. |
| TAX_NUMBER | Text 50 | Yes if PRINTED or CONTROLLED | The tax number of the ticket. Mandatory if the ticket has been printed or controlled. |
| SHIPMENT_DATE | Date | Yes | Shipment date of the ticket. Default value: Order date. |
| SHIPMENT_MODE | Code | Yes if PRINTED or CONTROLLED | Shipment mode of the ticket. Allowed values: TBD. Mandatory if the ticket has been printed or controlled. |
...