Previous Topic

Next Topic

E-Folio Export - Visa

Setting up Visa E-Folio Export in PMS

To set up in PMS

  1. In PMS, go to Setup>Configuration>Setup>END OF DAY Sequence>Procedures>Final Procedures.
  2. Select Show Inactive check box.
  3. Find Visa E-Folio Export listed on grid.
  4. Select Edit button.
  5. Select OK.
  6. Run end of day.
  7. In the export folder of your resort's app server, locate a file named "VISAMMDDYYEXP" (no file extension).
  8. 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.

Export File Header

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'

Export File Details

COL_NAME

COL_LENGTH

COL_FORMAT

COL_TYPE

FORMULA

stdValue

2

 

FORMULA

'9'

stdValue

4

 

FORMULA

'380'

Party

0

 

FORMULA

 

BaseItemDetails

0

 

FORMULA

 

CardInfo

0

 

FORMULA

 

stdValue

20

 

FORMULA

H_CURRENCY

PartNum

20

 

FORMULA

TRX_CODE

InvoiceHeader

0

 

FORMULA

 

NetValue

50

 

FORMULA

H_TOTAL_NET

CardNum

50

 

FORMULA

H_CC_NO

InvoiceTotals

0

 

FORMULA

 

stdValue

3

 

FORMULA

'NLL'

InvoiceType

0

 

FORMULA

 

Invoice

0

 

FORMULA

 

stdValue

2

 

FORMULA

'P'

stdValue

10

 

FORMULA

P_PARTY_TYPE

stdName

10

 

FORMULA

'UNTDID:3035'

stdName

20

 

FORMULA

'ISO:4217'

PartDesc

200

 

FORMULA

TRX_DESC

stdName

20

 

FORMULA

'VISA:INVT'

stdName

20

 

FORMULA

'VISA:TAXT'

stdName

20

 

FORMULA

'UNTDID:1225'

InvoiceStatus

0

 

FORMULA

 

stdName

20

 

FORMULA

'UNTDID:1001'

InvoiceDetails

0

 

FORMULA

 

CardAuthCode

50

 

FORMULA

H_CC_APPROVAL_CODE

GrossValue

50

 

FORMULA

H_TOTAL_GROSS

InvoiceSummary

0

 

FORMULA

 

Quantity

10

 

FORMULA

QUANTITY

TaxTreatment

0

 

FORMULA

 

CardExpirationDate

50

 

FORMULA

"nvl(H_CC_EXP_DT_STR,'12/31')"

TaxValue

50

 

FORMULA

h_total_gross-h_total_net

PartyID

20

 

FORMULA

P_AGENT_IATA_NO

InvoiceTreatment

0

 

FORMULA

 

name

50

 

FORMULA

P_NAME

UnitPrice

10

 

FORMULA

GAD

CardType

20

 

FORMULA

H_CC_TYPE

CardholderName

50

 

FORMULA

H_CC_NAME

Street1

500

 

FORMULA

P_ADDRESS_1

TaxableAmount

10

 

FORMULA

TAX_AMOUNT

InvoiceNumber

30

 

FORMULA

H_INVOICE_NO

InvoiceDate

34

 

FORMULA

"to_char(H_INVOICEDATE,'yyyy-mm-dd') || ' T00:00:00'"

Street2

200

 

FORMULA

P_ADDRESS_2

Currency

0

 

FORMULA

 

Street3

200

 

FORMULA

P_ADDRESS_3

Street4

50

 

FORMULA

P_ADDRESS_4

Parties

0

 

FORMULA

 

City

40

 

FORMULA

P_CITY

Payment

0

 

FORMULA

 

PostalCode

15

 

FORMULA

P_POSTAL_CODE

Country

20

 

FORMULA

P_COUNTRY_CODE

TelNum

200

 

FORMULA

P_TELEPHONE

EMail

200

 

FORMULA

P_EMAIL

Function

40

 

FORMULA

P_DEPARTMENT

See Also