About Commission EFT Export File Formats

Depending on the setup of the commission bank account, you can make commission payments using printed checks or from an electronic funds transfer (EFT) export file sent to a central clearinghouse for remittance to travel agents.

The EFT Export Format OPERA Control determines the file format for all commission bank accounts setup with EFT selected as the Payment method.

The EFT export formats available are:

• EGS (Eruca Global Services)

• HCC (Pegasus)

• INF (Infinium)

• NPC (National Processing Company)

• WTP (World Travel Payment) , also known as TACS and GCMS

On selecting a value for the EFT Export Format OPERA Control, additional OPERA Control settings are enabled to provide property and tax data that is included in the EFT export.

Each time you process commissions payments, an export file is generated and delivered according to the delivery method selected in the Delivery Method OPERA Control setting. (File System, SFTP, HTTPS).

• EGS (Eruca Global Services) Commission Export
  
• HCC (Pegasus) Commission Export
  
• INF (Infinium) Commission Export
  
• NPC (National Processing Company) Commission Export
  
• WTP (World Travel Payment) Commission Export
  

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.

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: 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

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.

INF (Infinium) Commission Export

On selecting INF 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	Select the file name format to be used for EFT Export file: RESORTNAME_MMDDYY_SEQUENCE RESORTNAME_DDMMYY_SEQUENCE RESORTNAME_MMDDYYYY_SEQUENCE RESORTNAME_MMDDYYYYHH24MI RESORTNAME_DDMMYYYYHH24MI
Delivery Method	Set the delivery method to be used for EFT Export: SFTP SFTP Legacy HTTPS File System (download)

Export File Data Definition

The INF data export file consists of one record type.

Note:

Amounts do not include a decimal (for example, if the  commission amount is $21.75, the Actual Commission Due amount is shown as 000002175) in the Infinium export.

Position	Length	Description
1	12	IATA # or if commission code not = "Z" = AREA CODE/TELEPHONE #.
13	30	Travel Agent Name.
43	6	Departure Date.
49	12	OPERA Profile ID.
61	30	Guest Name.
91	6	Guest Folio.
97	3	Active/Inactive.
100	1	List Number.
101	1	Folio Reservation Status.
102	1	"H" or "R."
103	30	Travel Agent Address1.
133	30	Travel Agent Address2.
163	20	Travel Agent City.
183	10	Travel Agent Zip.
193	3	Travel Agent Country.
196	10	Travel Agent Phone #.
206	30	Travel Agent Contact Name.
236	2	Travel Agent State.
238	5	Audit Date.
243	5	Audit Date.
248	5	Number of Rooms.
253	5	Number of Guests.
258	6	Nothing gets moved into the field.
264	1	Nothing gets moved into the field.
265	2	Commission Percentage.
267	2	Commission Percentage.
269	2	Commission Percentage.
271	2	Commission Percentage.
273	2	Commission Percentage
275	2	Commission Percentage
277	2	Commission Percentage
280	9	Room Rate.
290	9	Actual Rate.
300	9	Net Amount Due.
309	6	Primary Folio.
315	2	Number of Rooms.
317	1	Blank or "-" for negative.
318	2	Number of Guests.
320	6	Booking Date.
326	5	Audit Date.
331	6	Arrival Date.
337	2	Number of Nights.
339	10	Same as tap phone Agent Phone #.
349	5	Actual Number of Nights.
354	5	Expected number of Nights.
359	1	Blank or "-" for negative.
360	1	Actual Room Revenue.
369	9	Blank or "-" for negative.
370	9	Non Room Revenue.
379	5	Number of Guests in Room.
384	9	Actual Commission Due.
393	9	Deducted Amount.
402	1	Asterisk.
403	15	SSN or TIN.
418	13	OPERA Confirmation Number.
431	55	Filler.

NPC (National Processing Company) Commission Export

On selecting NPC 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: XF_PROPERY XF_PROPERTY_DDMMYY XF_PROPERTY_MMDDYY XF_PROPERTY_DDMMYYHH24MI XF_PROPERTY_MMDDYYHH24MI
Property ID	Property ID, maximum 10 characters.
Property Name	Name of the property/chain.
Tax Identifier	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)
SFTP Name	Name of the SFTP endpoint. Obtain this from your system administrator.

Export File Data Definition

The NPC data export file consists of 4 record types as described below.

Note:

All amounts are shown in the bank currency.

Vendor Record

Required - 1 per funding currency batch, multiple batches per commission file.

