|
|
|
EFT File Data
Depending on the setup of the bank account chosen to process commissions within the OPERA Commissions module, it is possible to determine whether the commission payment should be made using checks or electronic funds transfer (EFT) export file. The EFT export file is transferred to a central clearinghouse for consolidation and payment. This allows chain properties to promptly pay commissions as well as work with commission overrides (additional payment if certain thresholds are made within an account period).
OPERA supports several electronic funds transfer commission export routines. The export routine configured for your property (determined by the commission export license code which is active) is accessed via System Configuration>Commission Processing>EFT File Data. Only one commission export license code can be active at a time. These EFT options, and their respective setup screens, are described below.
The HCC/Pegasus export routine is available when the license code OPP HCC (Electronic Data Commission Transfer for HCC) is active. HCC /Pegasus is then responsible for any currency conversions for payment to respective agencies or sources. This utility lets you create the export file only. If you are using the HCC export type, the following rules apply:
The ASCII file contains fields of variable length. The field delimiter is the pipe symbol (|). If there is a pipe symbol within the field data, OPERA changes it into a space before writing the data into the ASCII file. Record separators are carriage return / linefeed: chr(13)+chr(10).
Brand/Destination ID. Two- character code. Note that brand codes must have prior approval from Pegasus Commission Processing. This code appears in the second field of the Property Maintenance record of the HCC EFT file.
Property ID. Property ID up to ten characters. OPERA uses the first six characters to name the HCC EFT file. If a property does not have an ID (minimum of six characters), HCC/Pegasus will provide one.
Note: The name of the ASCII file will be made up from the first six characters of the property ID plus a three-digit sequence number and .HLK as the file extension.
Property Name. Name of the property/chain.
Last Export Date. Date when the last export file was created.
Last Exported File. System- assigned number for the last export file. This number is appended to the file name.
Country of Taxing Authority. If taxes are calculated on commissions, the clearinghouse needs to know the ISO country code for the property. Select the down arrow to choose the country code.
Tax Type. If taxes are calculated on commissions, the clearinghouse needs to know the tax type for the property. Select the down arrow to choose the type of tax being reported.
Export File Destination. In the Thin Client environment, the file name of the last exported file appears here and is view-only.
Company. The EFT clearinghouse that processes these files. When the EFT file is generated, you may wish to send a fax or email transmittal letter to this company to notify them of the availability of the file. The transmittal letter is generated by the commission payment process. The company and address populates the To: section of the Transmittal Letter form.
Note: The transmittal letter summarizes the transactions that are included in the batch file, including blank values. On the report is an authorized signature line that is to be signed by a designated property employee. This report is required by most clearinghouses for processing of the EFT file. As with the EFT file itself, OPERA is not responsible for the delivery of the transmittal letter to the processing agency.
Address. The address of the EFT clearinghouse that processes these files.
Telephone. The voice phone number of the EFT clearinghouse that processes these files.
Fax. The fax phone number of the EFT clearinghouse that processes these files.
For information about the layout of the EFT ASCII file, see HCC Export File Data Definition.
The World Travel Payment (WTP) export routine is available when the add-on license code OPP WTP (Electronic Commission Data Transfer for WTP) is active. WTP (World Travel Payment) is also known as TACS (Travel Agent Commission Settlement) or GCMS (Citibank’s Global Cash Management Services). If you are using the WTP export type, the following rules apply:
Chain ID. Alphanumeric chain identification code. 6 characters minimum.
Location ID. 6 to 10 character location identification code. OPERA uses the first five characters for the naming convention of the EFT file.
Note: The name of the ASCII file consists of the first six characters of the location ID plus a two-digit sequence number plus the extension .DCR. Files with this name can be sent to the WTP center as production files. If you want to create test files and send them to the WTP center, the files need to have the extension *.TST. You can rename one of the export files during testing.
Chain Name. Name of the property/ chain.
Reporting Currency. select the down arrow to choose a country code for the reporting currency.
Transmission ID. Transmission ID provided by WPT.
Reporting Method. The use of this field is optional and will be made available for use in the export in a future release.
Last Export Date. Date when the last export file was created.
Last Exported File. System- assigned number for the last export file. This number is appended to the file name.
Use Country Code for ISO Code. Check this check box to use the country code as the ISO code.
Compressed Export File Ext . Specify dcr as the extension to be used for compressed export files.
Country of Taxing Authority. If taxes are calculated on commissions, the clearinghouse needs to know the ISO country code for the property. Select the down arrow to choose the country code.
Export File Destination. In the Thin Client environment, the file name of the last exported file appears here and is view-only.
Tax Type. If taxes are calculated on the commissions, the clearinghouse needs to know the ISO country code for the property. Select from the list of values which type of tax is being reported.
Company. The EFT clearinghouse that processes these files. When the EFT file is generated, you may wish to send a fax or email transmittal letter to this company to notify them of the availability of the file. The transmittal letter is generated by the commission payment process. The company and address populates the To: section of the Transmittal Letter form.
Note: The transmittal letter summarizes the transactions that are included in the batch file, including blank values. On the report is an authorized signature line that is to be signed by a designated property employee. This report is required by most clearinghouses for processing of the EFT file. As with the EFT file itself, OPERA is not responsible for the delivery of the transmittal letter to the processing agency.
Address. The address of the EFT clearinghouse that processes these files.
Telephone. The voice phone number of the EFT clearinghouse that processes these files.
Fax. The fax phone number of the EFT clearinghouse that processes these files.
Tax ID . (Optional) This field stores the travel agent's Tax ID should one exist and the user is advised of it. If your property uses this field, add it with Screen Painter. This field can also been added to the Travel Agent Profile screen.
For information about the layout of the EFT ASCII file, see WTP Export File Data Definition.
The EGS export routine is available when the add-on license code OPP EGS is active.
Brand/Destination ID. Two- character code.
Property ID. Property ID up to ten characters. OPERA uses the first five characters to name the EGS EFT file.
Note: The name of the ASCII file will be made up from the first five characters of the property ID plus a three-digit sequence number and .EGS as the file extension.
Property Name. Name of the property/chain.
Last Export Date. Date when the last export file was created.
Last Exported File. System- assigned number for the last export file. This number is appended to the file name.
Country of Taxing Authority. If taxes are calculated on commissions, the clearinghouse needs to know the ISO country code for the property. Select the down arrow to choose the country code.
Tax Type. If taxes are calculated on commissions, the clearinghouse needs to know the tax type for the property. Select the down arrow to choose the type of tax being reported.
Export File Destination. In the Thin Client environment, the file name of the last exported file appears here and is view-only.
Company. The EFT clearinghouse that processes these files. When the EFT file is generated, you may wish to send a fax or email transmittal letter to this company to notify them of the availability of the file. The transmittal letter is generated by the commission payment process. The company and address populates the To: section of the Transmittal Letter form.
Note: The transmittal letter summarizes the transactions that are included in the batch file, including blank values. On the report is an authorized signature line that is to be signed by a designated property employee. This report is required by most clearinghouses for processing of the EFT file. As with the EFT file itself, OPERA is not responsible for the delivery of the transmittal letter to the processing agency.
Address. The address of the EFT clearinghouse that processes these files.
Telephone. The voice phone number of the EFT clearinghouse that processes these files.
Fax. The fax phone number of the EFT clearinghouse that processes these files.
For information about the layout of the EFT ASCII file, see EGS Export File Data Definition.
The NPC export routine is available when the add-on license code OPP NPC is active.
Hotel Number. Property ID up to ten characters. OPERA uses the first five characters to name the NPC EFT file.
Note: The name of the ASCII file will be made up from XF (for eXport File) plus the first five characters of the property ID and .NPC as the file extension. No sequence number identifies the file; successive files overwrite one another.
Property Name. Name of the property/chain.
Last Export Date. Date when the last export file was created.
Last Exported File. System- assigned number for the last export file. This number is appended to the file name.
Tax Identifier. If taxes are calculated on commissions, the clearinghouse needs to know the tax type for the property. Select the down arrow to choose the type of tax being reported.
Export File Destination. In the Thin Client environment, the file name of the last exported file appears here and is view-only.
Company. The EFT clearinghouse that processes these files. When the EFT file is generated, you may wish to send a fax or email transmittal letter to this company to notify them of the availability of the file. The transmittal letter is generated by the commission payment process. The company and address populates the To: section of the Transmittal Letter form.
Note: The transmittal letter summarizes the transactions that are included in the batch file, including blank values. On the report is an authorized signature line that is to be signed by a designated property employee. This report is required by most clearinghouses for processing of the EFT file. As with the EFT file itself, OPERA is not responsible for the delivery of the transmittal letter to the processing agency.
Address. The address of the EFT clearinghouse that processes these files.
Telephone. The voice phone number of the EFT clearinghouse that processes these files.
Fax. The fax phone number of the EFT clearinghouse that processes these files.
For information about the layout of the EFT ASCII file, see NPC Export File Data Definition.
The Infinium (INF) export routine is available when the add-on license code OPP INF (Electronic Commission Data Transfer for INF) is active. The name of the ASCII file will have a format of the following ResortIDMMDDYYseq#.ifm. For information about the layout of the INF ASCII file, see INF Export File Data Definition.
See Also
