Page tree

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

Compare with Current View Page History

« Previous Version 6 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.

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