Target Column	Business Definition	Database Data Type	Source Name	Source Column
AUTHORIZATION_KEY	Unique internal identification number of the authorization record.	NUMBER	FTPREXPS	FTRBAUTH_ID
CALCULATED_AMOUNT	Depending on the expense type format, could represent the base currency amount for the expense item represented by dividing the entered foreign amount by the conversion rate, rounded to 2 decimals. Could represent calculated per diem rate. Could represent number of units times the rate if using distance rate.	NUMBER	FTPREXPS	CALCULATED_AMOUNT
CALCULATED_AMOUNT_NO_TAX		NUMBER
COMMODITY	User defined code associated with this commodity. This is associated with the expense group item and used to populate the commodity code on the generated invoice.	VARCHAR2(10)	FTTVEXPG	COMMODITY_CODE
COMMODITY_DESC	Commodity description.	VARCHAR2(50)	FTVCOMM	FTVCOMM_DESC
CURRENCY	Foreign currency code used for the entered expense amount.	VARCHAR2(4)	FTPREXPS	CURRENCY_CODE
CURRENCY_DESC	Currency code description or title.	VARCHAR2(35)	GTVCURR	GTVCURR_TITLE
CURRENCY_KEY		NUMBER
CURRENCY_RATE	Conversion rate on which to base the currency amount determined by the expense receipt date.	NUMBER	FTPREXPS	CURRENCY_CONVERSION_RATE
CURRENT_DATE	This is a the system current date (sysdate).	DATE	NA	SYSDATE
DOMAIN_VALUE	Domain column for future use, not currently populated.	VARCHAR2(6)	NA	NA
ENTERED_AMOUNT	Actual amount entered for the expense item, that can be entered in foreign currency.	NUMBER	FTPREXPS	ACTUAL_AMOUNT
EXPECTED_EXPENSE_DATE	Expected expense date of the expense item.	DATE	FTPREXPS	EXPENSE_RECEIPT_DATE
EXPENSE_ADVANCE_CLEARED_IND		VARCHAR2(1)
EXPENSE_GROUP_ITEM	Groups expense items into one encumbrance line item or one invoice line item. Enables the liquidation of an encumbrance (travel authorization) by an invoice (travel reimbursement) line item by line item.	NUMBER	FTTVEXPG	EXPENSE_GROUP_ITEM
EXPENSE_GROUP_KEY	Unique internal identification number of the expense group record.	NUMBER	FTTVEXPT	FTTVEXPG_ID
EXPENSE_GROUP_NAME	Unique internal identification number of the expense group record. Used to group expense types.	VARCHAR2(50)	FTTVEXPG	NAME
EXPENSE_ITEM_KEY	Unique internal identification number of the expense item record.	NUMBER	FTPREXPS	ID
EXPENSE_LOCATION	Location where the expense is incurred.	VARCHAR2(60)	FTPREXPS	LOCATION
EXPENSE_TYPE	Expense type unique code identification identifying the type of expense.	VARCHAR2(8)	FTTVEXPT	FTTVEXPT_ID
EXPENSE_TYPE_DESC	Expense type long description.	VARCHAR2(255)	FTTVEXPT	DESCRIPTION
EXPENSE_TYPE_KEY	Unique internal identification number of the expense type record.	NUMBER	FTPREXPS	FTTVEXPT_ID
EXPENSE_TYPE_NAME	Name assigned to the expense type.	VARCHAR2(60)	FTTVEXPT	NAME
EXPENSE_TYPE_SHORT_DESC	Expense type short description.	VARCHAR2(25)	FTTVEXPT	SHORT_NAME
INSTITUTION_CREDIT_CARD_IND	Determines if the payment method uses the institution's credit card. (Y)es, the payment method uses the institutions credit card. (N)o, the payment method does not use the institutions credit card. If (Y)es, then the expense is not reimbursable.	VARCHAR2(1)	FTTVPAYM	INSTITUTION_CARD_IND
ITEM_ACTIVITY_DATE	Date information for this record in the table was entered or last updated.	DATE	FTPREXPS	ACTIVITY_DATE
ITEM_CREATE_DATE	Date and time when the new expense detail record was created.	DATE	FTPREXPS	CREATE_DATE
ITEM_CREATE_SOURCE	Source system that created the data.	VARCHAR2(30)	FTPREXPS	CREATE_SOURCE
ITEM_CREATE_USER	ID of the person who created this new record.	VARCHAR2(30)	FTPREXPS	CREATE_USER
ITEM_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(30)	FTPREXPS	DATA_ORIGIN
ITEM_DESC	Expense item description.	VARCHAR2(255)	FTPREXPS	DESCRIPTION
ITEM_USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	FTPREXPS	USER_ID
ITINERARY_KEY	Unique internal identification number of the itinerary record.	NUMBER	FTPREXPS	FTPRITIN_ID
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
PAYMENT_METHOD	Payment method unique code identification.	VARCHAR2(8)	FTTVPAYM	PAYMENT_METHOD_CODE
PAYMENT_METHOD_DESC	Payment method long description.	VARCHAR2(255)	FTTVPAYM	DESCRIPTION
PAYMENT_METHOD_KEY	Unique internal identification number of the payment method record.	NUMBER	FTPREXPS	FTTVPAYM_ID
PAYMENT_METHOD_NAME	Name assigned to the payment method. As an example, Ghost Card, Personal Credit Card.	VARCHAR2(60)	FTTVPAYM	NAME
PAY_CONVERSION_EXCHANGE_RATE		NUMBER
PAY_CURRENCY_AMOUNT		NUMBER
PAY_CURRENCY_AMOUNT_NO_TAX		NUMBER
PAY_CURRENCY_IND		VARCHAR2(1)
PCARD_ID	The last four digits of the institution procurement card. The procurement card maintained by the institutution and billed to the institution.	VARCHAR2(4)	FTPREXPS	PCARD_ID
PERSONAL_CREDIT_CARD_IND	Determines if the payment method uses the expense owner's personal credit card. (Y)es, the payment method uses a personal credit card. (N)o, the payment method does not use a personal credit card. If (Y)es, then the expense is not reimbursable.	VARCHAR2(1)	FTTVPAYM	INDIVIDUAL_CARD_IND
PER_DIEM_IND	Indicates if the expense was for per diem. This expense uses per diem rates.	VARCHAR2(1)	FTPREXPS	PER_DIEM_IND
PROVIDER_KEY	Unique internal identification number of the provider record.	NUMBER	FTPREXPS	FTTVPROV_ID
PROVIDER_NAME	Name of a provider for an expense that is used instead of a predefined provider name.	VARCHAR2(60)	FTPREXPS	ALT_PROVIDER_NAME
PURCHASE_CARD_ID	Information only. The last four digits of the institution procurement card. The procurement card is maintained by the institution and billed to the institution.	VARCHAR2(4)	CALCULATION	NVL(FTPREXPS.PCARD_ID, FTTVPAYM.PCARD_ID)
REIMBURSABLE_IND	Determines if the payment method is expense reimbursable or not. (Y)es, payment method is reimbursable. (N)o, payment method is not reimbursable.	VARCHAR2(1)	FTTVPAYM	REIMBURSE_IND
REIMBURSEMENT_KEY	Unique internal identification number of the reimbursement record.	NUMBER	FTPREXPS	FTRBREMB_ID
TAX_GROUP		VARCHAR2(4)
TAX_GROUP_DESC		VARCHAR2(35)
TAX_LOCALE		VARCHAR2(25)
TAX_LOCALE_DESC		VARCHAR2(255)
TAX_LOCALE_KEY		NUMBER
UNITS	Typically used as distance in the number of miles or kilometers, etc. driven from and to a location. May also be used for other types of units like per diem.	NUMBER	FTPREXPS	DISTANCE
UNIT_RATE	Rate to use multiplied by the distance units calculating a total amount for the expense item. Typically used to determine costs when using ones own vehicle. May be used for other types of expense like per diem rates.	NUMBER	FTTVDRAT	RATE
UNIT_RATE_END_DATE	End date that applies to the rate.	DATE	FTTVDRAT	END_DATE
UNIT_RATE_KEY	Unique internal identification number of the unit rate record.	NUMBER	FTPREXPS	FTTVDRAT_ID
UNIT_RATE_LONG_DESC	Unit rate long description.	VARCHAR2(255)	FTTVDRAT	DESCRIPTION
UNIT_RATE_NAME	Unit rate name.	VARCHAR2(60)	FTTVDRAT	NAME
UNIT_RATE_START_DATE	Effective date that applies to the rate.	DATE	FTTVDRAT	START_DATE
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA

Ver: