Page tree
Skip to end of metadata
Go to start of metadata

The generic file format is described in Generic file format (Extended). This documents describes all available import fields.

There are many different possible configurations for season tickets. Not all of them are available for season tickets imports.

  • For fixed prices imports, the pricing information must be given in the first part (red part).
  • For calculated pricing, the pricing information must be given in the second file (yellow part) and will remain empty in the first file.

The data to be imported needs to be described on two files

  1. The first file describes the season ticket itself.
  2. The optional second file describes each performance included in each season ticket.

Examples

  File Modified
Microsoft Excel Spreadsheet Seasonticket Fixed Price Example.xlsx Mar 14, 2019 by mkh
Microsoft Excel Spreadsheet Seasonticket Calculated Price Example.xlsx Mar 14, 2019 by mkh

File format for Season Tickets


Field codeField typeMandatoryDescription
INSTITUTIONText 15YesInstitution code owning the data to be imported.
ORGANIZATIONText 15Yes

Organization code owning the data to be imported.

By default, the organization code is the same as the institution code.

ORDER_NRNumberYesOrder number.
ORDER_DATEDateYesOrder date.
OPERATION_TYPEText 70Yes

Operation type.

Possible values: SALE or RESERVATION

REMARKText
Order remark
BUYING_CONTACT_NRNumberYesBuying contact number.
CULTURAL_CONTACT_NRNumber
Cultural contact number. By default it is identical to the buying contact number.
FIRST_NAMEText 50
Beneficiary first name. Set this info only for sold tickets.
LAST_NAMEText 50
Beneficiary last name. Set this info only for sold tickets.
ST_NUMBERNumberYesSeason ticket number
SEASONCodeYesSeason code of the season ticket.
ST_CODECodeYesProduct code of season ticket.
PRICE_LEVELCode
Price level
SEAT_NUMBERSeatNumber
Seat number if the ticket holder is seated at the same place for all performances included in the season ticket
CONTINGENTCode
Common contingent.
SEATCAT_CODECodeYesSeat category code.
TARIFFCodeYesTarif code.
PRICEAmountYesPrice of season ticket * 100
VATPercentageYes

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_DATEDate

Payment date must be empty if price is 0 or operation type is RESERVATION.

TICKET_STATEEnumYes

Ticket state.

Allowed values: NOT_PRINTED, PRINTED or CONTROLLED

GENERATION_DATETimestamp

Generation date

Mandatory when the ticket state is PRINTED or CONTROLLED

BARCODEText 50

Bar code of the season ticket.

TAX_NUMBERText 50

The tax number of the season ticket.

SHIPMENT_DATEDate

Shipment date of the season ticket.

Default value: Order date.

SHIPMENT_MODEText 50

Shipment mode of the season ticket.

Allowed values: TBD

Mandatory when the ticket state is PRINTED or CONTROLLED


File format for Season Ticket Lines

Each row describes one performance included in a season ticket. The rows are linked to the first file using INSTITUTION and ST_NUMBER.

Field codeField typeMandatoryDescription
INSTITUTIONText 15Yes

Institution code owning the data to be imported.

ORGANIZATIONText 15YesOrganization code owning the data to be imported.
ST_NUMBERText 20YesInstance number of season ticket.
If several season tickets in one order, they should all have different number so that SecuTix will acknowledge them as different season ticket product
SEASONCodeYesSeason code of the event
ST_CODECodeYesProduct code of season ticket.
EVENT_CODECodeYesThe event code
STARTTIMETimestampYesThe performance start time of the event
SEAT_NUMBERSeatNumberYes
CONTINGENTCode
Contingent code
SEATCAT_CODECodeYesSeat category code
TARIFFCodeYesTarif code
PRICEAmountYesPrice of the seat * 100
VATPercentageYes

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_DATEDate
Payment date must be empty if price is 0 or operation type is RESERVATION.
TICKET_STATECodeYes

Ticket state.

Allowed values: NOT_PRINTED, PRINTED or CONTROLLED

GENERATION_DATETimestamp

Generation date.

Mandatory when the ticket state is PRINTED or CONTROLLED

BARCODEText 50

Bar code of the ticket.

TAX_NUMBERText 50

The tax number of the ticket.

SHIPMENT_DATEDate

Shipment date.

Default value: Order date.

SHIPMENT_MODEText 50

Shipment mode.

Allowed values:

Mandatory when the ticket state is PRINTED or CONTROLLED