Reporting View Source: FTPREXPS

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: FTPREXPS Travel And Expense Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column
ACTIVITY_DATE	NA	REPORTING VIEW	REIMBURSEMENT_ITEM AUTHORIZATION_ITEM	ITEM_ACTIVITY_DATE ITEM_ACTIVITY_DATE
ACTUAL_AMOUNT	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	ENTERED_AMOUNT ENTERED_AMOUNT
ALT_PROVIDER_NAME	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	ALTERNATE_PROVIDER_NAME PROVIDER_NAME
CALCULATED_AMOUNT	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	CALCULATED_AMOUNT CALCULATED_AMOUNT
CALCULATED_APPR_AMOUNT	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	CALCULATED_AMOUNT_NO_TAX CALCULATED_AMOUNT_NO_TAX
CREATE_DATE	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	ITEM_CREATE_DATE ITEM_CREATE_DATE
CREATE_SOURCE	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	ITEM_CREATE_SOURCE ITEM_CREATE_SOURCE
CREATE_USER	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	ITEM_CREATE_USER ITEM_CREATE_USER
CURRENCY_CODE	NA
CURRENCY_CONVERSION_RATE	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	CURRENCY_RATE CURRENCY_RATE
DATA_ORIGIN	NA	REPORTING VIEW	REIMBURSEMENT_ITEM AUTHORIZATION_ITEM	ITEM_DATA_ORIGIN ITEM_DATA_ORIGIN
DESCRIPTION	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	ITEM_DESC ITEM_DESC
DISTANCE	NA	REPORTING VIEW	AUTHORIZATION_ITEM PORTFOLIO_SUMMARY REIMBURSEMENT_ITEM	UNITS UNITS UNITS
EXPENSE_RECEIPT_DATE	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	EXPECTED_EXPENSE_DATE EXPENSE_RECEIPT_DATE
FTPRITIN_ID	NA
FTRBAUTH_ID	NA	REPORTING VIEW	AUTHORIZATION_ACCOUNTING AUTHORIZATION_ITEM	AUTHORIZATION_KEY AUTHORIZATION_KEY
FTRBREMB_ID	NA	REPORTING VIEW	REIMBURSEMENT_ITEM REIMBURSEMENT_ACCOUNTING	REIMBURSEMENT_KEY REIMBURSEMENT_KEY
FTTVCURR_ID	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	CURRENCY_KEY CURRENCY_KEY
FTTVDRAT_ID	NA	REPORTING VIEW	REIMBURSEMENT_ITEM AUTHORIZATION_ITEM	UNIT_RATE_KEY UNIT_RATE_KEY
FTTVEXPT_ID	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	EXPENSE_TYPE_KEY EXPENSE_TYPE_KEY
FTTVPAYM_ID	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	PAYMENT_METHOD_KEY PAYMENT_METHOD_KEY
FTTVPROV_ID	NA
FTTVTLOC_ID	NA	REPORTING VIEW	REIMBURSEMENT_ITEM AUTHORIZATION_ITEM	TAX_LOCALE_KEY TAX_LOCALE_KEY
ID	NA	REPORTING VIEW	REIMBURSEMENT_ITEM AUTHORIZATION_ITEM	EXPENSE_ITEM_KEY EXPENSE_ITEM_KEY
LOCATION	NA	REPORTING VIEW	REIMBURSEMENT_ITEM AUTHORIZATION_ITEM	EXPENSE_LOCATION EXPENSE_LOCATION
PAY_AMOUNT	NA	REPORTING VIEW	REIMBURSEMENT_ITEM AUTHORIZATION_ITEM	PAY_CURRENCY_AMOUNT PAY_CURRENCY_AMOUNT
PAY_APPR_AMOUNT	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	PAY_CURRENCY_AMOUNT_NO_TAX PAY_CURRENCY_AMOUNT_NO_TAX
PCARD_ID	NA
PER_DIEM_IND	NA
RECEIPT_TO_PAY_EXCHNG_RATE	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	PAY_EXCHANGE_RATE PAY_EXCHANGE_RATE
TGRP_CODE	NA	REPORTING VIEW	REIMBURSEMENT_ITEM_TAX REIMBURSEMENT_ITEM AUTHORIZATION_ITEM AUTHORIZATION_ITEM_TAX	TAX_GROUP TAX_GROUP TAX_GROUP TAX_GROUP
USER_ID	NA	REPORTING VIEW	AUTHORIZATION_ITEM REIMBURSEMENT_ITEM	ITEM_USER_ID ITEM_USER_ID

Ver: 8.5