...
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Text 15Code | Yes | Institution code owning the data to be imported. |
| ORGANIZATION | Text 15Code | Yes | Organization code owning the data to be imported. By default, the organization code is the same as the institution code. |
| ORDER_NR | Number | No | Order number. Will be set by import package while importing if left empty. |
| ORDER_DATE | Date | Yes | Order date. By default, order date is importing date. |
| OPERATION_TYPE | Text 70Enum | Yes | Operation type. Possible Allowed values: SALE or RESERVATION. |
| REMARK | Text | No | Order remark. |
| BUYING_CONTACT_NR | Number | Yes | Buying contact number. |
| CULTURAL_CONTACT_NR | Number | No | Cultural contact number. By default it is identical to the buying contact number. |
| FIRST_NAME | Text 50 | No | Beneficiary first name. Set this info only for sold tickets. |
| LAST_NAME | Text 50 | No | Beneficiary last name. Set this info only for sold tickets. |
| ST_NUMBER | Number | Yes | Season ticket number is a unique number for each ticket. Mandatory when calculated price because this number It can be started from 1. |
| SEASON | Code | Yes | Season code of the season ticket. |
| ST_CODE | Code | Yes | Product code of season ticket. |
| PRICE_LEVEL | Code | No | Price level. |
| SEAT_NUMBER | SeatNumber | Yes if fixed price | Seat number if the ticket holder is seated at the same place for all performances included in the season ticket. Mandatory when SSTK is fixed price. |
| CONTINGENT | Code | No | Contingent code. |
| SEATCAT_CODE | Code | Yes | Seat category code. |
| TARIFF | Code | Yes | Tarif code. |
| PRICE | Amount | Yes | Price of season 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 | Ticket 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 when if the ticket state is PRINTED or CONTROLLEDhas been printed or controlled. Default value: Order date. |
| BARCODE | Text 50 | Yes if PRINTED or CONTROLLED | Bar code of the season ticket. Mandatory if the ticket has been printed or controlled. |
| TAX_NUMBER | Text 50 | Yes if PRINTED or CONTROLLED | The tax number of the season ticket. Mandatory if the ticket has been printed or controlled. |
| SHIPMENT_DATE | Date | Yes | Shipment date of the season ticket. Default value: Order date. |
| SHIPMENT_MODE | Text 50Code | Yes if PRINTED or CONTROLLED | Shipment mode of the season ticket. Allowed values: TBD. Mandatory when if the ticket state is PRINTED or CONTROLLEDhas been printed or controlled. |
File format for Season Ticket Lines
...
| Field code | Field type | Mandatory | Description | |
|---|---|---|---|---|
| INSTITUTION | Text 15Code | Yes | Institution code owning the data to be imported. | |
| ORGANIZATION | Text 15Code | Yes | Org By default, the organization code is the same as the institution code. | |
| ST_NUMBER | Text 20Number | Yes | Season ticket number which is defined in the sheet for season ticket. | |
| SEASON | Code | Yes | Season code of the event/competition. | |
| ST_CODE | Code | Yes | Product code of season ticket. | |
| EVENT_CODE | Code | Yes | The event code | STARTTIMEProduct code of event/competition in the season ticket. |
| START_TIME | Timestamp | Yes | The performance start time of the event or the match start time of the competition. | |
| SEAT_NUMBER | SeatNumber | Yes | Seat number for each performance in the season ticket. Mandatory when SSTK season ticket is calculated price. | |
| CONTINGENT | Code | No | Contingent cod. | |
| SEATCAT_CODE | Code | Yes | Seat category code. | |
| TARIFF | Code | Yes | Tarif code. | |
| PRICE | Amount | Yes | Price of the seat * 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 | CodeEnum | Yes if SALE | Ticket stateThe 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 when if the ticket state is PRINTED or CONTROLLEDhas 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 | Text 50Code | Yes if PRINTED or CONTROLLED | Shipment mode of the ticket. Allowed values: TBD. Mandatory when if the ticket state is PRINTED or CONTROLLEDhas been printed or controlled. |