Page tree

Versions Compared

Key

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

...

Field codeField typeMandatoryDescription
INSTITUTIONText 15CodeYes

Institution code owning the data to be imported.

ORGANIZATIONText 15CodeYes

Organization code owning the data to be imported.

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

ORDER_NRNumberNo

Order number.

Will be set by import package while importing if left empty.

SALEORDER_DATETimestampYes

Date of the saleOrder date.

By default, sale order date is importing date.

OPERATION_TYPEText 50EnumYes

Operation type.

Allowed values: SALE or RESERVATION.

REMARKTextNoOrder remark.
CONTACT_NRText 15NumberYesThe contact number of contact that owner the membership card.
FIRST_NAMEText 50NoBeneficiary first name. Set this info only for sold membership cards.
LAST_NAMEText 50NoBeneficiary last name. Set this info only for sold membership cards.
MEMBER_NRNumberYesThe membership number of contact. This number allows another member to buy ticket on behalf of this member.
SEASONCodeYesSeason code of the membership product.
MEMBERSHIPCodeYesThe product code of the membership that is to be imported.
TARIFFCodeYes

The tariff code linked to the season that match one of these conditions :

  1. Main category = 'OCCASIONAL' and secondary category = 'INDIVIDUAL'
  2. Main category = 'INVITED'.
VALIDITY_BEGINDateYesBeginning of the membership.
VALIDITY_ENDDateYesEnd of the membership.
PRICEAmountYesPrice of season ticket * 100.
CHARGEAmountNo

Charge of ticket * 100.

Not used yet.

VATPercentageYes

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_DATEDateYes if SALE

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

Default value: Order date.

TICKET_STATEEnumYes if SALE

The state of ticket.

Mandatory when the operation type is SALE.

Allowed values: NOT_PRINTED or PRINTED.

GENERATION_DATETimestampYes if PRINTED

Generation date.

Mandatory when if the ticket state is PRINTEDhas been printed.

Default value: Order date.

BARCODEText 100Yes if PRINTED

The bar Bar code of the membership card. Mandatory if the ticket . Ex: Input = 345678920has been printed.

TAX_NRNUMBERText 30Yes if PRINTED

The tax number of the membership card. Mandatory if the ticket

. If not inserted, the tax number will

has been printed.

Will be generated with prefix equal to "IMP-" if left empty.

SHIPMENT_DATEDateYes

Shipment date of the membership card.

Default value: Order date.

SHIPMENT_MODECodeYes if PRINTED

Shipment mode of the membership card.

Allowed values: TBD.

Mandatory if the ticket has been printed.