Composite View Source: FTPREXPS

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

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target
ACTIVITY_DATE	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ITEM_ACTIVITY_DATE	NO
ACTUAL_AMOUNT	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ENTERED_AMOUNT	NO
ALT_PROVIDER_NAME	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	PROVIDER_NAME	NO
CALCULATED_AMOUNT	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	CALCULATED_AMOUNT	NO
CALCULATED_APPR_AMOUNT	NA	NO
CREATE_DATE	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ITEM_CREATE_DATE	NO
CREATE_SOURCE	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ITEM_CREATE_SOURCE	NO
CREATE_USER	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ITEM_CREATE_USER	NO
CURRENCY_CODE	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	CURRENCY	NO
CURRENCY_CONVERSION_RATE	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	CURRENCY_RATE	NO
DATA_ORIGIN	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ITEM_DATA_ORIGIN	NO
DESCRIPTION	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ITEM_DESC	NO
DISTANCE	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	UNITS	NO
EXPENSE_RECEIPT_DATE	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	EXPECTED_EXPENSE_DATE	NO
FTPRITIN_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ITINERARY_KEY	NO
FTRBAUTH_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	AUTHORIZATION_KEY	NO
FTRBREMB_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	REIMBURSEMENT_KEY	NO
FTTVCURR_ID	NA	NO
FTTVDRAT_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	UNIT_RATE_KEY	NO
FTTVEXPT_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	EXPENSE_TYPE_KEY	NO
FTTVPAYM_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	PAYMENT_METHOD_KEY	NO
FTTVPROV_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	PROVIDER_KEY	NO
FTTVTLOC_ID	NA	NO
ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	EXPENSE_ITEM_KEY	NO
LOCATION	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	EXPENSE_LOCATION	NO
PAY_AMOUNT	NA	NO
PAY_APPR_AMOUNT	NA	NO
PCARD_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	PCARD_ID	NO
PER_DIEM_IND	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	PER_DIEM_IND	NO
RECEIPT_TO_PAY_EXCHNG_RATE	NA	NO
TGRP_CODE	NA	NO
USER_ID	NA	NO	COMPOSITE VIEW	AE_EXPENSE_ITEM	ITEM_USER_ID	NO

Ver: