Page tree

Versions Compared

Key

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

...

Field codeField typeMandatoryDescription
INSTITText 15Yes

Institution code owning the data to be imported.

ORGANIZATIONText 15YesOrganization code owning the data to be imported.
OPERATION  Not yet use.
ORDER_NRText 50YesOrder number.
ORDER_DATEDateYesOrder date.
OP_TYPE Yes 
REMARKText Order remark.
SEASON_CODE Yes 
EVENTSERVICE_CODE Yes Code of service product.
START_TIMEDate ???Don't need.
SEAT_NUMBER  ???Don't need.

BUYING_CONTACT_NR

Number Contact Buying contact number.
ORIGIN_COUNTRY Text 50  Country of contact.
ORIGIN_REGION Text 50  Region.
ORIGIN_ZIPCODE Text 50  Zip code.
CULTURAL_CONTACT_NR Number  Cultural contact number.
FIRST_NAME Text 50  First name of cultural contact.
LAST_NAME Text 50  Last name of cultural contact.
SEATCAT_CODE Text 15  Not use yet.
TARIFAUDSUBCAT_CODE Text 15  Tarif code of order.
CONTINGENT_CODE Text 15  Not use yet.
PRICE Amount  Price of service.
CHARGE Amount  Charge of service.
VAT Number  VAT in percent.
PAYMENT_DATEDate  

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

or operation type = 'RESERVATION'.

 

TICKET_STATE Text 50 YesTicket state in ('NOT_PRINTED','PRINTED','CONTROLLED'). 
GENERATION_DATE Timestamp  Generation date is null when ticket state = 'NOT_PRINTED'.
BARCODEText 50  

Bar code of the ticket. (Not yet used).

Default now is 'IMP-' + ticket id.

 

FISCAL_NRText 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'.
PERFORMANCE_DATE   Don't need.