File format for memberships
The generic file format is described in Generic file format (Extended). This documents describes all available import fields.
| Field code | Field type | Mandatory | Description |
|---|---|---|---|
| INSTIT | 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. | |
| CONTACT_NUMBER | Text 15 | Yes | The contact number of contact that owner the membership card. |
| MEMBER_NUMBER | Text 50 | Yes | The membership number of contact. This must contains only numbers. |
| SEASON_CODE | Text 50 | Yes | Season code of the organization owning the data to be imported. |
| MEMBERSHIP_CODE | Text 50 | Yes | The product code of the MEMBERSHIP that need to be imported. |
| TARIF_CODE | Text 50 | Yes | The ACTIVE tarif code of the season that match 1 of 2 condition below:
|
| SALE_DATE | Timestamp | Not used yet. | |
| MEMBERSHIP_BEGIN | Timestamp | Yes | The start date time of the membership. |
| MEMBERSHIP_END | Timestamp | Yes | The end date time of the membership. |
| AMOUNT | Text 30 | Yes | |
| CHARGES | Text 30 | No | Not used yet. |
| VAT | Text 30 | Yes | Vat rate in percent . |
| TICKET_STATE | Text 30 | Yes | The state of ticket must be in ('PRINTED','NOT_PRINTED'). |
| GENERATION_DATE | Text 30 | ||
| FISCAL_NUMBER | Text 30 | ||
| BARCODE | Text 100 |