...
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 | Yes | Order number. |
ORDER_DATE | Date | Yes | Order date. |
OPERATION_TYPE | Text 70 | Yes | Operation type. Possible values: SALE or RESERVATION |
REMARK | Text | Order remark | |
BUYING_CONTACT_NR | Number | Yes | Buying contact number. |
CULTURAL_CONTACT_NR | Number | Cultural contact number. By default it is identical to the buying contact number. | |
FIRST_NAME | Text 50 | Beneficiary first name. | |
LAST_NAME | Text 50 | Beneficiary last name. | |
ST_NUMBER | Number | Yes | Season ticket number |
SEASON | Code | Yes | Season code of the season ticket. |
ST_CODE | Code | Yes | Product code of season ticket. |
PRICE_LEVEL | Code | Price level | |
SEAT_NUMBER | SeatNumber | Seat number if the ticket holder is seated at the same place for all performances included in the season ticket | |
CONTINGENT | Code | Common contingent. | |
SEATCAT_CODE | Code | Yes | Seat category code. |
TARIFF | Code | Yes | Tarif code. |
PRICE | Amount | Yes | Price of season ticket. |
VAT | Percentage | Yes | Vat rate in percent. 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 | Payment date must be empty if price is 0 or operation type is RESERVATION. | |
TICKET_STATE | Enum | Yes | Ticket state. Allowed values: NOT_PRINTED, PRINTED or CONTROLLED |
GENERATION_DATE | Timestamp | Generation date Mandatory when the ticket state is PRINTED or CONTROLLED | |
BARCODE | Text 50 | Bar code of the season ticket. | |
TAX_NUMBER | Text 50 | The tax number of the season ticket. | |
SHIPMENT_DATE | Date | Shipment date of the season ticket. Default value: Order date. | |
SHIPMENT_MODE | Text 50 | Shipment mode of the season ticket. Allowed values: TBD Mandatory when the ticket state is PRINTED or CONTROLLED |
...