Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

File format for Non-dated Pass

The generic file format is described in Generic file format (Extended). This documents describes all available import fields for Non-dated Pass.

Examples

Non Dated Pass Example.xlsx

Global fields

Field CodeField TypeMandatoryDescription
INSTITUTIONText 15YesInstitution code to import the data to.
ORDER_NRNumberYesOrder number.
ORDER_DATEDateYesOrder date.
OPERATION_TYPEText 70Yes

Operation type.
Possible values: SALE or RESERVATION

If importing a 'RESERVATION', the PAYMENT_DATE will be set to null.

START_DATEDate The validity start date of the non-dated pass.
END_DATEDate The validity end date of the non-dated pass.
DATE_FLAGText 50YesType of the validity date. 
Possible values: INPUTED or CALCULATED.
BUYING_CONTACT_NRNumber Buying contact number.
CULTURAL_CONTACT_NRNumber Cultural contact number. By default it is identical to the buying contact number.
SEASON_CODECodeYesSeason code of the non-dated pass.
PRODUCT_CODECodeYesProduct code of the non-dated pass.
ADVANTAGE_CODECode Advantage code.
TARIFFCodeYesTariff Code.
PRICEAmountYesPrice of the non-dated pass.
VATPercentageYes

Vat rate in percent (eg: 1960 for 19.6% VAT).

There must be an active vat rate to link to in the configuration.

Additionally, the ORDER_DATE for the non-dated pass must be inside the validity dates configured for this vat rate.

CHARGEAmount Additional costs on top of the price. Eg: booking fee, exchange fee.
REMARKText Note or remark about this order.
PAYMENT_DATEDate If the operation type is 'RESERVATION' then the PAYMENT_DATE will be set to null.
TICKET_STATEText 50 State of the Ticket.
Possible values: blank (ie: no value), NOT_PRINTED, PRINTED, CONTROLLED
GENERATION_DATETimestamp if TICKET_STATE is blank (ie: no value) or NOT_PRINTED then GENERATION_DATE is set to null.
FISCAL_NUMBERText 50 A unique tax number for the ticket.
SHIPMENT_MODEText 50 If the TICKET_STATE is blank (ie: no value) or NOT_PRINTED, then the SHIPMENT_MODE will be set to null.
SHIPMENT_DATEDate 

Shipment date.

If SHIPMENT_DATE is blank (ie: no value), then the SHIPMENT_DATE will be set with the ORDER_DATE.

BARCODEText 50 Bar code of the ticket. Mandatory if the ticket has been printed.
  • No labels