Worldspan TVL Segment Formats

The TVL segment format follows:

TNZZMK1XXX15DEC15DEC/segment information/AC1-more data/AC2-more data

where:

T	Record identifier that says it is a TVL segment
N	Segment number
ZZ	Chain code
MK	Status code
1	Number of people
XXX	Associate type
15DEC25DEC	Start date and end date
segment information	Codes and values for amount, commission, FOP, and so forth
AC1-	Free-form area to enter accounting system data
AC2	Free-form area to enter accounting system data

How the interface stores data from standard TVL segment information fields is described below. How the interface stores additional data from GlobalWare-specific formats is described in GlobalWare TVL Segments and GlobalWare Non-Air General Remarks.

Amount

GlobalWare stores the Total Cost from the following Worldspan amount formats:

/DA1, /DA2, /DA3, /DA4	(Due amount 1, 2, 3, 4)
/FDA, /SDA, /TDA, /FPA	(First deposit amount, second deposit amount, third deposit amount, final payment amount)
/RG, /RQ, /PA	(Guaranteed rate, quoted rate, accident insurance rate)
/CRD	(With DP1 through 9 in /AC1 will store payments/credits on account)

If none of the above are in the TVL segment, no item is stored in GlobalWare. See Example: Multiple Payments invoiced separately (with each payment).

If the TVL segment has multiple deposit/final payment amounts (for example, /DA1 and /DA2), an invoice item will be created for each amount. See Example: Multiple Payments invoiced together (with first payment). If there are multiple rate amounts, only one invoice item is created.

By default, manually booked cars and hotels are stored with a flat rate (the amount entered is stored in Total Cost, zero in Base Fare, and the rate * units * days calculation is not done). To store a daily rate, include the /RTD (rate description) format with DY or DAILY. (See Example: Manually booked hotel.)

If there is more than one passenger in the PNR, you can create an invoice item for each passenger from one TVL segment. See Separate Items for Each Passenger under GlobalWare TVL Segment Formats.

Commission

GlobalWare stores the commission from the /CP (commission percent) or /CM (commission amount) format. If neither is in the TVL segment, GlobalWare stores the provider account ID’s default commission percent. If the provider ID does not exist in GlobalWare, 10% is stored.

If you want to store the item with no commission, you must include /CP-0 or /CM-0. See Example: Multiple Payments invoiced separately (with each payment).

If multiple invoice items are created from the TVL segment (for example, it contains /FDA and /FPA formats), the commission is stored on the last item only. If a commission percent is entered, all the amounts are totaled, that amount is multiplied by the commission percent, and the calculated amount is stored on the last item. See Example: Multiple Payments invoiced together (with first payment).

Form of Payment

GlobalWare stores the form of payment from the /FOP format. See Example: One Payment. /FOP format codes are stored as follows:

TVL Segment	FOP in GlobalWare
/FOP-AR, /FOP-AN	R
/FOP-AG	A
/FOP-CK, /FOP-CA, /FOP-MS, /FOP-GR	C
All others	P

If there is no /FOP format in the TVL segment, GlobalWare stores the PNR form of payment.

There is also a GlobalWare-specific FOP format, which overrides the Worldspan TVL /FOP format and the PNR form of payment for deposit/final payment amounts (/DA1, /FDA, and so forth). See Form of Payment under GlobalWare TVL Segment Formats.

Note: Credit card data (company, number, expiration date, approval code) is not stored if the TVL /FOP format is used. If you need this data and the information is different from the PNR form of payment, use the GlobalWare format.

Revenue and Travel Types

GlobalWare stores the revenue type entered in the /VTC format. See Example: Agency-collected service fee. If there is no /VTC format, the revenue type is stored based on the associate type.

Worldspan Associate Type Code	GlobalWare Revenue Type
AIR, ATX, PRP	A – Air
BUS	B – Bus
CAR	C – Car
BKG, CNL, SVC, TKT	F – Fee
CRU	S – Ship
HTL	H – Hotel
INS	I – Insurance
TRN	R – Rail
TUR	T – Tour
ACC, CHT, FAX, FRE, HEL, HOV, LMO, MAI, MIS, TCK, TEL, TLX, TRF, WTX, XMA	O – Other

Note: If the associate type code is not one of the above, no item is stored in GlobalWare.

For the invoice’s travel type, GlobalWare stores the travel type associated with the revenue type.

Itinerary

The information stored in the Itinerary field is based on the amount format and travel type.

• If the amount format is /FPA or /DA4, "Final Payment" is stored.

• If the amount format is /DA1, /DA2, /DA3, /FDA, /SDA, or /TDA, and only one amount format is in the TVL segment, "Full Payment" is stored.

• If the amount format is /DA1, /DA2, /DA3, /FDA, /SDA, or /TDA, and there is more than one amount is in the TVL segment, the last amount’s itinerary is "Final Payment".

  For the deposits, the itinerary for /DA1 and /FDA is "First Deposit", for /DA2 and /SDA it is "Second Deposit", and for /DA3 and /TDA it is "Third Deposit".

• If the amount is a rate-type amount: if the travel type is F or M, the Itinerary is "Service Fee". If the travel type is I, it is "Insurance". If the travel type is H, it is Destination and hotel name (from the /AN format if there is one, if not from the /PRP format). If the travel type is C, it is Destination. For all others, it is "Miscellaneous Booking".

You can override the itinerary. See GlobalWare TVL Segment Formats.

See Examples.

Airline, Provider, and Property

GlobalWare reads the /VA (validating airline) and /VC (vendor code) formats.

• If the segment is air, car, or hotel and there is a /VA format, it is stored in Airline and Provider. If there is no /VA, the /VC format is stored in Airline and Provider. If neither format is in the segment, GlobalWare stores the vendor code field (for example, ZZ).

•  If the segment is any other type (for example, tour, cruise, insurance), the /VA code is stored in Airline if the settlement is ARC or Direct. The /VC code is stored in Provider. See Example: One Payment on MCO. If there is no /VC format, GlobalWare stores the vendor code field (for example, ZZ).

For hotels booked in a TVL segment, GlobalWare stores the property code entered in the /PID format. See Example: Manually booked hotel.

Provider Account ID Information

If GlobalWare creates a provider account ID (the vendor code in the TVL segment does not exist in GlobalWare and Create New Providers is checked), the following formats are read.

Provider Name	/AN or /PRP if there is no /AN
Address	/AA1 and /AA2
Phone	/AP

Enter the city, state, and zip in /AA2. GlobalWare will store the last word as the zip code, the second to the last word of the last field as the state code, and the remainder as the city.

See Example: One Payment on MCO.

Traveler

GlobalWare stores the traveler name entered in the /NM format. See Example: Payment on Account. If there is no /NM format, the PNR name field is stored.

Destination

GlobalWare stores the city code entered in the /CC2 format. See Example: One Payment.

Depart and Return Dates

GlobalWare stores the depart date entered in the /DTD format and the arrival date entered in the /DTA format. If these are not in the TVL segment, the TVL segment start and end dates are stored.

If the segment start and end dates are stored, GlobalWare reads the year from /Y1 and /Y2. See Example: One Payment. If these are not in the TVL segment, GlobalWare calculates the year.

Document Number

GlobalWare stores the document number from the /DOC or /CF format. If the TVL segment has both, GlobalWare stores the /DOC format for ARC items, and the /CF format for all non-ARC items. See Example: One Payment on MCO and Example: One Payment.

Number of Units

GlobalWare stores the number of units entered for the segment quantity. See Example: Manually booked hotel.

Frequent Flyer

GlobalWare stores the frequent flyer number from the /FG format in Comments line 104. See Example: Manually booked hotel.

Tour Code

GlobalWare stores the tour code (IT number) from the /IT format in Comments line 113. See Example: Multiple Payments invoiced together (with first payment).

Car/Room Type

GlobalWare stores the car or room type for manually booked cars and hotels from the /RD and /VT formats in Comments line 103. See Example: Manually booked hotel.

Check Number

GlobalWare stores the check number for FOP cash items from the /CK format in Comments line 101. See Example: One Payment.