Travel Expense Report (APR025)
-
Print
-
DarkLight
-
PDF
Travel Expense Report (APR025)
-
Print
-
DarkLight
-
PDF
Article summary
Did you find this summary helpful?
Thank you for your feedback
Report Description
A report that lists travel cost of air carriers, car rentals, and hotels (by supplier) regardless of how they are paid (i.e., via P-Card, reimbursement to employee or direct payment). This report will list expenses made within an agency that are associated with travel account values, identify travel payments by Traveler and/or Supplier ID, and include unique information to identify specific travel occurrences (e.g., Document Number, Service Dates). This on-demand report is primarily intended to support agency users to monitor travel payment activities and may also be used by enterprise partners.
Report Location
Data Warehouse
Report Sample Layout
See the sample layout report below.
Report Navigation
Coming Soon!
Report Audience
- AP Reporter
- Confidential AP Reporter
Suggested Report Frequency
- Ad Hoc
- Daily
- Monthly
Business Process Models
This report can be found in the following business processes:
Report Prompts
The report data can be filtered by the following report prompts:
Parameter Name | Default Value | Column in Subject Area | Required (Y/N) | User Input |
|---|---|---|---|---|
Business Unit | N | Financials – AP Transactions.AP Voucher Business Unit.Business Unit | Y | Y |
Vouchered Entered Date | N | Financials – AP Transactions.Payables Payment Voucher Details.Voucher Entered Date | N | Y |
Voucher Origin | N | Financials – AP Transactions.Payables Payment Voucher Details.Voucher Origin | N | Y |
Organization | N | Financials – AP Transactions.APVoucher Business Unit.Organization | N | Y |
Budget Date | N | Financials – AP Transactions. Payables Payment Voucher Details.Budget Date | N | Y |
Service Date From | N | Financials – AP Transactions.Payables Payment Voucher Details.Service Date From | N | Y |
Service Date To | N | Financials – AP Transactions.Payables Payment Voucher Details.Service Date T | N | Y |
Confidential | N | Financials – AP Transactions.Account Payables Identifiers.Confidential Description | N | Y |
Report Columns
The layout of the report is listed below.
Column Name | Column in Subject Area or TableName.ColumnName |
|---|---|
Business Unit | Financials – AP Transactions.AP Voucher Business Unit.Business Unit |
Organization | Financials – AP Transactions.APVoucher Business Unit.Organization |
Voucher Origin | Financials – AP Transactions.Payables Payment Voucher Details.Voucher Origin |
Related Voucher ID | Financials – AP Transactions.Payables Payment Voucher Details.Related Voucher ID |
Voucher ID | Financials – AP Transactions.Account Payables Identifiers.Voucher ID |
Receipt ID | Financials – AP Transactions.AP Account Payables Identifiers.Receipt ID |
Voucher Entered Date | Financials – AP Transactions.Payables Payment Voucher Details.Voucher Entered Date |
Supplier ID | Financials – AP Transactions.Supplier Account.Supplier Account Number |
Remit Supplier Name | Financials – AP Transactions.Payables Payment Voucher Details.Name1 |
Voucher Line ID | Financials – AP Transactions.Account Payables Identifiers.Voucher Line Number |
Document Number | Financials – AP Transactions Payables Payment Voucher Details.Document Number |
Merchant | Financials – AP Transactions.Payables Payment Voucher Details.Merchant |
Traveler | Financials – AP Transactions.Payables Payment Voucher Details.Traveler |
Voucher Distribution Line Number | Financials – AP Transactions.Payables Payment Voucher Details.Distribution Line number |
Distribution Line Merchandise Amount | Financials – AP Transactions.Fact – Fins – AP Transaction Custom.Merchandise Amount |
Account | Financials – AP Transactions.GL Account.Account |
Fund | Financials – AP Transactions.GL Account.Fund |
Budget Entity | Financials – AP Transactions.GL Account.Budget Entity |
Category | Financials – AP Transactions.GL Account.Category |
Budget Date | Financials – AP Transactions. Payables Payment Voucher Details.Budget Date |
Service Date From | Financials – AP Transactions.Payables Payment Voucher Details.Service Date From |
Service Date To | Financials – AP Transactions.Payables Payment Voucher Details.Service Date To |
Payment Reference ID | Financials – AP Transactions.Account Payables Identifiers.Payment Reference ID |
Payment Status | Financials – AP Transactions.Payables Payment Voucher Details.Payment Description |
Confidential | Financials – AP Transactions.Account Payables Identifiers.Confidential Description |
Data
More information about the data fields, including business definition and key values, is included as part of the Interface Catalog and applicable interface file layouts.
More information about the data values is included here: Configured Data Values.
More information about the ChartFields and related values is included in the Chart of Accounts Design.
Version History
Date | Revision Description |
|---|---|
01/31/2025 | Original Version |
Was this article helpful?
