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.