File format for Service import
The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
Examples
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Code | Yes | Institution code owning the data to be imported. |
| ORGANIZATION | Code | No | Organization code owning the data to be imported. If leave it empty, the institution code will be used. |
| ORDER_NR | Number | No | If leave it empty, order number will be set while importing by default. One line is one ticket. So each line is a unique order number if leave it empty. Many tickets can be in an order if leave them the same order number. This number can be started from 1 in a new data file. Then it will be given new one while importing. This will be file number also. |
| ORDER_DATE | Date | No | Buying date. If leave it empty, it will be imported date by default. |
| OPERATION_TYPE | Enum | Yes | Allowed values: SALE or RESERVATION. |
| CONFIRMATION_DATE | Date | No | Expiration date to confirm reservation. |
| REMARK | Text 2000 | No | Internal remark of order. |
| BUYING_CONTACT_NR | Number | Yes | Contact number who buys the order. Mandatory because an open product needs a contact. |
| SEASON | Code | Yes | Season code of open product. |
| OPEN_PRODUCT | Code | Yes | Product code of open product. |
| ITEM | Code | Yes | Item code of open product. |
| TARIFF | Code | Yes | Tariff code. |
| PRODUCT_DESIGNATION | Text 50 | Yes | Comment for open product. |
| PRICE | Amount | Yes | Price of ticket * 100 (so that 25$ = 2500). |
| CHARGE | Amount | No | Charge of ticket * 100 (so that 1$ = 100). |
| VAT | Percentage | No | If leave it empty, it will be 0 while importing by default. 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. |
| CULTURAL_CONTACT_NR | Number | No | Contact number who is ticket holder. If leave it empty and first/last name are empty, the buying contact number will be used by default. |
| BENEFICIARY_FIRSTNAME | Text 50 | No | Beneficiary first name (only if cultural contact is not specified). |
| BENEFICIARY_LASTNAME | Text 50 | No | Beneficiary last name (only if cultural contact is not specified). |
| SHIPMENT_DATE | Date | No | If leave it empty, the order date will be used by default. Means it can be imported date if the order date is not given. |
| SHIPMENT_MODE | Code | No | If leave it empty and the ticket has been printed or controlled, it will be imported following import rules by default. |