Form of Payment Exchange

Name	Form of Payment Exchange
Code	FopExchg
Source	Entity FopExchg
XML Element	TicketingData/TicketFOP/Exchange

Description

This table is populated when one ticket is used as payment for another (exchange). The value of the ticket being exchanged can be less than, equal to, or greater than the value of the ticket being purchased. The ’FopExchg’ table contains data specific to an Air Ticket Exchange transaction. Fields will be populated based on where (i.e. Galileo or Apollo) the exchange is performed, the type of exchange functionality used by the travel or reservation agent and the presence of applicable data in an exchange ticketing event. Many of the data fields below map to a field or functional entry in an exchange process performed by an Apollo or Galileo travel or reservation agent. Otherwise, fields will be populated with system generated data.

Fields

Travel Order Event Identifier

Field Label	TravelOrderIdentifier
XML Element	No equivalent XML.
Attributes	4 N
Status	Mandatory
Description	A programmatically generated number that uniquely identifies the travel order event. Passed to this table from the TableOrderEvent table.
Event Type	Ticketing
Allowable Values	Not applicable.

FOP Sequence Number

Field Label	FopSequenceNbr
XML Element	No equivalent XML.
Attributes	2 N
Status	Mandatory
Description	A programmatically generated number that provides uniqueness of the form or payment with respect to the ticket transaction.
Event Type	Ticketing
Allowable Values	Not applicable.

Exchange Sequence Number

Field Label	ExchangeSequenceNbr
Attributes	2 N
Status	Optional
Description	Programmatically assigned number that ensures the uniqueness of the form of payment with respect to an exchange transaction.
Event Type	Ticketing
Allowable Values	Not applicable.

Original Ticket Number

Field Label	OriginalTicketNbr
XML Element	OriginalTicketNbr
Attributes	10 A/N
Status	Optional
Description	The ticket number of the originally issued ticket that is used for the exchange.
Event Type	Ticketing
Allowable Values	Not applicable.

Exchange Type

Field Label	ExchangeType
XML Element	Type
Attributes	1 A
Status	Optional
Description	The type of exchange transaction.
Event Type	Ticketing
Allowable Values	E Even A Add Collect R Refund

Exchange Issue Place

Field Label	ExchangeIssuePlace
XML Element	IssueLocation
Attributes	6 A/N
Status	Optional
Description	The city code of the location where the exchanged document was issued.
Event Type	Ticketing
Allowable Values	Not applicable.

Exchange Issue Date

Field Label	ExchangeIssueDate
XML Element	IssueDate
Attributes	10 A/N
Status	Optional
Description	The date when the exchanged ticket was issued. Format: YYYY-MM-DD.
Event Type	Ticketing
Allowable Values	Not applicable.

Exchange Issue IATA

Field Label	ExchangeIssueIata
XML Element	IssueIATA
Attributes	9 A/N
Status	Optional
Description	The IATA number of the ticketing location that issued the exchanged ticket.
Event Type	Ticketing
Allowable Values	Not applicable.

Original Plating Number

Field Label	OriginalPlatingNbr
XML Element	OriginalCarrierPlatingNbr
Attributes	3 A/N
Status	Optional
Description	The air carrier over which the exchanged (original) document was validated.
Event Type	Ticketing
Allowable Values	Not applicable.

Exchange Currency Code

Field Label	ExchangeCurrencyCode
XML Element	CurrencyCode
Attributes	3 A/N
Status	Optional
Description	The currency in which this transaction will be paid.
Event Type	Booking Fare Quote
Allowable Values	Not applicable.

Exchange Ticket Number

Field Label	ExchangeTicketNbr
XML Element	TicketNbr
Attributes	10 N
Status	Optional
Description	The ticket number used in payment.
Event Type
Allowable Values	Not applicable.

Decimal Number

Field Label	DecimalNbr
XML Element	DecimalPlaces
Attributes	1 N
Status	Optional
Description	Identifies where in the money value to position the decimal (if applicable).
Event Type	Fare Quote Ticketing
Allowable Values	0, 1, or 2

