Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Field codeField typeMandatoryDescription
INSTITUTIONText 15Yes

Institution code owning the data to be imported.

ORGANIZATIONText 15YesOrganization code owning the data to be imported.
ST_NUMBERText 20Yes

Season ticket number which is defined in the sheet Season Ticket.

SEASONCodeYesSeason code of the event
ST_CODECodeYesProduct code of season ticket
EVENT_CODECodeYesThe event code
STARTTIMETimestampYesThe performance start time of the event
SEAT_NUMBERSeatNumberYes

Seat number for each performance in the season ticket.

Mandatory when SSTK is calculated price.

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 Mandatory when the operation type is SALE and price is not 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

...