...
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 | Text 30Timestamp | Not used yet. | ||
MEMBERSHIP_BEGIN | Text 30Timestamp | Yes | The start date time of the membership. | |
MEMBERSHIP_END | Text 30Timestamp | Yes | The end date time of the membership. | |
AMOUNT | Text 30 | Yes | ||
CHARGES | Text 30 | Yes | 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 |