Exporting Data

You can export invoices and related data (payment, segments, and so forth) for use with third-party applications.

You can also export data in the ClientBase Plus XML format. When you export for ClientBase Plus, you have the option of creating profiles from the invoice account ID or market ID.

Note: Market ID is not a required field. If you select Market ID and an invoice item does not contain a market ID, it will not be exported. For information about market IDs, see Market ID.

GlobalWare gives you the option to include or exclude commission data. You might not want to export commission information if you are exporting data to give it to a corporate account.

To export data, enter the query search criteria. When the results appear in the Search Results grid on the Invoice Edit & Query screen, click EXPORT.

The Invoice Export for PRISM and Other Applications dialog box appears.

Note: GlobalWare automatically saves the selections you make on this dialog box when you click EXPORT. You do not need to make selections again for future exports. If you subsequently make changes, GlobalWare updates your previously saved selections. Saved selections are user-specific.

1. In the File Type field, select one of the following options:

   • ClientBase Plus – Uses the Client Base Plus format.
   • Comma Delimited Text – Separates the fields with commas.
   • Fixed Length Text (SDF) – Makes all the fields a fixed length.
   • Tab Delimited Text (PRISM) – Separates the fields with tabs.
2. If you selected comma-delimited or tab-delimited fields, select Use Quotes to include quotes around each field.

3. Select the Include Commissions option to include commissions. If commissions are not included, you have the following options:

   • Skip Commission Fields – Commission fields are not stored.
   • Zero-Fill Commission Fields – Stores the commission fields with zero. The commission fields are listed in the Export File Layouts section below.

   If you are exporting for ClientBase Plus, select Account ID or Market ID.

4. To mask credit card number or traveler name (by replacing the actual values with XXX…), select the Mask Credit Card Number or Mask Traveler Name options.

5. If you are exporting for ClientBase Plus, only invoice data is exported. Otherwise, select the tables to export. You can select any or all of the following:

   • Invoice
   • Comments
   • Segments
   • True OD segments
   • Exchange
6. In the Location of Files field, enter the location (drive and path) where you want the files to be stored. You can click the ellipsis () button to select the desired location.
7. Click EXPORT. The files are saved to the location you selected.

Export file layouts

The Invoices export file includes Invoice and Payments table fields. The fields are in the same order as the database (see Printing the Database Structure), with Invoice fields first, then Payments table fields.

If Include Commissions is not checked, the following fields are excluded: Invoice Commission Percentage, Invoice Commission Amount, Payments Commission Due Date, Payments Commission Received Date, Payments Commission Due Amount, Payments Commission Received Amount, and Payments Commission Received Flag.

If Zero-fill Commission fields is selected, no data is stored in the date fields, zero is stored for amounts, and "X" is stored for the flag.

The other export files include all fields from the respective tables. The fields are in the same order as the database (see Printing the Database Structure).

ClientBase Plus

The ClientBase Plus format conforms to the ClientBase Plus ImportXml v.1.0.1.3 specifications. For details about this format, contact ClientBase Plus.

The tables below define how this file is populated with GlobalWare data. All fields not listed are not populated, populated with constant data, or not available in ClientBase Plus.

Notes:

• ClientBase Plus requires InvoiceNumber to be unique. Because PayId is GlobalWare’s unique identifier, it is stored in this field. GlobalWare’s invoice number is appended to the PassengerName so that you have a record of it in ClientBase Plus.
• ClientBase Plus statuses are void, not applicable, open, and closed. ClientBase Plus will not import a status of closed; therefore all items that are open or closed in GlobalWare will be open in ClientBase Plus.
• See the ClientBase Plus and GlobalWare Export.doc on the GlobalWare CD for details on importing GlobalWare data into ClientBase Plus.

Profile, address, and communication (Account ID table)

Field	Description
ProfileType_LinkCode	"C" (commercial) for business accounts, "I" (individual) for all others.
Name	Name (for business accounts).
LastName	The last "word" in the Name field (for non-business accounts).
FirstName	All other characters in the Name field (for non-business accounts).
InterfaceID	AccountId.
Address1	Addr2 (first address line in Account Maintenance).
Address2	Addr3 (second address line).
City, State, Zip	City, State, Zip.
CommValue	HomePhone (for non-business accounts) or BusPhone (business accounts), FaxPhone, or Email.
Description	"Home", "Business", "Fax", or "Email".

Invoice, booking, vendor, agent (Invoice and Payments tables)

Field	Description
Client_LinkNo	AccountId or MarketId.
IssueDate	InvoiceDate.
InvoiceType_LinkCode	"R" for refunds, "O" for spoiled tickets, "S" (sales) for all others.
InvoiceNumber	PayID (see note).
DepartDate	DepartDate.
TravelType	TravelType.
StartingTicketNo	TicketNum if TravelType is A.
Itinerary	Itinerary if TravelType is A.
ClientPayStatus_LinkCode	Based on Status and CustRcvdFlag (see note above).
VendorPayStatus_LinkCode	Based on Status, ProvPaidFlag, and CommRcvdFlag (see note above).
Inter_LinkCode	DomInt.
SubmitTo_LinkCode	Based on Settle.
ClientPaidByCC	If FOP is P or A, Y otherwise N.
ClientRemarks	Sort1.
CommAmt	CommAmount.
ConfirmNo	TicketNum if TravelType is other than A.
PassengerName	Traveler plus InvoiceNumber.
TotalFare	TotalCost.
VendorRemarks	Itinerary if TravelType is other than A.
Name (of vendor)	AccountID Name for the provider.
InterfaceID (of vendor)	Provider.
InterfaceID (agent)	BkAgt.