The generic file format is described in Generic file format (Extended). This documents describes all available import fields for Non-dated Pass.
Non Dated Pass Example.xlsx
Global fields
| Field Code | Field Type | Mandatory | Description |
|---|
| INSTITUTION | Text 15 | Yes | Institution code to import the data to. |
| ORGANIZATION | Text 15 | Yes | Organization code owning the data to be imported. By default, the organization code is the same as the institution code. |
| ORDER_NR | Number | Yes | Order number. |
| ORDER_DATE | Date | Yes | Order date. |
| OPERATION_TYPE | Text 70 | Yes | Operation type.
Possible values: SALE or RESERVATION If importing a 'RESERVATION', the PAYMENT_DATE will be set to null. |
| START_DATE | Date |
|
| The validity start date of the non-dated pass. |
| END_DATE | Date |
|
| The validity end date of the non-dated pass. |
| BUYING_CONTACT_NR | Number |
|
| 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 (eg: 1960 for 19.6% VAT). There must be an active vat rate to link to in the configuration. Additionally, the ORDER_DATE for the non-dated pass must be inside the validity dates configured for this vat rate. |
| CHARGE | Amount |
|
| Additional costs on top of the price. Eg: booking fee, exchange fee. |
| REMARK | Text |
|
| Note or remark about this order. |
| PAYMENT_DATE | Date |
|
| If the operation type is 'RESERVATION' then the PAYMENT_DATE will be set to null. |
| TICKET_STATE | Text 50 |
|
| State of the Ticket.
Possible values: blank (ie: no value), NOT_PRINTED, PRINTED, CONTROLLED |
| GENERATION_DATE | Timestamp |
|
| if TICKET_STATE is blank (ie: no value) or NOT_PRINTED then GENERATION_DATE is set to null. |
| FISCAL_NUMBER | Text 50 |
|
| A unique tax number for the ticket. |
| SHIPMENT_MODE | Text 50 |
|
| If the TICKET_STATE is blank (ie: no value) or NOT_PRINTED, then the SHIPMENT_MODE will be set to null. |
| SHIPMENT_DATE | Date |
|
| Shipment date. If SHIPMENT_DATE is blank (ie: no value), then the SHIPMENT_DATE will be set with the ORDER_DATE. |
| BARCODE | Text 50 |
|
| Bar code of the ticket. Mandatory if the ticket has been printed. |