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

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

Ver: 9.2