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

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

AE_EXPENSE_ITEM

ITEM_ACTIVITY_DATE

 
ACTUAL_AMOUNT NA COMPOSITE VIEW

AE_EXPENSE_ITEM

ENTERED_AMOUNT

 
ALT_PROVIDER_NAME NA COMPOSITE VIEW

AE_EXPENSE_ITEM

PROVIDER_NAME

 
CALCULATED_AMOUNT NA COMPOSITE VIEW

AE_EXPENSE_ITEM

CALCULATED_AMOUNT

 
CALCULATED_APPR_AMOUNT NA        
CREATE_DATE NA COMPOSITE VIEW

AE_EXPENSE_ITEM

ITEM_CREATE_DATE

 
CREATE_SOURCE NA COMPOSITE VIEW

AE_EXPENSE_ITEM

ITEM_CREATE_SOURCE

 
CREATE_USER NA COMPOSITE VIEW

AE_EXPENSE_ITEM

ITEM_CREATE_USER

 
CURRENCY_CODE NA COMPOSITE VIEW

AE_EXPENSE_ITEM

CURRENCY

 
CURRENCY_CONVERSION_RATE NA COMPOSITE VIEW

AE_EXPENSE_ITEM

CURRENCY_RATE

 
DATA_ORIGIN NA COMPOSITE VIEW

AE_EXPENSE_ITEM

ITEM_DATA_ORIGIN

 
DESCRIPTION NA COMPOSITE VIEW

AE_EXPENSE_ITEM

ITEM_DESC

 
DISTANCE NA COMPOSITE VIEW

AE_EXPENSE_ITEM

UNITS

 
EXPENSE_RECEIPT_DATE NA COMPOSITE VIEW

AE_EXPENSE_ITEM

EXPECTED_EXPENSE_DATE

 
FTPRITIN_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

ITINERARY_KEY

 
FTRBAUTH_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

AUTHORIZATION_KEY

 
FTRBREMB_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

REIMBURSEMENT_KEY

 
FTTVCURR_ID NA        
FTTVDRAT_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

UNIT_RATE_KEY

 
FTTVEXPT_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

EXPENSE_TYPE_KEY

 
FTTVPAYM_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

PAYMENT_METHOD_KEY

 
FTTVPROV_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

PROVIDER_KEY

 
FTTVTLOC_ID NA        
ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

EXPENSE_ITEM_KEY

 
LOCATION NA COMPOSITE VIEW

AE_EXPENSE_ITEM

EXPENSE_LOCATION

 
PAY_AMOUNT NA        
PAY_APPR_AMOUNT NA        
PCARD_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

PCARD_ID

 
PER_DIEM_IND NA COMPOSITE VIEW

AE_EXPENSE_ITEM

PER_DIEM_IND

 
RECEIPT_TO_PAY_EXCHNG_RATE NA        
TGRP_CODE NA        
USER_ID NA COMPOSITE VIEW

AE_EXPENSE_ITEM

ITEM_USER_ID

 


Ver: