Handoff File Information

The handoff files contain air, hotel, and car sales transactions for the handoff file accounts. The air handoff file also contains refunds for these customers. The files are stored in the Gblware folder. (You indicated where the Gblware folder should be located when you installed GlobalWare.) The names of the handoff files are as follows:

Air Handoff File

The Air Handoff File contains a location record, an account record, detail records, and a trailer record.

Location Record

The file is sorted by location. A location record is stored at the beginning of each location's transactions. This record contains the location name, address, and ARC number from the Location File. The code for this record type is 00.

If the location is not a valid location, zeros are stored for the ARC number and a message is printed on the report.

Account Record

Within each location, the file is sorted by handoff file account number. There is an account record at the beginning of each handoff file account's transactions. This record contains the following information:

Field Description

Account number

Handoff file account number.

Transaction date

Transaction date from Create Handoff Files entry screen.

Transaction number

Characters from transaction number specified for account.

Record type code

01.

Account name

From Customer Account File.

Account address

Address line 2 (if blank, line 1) from Customer Account File.

Account city, state, zip

Last non-blank address line from Customer Account File.

Last billing date

0.

Balance forward

0.

Format indicator

R (report).

Beginning date

From Create Handoff Files entry screen.

Ending date

From Create Handoff Files entry screen.

Detail Records

For each transaction, Corporate Consolidation stores main and detail transaction records, a user-defined fields record (per account), a routing record, and a flight schedule record. The following fields display in all detail records:

Field Description

Account number

Handoff file account number.

Subsidiary account

Handoff file account number.

Transaction date

Date of transaction.

Transaction number

Characters from transaction number specified for account.

Main Transaction Record

The main transaction record contains the following information:

Field Description

Record type code

10.

Transaction type

MP (multiple forms of payment).

Gross amount

Total sale (negative for refunds).

Unpaid balance

0.

Comparative fare code

Fare savings code (1 character).

Comparative fare amount

Full fare for fare savings (negative for refunds).

Check number

0.

Variable description

Client name for sales, ``REF ORG INV# nnnnn'' for refunds, or ``EXC ORG INV# nnnnn'' for sale exchanges (nnnnn = org invoice number).

Credit card information

Credit card info.

Previously on statement

N.

Agency branch identifier

Booking location from transaction number.

Agent identifier

Booking agent or 00 (per account), alphanumeric.

Market identifier

Market code (two characters).

Ticket location

Ticketing location.

User-Defined Fields Record

Corporate Consolidation stores one record for every two user-defined fields set up for the account. There can be up to four user-defined field records for each transaction (because an account can have up to eight user-defined fields stored). A user-defined field record contains the following information:

Field Description

Record type code

12.

User defined number

01.

User defined information

Field specified in the first User Defined Field for account.

User defined number

02.

User defined information

Field specified in the next User Defined Field for account.

Routing Record

A routing record contains the following information:

Field Description

Record type code

20.

Class of service

Class of service codes for the first nine legs or segments.

Routing part 1

Travel date, origin city, and destination city for legs 1 through 4.

Routing part 2

Travel date, origin city, and destination city for legs 5 through 9.

Carrier

Airline codes for the first nine legs in routing.

Ticket location

Ticketing location.

Flight Schedule Record

Corporate Consolidation creates a flight schedule record for every two legs in the routing. A flight schedule record is not stored for refunds or non-ARC air transactions. Each record includes the PNR locator and the following information from the two legs:

Field Description

Record type code

31.

From city code

Origin city for leg.

To city code

Destination city for leg.

Carrier code

Airline code for leg.

Fare basis

Fare basis amount (eight characters).

Flight number

Flight number for leg.

Class of service

Class of service for leg.

Departure date

Departure date for leg.

Departure time

Departure time for leg.

Arrival date

Departure date for leg.

Arrival time

Arrival time for leg.

Segment type code

Blank (stopover), period (connection), comma (Amtrak), S (surface).

Fare by leg

Fare for leg.

Transaction Detail Record

The transaction detail record contains the following information:

Field Description

Record type code

40.

Vendor type

0 (ARC air), 8 (non-ARC air).

Vendor number

Validating airline number.

Departure date

Travel date from first leg.

Document number

Numeric code for validating airline plus first ten digits of document #.

Conjunct ticket number

Last four characters of document number.

Gross amount

Total sale (negative for refunds).

Validating airline

Validating airline code.

Tax amount

Total sale less base fare (negative for refunds).

Service category

Class of service; if same for all legs, use F or Y; otherwise, P.

Domestic/International

Tariff indicator.

Passenger name

Client name.

Passenger information

Field specified for passenger information for the account.

Form of payment

1 (charge to AR), 2 (credit card), 3 (cash/check).

Ticket location

Ticketing location.

Trailer Record

One record is stored after the last transaction for each location. This record contains the following information:

Field Description

Record type code

90.

Ending date

From Create Handoff File entry screen.

Balance due

0.

Net receipts, disbursements, adjustments

0.

Net charges

Total of gross amount for all transactions in the location.

Record count

Number of records in file for location.

Refunds are subtracted from net charges and added to the record count.