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 Reporting View Source: FTPREXPS - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
ACTIVITY_DATE NA

REPORTING VIEW

AUTHORIZATION_ITEM

REIMBURSEMENT_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

REIMBURSEMENT_ITEM

AUTHORIZATION_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

AUTHORIZATION_ITEM

REIMBURSEMENT_ITEM

ITEM_DATA_ORIGIN

ITEM_DATA_ORIGIN

 
DESCRIPTION NA

REPORTING VIEW

AUTHORIZATION_ITEM

REIMBURSEMENT_ITEM

ITEM_DESC

ITEM_DESC

 
DISTANCE NA

REPORTING VIEW

PORTFOLIO_SUMMARY

REIMBURSEMENT_ITEM

AUTHORIZATION_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

REIMBURSEMENT_ITEM

AUTHORIZATION_ITEM

CURRENCY_KEY

CURRENCY_KEY

 
FTTVDRAT_ID NA

REPORTING VIEW

AUTHORIZATION_ITEM

REIMBURSEMENT_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

REIMBURSEMENT_ITEM

AUTHORIZATION_ITEM

PAYMENT_METHOD_KEY

PAYMENT_METHOD_KEY

 
FTTVPROV_ID NA        
FTTVTLOC_ID NA

REPORTING VIEW

AUTHORIZATION_ITEM

REIMBURSEMENT_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

AUTHORIZATION_ITEM

REIMBURSEMENT_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

REIMBURSEMENT_ITEM

AUTHORIZATION_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

AUTHORIZATION_ITEM_TAX

AUTHORIZATION_ITEM

REIMBURSEMENT_ITEM

TAX_GROUP

TAX_GROUP

TAX_GROUP

TAX_GROUP

 
USER_ID NA

REPORTING VIEW

AUTHORIZATION_ITEM

REIMBURSEMENT_ITEM

ITEM_USER_ID

ITEM_USER_ID

 


Ver: 9.2