Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: FTCRACTG Travel And Expense
Banner Operational Data Store Composite View Source: FTCRACTG - NULL

Source Column Source Form Local Source Target Type Target Target Column Local Target Calculation Formula
ACCI_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

ACCOUNT_INDEX

NO

 
ACCT_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

ACCOUNT

NO

 
ACTIVITY_DATE NA NO COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_ACTIVITY_DATE

NO

 
ACTV_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

ACTIVITY

NO

 
AMOUNT NA NO COMPOSITE VIEW

AE_ACCOUNTING

AMOUNT

NO

 
APPR_AMOUNT NA NO          
BANK_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

BANK

NO

 
COAS_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

CHART_OF_ACCOUNTS

NO

 
CREATE_DATE NA NO COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_CREATE_DATE

NO

 
CREATE_SOURCE NA NO COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_CREATE_SOURCE

NO

 
CREATE_USER NA NO COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_CREATE_USER

NO

 
DATA_ORIGIN NA NO COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_DATA_ORIGIN

NO

 
FTOBPROF_ID TBD NO COMPOSITE VIEW

AE_ACCOUNTING

PROFILE_KEY

NO

 
FTPBPORT_ID TBD NO COMPOSITE VIEW

AE_ACCOUNTING

PORTFOLIO_KEY

NO

 
FTPREXPS_ID NA NO COMPOSITE VIEW

AE_ACCOUNTING

EXPENSE_ITEM_KEY

NO

 
FUND_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

FUND

NO

 
ID NA NO COMPOSITE VIEW

AE_ACCOUNTING

ACCOUNTING_KEY

NO

 
LOCN_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

LOCATION

NO

 
ORACLE_ID NA NO COMPOSITE VIEW

AE_ACCOUNTING

FINANCE_SECURITY_ID

NO

 
ORGN_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

ORGANIZATION_CODE

NO

 
PAY_AMOUNT NA NO          
PAY_APPR_AMOUNT NA NO          
PERCENT_OF_TOTAL NA NO COMPOSITE VIEW

AE_ACCOUNTING

DISTRIBUTION_PERCENT

NO

 
PROG_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

PROGRAM

NO

 
PROJ_CODE NA NO COMPOSITE VIEW

AE_ACCOUNTING

PROJECT

NO

 
USER_ID NA NO COMPOSITE VIEW

AE_ACCOUNTING

FUNDING_USER_ID

NO

 


Ver: