EGS (Eruca Global Services) Commission Export

On selecting EGS 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: PROPERTYID_SEQUENCE PROPERTYID_SEQUENCE_DDMMYY PROPERTYID_SEQUENCE_MMDDYY PROPERTYID_SEQUENCE_DDMMYYHH24MI PROPERTYID_SEQUENCE_MMDDYYHH24MI
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: SFTP SFTP Legacy HTTPS File System (download)

Export File Data Definition

BH – Batch Header

The EGS data export file consists of four 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 the 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.

EGS Field Name	Length	Description
Record ID	2 Char	BH.
Property ID	10 Char	Property ID.
Destination ID	3 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	EGS Batch: BOSSO102.hlk (5 digit property code + 3 digit revolving batch number. Batch ID will be taken plus the .HLK as the file extension.

PM - Property Maintenance

EGS 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.

EGS 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 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.

BT - Batch Trailer

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.

EGS Field Name	Length	Description
Record ID	2 Char	BT.
Total RC Records	8 Digits	Total number of RC 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.