Page tree
Skip to end of metadata
Go to start of metadata

File format for vouchers

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

Examples

  File Modified
Microsoft Excel Spreadsheet Voucher Example 1.xlsx Dec 20, 2021 by rks

Fields

Field codeField typeMandatoryDescription
INSTITUTIONText 15Yes

Institution code owning the data to be imported.

ORGANIZATIONText15Yes

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_DATEDateYes

Order date.

By default, order date is importing date.

OPERATION_TYPEEnumYes

Operation type.

Allowed values: SALE or RESERVATION.

REMARKTextNoOrder remark.
BUYING_CONTACT_NRText 15YesThe contact number of contact that bought the voucher.
CULTURAL_CONTACT_NRNumberNo

Cultural contact number.

By default it is identical to the buying contact number.

FIRST_NAMEText 50NoBeneficiary first name. Set this info only for sold tickets.
LAST_NAMEText 50NoBeneficiary last name. Set this info only for sold tickets.
VOUCHER_NRNumberNo

The voucher number of contact.

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

SEASONCodeYesSeason code of voucher product.
VOUCHER_CODECodeYesProduct code of voucher.
ITEM_CODECodeYesItem code of voucher.
VALIDITY_BEGINDateYesBeginning of the validity of the voucher.
VALIDITY_ENDDateYesEnd of the voucher.
TARIFFCodeYes

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

  • Main category = 'OCCASIONAL' and secondary category = 'INDIVIDUAL'
PRICEAmountYesPrice of the voucher * 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 voucher card. Mandatory if the ticket has been printed.

TAX_NUMBERText 30Yes if PRINTED

The tax number of the voucher 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 voucher card.

Default value: Order date.

SHIPMENT_MODECodeYes if PRINTED

Shipment mode of the voucher card.

Allowed values: TBD.

Mandatory if the ticket has been printed.

  • No labels