...
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. |
ST_NUMBER | Text 20 | Yes | Season ticket number which is defined in the sheet Season Ticket. |
SEASON | Code | Yes | Season code of the event |
ST_CODE | Code | Yes | Product code of season ticket |
EVENT_CODE | Code | Yes | The event code |
STARTTIME | Timestamp | Yes | The performance start time of the event |
SEAT_NUMBER | SeatNumber | Yes | Seat number for each performance in the season ticket. Mandatory when SSTK is calculated price. |
CONTINGENT | Code | Contingent code | |
SEATCAT_CODE | Code | Yes | Seat category code |
TARIFF | Code | Yes | Tarif code |
PRICE | Amount | Yes | Price of the seat * 100 |
VAT | Percentage | Yes | Vat rate in percent *100 (so that 1% = 100). 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 | Mandatory when the operation type is SALE and price is not 0. | |
TICKET_STATE | Code | 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 ticket. | |
TAX_NUMBER | Text 50 | The tax number of the ticket. | |
SHIPMENT_DATE | Date | Shipment date. Default value: Order date. | |
SHIPMENT_MODE | Text 50 | Shipment mode. Allowed values: TBD Mandatory when the ticket state is PRINTED or CONTROLLED |
...