...
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 | YesNo | 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 | |||
. 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. | ||||||
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 | ISO Language code of the visit (fr, en, ...) (only useful for guided visits) | ||||
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 | ||||||
No | 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. | TARIFF | Code | Yes | CONTINGENT | Code | Contingent Code|
PRICE | Amount | Yes | Gross amountPrice 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 | 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. | ||||||
CHARGE | Amount | REMARK | Text | PAYMENT_DATE | Timestamp | Yes if | OPERATION_TYPE=SALESALE | Mandatory when the operation type is SALE and price is not 0. Default value: Order date. | |
TICKET_STATE | CodeEnum | Yes if | OPERATION_TYPE=SALESALE | The state of ticket. Mandatory when the operation type is SALE. Allowed | Possible values: NOT_PRINTED, PRINTED | , or CONTROLLED. | |||
GENERATION_DATE | Timestamp | Yes | if TICKET_STATEPRINTEDif PRINTED or CONTROLLED | Generation date. Mandatory if the ticket has been printed or controlled. Default value: Order date. | |||||
BARCODE | Text | Yes if | TICKET_STATE>=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. | TICKET_STATE=PRINTED||||||
SHIPMENT_MODE | Code | Yes if | TICKET_STATE=PRINTEDPRINTED or CONTROLLED | Shipment mode of the season ticket. Allowed values: | Possible values are SENT, SENT EMAIL, BOXOFFICE, CONTROL | SHIPMENT_DATE | Timestamp | Yes if SHIPMENT_MODE=SENT | . 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 | PLACE | GUIDE | Text50 | Last name and First name of the guide. | |||
GROUP_CRIT_ELEMENT | Code | No | Group Criterion Element Codecriterion element code. |