File format for Pass Visits
The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
Examples
Global fields
| Field Code | Field Type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Text 15 | Yes | Institution code owning the data to be imported. |
| ORDER_NR | Number | Yes | Order number. |
| ORDER_DATE | Date | Yes | Order date. |
| OPERATION_TYPE | Text 70 | Yes | Operation type. Possible values: SALE or RESERVATION |
| BUYING_CONTACT_NR | Number | Yes | Buying contact number. |
| CULTURAL_CONTACT_NR | Number | Cultural contact number. By default it is identical to the buying contact number. | |
| SEASON_CODE | Code | Yes | Season code of the non-dated pass. |
| PRODUCT_CODE | Code | Yes | Product code of the non-dated pass. |
| ADVANTAGE_CODE | Code | Advantage code. | |
| TARIFF | Code | Yes | Tariff Code. |
| PRICE | Amount | Yes | Price of the non-dated pass. |
| VAT | Percentage | Yes | Vat rate in percent. 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 | Charge of the non-dated pass. | |
| REMARK | Text | Order remark. | |
| PAYMENT_DATE | Date | Payment date is null when operation type = 'RESERVATION'. | |
| TICKET_STATE | Text 50 | Ticket state. Possible value: blank, NOT_PRINTED, PRINTED, CONTROLLED | |
| GENERATION_DATE | Timestamp | Generation date is null when ticket state is null or NOT_PRINTED. | |
| FISCAL_NUMBER | Text 50 | The tax number of the ticket. | |
| SHIPMENT_MODE | Text 50 | Shipment mode is null when ticket state is null or NOT_PRINTED. | |
| SHIPMENT_DATE | Date | Shipment date. If not input: Shipment date = Order date. | |
| BARCODE | Text 50 | Bar code of the ticket. Mandatory if the ticket has been printed. |