Field Name	Type	Start	Length	Decimals	Req'd/Opt.	Comments
Record Type	CHAR	1	1		R	A= Vendor record for this currency batch.
Batch currency code	CHAR	2	3		r	Funding currency code for this batch. Example: NOK -= Norwegian Krone, USD = US dollars.
File date	NUMERIC	5	8		R	Date file created (mmddyyyy).
Vendor #	CHAR	13	6		R	NPC assigned number.
Vendor type	CHAR	19	1		R	2=Hotel.
Vendor name	CHAR	20	30		R
Vendor address1	CHAR	50	30		R
Vendor address2	CHAR	80	30		O
Vendor city	CHAR	110	30		R
Vendor state/province	CHAR	140	28		O
Vendor ZIP/postal code	CHAR	168	10		O
Vendor contact phone #	CHAR	178	30		R	Vendor phone # for NPC Commision Express.
Vendor cust. Svc. phne #	CHAR	208	30		O	Vendor customer service phone # as it should appear on vendor's report.
Vendor email address	CHAR	238	50		O	If billing is set at vendor level, email address to which NPC can send a funds require confirmation and related billing information. Otherwise, spaces.
Vendor fax #	CHAR	288	30		O	If billing is set at the vendor level, fax # to that NPC can send a funds required confirmation and related billing information. Otherwise, spaces.
Vendor # records	NUMERIC	318	7		R	Total number of detail records in this currency batch. Total should include any optional tax detail records.
Vendor total amount	SIGNED NUMERIC	325	20	2	R	Total vendor commission payments for this currency batch including any optional tax detail records. No commas, decimals, or currency symbols. Required sign in the first character position. Example: 5000.00 = +0000000000000500000.
Vendor country code	CHAR	345	2		O	Example: US = USA, DE = Germany. This is an ISO code.
Vendor customer. service phone # 2	CHAR	347	30		O	Vendor customer service phone # as it should appear on the Agent's report.
Batch currency entry cd*	CHAR	377	2		O	Default for Euro currency will be DE (German). Example: International: 123-1-123- 1234. If currency = Euro, then the country currency has to be sent also.
Unassigned	space filled	377	124
Total record length			500

All optional and unassigned columns should be space filled if not data populated. All character columns should be left-justified. All numeric columns should be right-justified.

*Accepted Euro Funding countries are AT (Austria), BE (Belgium), DE (Germany), ES (Spain), FI (Finland), FR (France), IT (Italy), and NL (Netherlands).

Agency Record

Required – many per currency batch.

Field Name	Type	Start	Length	Decimals	Req'd/Opt.	Comments
Record type	CHAR	1	1		R	C = Agency record.
Batch currency code	CHAR	2	3		R	Funding currency code of this batch of your commissions. Must be consistent for all agency records within  batch.
Agency #	CHAR	5	8		R	IATA, ARC, CLIA, or BSP Agency #. If no IATA exists send RNnnnnn where n = internal ID (name ID) of agency.
Agency name*	CHAR	13	35		R
Agency address1*	CHAR	48	35		R
Agency address2*	CHAR	83	35		O
Agency city*	CHAR	118	30		R
Agency state/province*	CHAR	148	28		O/R	Required if USA. Use 2- character state code. Example: US = 47172-0203; Canada = T1Y 1N5.
Agency country name*	CHAR	186	26		R	Example: US, France, Canada, and so on.
Agent contact name*	CHAR	212	30		O
Agent phone #*	CHAR	242	30		O
Agent currency*	CHAR	272	3		O	Default = USD.
Agency country code	CHAR	275	2		O	Mailing address country code. Example: US = USA, DE = Germany.
Sub- vendor #	CHAR	277	6		O	Consistent with sub-vendor # from the optional batch sub-vendor record (B record).
Currency country cd*	CHAR	283	2		R/O	Required for Euro currency. Optional otherwise.
Unassigned	space filled	285	216
Total record length			500

Detail Record

Required – many per currency batch.

