...
| 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. | OPERATION | Text 30 | Not used yet 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 | Text 50 | Yes | The membership number of contact. This must contains only numbers. | ||||
| SEASON_CODE | Text 50Code | Yes | Season code of the organization owning the data to be imported. | ||||
| MEMBERSHIP_CODE | Text 50Code | Yes | The product code of the MEMBERSHIP that need to be imported. | ||||
| TARIF_CODE | Text 50Code | Yes | The ACTIVE tarif code of the season that match 1 of 2 condition below:
| ||||
| SALE_DATE | Timestamp | Not used yet. | |||||
| MEMBERSHIPVALIDITY_BEGIN | Date | Yes | Beginning of the membership. | ||||
| MEMBERSHIPVALIDITY_END | Date | Yes | End of the membership. | ||||
| AMOUNTPRICE | Amount | Yes | The gross amount of order of the inserted membership. | ||||
| CHARGES | Text 30Amount | No | Not used yet. | ||||
| VAT | Text 30Percentage | Yes | Vat rate in percent. Choose the rate that active and valid following this: Valid from date of vat rate <= MEMBERSHIPVALIDITY_BEGIN <= Valid to date of vat rate. | ||||
| TICKET_STATE | Text 30Enum | 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. | ||||
| FISCALTAX_NR | Text 30 | Yes if PRINTED | The fiscal tax number of the ticket. If not inserted, the fiscal tax number will be generated with prefix equal to "IMP-". | ||||
| BARCODE | Text 100 | Yes if PRINTED | The bar code of ticket. Ex: Input = 345678920 --> barcode will be "CODE128C;TEXT;345678920".If not inserted, the bar code will be generated like this: "CODE128C;TEXT;IMP-xxxxxxxx". |