...
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Text 8 | Yes | Institution code owning the data to be imported. |
| CONTACT_NR | Number | Yes | Contact number |
| ORDER_NR | Number | Yes | Order number |
| SEASON_CODE | Code | Yes | Season code for the visit |
| VISIT_CODE | Code | Yes | Code of the visit product |
| START_TIME | Date | Yes | Start time of the visit |
| DURATION | Number | Yes | Duration of the visit in minutesseconds |
| GROUP_NAME | Text | Yes for group visits Leave empty for individual visits | Name of the group. If empty, use the name of the contact
|
| 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 | Contact | If not filled in, the purchase contact is used For a group visit, the contact must be of type RELAY. number of the group responsible |
| ORDER_DATE | Date | 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 ACCOMPANYINGACCOMPANIER | |
| NB_VISITORS | Number | Yes | Number of |
| TARIFF | Code | Yes | |
| PRICE | Amount | Yes | Gross amount If flat rate, full price of the visit If individual rate, unit price per participant |
| VAT | Percentage | Yes | |
| CHARGE | Amount | ||
| REMARK | Text | ||
| PAYMENT_DATE | Timestamp | Yes if OPERATION_TYPE=SALE | |
| TICKET_STATE | Code | Yes if OPERATION_TYPE=SALE | PRINTED or Possible values: NOT_PRINTED, PRINTED, CONTROLLED. |
| GENERATION_DATE | Timestamp | Yes if TICKET_STATE=PRINTEDSTATEPRINTED | |
| BARCODE | Text | Yes if TICKET_STATESTATE>=PRINTED | |
| TAX_NUMBER | Text | Yes if TICKET_STATE=PRINTED | |
| SHIPMENT_MODE | Code | Yes if TICKET_STATE=PRINTED | Possible values are SENT, SENT EMAIL, BOXOFFICE, CONTROL |
| SHIPMENT_DATE | Timestamp | Yes if SHIPMENT_MODE=STATESENT | |
| PLACE | |||
| GUIDE |