Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: FTPRETAX Travel And Expense Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: FTPRETAX - NULL

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

REPORTING VIEW

REIMBURSEMENT_ITEM_TAX

AUTHORIZATION_ITEM_TAX

TAX_ITEM_ACTIVITY_DATE

TAX_ITEM_ACTIVITY_DATE

 
ACTUAL_TAX_AMOUNT NA

REPORTING VIEW

AUTHORIZATION_ITEM_TAX

REIMBURSEMENT_ITEM_TAX

ACTUAL_TAX_AMOUNT

ACTUAL_TAX_AMOUNT

 
CALCULATED_TAX_AMOUNT NA

REPORTING VIEW

AUTHORIZATION_ITEM_TAX

REIMBURSEMENT_ITEM_TAX

CALCULATED_TAX_AMOUNT

CALCULATED_TAX_AMOUNT

 
DATA_ORIGIN NA

REPORTING VIEW

REIMBURSEMENT_ITEM_TAX

AUTHORIZATION_ITEM_TAX

TAX_ITEM_DATA_ORIGIN

TAX_ITEM_DATA_ORIGIN

 
FTPREXPS_ID NA

REPORTING VIEW

REIMBURSEMENT_ITEM_TAX

AUTHORIZATION_ITEM_TAX

EXPENSE_ITEM_KEY

EXPENSE_ITEM_KEY

 
ID NA

REPORTING VIEW

AUTHORIZATION_ITEM_TAX

REIMBURSEMENT_ITEM_TAX

EXPENSE_TAX_ITEM_KEY

EXPENSE_TAX_ITEM_KEY

 
PAY_TAX_AMOUNT NA

REPORTING VIEW

REIMBURSEMENT_ITEM_TAX

AUTHORIZATION_ITEM_TAX

PAY_TAX_AMOUNT

PAY_TAX_AMOUNT

 
TAX_RATE_CODE NA

REPORTING VIEW

AUTHORIZATION_ITEM_TAX

REIMBURSEMENT_ITEM_TAX

TAX_RATE

TAX_RATE

 
USER_ID NA

REPORTING VIEW

REIMBURSEMENT_ITEM_TAX

AUTHORIZATION_ITEM_TAX

TAX_ITEM_USER_ID

TAX_ITEM_USER_ID

 


Ver: 8.5