File format for Service import
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 | Not yet use. | ||
| ORDER_NR | Text 50 | Yes | Order number. |
| ORDER_DATE | Date | Yes | Order date. |
| OP_TYPE | Yes | ||
| REMARK | Text | Order remark. | |
| SEASON_CODE | Yes | ||
| EVENT_CODE | Yes | ||
| START_TIME | Date | ??? | |
| SEAT_NUMBER | ??? | ||
BUYING_CONTACT_NR | Number | Contact number | |
| ORIGIN_COUNTRY | |||
| ORIGIN_REGION | |||
| ORIGIN_ZIPCODE | |||
| CULTURAL_CONTACT_NR | |||
| FIRST_NAME | |||
| LAST_NAME | |||
| SEATCAT_CODE | |||
| AUDSUBCAT_CODE | |||
| CONTINGENT_CODE | |||
| PRICE | |||
| CHARGE | |||
| VAT | |||
| PAYMENT_DATE | |||
| TICKET_STATE | |||
| GENERATION_DATE | |||
| BARCODE | |||
| FISCAL_NR | |||
| SHIPMENT_DATE | |||
| SHIPMENT_MODE | |||
| PERFORMANCE_DATE |