Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 4 Next »

File format for Season Tickets

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

  • The first file describes the season ticket itself.
  • The second file describes each performance included in each season ticket. This file is only needed when the list of performances if not

Season Ticket

Each row describes one season ticket

 Field codeField typeMandatoryDescription
ORDER INFOINSTITText 8YesInstitution code owning the data to be imported.
ORDER_NR Yes 
DATE Yes 
REMARK   

SEASON TICKET

INFO




S_TICKET_NR Yes 
SEASON_CODE Yes 
S_TICKET_CODE Yes 
SEAT_NRSeatNumber  
COMMON_CONT  Common contingent
CONTACT INFO



BUYING_CONTACT_NR Yes 
CULTURAL_CONTACT_NR   
FIRST_NAME   
LAST_NAME   
 SEATCAT_CODE Yes 
 TARIF_CODE Yes 
 PRICE_LEVEL Yes 
 VAT Yes 
 PAYMENT_DATE   
 TICKET_STATE   
 GENERATION_DATE   
 BARCODE   
 FISCAL_NR   
 SHIPMENT_DATE   
 SHIPMENT_MODE   

 

Season Ticket Line (TO DO)

Each row describes one performance included in a season ticket.

Field codeField typeMandatoryDescription
INSTITText 8Yes

Institution code owning the data to be imported.

  • No labels