Page tree

Versions Compared

Key

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

...

Field codeField typeMandatoryDescription
INSTITUTIONCodeYes

Institution code owning the data to be imported.

ORGANIZATIONCodeYes

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.

ORDER_DATETimestampYes

Order date.

By default, order date is importing date.

OPERATION_TYPEEnumYes

Operation type.

Allowed values: SALE or RESERVATION.

REMARKTextNoOrder remark.
CONTACT_NRNumberYesThe 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_NRNumberYesNoThe membership number of contact. This number allows another member to buy ticket on behalf of this member.
SEASONCodeYesSeason code of 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 if the ticket has been printed.

Default value: Order date.

BARCODEText 100Yes if PRINTED

Bar code of the membership card. Mandatory if the ticket has been printed.

TAX_NUMBERText 30Yes if PRINTED

The tax number of the membership card. Mandatory if the ticket 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.

...