Page tree

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

Compare with Current View Page History

« Previous Version 7 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 owning the data to be imported.
ORDER_NRNumberYesOrder number.
ORDER_DATEDateYesOrder date.
OPERATION_TYPEText 70YesOperation type.
Possible values: SALE or RESERVATION
BUYING_CONTACT_NRNumberYesBuying 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.
VATPercentageYesVat rate in percent. Choose the rate that active and valid following this:
Valid from date of vat rate <= ORDER_DATE <= Valid to date of vat rate.
CHARGEAmount Charge of the non-dated pass.
REMARKText Order remark.
PAYMENT_DATEDate Payment date is null when operation type = 'RESERVATION'.
TICKET_STATEText 50 Ticket state.
Possible value: blank, NOT_PRINTED, PRINTED, CONTROLLED
GENERATION_DATETimestamp Generation date is null when ticket state is null or NOT_PRINTED.
FISCAL_NUMBERText 50 The tax number of the ticket.
SHIPMENT_MODEText 50 Shipment mode is null when ticket state is null or NOT_PRINTED.
SHIPMENT_DATEDate Shipment date. If not input: Shipment date = Order date.
BARCODEText 50 Bar code of the ticket. Mandatory if the ticket has been printed.
  • No labels