Field Name	Type	Start	Length	Decimals	Req'd/Opt.	Comments
Record type	CHAR	1	1		R	D = Detail record.
Batch currency code	CHAR	2	3		R	Funding currency code for this batch of commissions. Must be consistent for all detail records within this batch.
Agency #	CHAR	5	8		R	IATA, ARC, CLIA, or BSP agency. If no IATA exists, send RNnnnnn where n = internal ID (name ID) of agency.
Guest name	CHAR	13	25		O
Confirm #	CHAR	38	15		O
Arrival date	CHAR	53	6		O	In mmddyy format.
Departure date	CHAR	59	6		O	In mmddyy format.
Hotel charge	SIGNED NUMERIC	65	20	2	O	No commas, decimals, or currency symbols. Required sign in first character position.  Example: 5000.00 = +0000000000000500000.
Reference	CHAR	85	12		O	Example: NO SHOW, COMM PAID.
Commission %	NUMERIC	97	4	4	O	Example: 10% = 1000.
Unassigned	space filled	101	20
Commission amount	SIGNED NUMERIC	121	20	2	R	No commas, decimals, or currency symbols. Required sign in first character position.  Example: 5000.00 = +0000000000000500000.
Asterisk	CHAR	141	1		O	Asterisk used in combination with a message record.
Hotel #	NUMERIC	142	10		R
Hotel name	CHAR	152	75		R
Nights stayed	CHAR	227	3		O
Unassigned	space filled	230	4
Sub- vendor #	CHAR	234	6		O	If you are reporting or billing at a sub-vendor level, provide the appropriate sub-vendor # for this detail record.
Unassigned	space filled	240	161
Vendor variable data	CHAR	401	100		O	Reserved for vendor use as defined by contract.
Total record length			500

TX Detail Record

Optional - many per currency batch.

Field Name	Type	Start	Length	Decimals	Req'd/Opt.	Comments
Record type	CHAR	1	1		R	D = Tax detail record.
Batch currency code	CHAR	2	3		R	Funding currency code for this batch of commissions. Must be consistent for all detail records within this batch.
Agency #	CHAR	5	8		R	IATA, ARC, CLIA, or BSP agency .  If no IATA exists send RNnnnnn where n = internal ID (name ID) of agency.
Guest name	CHAR	13	25		O	This field should be populated with the guest name to report the tax at the guest/transaction level. To report at the agency level, initialize with spaces. If this field is populated, Hotel # and Hotel name must also be provided.
Unassigned	space filled	38	15
Sort control #1	CHAR	53	6		R	To report the tax at the guest/transaction level, this field should be populated with the rental start date and sort control #2 should be all 9s. To report at the agency level, initialize with all 9s.
Sort control #2	CHAR	59	6		O	See sort control #1. To report the tax at the guest/transaction level, this field should be populated with all 9s.
Unassigned	space filled	65	20
Tax identifier	CHAR	85	12		O	Example: VAT, G&S TAX, PROV TAX.
Unassigned	space filled	97	24
Tax amount	SIGNED NUMERIC	121	20	2	R	No commas, decimals, or symbols.  Example: 5000.00 = +0000000000000500000. Any tax amount here is added into the agency's total payment and therefore should not be included in the commission amount of the detail record.
Unassigned	space filled	141	1
Hotel #	CHAR	142	10		O	If guest name is populated (you want to report the tax at the guest/transaction level), Hotel # and Hotel name must also be provided.
Hotel name	CHAR	152	75		O	If guest name is populated (you want to report the tax at the guest/transaction level), Hotel # and Hotel name must also be provided.
Unassigned	space filled	227	7
Sub- vendor #	CHAR	234	6		O	If you are reporting or billing at a sub-vendor level, provide the appropriate sub-vendor # for this detail record.
Unassigned	space filled	240	261
Total record length			500

All optional and unassigned columns should be space filled if not data populated. All character columns should be left-justified. All numeric columns should be right-justified.

WTP (World Travel Payment) Commission Export

On selecting NPC 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
Use Country Code for ISO Code [USE_COUNTRY_CODE_FOR_ISO_CODE]	Activate to use <what> country code as the ISO code.
File Name Format	Select the file name format to be used for EFT Export file: PROPERTYID_SEQUENCE PROPERTYID_SEQUENCE_DDMMYY PROPERTYID_SEQUENCE_MMDDYY PROPERTYID_SEQUENCE_DDMMYYHH24MI PROPERTYID_SEQUENCE_MMDDYYHH24MI
Chain ID	Alphanumeric chain identification code, 6 characters minimum.
Location ID	Location identification code, 6-10 characters.
Chain Name	Name of the property/chain.
Reporting Currency	Select country code for reporting currency.
Transmission ID	Transmission ID provided by WTP.
Country of Taxing Authority	Select the country code of the property.
Tax Types	Select the Tax Type required.
Company	Clearinghouse company name.
Address	Address of the clearinghouse.
Phone	Telephone number of the clearinghouse
Fax	Fax number of the clearinghouse.
Delivery Method	Set the delivery method to be used for the EFT Export: SFTP SFTP Legacy HTTPS File System (download)

Export File Data Definition

The WTP data export file consists of 11 record types as described below.

00 – File Header

The File Header record contains information about the commission transaction file. There is one File Header per commission transaction file.

