Page Comparison

...

Yes

Name of the group.

ISO Language code of the visit (fr, en, ...)

(only useful for guided visits)Gross amount OPERATION_TYPE=SALECode OPERATION_TYPE=SALEPossible , if TICKET_STATEPRINTED TICKET_STATE>= TICKET_STATE=PRINTED TICKET_STATE=PRINTEDPossible values are Text50

Field code	Field type	Mandatory	Description
INSTITUTION	Text 15Code	Yes	Institution code owning the data to be imported.
ORGANIZATION	Text 15Code	Yes	Organization code owning the data to be imported. By default, the organization code is the same as the institution code. CONTACT_NR
Number	Yes	Contact number	ORDER_ID	Number	No	Order number
SEASON_CODE	Code	Yes	Season code for the visit
VISIT_CODE	Code	Yes	Code of the visit product
START_TIME	Timestamp	Yes	Start time of the visit
DURATION	Number	Yes	Duration of the visit in seconds
GROUP_NAME	Text	Yes for group visits Leave empty for individual visits
GROUP_KIND	Code	Yes for group visits Leave empty for individual visits	Group kind
THEME	Code	Theme of the visit (only useful for guided visits)	LANGUAGE	Code	. Will be set by import package while importing if left empty.
ORDER_DATE	Date	Yes	Order date. By default, order date is importing date.
OPERATION_TYPE	Enum	Yes	Operation type. Allowed values: SALE or RESERVATION.
REMARK	Text	No	Order remark.
CONTACT_NR	Number	Yes	Buying contact number.
HOLDER_CONTACT_NR	Number	No	If not filled in, the purchase contact is used. For a group visit, the contact must be of type RELAY.
ORDERFIRST_DATENAME	DateText 50	Yes	Order date
OPERATION_TYPE	Text 50	Yes	Operation type. Possible values: SALE or RESERVATION
VISITOR_TYPE	Yes	Type of visitor Possible values: PARTICIPANT or ACCOMPANIER
NB_VISITORS	Number	Yes	Number of
TARIFF	Code	Yes	CONTINGENT	Code	Contingent CodeNo	Beneficiary first name. Set this info only for sold visits.
LAST_NAME	Text 50	No	Beneficiary last name. Set this info only for sold visits.
SEASON_CODE	Code	Yes	Season code of visit pass.
VISIT_CODE	Code	Yes	Product code of visit pass.
START_TIME	Timestamp	Yes	Start time of the visit.
DURATION	Number	Yes	Duration of the visit in seconds.
CONTINGENT	Code	No	Contingent code.
TARIFF	Code	Yes	Tariff code.
PRICE	Amount	Yes	Price of visit * 100. If flat rate, full price of the visit. If individual rate, unit price per participant.
CHARGE	Amount	No	Charge of ticket * 100.
VAT	Percentage	Yes	CHARGE	Amount	REMARK	Text	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_DATE	Timestamp	Yes if	SALE	Mandatory when the operation type is SALE and price is not 0. Default value: Order date.
TICKET_STATE	Enum	Yes if	SALE	The state of ticket. Mandatory when the operation type is SALE. Allowed values: NOT_PRINTED, PRINTED	or CONTROLLED.
GENERATION_DATE	Timestamp	Yes	if PRINTED or CONTROLLED	Generation date. Mandatory if the ticket has been printed or controlled. Default value: Order date.
BARCODE	Text	Yes if	PRINTED or CONTROLLED	Bar code of the visit. Mandatory if the ticket has been printed or controlled.
TAX_NUMBER	Text	Yes if	PRINTED or CONTROLLED	The tax number of the visit. Mandatory if the ticket has been printed or controlled.
SHIPMENT_DATE	Timestamp	Yes if SHIPMENT_MODE=SENT	Shipment date of the visit. Default value: Order date.
SHIPMENT_MODE	Code	Yes if	PRINTED or CONTROLLED	Shipment mode of the season ticket. Allowed values: SENT, SENT EMAIL, BOXOFFICE, CONTROL	SHIPMENT_DATE	Timestamp	Yes if SHIPMENT_MODE=SENT	PLACE	GUIDE	. Mandatory if the ticket has been printed or controlled.
GROUP_NAME	Text	Yes if group visits	Name of the group. Leave empty for individual visits.
GROUP_KIND	Code	Yes if group visits	Group kind. Leave empty for individual visits.
THEME	Code	No	Theme of the visit (only useful for guided visits)
LANGUAGE	Code	No	ISO Language code of the visit (fr, en, ...) (only useful for guided visits)
VISITOR_TYPE	Enum	Yes	Type of visitor. Allowed values: PARTICIPANT or ACCOMPANIER.
NB_VISITORS	Number	Yes	Number of visitors. Must be > 0.
PLACE	Text50	No
GUIDE	Text50	No	Last name and First name of the guide.
GROUP_CRIT_ELEMENT	Code	No	Group Criterion Element Codecriterion element code.

Versions Compared

Old Version 10

New Version 11

Key