HCC (Pegasus) Commission Export
On selecting HHC for the EFT Export Format OPERA Control, additional OPERA Control settings are enabled to provide data to include in the EFT export.
OPERA Control | Description |
---|---|
File Name Format |
File Name Format:
|
Brand/Destination ID |
Brand Code/Destination ID, 2 character code. |
Property ID |
Property ID, maximum 10 characters, Provided by HCC if property has no code. |
Property Name |
Name of the property/chain. |
Country of Taxing Authority |
Select the country code of the property. |
Tax Type |
Select the tax type required. |
Company |
Clearinghouse company name. |
Address |
Address of the clearinghouse. |
Telephone |
Telephone number of the clearinghouse. |
Fax |
Fax number of the clearinghouse. |
Delivery Method |
Set the delivery method to be used for EFT Export:
|
Export File Data Definition
The HCC data export file consists of five record types as described below. Each field within the records is separated by the pipe symbol. Although a field is mandated by a certain number of characters, the exact length of the data can be less than the column, but not more. In all cases the termination of the field is again with existence of the pipe symbol (|). For a numeric value, it is not necessary to pad either left or right with zeros. Decimal placement is based on the property data. If no taxes are reported on the RC Report Commission, a TX Tax Record will not be created.
BH – Batch Header
HCC Field Name | Length | Description |
---|---|---|
Record ID |
2 Char |
BH. |
Property ID |
10 Char |
Property ID. |
Destination ID |
2 Char |
Brand/Destination ID. |
Batch ID |
16 Char |
Unique batch identification number (revolving 3 digit number). |
Batch Creation Date |
8 Char |
YYYYMMDD format. |
File Creation Time |
4 Char |
HHMM format (military time). |
Batch Description |
24Char |
HHC Batch: BOSSO102.hlk (6 digit property code + 3 digit revolving batch number. Batch ID is taken plus the .HLK as the file extension. |
PM - Property Maintenance
This should always be the second record in the file after the BH.
HCC Field Name | Length | Description |
---|---|---|
Record ID |
2 Char |
PM. |
Brand Code |
2 Char |
Brand/Destination ID. |
Chain Property ID |
10 Char |
Property ID. |
Action Code |
1 Char |
A. |
Property Name |
30 Char |
Name of the Property as shown in Property Data. |
Address Line 1 |
25 Char |
Properties Street Address. |
Address Line 2 |
25 Char |
Blank. |
City |
15 Char |
Properties City Address. |
State/Province Code |
3 Char |
Properties State Address. |
Country Code |
2 Char |
Properties Country Address. |
Postal Code |
15 Char |
Properties Postal/Zip Code. |
Phone Number |
20 Char |
Properties Telephone Number. |
Property ID - Sabre |
10 Char |
Blank. |
Property ID Covia |
10 Char |
Blank. |
Property ID System One |
10 Char |
Blank. |
Property ID Pars |
10 Char |
Blank. |
Property ID Datas II |
10 Char |
Blank. |
Property ID JAL |
10 Char |
Blank. |
Property ID Sita/Sahara |
10 Char |
Blank. |
Property ID Abacus |
10 Char |
Blank. |
Property ID Gemini |
10 Char |
Blank. |
Property ID Galileo |
10 Char |
Blank. |
Property ID AAA |
10 Char |
Blank. |
RC - Report Commission (Guest Record)
Reported commission records account for reservation stays, cancellations, and no-shows. Within this format, Gross is referenced as Net, and Net is referenced as Gross. For each commissionable guest, one RC record is created.
HCC Field Name | Length | Description. |
---|---|---|
Record ID |
2 Char |
RC. |
Action Code |
1 Char |
A. |
Guest Stay Number |
12 Char |
Unique identifier for guest stay (reported commission) number. (5 digits property ID + last 7 digits of reservation name ID). |
Brand Code |
2 Char |
Brand/Destination ID. |
Booking Source Code |
3 Char |
OTH. |
Property ID |
10 Char |
Property ID. |
PNR Number |
6 Char |
Blank. |
Confirmation Number |
12 Char |
Confirmation Number. |
Cancellation Number |
12 Char |
If reservation is of a canceled status CXL; otherwise Blank. |
Corporate ID Number |
12 Char |
If company profile attached uses the CORPID/Member number. If no CORPID exists, use company name ID. If no company is attached, then Blank. RESERVATION GENERAL VIEW.COMPANY ID. |
Travel Agency Number |
8 Char |
IATA number. If Blank, then use internal number. |
Guest Last Name |
30 Char |
Guest Last Name. |
Guest First name |
20 Char |
Guest First Name. |
Status Code |
2 Char |
1 = Fully commissionable, 3= Zero Commission, 4 = Cancellation, 5 = No show |
Reason Code |
6 Char |
Blank. |
Arrival Date |
8 Char |
YYYYMMDD format. |
Departure Date |
8 Char |
YYYYMMDD format. |
Number of Nights |
3 Digits |
Nights. |
Number of Rooms |
3 Digits |
1. |
Commissionable Revenue |
15 Digits |
Revenue that is commissionable. |
Net Commission Due |
15 Digits |
Net commission (Gross Commission - Tax Amount). |
Adjustment Amount |
15 Digits |
0.00. |
Net Commission Due |
15 Digits |
Gross Commission (Net Commission + Tax Amount). |
Currency Code |
3 Char |
Currency Code of Bank Account. |
Comments |
250 Char |
Blank. |
Number of Tax Records |
3 Digits |
1 or 0 based on where tax has been calculated ( CALC VAT ON COMMISSIONS OPERA Control). |
Tax Amount |
15 Digits |
The calculated tax amount. |
Agency Name |
30 Char |
Travel agent name attached to the reservation. |
Agency Address 1 |
25 Char |
Travel agent address 1 attached to the reservation. |
Agency Address 2 |
25 Char |
Travel agent address 2 attached to the reservation. |
Agency City |
15 Char |
Travel agent city attached to the reservation. |
Agency State/Province |
3 Char |
Required if country code = US or CA. |
Agency Country Code |
2 Char |
Travel agent country code. |
Agency Postal Code |
15 Char |
Travel agent postal code. |
Agency Phone Number |
20 Char |
Travel agent telephone number. |
TX - Tax Record
There is one tax record for each reported commission record. This record type must immediately follow the associated RC record. Tax Record is mandatory for each commission record. This record is only required for properties sending tax information that is based on where the parameter called CALC VAT ON COMMISSION is active. If there is not a tax amount in the RC record, a TX record is not required.
HCC Field Name | Length | Description |
---|---|---|
Record ID |
2 Char |
TX |
Brand Code |
2 Char |
Brand/Destination ID |
Guest Stay Number |
12 Char |
Reservation Confirmation Number (resv name id). Same as reported in the RC record. |
Taxing Authority Code |
3 Char |
Country of Tax Authority |
Tax Type |
8 Char |
Tax Code |
Reporting Cycle |
1 Char |
Blank |
Net Commission Amount |
15 Digits |
Net Commission (Gross Commission Tax Amount) |
Tax Amount |
15 Digits |
Tax calculated on Net Commission |
Commission Amount |
15 Digits |
Gross Commission (Net Commission + Tax AMOUNT) |
Tax Percentage Used |
6 Digits |
Right four digits considered decimal positions. 10% would appear in this field as 100000. |
Travel Agent Tax ID |
15 Digits |
If a TAX ID shown on the associated Travel Agent profile has been entered this should populate this column, otherwise the words NOT PROVIDED must appear in TAX1 NO field |
Reporting Flag |
1 Char |
Blank |
BT - Batch Record
The Batch Trailer record is mandatory for all batch transfers. This record must be the last record in the file.
Note:
The total values are not calculated, but are added up from the RC (Reported Commission) included with the file.HCC Field Name | Length | Description |
---|---|---|
Record ID |
2 Char |
BT. |
Total RC Records |
8 Digits |
Total number of RC records in this batch. |
Total TX Records |
8 Digits |
Total number of TX records in this batch. |
Total PM Records |
8 Digits |
Total number of PM records in this batch. |
Total Commissionable Revenue |
15 Digits |
Total Commissionable revenue from which the commission is calculated. |
Total Gross Commission |
15 Digits |
Total Net commission (Gross commission Tax Amount). |
Total Adjustment Amount |
15 Digits |
0.00. |
Total Tax Amount |
15 Digits |
Tax calculated on Net Commissions. |
Total Net Commission Due Amount |
15 Digits |
Total Gross Commission (Net Commission + Tax Amount). |
Currency Code |
3 Char |
Use the 3 digit currency code defined in the EFT setup. |
Parent topic: About Commission EFT Export File Formats