TCR Vendor Reports

TBO Vendor Report	Description	Excel	Report Fields	Report Filters
CommTrak Export CommTrak Export.rpt	http://static.trams.com/tramslibrary/reports /descriptions/CommTrakExport.pdf	No Excel	Not available, report is exported and sent to CommTrack [e-mail]. No Sample	Date From and to
Pegasus II Export pegasusIIexport.rpt	http://static.trams.com/tramslibrary/reports /descriptions/PegasusIIExportDescr.pdf	No Excel	Not available, report is exported and sent to Pegasus. No Sample	Date From and to
CommTrack Vendor Balances Report 401CommtrackVendorBalances100.rpt	http://static.trams.com/tramslibrary/reports /descriptions/CommTrackVendorBalancesRe portDescr.pdf	MS Excel 97-2000	Vendor Name, Vendor ID, Number of bookings, Commission amount for each aging period, Commission, and Total fare. Detail report includes Invoice Number, Depart Date, Passenger, Travel Category. Sample	Select Depart or issue date.  Enter as of date. Select aging option. Sort: Vendor name or ID. Select Summary or Detail. Hotel Chain codes? Select travel categories.
Vendor Net Remit Cash Flow Report 400VendorNetRemit102.rpt	http://static.trams.com/tramslibrary/reports /descriptions/VendorNetRemitCash.pdf	No Excel	Vendor name, Net remit Due for the next 12 months Sample	End date Branch Number (One or All)
US-HPSegmentExport.rpt  US-HP Segment Export	http://static.trams.com/tramslibrary/reports /descriptions/US-HPSegmentExport.pdf	MS Excel 97-2000	Not available, report is exported and sent to US Airways. No Sample	Report type –All clients, one client or group. Client id or group if needed. Issued date from & to Depart date (yes/no) Depart date range ARC only?
Vendor Comparative Sales for Year 404VendorCompSalesYear100.rpt	Breaks down the total fare per booking by month for the year entered based on issue date. The report totals each month and the year.	No Excel	Vendor Name, Comparative Sales for the year. Sample	Vendor: One, Group, or All.  Enter Interface ID or Group Name if needed.   Vendor Type: All, Preferred Only, Non- Preferred  Only  Enter Year: (issue date).  Select Sort: Alphabetically Descending By Yearly Total.  Submit To: ARC/BSP, Supplier, CommTrack  Branch: One, Group, or All Branches.  Enter Branch Number or Group Name if needed.
Vendor Comparative Revenue for Year 403VendorCompRevenueYear100.rpt	Breaks down the total commission per booking by month for the year entered based on issue date. The report totals each month and the year.	No Excel	Vendor Name Revenue for the year specified by month and a total for the year. Sample	Vendor: One, Group, or All Vendors.  Vendor Interface ID or Group Name if needed.  Vendor Type: All , Preferred Only, or NonPreferred Vendors Only  Enter Year: (issue date).   Sort: Alphabetically by Vendor Name or Descending By Yearly Total.  Submit To: ARC/BSP, Supplier, CommTrack  Branch: One, Branch Group, or All Branches.  Enter Branch Number if or group I needed.
Vendor Comparative Productivity in Summary 402VendorCompProdSummYear100.rpt	Calculates Total Fare and Total Commission based on an Issue Date range. The date range must be in the same year for the report to work correctly as the report also calculates the Prior Year Total Fare and Total Commission. Year-To-Date totals for the current year and the prior year are calculated to finish the report.	No Excel	Vendor Name Total Fare & Commission for Current period, Last year Period, Current year to date & last year to date Sample	Vendor: One, Group, or All Vendors.  Vendor Interface ID or Group Name if needed.  Vendor Type: All , Preferred Only, or NonPreferred Vendors Only  Issue Date: From & To  Submit To: ARC/BSP, Supplier, CommTrack  Branch: One, Branch Group, or All Branches.  Enter Branch Number if needed.
Vendor Statement By Confirmation Number 406VendorStatementByConfirmNumber.100rpt	http://static.trams.com/tramslibrary/reports /descriptions/VendorStatementByConfirmNu mberDescr.pdf	No Excel	Vendor  Passenger, Depart date, Confirmation No., Total Fare, Commission and Net Remit. No Sample	Report Type: Statement or Summary.  Submit To: Supplier and CommTrack, Supplier Only, CommTrack Only.  Vendor: All, One, or Group.  Required ID: Vendor ID or Group if needed.  Report Format (Not Valid for One Vendor): Group (All Vendors on One Report), Batch [Separate Reports for Vendors].  Run by Invoice Date or Depart Date?  Date range: From & To.  Branch: One, Group or All.  Enter Branch Number and/or Group name if necessary.
Vendor Balances With Invoice Group and due date flags VendorBalancesV4.2.2.rpt Revised 5/24/17 - JN	Report allows the Vendor Balances report in Trams Back Office to run with the option of including or not including invoices that have an invoice group on them, flagging past due date (those items where the depart date is earlier than the date of the Vendor Balances), using a past due date earlier than the balance date.		Sample	As Of Date (Required): Vendor balances as of the specified date. Report Format: Summary or Detail. Vendor: All, One, or a Group.  Required ID: Interface ID or Group Name if needed.  Branch: One, Group or All.    Enter Branch Number or Branch Group if needed  Invoice Group: All Invoices Include Only Invoice Groups, Exclude All Invoice Groups.  Past due date highlight
Canada Vendor List 405CanadaVendorList100.rpt	Provides list of vendor in database so you can verify the accuracy of the information.	MS Excel 97-2000	Profile Number, Vendor Name, City, Province, Postal Code, Country No Sample	No criteria required
Vendor Activity Drill Down Report 408VendorActivityDrillDown100.rpt	http://static.trams.com/tramslibrary/rep orts/descriptions/VendorActivityDrillDo wnDesc.pdf	MS Excel 97-2000	Vendor Name, Interface ID, Number of invoices, Number of bookings, Total Fare, Commission, Net Remit. No Sample	For ARC/BSP. Supplier and Commtrack Select: Issue Date (Vendor Open or Closed), Vendor payment date, Issue date (vendor Open) or Exclude. Invoice Type All, Incoming, or Outgoing. Travel Categories: Add All or each travel category. Enter Dates “From” and “To”.  Branch: One, Group, or All Branches.  Enter number or group if needed.
Vendor Commission By As Of Date 409VendorCommissionByAsofDate101.rpt	http://static.trams.com/tramslibrary/rep orts/descriptions/VendorCommissionBy AsOfDateDescr.pdf	No Excel	Vendor Name, Vendor ID, Number of bookings, Commission, Total Fare. Invoice No., Branch, Depart Date or final pay	Select Depart Date or Final Payment Due Date.  Enter as of date.  Select report type: Both types, Open Commtrack or Supplier Paid Credit Card.
			date, Agent, Passenger, and Travel Category. Sample	Select Aging: None, 60/90/120, 30/60/90, 15/30/45, or 7/14/21. Sort report by Vendor Name or by Vendor Interface ID.  Run for All Vendors or Run By Vendor Group.  Enter Vendor Group if needed. Include Agent Breakdown: Select No Agent, One report all agents, or Print as Separate Reports, one for each agent.  Report Format: Detail or Summary.  Hotel Chain Codes: Sort by Two Letter Code From Hotel ID or No Sorting .Travel Categories – Add the travel categories, All or Selected by Using Drop Down.
Vendor Commission By Date Range 410VendorCommissionByDateRange100.rpt	http://static.trams.com/tramslibrary/rep orts/descriptions/VendorCommissionBy DateRangeDescr.pdf	MS Excel 97-2000	Vendor Name, Vendor ID, Number of bookings, Commission, Total Fare. Invoice Number, Branch, Depart Date or final pay date, Agent, Passenger, Travel Category. Sample	Run by Depart Date or Run by Final Payment Due Date.   Enter the starting date for From and to dates.  Select report type: Both types, Open Commtrack or Supplier Paid Credit Card.  Sort report by Vendor Name or by Vendor Interface ID. Run for All Vendors or Run By Vendor Group.  Enter Vendor Group if needed. Include Agent Breakdown: Select No Agent, One report all agents, or Print as Separate Reports, one for each agent.  Report Format: Detail or Summary.  Hotel Chain Codes: Sort by Two Letter Code From Hotel ID or No Sorting .Travel Categories – Add the travel categories, All or Selected by Using Drop Down.