Full Partial Indicator 7.1

Field Label	FullPartialIndicator
XML Element	FullPartialIndicator
Attributes	1 A
Status	Optional
Description	The type of exchange transaction modifier used by the Apollo or Galileo travel or reservation agent to perform an exchange. e.g. When a Partial exchange functional modifier is used to perform a Full exchange the ‘Exchange Type’ will be P (not F)
Event Type	Ticketing
Allowable Values	F Full Exchange P Partial Exchange

Unused Coupons 7.1

Field Label	UnusedCoupons
XML Element	UnusedCoupons
Attributes	19 A/N
Status	Optional
Description	Unused coupons being exchanged for DOC1 up through DOC4. Ticket documents contain up to four coupons per booklet. This field contains information on unused coupons for each document booklet in a exchange transaction. Each booklet is separated by an underscore mark (_). Where a coupon is ‘USED’ or the data coupon indicator is ‘N’, the coupon is represented by a period (.). For example: 123._.2.4_1..._....
Event Type	Ticketing
Allowable Values	N/A

Commission Amount On Exchanged Document 7.1

Field Label	CommissionAmountOnExchangedDocument
XML Element	CommissionAmountOnExchangedDocument
Attributes	11 N (variable)
Status	Optional
Description	The commission rate originally collected on the document being exchanged. Input in Galileo in ORIGINAL COMM RATE as nn.nn, output as 00.00.
Event Type	Ticketing
Allowable Values	N/A

Cash Fare Paid 7.1

Field Label	CashFarePaid
XML Element	CashFarePaid
Attributes	11 N (variable)
Status	Optional
Description	The cash fare amount paid (excluding taxes) for the ticket being exchanged. Shown in Galileo in ‘CASH AMT EX TAX PAID’ or in Apollo in ‘BASE FARE PAID’, or through ARNE in ‘ORIGINAL: FARE’
Event Type	Ticketing
Allowable Values	N/A

Credit Card Fare Paid 7.1

Field Label	CreditCardFarePaid
XML Element	CreditCardFarePaid
Attributes	11 N (variable)
Status	Optional
Description	The credit card fare amount paid (excluding taxes) for the ticket being exchanged. Shown in Galileo in “CREDIT AMT EX TAX PAID’, or in Apollo in ‘BASE FARE PAID’, or through ARNE in ‘ORIGINAL: FARE’
Event Type	Ticketing
Allowable Values	N/A

Total Tax Amount Paid 7.1

Field Label	TotalTaxAmountPaid
XML Element	TotalTaxAmountPaid
Attributes	11 N (variable)
Status	Optional
Description	The total tax amount paid for the ticket being exchanged.
Event Type	Ticketing
Allowable Values	N/A

Total Exchange Amount 7.1

Field Label	TotalExchangeAmount
XML Element	TotalExchangeAmount
Attributes	11 N (variable)
Status	Optional
Description	Total amount of add collect/refund due of the exchange.
Event Type	Ticketing
Allowable Values	N/A

Additional Collection Amount 7.1

Field Label	AdditionalCollectionAmount
XML Element	AdditionalCollectionAmount
Attributes	11 N (variable)
Status	Optional
Description	Amount outside original price paid.
Event Type	Ticketing
Allowable Values	N/A

Change Fee Penalty 7.1

Field Label	ChangeFeePenalty
XML Element	ChangeFeePenalty
Attributes	11 N (variable)
Status	Optional
Description	Vendor's charges for changing the ticket; similar to administration fee
Event Type	Ticketing
Allowable Values	N/A

Commission Amount on Penalty ^7.1

Field Label	CommissionAmountOnPenalty
XML Element	CommissionAmountOnPenalty
Attributes	11 N (variable)
Status	Optional
Description	The Commission Amount on Penalty for the exchange. The number of decimals must be the same as for Passenger Total Amount.
Event Type	Ticketing
Allowable Values	N/A