WTP Field Name	Length	Description
Record Type	2 Char	00.
Filler	7 Char	Blank.
Group ID	7 Char	Group ID (Chain ID) assigned by WTP. It consists of an H followed by six digits (Hnnnnnn).
Filler	3 Char	Blank.
Date	6 Char	Date this file was created (YYMMDD).
Filler	15 Char	Blank.
Group Name	32 Char	Name of your Group or Chain.
Transmission ID	8 Char

10 – Batch Header

A batch contains information about commission transactions for a specific location and a specific reporting currency. The Batch Header record is the first record of a batch and identifies the location and reporting currency. Following within the batch are Detail and Agency Records for each commission transaction for this location and reporting currency. The Batch Trailer record is the last record of a batch.

Each time the location or reporting currency changes, you must start a new batch. There is no limit to the number of batches within a file.

WTP Field Name	Length	Description
Record Type	2 Char	10.
Filler	7 Char	Blank.
Location ID	7 Char	Location ID assigned by WTP for your location. This is different from the Group ID. The Location ID consists of an H followed by six digits (Hnnnnnn).
Filler	13 Char	Blank.
Reporting Currency	3 Char	Currency Code.
Remitting Currency	3 Char	Currency Code.
Filler	4 Char	Blank.
Location Name	32 Char	Name of the location.
Filler	9 Char	Blank.

11 - Detail Record One

Detail Record One contains booking information.

WTP Field Name	Length	Description
Record Type	2 Char	11
Transaction Code	2 Char	Transaction codes in the WTP export file are used to identify the transaction type. These codes are used in the transaction code field in Record Type 11. The following codes are used in the OPERA generated WTP EFT export file: For Cancelled Reservations, code used is NA (Cancelled). For No Show Reservations, code used is NS (No Show - Non- Commissionable). For Commission record where commission payment has been manually edited to a zero amount, code used is NC (Non-Commissionable). For Commission records where a pre-payment equal to the commission amount payable has been made, code used is NP (Previously paid or pre-paid in full). For Commission records where a partial pre-payment is made, the code used is CB (Commission paid on original booking with or without change, that is, the changed amount is not equal to 0.00). Note: This code is also be used when the commission on the original booking was not changed. Also, use this code when other transaction codes do not better define the transaction.
Arrival Date	6 Char	Date traveler or group departed from location or, for no-shows and cancellations, date booked to depart (YYMMDD).
Departure Date	6 Char	The Departure Date must be later than or equal to the Arrival Date. Future dates are rejected.
Booking Date	6 Char	Booking or reservation date is YYMMDD format. This must be earlier than or equal to the arrival date. If this date is unknown, Blank.
Commission Amount	15 Digit	Commission amount to be paid to the travel agency, after applying all Record 35 taxes, if applicable. This field assumes two decimal positions. For commission overpaids (Transaction Code=CO), the commission Amount field must be an absolute number. Do not use a minus (-) sign. This field will be zero filled for the following transaction codes: NA Cancellations NS No Shows NC Non-commissionable NP Previously paid (Paid in Full)
Confirmation Number	12 Char	Confirmation number for this reservation. If the confirmation number is unknown, enter Unknown in this field.
PNR Number	10 Char	Blank
Number of Rooms	3 Char	Number of rooms used, minimum of one.
Number of Nights	3 Char	Number of nights stayed, minimum of one. Do not total the number of nights with the number of rooms.
Booking Source	3 Char	OTH
Corporate ID	12 Char	Number used in granting corporate discounts. Blank.

12 - Detail Record Two

Detail Record Two contains traveler and agent information.

WTP Field Name	Length	Description
Record Type	2 Char	12.
Travel Agency Type	2 Char	IA=IATA, ARC, or TIDS member. Use IA only if you provide a valid IATA, ARC, or TIDS number in the Travel Agency field below. Otherwise use CA. CA=Client Assigned (number created by group or location). PROFILE 1W.IATA CORP NO is null then CA otherwise IA.
Travel Agency ID	20 Char	If Travel Agency Type=IA the agency's 7 or 8-digit IATA, ARC or TIDS number. Invalid IATA, ARC, or TIDS numbers will reject the transaction. If you do not have a valid IATA, ARC or TIDS number, provide a client-assigned (CA) number. The CA number must take the form CAHnnnnnnXXXXXXXXXXX. Where CA is a constant, Hnnnnnn is the location ID and XXXXXXXXXXX is a 1-11 character CA identification. Use from 1 to 11 characters for the CA identification, starting from left to right, and leave any unused positions blank.
Traveler's Last Name	30 Char	Name of the traveler.
Traveler's First Name	20 Char	First name of the traveler. If unknown, Blank.
Reason Codes	6 Char	Blank.

13 - Detail Record Three

