Composite View Source: FTPREXPS

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: FTPREXPS Travel And Expense

**SGHE Banner Operational Data Store**
Source Column	Source Form	Target Type	Target	Target Column
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: