...
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.
| Field code | Field type | Mandatory | Description | ||||
|---|---|---|---|---|---|---|---|
| INSTITINSTITUTION | Text 15 | Yes | Institution code owning the data to be imported. | ||||
| ORGANIZATION | Text 15 | Yes | Organization code owning the data to be imported. | ||||
| OPERATION | Not yet use. | ||||||
| . By default = institution code | |||||||
| ORDER_NR | Text 50Number | Yes | Order number. | ||||
| ORDER_DATE | Date | Yes | Order date. | ||||
| OPOPERATION_TYPE | Text 50 | Yes | Operation type. Possible values: SALE or RESERVATION , SALE. | ||||
| 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 contact.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.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 | Text 15Code | Yes | Seat category number of the performance. | TARIF_CODE | |||
| TARIFF | CodeText 15 | Yes | Tarif Tariff code of order. | ||||
| CONTINGENT_CODE | Text 15Code | Contingent code. | |||||
| PRICE | Amount | Yes | Price of ticket. | ||||
| CHARGE | Amount | Yes | Charge of ticket. | ||||
| VAT | NumberPercentage | 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 in ('. 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. (Not yet used). Default now is 'IMP-' + ticket id. Mandatory if the ticket has been printed. | |||||
| TAX_NUMBERFISCAL_NR | Text 50 | The fiscal tax number of the ticket.(Not yet used).Default now is 'IMP-' + ticket id. | |||||
| 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'. | PERFORMANCE_CODE | Don't need. |