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.
ORDER_NR	Text 50Number	Yes	Order number.
ORDER_DATE	Date	Yes	Order date.
OPERATION_TYPE	Text 70	Yes	Operation type in ('SALE','RESERVATION'). . Possible values: SALE or RESERVATION
REMARK	Text		Order remark

Season ticket info

Text 20_CODESTICKET_Text 50.Text 100

Field code	Field type	Mandatory	Description
S_TICKET_NR	ST_NUMBER	Number	Yes	Instance number of season ticket.
SEASON	Text 15	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.

Contact info

Field type

Field code		Mandatory	Description
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.

...

Text 15

Field code	Field type	Mandatory	Description

SEATCAT_CODE	Code	Yes	Seat category code.	TARIF_CODE
Text 15TARIFF	Code	Yes	Tarif code.
PRICE_LEVEL	Text 15Code	Yes	Price level (Not yet used).
PRICE	Amount	Yes	Price of season ticket.
VAT	NumberPercentage	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'.

Description If not input: Shipment date = date is null when ticket state = 'NOT_PRINTED'.

Field code	Field type	Mandatory
TICKET_STATE	Text 50Enum	Yes	Ticket state in (' . Allowed values: NOT_PRINTED ' , ' PRINTED ','CONTROLLED'). or CONTROLLED
GENERATION_DATE	Timestamp		Generation date is null when Mandatory where ticket state = 'NOT_PRINTED'. is PRINTED or CONTROLLED
BARCODE	Text 50		Bar code of the ticket. (Not yet used).Default now is 'IMP-' + ticket id.
FISCALTAX_NRNUMBER	Text 50		The fiscal tax number of the ticket.(Not yet used).Default now is 'IMP-' + ticket id.
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
INSTITINSTITUTION	Text 15	Yes	Institution code owning the data to be imported.
ORGANIZATION	Text 15	Yes	Organization code owning the data to be imported.
SST_TICKET_NRNUMBER	Text 20	Yes	Instance number of season ticket.
SEASON_CODE	Text 15Code	Yes	Season code of the organization that need to be imported.event
EVENT_CODE	Text 20Code	Yes	The event code of the season ticket line.
STARTTIME	Timestamp	Yes	The performance start time of the event of the season ticket line.
SEAT_NUMBER	SeatNumber	Yes
CONTINGENT	Text 100Code		Contingent code
TICKET_STATE	Text 50Code	Yes	Ticket state in (' . Allowed values: NOT_PRINTED ' , ' PRINTED ','CONTROLLED'). or CONTROLLED
GENERATION_DATE	Timestamp		Generation date is null when Mandatory where ticket state = 'NOT_PRINTED'.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'.