Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

File format for Service import

The generic file format is described in Generic file format (Extended). This documents describes all available import fields.

Examples

Attachments
 

Field codeField typeMandatoryDescription
INSTIT
INSTITUTION
Text 15
CodeYesInstitution code owning the data to be imported.
ORGANIZATION
Text 15
Code
Yes
NoOrganization code owning the data to be imported.

By default, the organization code is the same as the institution code.

If leave it empty, the institution code will be used.
ORDER_NRNumberNoIf leave it empty, order number will be set while importing by default.
One line is one ticket. So each line is a unique order number if leave it empty.
Many tickets can be in an order if leave them the same order number. This number can be started from 1 in a new data file. Then it will be given new one while importing.
This will be file number also
OPERATION  Not yet use.ORDER_NRNumberYesOrder number
.
ORDER_DATEDateNo
YesOrder date.OP
Buying date.
If leave it empty, it will be imported date by default.
OPERATION_TYPE
Text 50
EnumYes
Operation type
Allowed values: SALE or RESERVATION
, SALE
.
REMARKText Order remark.SEASON_CODE Yes SERVICE_CODE YesCode of service product.START_TIMEDate Don't need.SEAT_NUMBER  
CONFIRMATION_DATEDateNoExpiration date to confirm reservation.
REMARKText 2000NoInternal remark of order
Don't need
.
BUYING_CONTACT_NRNumber
 
No
Buying contact number.
Contact number who buys the order.
If leave it empty, the sale will be anonymous by default.
ORIGIN_COUNTRYText 50
 
NoCountry of buying contact (only if buying contact is not specified).
ORIGIN_REGIONText 50
 
NoRegion of buying contact (only if buying contact is not specified).
ORIGIN_ZIPCODEText 50
 
NoZip code of buying contact (only if buying contact is not specified).
CULTURAL_CONTACT_NRNumber Cultural contact number.FIRST_NAMEText 50 First name of cultural contact.LAST_NAMEText 50 Last name of cultural contact.SEATCAT_CODEText 15 Not use yet.TARIF_CODEText 15 Tarif code of order.
SEASONCodeYesSeason code of service.
SERVICECodeYesProduct code of service.
ITEMCodeYesItem code of service.
VALIDITY_BEGINTimestampYesThe date starts to validate.
VALIDITY_ENDTimestampYesThe date stops to validate.
TARIFFCodeYesTariff code
CONTINGENT_CODEText 15 Not use yet
.
PRICEAmount
 
YesPrice of
service
ticket * 100 (so that 25$ = 2500).
CHARGEAmount
 
NoCharge of
service
ticket * 100 (so that 1$ = 100).
VAT
Number VAT in percent.
PercentageNoIf leave it empty, it will be 0 while importing by default.
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_DATEDate
 

Payment date is null when operation type = 'SALE' and price = 0

NoIf leave it empty, the operation type is SALE and the price is not 0, the order date will be used by default. Means it can be imported date if the order date is not given.
SERVICE_NRNumberNoEach service has a unique number to know how many services have been published.
In importation, it helps to define ticket to check between data excel file and database system after importing.
This number can be started from 1 in a new data file. Then it will be given new one while importing.
CULTURAL_CONTACT_NRNumberNoContact number who is ticket holder.
If leave it empty and first/last name are empty, the buying contact number will be used by default.
BENEFICIARY_FIRSTNAMEText 50NoBeneficiary first name (only if cultural contact is not specified).
BENEFICIARY_LASTNAMEText 50NoBeneficiary last name (only if cultural contact is not specified)
or operation type = 'RESERVATION'
.
TICKET_STATE
Text 50
EnumYes
Ticket state in ('
if SALEMandatory when the operation type is SALE.
Allowed values: NOT_PRINTED
'
,
'
PRINTED
'
,
'
CONTROLLED
')
.
GENERATION_DATE
Timestamp
Date
 
NoIf leave it empty and the ticket has been printed or controlled, the order date will be used by default. Means it can be imported date if the order date is not given
Generation date is null when ticket state = 'NOT_PRINTED'
.
BARCODEText 50
 

Bar code of the ticket. (Not yet used).

NoIf leave it empty and the ticket has been printed or controlled, it will be generated following import rules by default
Default now is
'IMP-' + ticket id.
FISCAL
TAX_
NR
NUMBERText 50
 

The fiscal number of the ticket.(Not yet used).

NoIf leave it empty and the ticket has been printed or controlled, it will be generated following import rules by default
Default now is
'IMP-' + ticket id.
SHIPMENT_DATEDate
 
NoIf leave it empty, the order date will be used by default. Means it can be imported date if the order date is not given
Shipment date. If not input: Shipment date = Order date
.
SHIPMENT_MODE
Text 50
Code
 Shipment date is null when ticket state = 'NOT_PRINTED'.
NoIf leave it empty and the ticket has been printed or controlled, it will be imported following import rules by default
PERFORMANCE_DATE  Don't need
.