Page tree

Versions Compared

Key

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

...

First name of cultural contact
Field codeField typeMandatoryDescription
INSTITUTIONText 15Yes

Institution code owning the data to be imported.

ORGANIZATIONText 15Yes

Organization code owning the data to be imported.

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

ORDER_NRNumberYesOrder number.
ORDER_DATEDateYesOrder date.
OPOPERATION_TYPEText 50EnumYes

Operation type.

Allowed values: SALE or RESERVATION

, SALE

.

REMARKTextNoOrder remark.SEASON_CODEText15YesSERVICE_CODEText15YesCode of service product.

BUYING_CONTACT_NR

NumberNoBuying contact number. If it is empty, the sale is anonymous.
ORIGIN_COUNTRYText 50NoCountry of buying contact (only if Buying contact is not specified).
ORIGIN_REGIONText 50NoRegion of buying contact (only if Buying contact is not specified).
ORIGIN_ZIPCODEText 50NoZip code of buying contact (only if Buying contact is not specified).
CULTURAL_CONTACT_NRNumberNo

Cultural contact number.

If left empty and first/last name are empty, the buying contact number is used.

FIRST_NAMEText 50NoBeneficiary first name (only if Cultural contact number is not specified).
LAST_NAMEText 50Last name of cultural contact.NoBeneficiary last name (only if Cultural contact number is not specified).
SEASONCodeYesSeason code of service product.
SERVICE_CODECodeYesProduct code of service.
ITEM_CODECodeYesItem code of service.
TARIFFCodeYesTarif codeTARIF_CODEText 15Tarif code of order.
PRICEAmountYesPrice of the service * 100.
CHARGEAmountYesCharge of service * 100.
VATNumberPercentageYes

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

VAT in percent

.

PAYMENT_DATEDate

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

or operation type = 'RESERVATION'
Yes if SALE

Mandatory when the operation type is SALE and price is not 0.

Default value: Order date.

TICKET_STATEText 50EnumYes if SALE

The state of ticket.

Mandatory when the operation type is SALE.

Allowed values:

Ticket state in ('

NOT_PRINTED

'

,

'

PRINTED

','

or CONTROLLED

')

.

GENERATION_DATETimestampYes if PRINTED or CONTROLLED

Generation date

is null when ticket state = 'NOT_PRINTED'

.

Mandatory if the ticket has been printed or controlled.

Default value: Order date.

BARCODEText 50Yes if PRINTED or CONTROLLED

Bar code of the ticket. (Mandatory if the ticket has been printed or controlled.

Not yet used). Default now is 'IMP-' + ticket id.

FISCALTAX_NRNUMBERText 50Yes if PRINTED or CONTROLLED

The tax The fiscal number of the ticket. Mandatory if the ticket .(has been printed or controlled.

Not yet used). Default now is 'IMP-' + ticket id.

SHIPMENT_DATEDateYes

Shipment date

. If not input: Shipment date =

of the service.

Default value: Order date.

SHIPMENT_MODEText 50Shipment date is null when ticket state = 'NOT_PRINTED'.CodeYes if PRINTED or CONTROLLED

Shipment mode of the service.

Allowed values: TBD.

Mandatory if the ticket has been printed or controlled.

ITEM_CODEText15YesItem code of Service