...
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Text 15 | Yes | Institution code owning the data to be imported. |
| 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 | No | Order number. Will be set by import package while importing if left empty. |
| SALE_DATE | Timestamp | Yes | Date of the sale. By default, sale date is importing date. |
| OPERATION_TYPE | Text 50 | Yes | Operation type. Allowed values: SALE or RESERVATION |
| REMARK | Text | No | Order remark. |
| CONTACT_NR | Text 15 | Yes | The contact number of contact that owner the membership card. |
| FIRST_NAME | Text 50 | No | Beneficiary first name. Set this info only for sold membership cards. |
| LAST_NAME | Text 50 | No | Beneficiary last name. Set this info only for sold membership cards. |
| MEMBER_NR | Number | Yes | The membership number of contact. This number allows another member to buy ticket on behalf of this member. |
| SEASON | Code | Yes | Season code of the membership product. |
| MEMBERSHIP | Code | Yes | The product code of the membership that is to be imported. |
| TARIFF | Code | Yes | The tariff code linked to the season that match one of these conditions :
|
| VALIDITY_BEGIN | Date | Yes | Beginning of the membership. |
| VALIDITY_END | Date | Yes | End of the membership. |
| PRICE | Amount | Yes | Price of season ticket * 100. |
| CHARGE | Amount | No | Charge of ticket * 100 Not used yet. |
| 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. |
| PAYMENT_DATE | Date | Yes if SALE | Mandatory when the operation type is SALE and price is not 0. |
| TICKET_STATE | Enum | Yes if SALE | The state of ticket. Mandatory when the operation type is SALE. Allowed values: NOT_PRINTED or PRINTED. |
| GENERATION_DATE | Timestamp | Yes if PRINTED | Generation date. Mandatory when the ticket state is PRINTED. |
| BARCODE | Text 100 | Yes if PRINTED | The bar code of ticket. Ex: Input = 345678920 |
| TAX_NR | Text 30 | Yes if PRINTED | The tax number of the ticket. If not inserted, the tax number will be generated with prefix equal to "IMP-". |
File format for memberships
The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
Examples
| Attachments | ||
|---|---|---|
|
Fields
...
Institution code owning the data to be imported.
...
Organization code owning the data to be imported.
By default, the organization code is the same as the institution code.
...
Operation type.
Possible values: SALE or RESERVATION
...
The tariff code linked to the season that match one of these conditions :
- Main category = 'OCCASIONAL' and secondary category = 'INDIVIDUAL'
- Main category = 'INVITED'.
...
Vat rate in percent. Choose the rate that active and valid following this:
Valid from date of vat rate <= VALIDITY_BEGIN <= Valid to date of vat rate.
...
The bar code of ticket. Ex: Input = 345678920