Detail Record Three contains the commissionable revenue, the cancellation number (if applicable), and optionally the WTP inquiry response.

WTP Field Name	Length	Description
Record Type	2 Char	13.
Cancellation Number	12 Char	Blank.
Commissionable Revenue	15 Digit	Total revenue used to calculate the transaction's commission amount. The amount must be greater than or equal to zero.
Inquiry Request Number	12 Char	Blank.
Filler	1 Char	Blank.
Resolution Code	2 Char	Blank.
Resolution Date	6 Char	Blank.
Travel Agency Contact	30 Char	Blank.

15 - Agency Record One

Agency Record One identifies the travel agency and contains the first address line. Use Agency Records Two and Three to complete the mailing address. The mailing address must be both complete and deliverable. An incomplete mailing address causes the transaction to be rejected.

WTP Field Name	Length	Description
Record Type	2 Char	15.
Travel Agency's Name	30 Char	Full travel agency's name to which the commission is to be paid.
Travel Agency's first address line.	30 Char	Travel agency's street address or postal box.
Filler	18 Char	Blank.

16 - Agency Record Two

Use Agency Record Two to continue the travel agency's address begun in Agency Record One.

WTP Field Name	Length	Description
Record Type	2 Char	16.
Travel Agency's second address line	30 Char	Travel agency's second address line, street address, or postal box, if applicable; otherwise Blank.
Travel Agency's City	25 Char	Travel agency's city.
Filler	23 Char	Blank.

17 - Agency Record Three

se Agency Record Three to complete the travel agency's mailing address, begun in Agency Records One and Two.

WTP Field Name	Length	Description
Record Type	2 Char	17.
Travel Agency's State or Province	25 Char	*Required for countries that have states or provinces, such as U.S. and Canada; otherwise Blank.
Travel Agency's Country	20 Char	Travel Agency's country.
Travel Agency's Postal Code	11 Char	*Required for countries using a postal code, such as U.S., U.K., and Canada, otherwise Blank.
Filler	22 Char	Blank.

35 - Tax Record (Optional)

The Tax record contains detail information about taxes reported, withheld, or paid for a given commission record. If multiple taxing authorities affect the transaction, you must provide a tax record for each applicable tax. For example, Canadian GST and Quebec PST.

WTP Field Name	Length	Description
Record Type	2 Char	35.
Country Code of Taxing Authority	2 Char	Country code of taxing authority. Choose the appropriate two-character ISO country code.
Filler	2 Char	Blank.
Tax Type Code	2 Char	Identifies the type of tax reported. Choose the appropriate tax type code.
Reporting Period Ending Date	6 Char	Blank.
Tax Reporting Period Cycle	1 Char	Blank.
Gross Commission Amount	15 Digit	Net Commission amount from which the tax is calculated.
Tax Amount	15 Digit	Tax amount included in the payment to the travel agency or withheld and paid to the taxing authority. Do not enter a minus sign for taxes withheld.
Reported Commission Amount	15 Digit	Commission amount after tax is applied to Gross Commission. Transactions are rejected unless (Reported Commission Amount)=(Gross Commission) +/- (Tax Amount).
Tax Percentage	6 Digit	Tax percentage, assuming four decimal positions. For example, 6.25% would be entered as 062500.
Travel Agency Tax ID	15 Char	Blank.
Reported Flag	1 Char	Blank.

19 - Batch Trailer

The Batch Trailer record contains summary information about the commission transactions within the batch.

WTP Field Name	Length	Description
Record Type	2 Char	19.
Filler	7 Char	Blank.
Transaction Count	5 Digit	Batch commission transaction count. (The number of Detail Record One records in this batch.)
Filler	5 Char	Blank.
Total Commissions	15 Digit	The hash total of all commissions payments due for this batch. (The absolute sum of the Commission Amount fields in all Detail Record One records in this batch regardless of their transaction codes.) If commission overpaid transactions are in the batch, the Total Commissions might not equal the actual commissions paid.
Filler	46 Char	Blank.

99 - File Trailer

The File Trailer record contains summary information about the commission transactions in this file.

WTP Field Name	Length	Description
Record Type	2 Char	99.
Filler	7 Char	Blank.
Transaction Count	5 Digit	Total number of commission transactions for this file. (The sum of the Transaction Count fields in all Batch Trailer records in this file.)
Filler	5 Char	Blank.
Total Commissions	15 Digit	A hash total of all commissions payments due for this file, regardless of reporting currency. (The absolute sum of the Total Commissions fields in all Batch Trailer records in this file.) The Total Commissions might not equal the actual commissions paid.
Filler	46 Char	Blank.