E-Folio Export

E-Folio Export - Visa

Setting up Visa E-Folio Export in PMS

Note: This export can only be run during End of Day processing.

Note: Based on VISA requirements, the VISA_EXTRACT and VISA_EXTRACT_DAY export files are part of the OPERA Export Module are available for all properties having OPP_EXP Export Files add-on license active.

Although VISA E-Folio Export is available via the night audit procedure, these new exports are more enhanced and flexible by utilizing the built in OPERA Export features in addition to new BIN ranges configuration introduced.

Also as a requirement from VISA, the old VISA E-Folio Export generated via the night audit process will still remain active, but can be inactivated by properties on demand. This ensures that the files are generated until the configuration of export files is completed.

To set up in PMS

In PMS, go to Setup>Configuration>Setup>END OF DAY Sequence>Procedures>Final Procedures.
Select Show Inactive check box.
Find Visa E-Folio Export listed on grid.
Select Edit button.
Select OK.
Run end of day.
In the export folder of your resort's app server, locate a file named "VISAMMDDYYEXP" (no file extension).
Add an XML extension to the file and open it with any XML reading application. You will see the VISA payment activities log of your hotel broken into layers of information grouped by invoice.

FILE_TYPE	EXP_VISA_EFOLIO
SOURCE_VIEW_CODE	EXP_EFOLIO_DETAILS_2
FILE_TYPE_DESC	VISA Efolio Export
PRE_EXP_PROC	exp_efolio_data.create_efolio_data_2
POST_EXP_PROC	exp_create_data.delete_report_table
PARAMETER_FORM
FILE_NAME	'VISA'
FILE_EXTENSION	'XML'

VXML Upgrade from 1.0 to 2.1

Based on the new Visa Efolio Specification 2.1, the following changes were made:

1. Added the 'Number of Invoices' main header tag. <Invoices NumberOfInvoices="2">

All invoices are now included in this main tag. Original functionality created new headers for each invoice. This has been changed to have only one header.

2. Added <Invoice sectorUsageVersion="1"> tag

3. All the Date formats have been changed to YYYY-MM-DD (e.g., <InvoiceDate>2008-09-13</InvoiceDate>).

4. Added Currency Tag. <Currency stdName="ISO:4217" stdValue="USD"/>

5. Added the Merchant Code to the PI party tag. <Ref stdValue="ADQ">VISA123456</Ref>. This is a merchant ID from the Payment Type configuration screen.

6. Added the below reference fields for ADQ, RMNO, RMRT, RSNO,STRT and END

<Ref stdValue="ADQ" stdName="VISA:REF">LG</Ref> : Always 'LG'

<Ref stdValue="RMNO" stdName="VISA:REF">132</Ref> : Last Room Number

<Ref stdValue="RMRT" stdName="VISA:REF">240.91</Ref> : Average Room Rate; i.e., rate on last night of stay or the rate on the date the bill is generated in case of advance/interim bill.

<Ref stdValue="RSNO" stdName="VISA:REF">2871005</Ref> : OPERA Confirmation No.

7. Added PartNum tag for the mapped values for each trx code.

A new export mapping type called VISA_EXP_TRX_CODES is created by SID data. A mapping code called PARTNUM is added. Users can map trx codes using this mapping code. This mapped value will be used in the export.

The tags will still be sent if the mapped value is null.

Changed the menu item for Export Mappings to be a new menu item in Config->External.

The Export Mapping menu item will be available if any of the export licenses are ON(OPP_EXP,OPP_ESM,OPP_EMB), Country Exports is ON , Commission exports is ON or if the visa export is configured in the night audit procedures.

Added a new permission for Export Mapping in the External config group. This will be available when any of the licenses above are available.

8. Changed format and added the stdvalue for the date.

9. Added payment meanings.

'10' for Cash

'20' for Check

'30' for other credit cards

'ZZZ' for Visa

'OTHER' if none of the above.

10. Changed the logic from the original format to send all payments made as part of the folio, as separate payment amounts in the Invoice summary. Original file sent only Visa payments.

The CC details will only appear for VISA cards, not for other CC payments.

11. Credit card expiration date format changed to MMYY

12. Card Type set to VS only for Visa credit card payments in the Actual Payments section.

13. Changed the behavior of the export to look at any folio that has a VISA payment. Earlier functionality would look at the last payment of the export. If the last payment was not a Visa payment, the folio would not be sent in the export.

Changed the logic to look for any payment in the folio to be a VISA payment.

We still look at reservation folios only (this has not changed from the original logic and not part of the required change)

14. Changed the date formats to include time.

15. Changed the order of the parties to be 'SU', 'PI' and then 'BY'.