The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
Season tickets need to be described on two files
| 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. |
| ORDER_NR | Number | Yes | Order number. |
| ORDER_DATE | Date | Yes | Order date. |
| OPERATION_TYPE | Text 70 | Yes | Operation type. Possible values: SALE or RESERVATION |
| REMARK | Text | Order remark | |
| ST_NUMBER | Number | Yes | Instance number of season ticket. |
| SEASON | Code | Yes | Season code of the organization that need to be imported. |
| ST_CODE | Code | Yes | Product code of season ticket. |
| COMMON_SEAT_NR | SeatNumber | Seat number if the ticket holder is seated at the same place for all performances included in the season ticket | |
| COMMON_CONT | Code | Common contingent. | |
| BUYING_CONTACT_NR | Number | Yes | Buying contact number. |
| CULTURAL_CONTACT_NR | Number | Cultural contact number. By default it is identical to the buying contact number. | |
| FIRST_NAME | Text 50 | Beneficiary first name. | |
| LAST_NAME | Text 50 | Beneficiary last name. | |
| SEATCAT_CODE | Code | Yes | Seat category code. |
| TARIFF | Code | Yes | Tarif code. |
| PRICE_LEVEL | Code | Yes | Price level (Not yet used). |
| PRICE | Amount | Yes | Price of season ticket. |
| VAT | Percentage | Yes | Vat rate in percent. 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 | Payment date is null when operation type = 'SALE' and price = 0 or operation type = 'RESERVATION'. | |
| TICKET_STATE | Enum | Yes | Ticket state. Allowed values: NOT_PRINTED, PRINTED or CONTROLLED |
| GENERATION_DATE | Timestamp | Generation date Mandatory where ticket state is PRINTED or CONTROLLED | |
| BARCODE | Text 50 | Bar code of the ticket. | |
| 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: Mandatory where ticket state is PRINTED or CONTROLLED |
Each row describes one performance included in a season ticket.
| 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. |
| ST_NUMBER | Text 20 | Yes | Instance number of season ticket. |
| SEASON_CODE | Code | Yes | Season code of the event |
| EVENT_CODE | Code | Yes | The event code |
| STARTTIME | Timestamp | Yes | The performance start time of the event |
| SEAT_NUMBER | SeatNumber | Yes | |
| CONTINGENT | Code | Contingent code | |
| TICKET_STATE | Code | Yes | Ticket state. Allowed values: NOT_PRINTED, PRINTED or CONTROLLED |
| GENERATION_DATE | Timestamp | Generation date Mandatory where ticket state is PRINTED or CONTROLLED | |
| BARCODE | Text 50 | Bar code of the ticket. (Not yet used). Default now is 'IMP-' + ticket id. | |
| FISCAL_NR | Text 50 | The fiscal 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 = 'NOT_PRINTED'. |