...
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. | |||||||
CULTURALORIGIN_CONTACT_NR | Number | Cultural contact number. If left empty and first/last name are empty, the buying contact number is used. | COUNTRY | Text 50 | Country of buying contact (only if Buying contact | FIRST_NAME | Text 50 | Beneficiary first name (only if Cultural contact number is not specified) | |
LASTORIGIN_NAMEREGION | Text 50 | Beneficiary last name Region of buying contact (only if Cultural Buying contact number is not specified) | |||||||
ORIGIN_COUNTRYZIPCODE | Text 50 | Country 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_NAMEORIGIN_REGION | Text 50 | Region of buying contact Beneficiary first name (only if Buying Cultural contact number is not specified) | |||||||
ORIGINLAST_ZIPCODENAME | Text 50 | Zip code of buying contact Beneficiary last name (only if Buying Cultural contact number is not specified) | |||||||
SEASON_CODE | Code | Yes | Season code of the event/competition | ||||||
EVENT_CODE | Code | Yes | Product code of event/competition | ||||||
START_TIME | Timestamp | Yes | Performance/Match 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 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 | 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 | Mandatory when the operation type is SALE and price is not 0. | |||||||
TICKET_STATE | Text 50 | Yes | Ticket state. Possible value: NOT_PRINTED, PRINTED, CONTROLLED | ||||||
GENERATION_DATE | Timestamp | Generation date. Mandatory when the ticket state is PRINTED or CONTROLLED | |||||||
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. Default value: Order date. | |||||||
SHIPMENT_MODE | Text 50 | Shipment mode. Allowed values: TBD Mandatory when the ticket state is PRINTED or CONTROLLED |
...