WTP Export File Data Definition

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

Note: Tables/Views along with the respective Column Names are highlighted in red.

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). ASCII FFORMAT-CORPORATE ID
Filler	3 Char	Blank
Date	6 Char	Date this file was created (YYMMDD). SYSTEM DATE
Filler	15 Char	Blank
Group Name	32 Char	Name of your Group or Chain. ASCII FFORMAT.CHAIN NAME
Transmission ID	8 Char	ASCII FFORMAT.TRANSMISSION ID

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). ASCII FFORMAT.HOTEL ID
Filler	13 Char	Blank
Reporting Currency	3 Char	Currency Code ASCII FFORMAT.REPORTING CURRENCY
Remitting Currency	3 Char	Currency Code ASCII FFORMAT.REMITTING CURRENCY
Filler	4 Char	Blank
Location Name	32 Char	Name of the location. RESORT.NAME
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 has been made, code used is CB (Commission paid on original booking with or without change, i.e., changed amount is not equal to 0.00) Note: This code will 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). TA GUEST COMMISSIONS.ARRIVAL
Departure Date	6 Char	The Departure Date must be later than or equal to the Arrival Date. Future dates will be rejected. TA GUEST COMMISSIONS.DEPARTURE
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. RESERVATION GENERAL VIEW.BUSINESS DATE CREATED
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) TA GUEST COMMISSIONS.COMMISSION AMOUNT
Confirmation Number	12 Char	Confirmation number for this reservation. If the confirmation number is unknown, enter Unknown in this field. RESERVATION GENERAL VIEW.CONFIRMATION NO
PNR Number	10 Char	Blank
Number of Rooms	3 Char	Number of rooms used, minimum of one. RESERVATION GENERAL VIEW.NO OF ROOMS
Number of Nights	3 Char	Number of nights stayed, minimum of one. Do not total the number of nights with the number of rooms. RESERVATION GENERAL VIEW.NIGHTS
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. PROFILE 1W.IATA CORP NO otherwise ASCII FFORMAT.HOTEL ID + PROFILE 1W.TRAVEL AGENT ID.
Traveler's Last Name	30 Char	Name of the traveler NAME.LAST/COMPANY
Traveler's First Name	20 Char	First name of the traveler If unknown, Blank. NAME.FIRST
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. TA GUEST COMMISSIONS.COMMISSION REVENUE
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 will cause 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. PROFILE 1W.NAME
Travel Agency's first address line.	30 Char	Travel agency's street address or postal box. PROFILE 1W.ADDRESS1
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. PROFILE 1W.ADDRESS2
Travel Agency's City	25 Char	Travel agency's city PROFILE 1W.CITY
Filler	23 Char	Blank

17 - Agency Record Three

Use 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 which have states or provinces, such as U.S. and Canada; otherwise Blank. PROFILE 1W.STATE
Travel Agency's Country	20 Char	Travel Agency's country PROFILE 1W.COUNTRY DESC
Travel Agency's Postal Code	11 Char	*Required for countries using a postal code, such as U.S., U.K., and Canada; otherwise Blank. PROFILE 1W.ZIP CODE
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. ASCII FFORMAT.CNTRY TAXING AUTHORITY
Filler	2 Char	Blank
Tax Type Code	2 Char	Identifies the type of tax reported. Choose the appropriate tax type code. ASCII FFORMAT.TAX TYPE
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. TA GUEST COMMISSIONS.COMMISSION AMOUNT - COMPUTED COMMISSIONS.VAT AMOUNT
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. COMPUTED COMMISSIONS.VAT AMOUNT
Reported Commission Amount	15 Digit	Commission amount after tax is applied to Gross Commission. Transactions will be rejected unless (Reported Commission Amount)=(Gross Commission) +/- (Tax Amount). TA GUEST COMMISSION.COMMISSION AMOUNT
Tax Percentage	6 Digit	Tax percentage, assuming 4 decimal positions. For example, 6.25% would be entered as 062500. RESORT COMMISSION.VAT AMOUNT
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. Total of TA GUEST COMMISSIONS.COMMISSION AMOUNT for the batch
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. Total of TA GUEST COMMISSIONS.COMMISSION AMOUNT for the batch
Filler	46 Char	Blank