Skip to end of metadata
Go to start of metadata

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

Compare with Current View Page History

« Previous Version 7 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 15YesInstitution code owning the data to be imported.
ORGANIZATIONText 15YesOrganization code owning the data to be imported.
ORDER_NRText 50YesOrder number.
ORDER_DATEDateYesOrder date.
OPERATION_TYPEText 70YesOperation type in ('SALE','RESERVATION').
REMARKText Order remark

SEASON TICKET

INFO




S_TICKET_NRText 20YesInstance number of season ticket.
SEASON_CODEText 15YesSeason code of the organization that need to be imported.
S_TICKET_CODEText 50YesProduct code of season ticket.
COMMON_SEAT_NRSeatNumber  
COMMON_CONTText 100 Common contingent
CONTACT INFO



BUYING_CONTACT_NRText 15Yes 
CULTURAL_CONTACT_NRText 15  
FIRST_NAMEText 50  
LAST_NAMEText 50  
PRICE INFO




SEATCAT_CODEText 15Yes 
TARIF_CODEText 15Yes 
PRICE_LEVELText 15Yes 
PRICEText 50Yes 
VATText 50Yes 
PAYMENT_DATEDate 

Payment date is null when operation type = 'SALE' and price = 0

or operation type = 'RESERVATION'.

TICKET INFO



TICKET_STATEText 50Yes 
GENERATION_DATETimestamp  
BARCODEText 50  
FISCAL_NRText 50  
SHIPMENT INFO

SHIPMENT_DATEDate  
SHIPMENT_MODEText 50  

 

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