File format for memberships
The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
Examples
Fields
| 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
Fields
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTITUTION | Text 15 | Yes | Institution code owning the data to be imported. |
| ORGANIZATION | Text 15 | No | Organization code owning the data to be imported. By default, the organization code is the same as the institution code. |
| CONTACT_NR | Text 15 | Yes | The contact number of contact that owner the membership card. |
| MEMBER_NR | Number | Yes | The membership number of contact. This number allows another member to buy ticket on behalf of this member. |
| ORDER_NR | Number | Yes | Order number. |
| OPERATION_TYPE | Text 50 | Yes | Operation type. Possible values: SALE or RESERVATION |
| SEASON | Code | Yes | Season code. |
| 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 :
|
| SALE_DATE | Timestamp | Yes | Date of the sale. |
| VALIDITY_BEGIN | Date | Yes | Beginning of the membership. |
| VALIDITY_END | Date | Yes | End of the membership. |
| PRICE | Amount | Yes | The gross amount of order of the inserted membership. |
| CHARGES | Amount | No | Not used yet. |
| VAT | Percentage | Yes | 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. |
| TICKET_STATE | Enum | Yes | The state of ticket must be in ('PRINTED', 'NOT_PRINTED'). |
| GENERATION_DATE | Timestamp | Yes if PRINTED | If the ticket state equal to 'PRINTED' the generation date must not null. |
| 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-". |
| BARCODE | Text 100 | Yes if PRINTED | The bar code of ticket. Ex: Input = 345678920 |