Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACTUAL_TAX_AMOUNT	Actual Tax Amount	Summarized receipt tax portion of the entered receipt amount.	NUMBER	FUNCTION	MEKFUNC.F_GET_TAX_AMOUNT(E.EXPENSE_ITEM_KEY,'A')
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CALCULATED_AMOUNT	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	Calculated Amount Number Tax	Amount for the expense in base currency without taxes.	NUMBER	FTPREXPS	CALCULATED_APPR_AMOUNT
CALCULATED_TAX_AMOUNT	Calculated Tax Amount	Summarized tax amount calculated in base currency.	NUMBER	FUNCTION	MEKFUNC.F_GET_TAX_AMOUNT(E.EXPENSE_ITEM_KEY,'C')
COMMODITY	Commodity	User defined code associated with this commodity known in Banner Finance. This is associated with the expense group item and used to populate the commodity code on the generated invoice.	VARCHAR2(63)	FTTVEXPG	COMMODITY_CODE
COMMODITY_DESC	Commodity Description	Commodity description.	VARCHAR2(255)	FTVCOMM	FTVCOMM_DESC
CURRENCY_DESC	Currency Description	Currency code description or title.	VARCHAR2(255)	GTVCURR	GTVCURR_TITLE
CURRENCY_KEY	Currency KEY	Unique internal identification number of the currency record.	NUMBER	FTPREXPS	FTTVCURR_ID
CURRENCY_RATE	Currency Rate	Conversion rate on which to base the currency amount determined by the expense receipt date.	NUMBER	FTPREXPS	CURRENCY_CONVERSION_RATE
ENTERED_AMOUNT	Entered Amount	Actual amount entered for the expense item, that can be entered in foreign currency.	NUMBER	FTPREXPS	ACTUAL_AMOUNT
EXPENSE_ADVANCE_CLEARED_IND	Expense Advance Cleared Indicator	Indicates whether the expense type is for an advance cleared amount	VARCHAR2(1)	CALCULATION	DECODE(C.EXPENSE_TYPE_CODE, '9900ADVC','Y','N')
EXPENSE_CURRENCY	Expense Currency	Foreign currency code used for the entered expense amount.	VARCHAR2(63)	FTTVCURR	CURRENCY_CODE
EXPENSE_GROUP_ITEM	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	Expense Group KEY	Unique internal identification number of the expense group record.	NUMBER	FTTVEXPT	FTTVEXPG_ID
EXPENSE_GROUP_NAME	Expense Group Name	Unique internal identification number of the expense group record. Used to group expense types.	VARCHAR2(255)	FTTVEXPG	NAME
EXPENSE_ITEM_KEY	Expense Item KEY	Unique internal identification number of the expense item record.	NUMBER	FTPREXPS	ID
EXPENSE_LOCATION	Expense Location	Location where the expense is incurred.	VARCHAR2(63)	FTPREXPS	LOCATION
EXPENSE_RECEIPT_DATE	Expense Receipt Date	Receipt date of the expense item.	DATE	FTPREXPS	EXPENSE_RECEIPT_DATE
EXPENSE_TYPE	Expense Type	Expense type unique code identification identifying the type of expense.	VARCHAR2(63)	FTTVEXPT	EXPENSE_TYPE_CODE
EXPENSE_TYPE_DESC	Expense Type Description	Expense type long description.	VARCHAR2(255)	FTTVEXPT	DESCRIPTION
EXPENSE_TYPE_KEY	Expense Type KEY	Unique internal identification number of the expense type record.	NUMBER	FTPREXPS	FTTVEXPT_ID
EXPENSE_TYPE_NAME	Expense Type Name	Name assigned to the expense type.	VARCHAR2(255)	FTTVEXPT	NAME
EXPENSE_TYPE_SHORT_DESC	Expense Type Short Description	Expense type short description.	VARCHAR2(255)	FTTVEXPT	SHORT_NAME
FISCAL_PERIOD	Fiscal Period	Unique identifier for a period within a fiscal year. Generally a fiscal period would be a value between 00 and 14.	VARCHAR2(63)	FUNCTION	SELECT SUBSTR(FISCAL_PERIOD,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE
FISCAL_YEAR	Fiscal Year	Unique identifier or code for the fiscal year.	VARCHAR2(63)	FUNCTION	SELECT SUBSTR(FISCAL_YEAR,1,63) FROM MFT_FISCAL_PERIOD F WHERE CHART_OF_ACCOUNTS = F.CHART_OF_ACCOUNTS AND TRANSACTION_DATE BETWEEN F.PERIOD_START_DATE AND F.PERIOD_END_DATE
INSTITUTION_CREDIT_CARD_IND	Institution Credit Card Indicator	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	Item Activity Date	Date information for this record in the table was entered or last updated.	DATE	FTPREXPS	ACTIVITY_DATE
ITEM_CREATE_DATE	Item Create Date	Date and time when the new expense detail record was created.	DATE	FTPREXPS	CREATE_DATE
ITEM_CREATE_SOURCE	Item Create Source	Source system that created the data.	VARCHAR2(63)	FTPREXPS	CREATE_SOURCE
ITEM_CREATE_USER	Item Create User	Banner ID of the person who created this new record.	VARCHAR2(63)	FTPREXPS	CREATE_USER
ITEM_DATA_ORIGIN	Item Data Origin	Source system that created or updated the data.	VARCHAR2(63)	FTPREXPS	DATA_ORIGIN
ITEM_DESC	Item Description	Expense item description.	VARCHAR2(255)	FTPREXPS	DESCRIPTION
ITEM_USER_ID	Item User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	FTPREXPS	USER_ID
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
PAYMENT_METHOD	Payment Method	Payment method unique code identification.	VARCHAR2(63)	FTTVPAYM	PAYMENT_METHOD_CODE
PAYMENT_METHOD_DESC	Payment Method Description	Payment method long description.	VARCHAR2(255)	FTTVPAYM	DESCRIPTION
PAYMENT_METHOD_KEY	Payment Method KEY	Unique internal identification number of the payment method record.	NUMBER	FTPREXPS	FTTVPAYM_ID
PAYMENT_METHOD_NAME	Payment Method Name	Name assigned to the payment method. As an example, Ghost Card, Personal Credit Card.	VARCHAR2(255)	FTTVPAYM	NAME
PAY_CURRENCY_AMOUNT	Pay Currency Amount	Amount to be paid to the traveler in pay currency.	NUMBER	FTPREXPS	PAY_AMOUNT
PAY_CURRENCY_AMOUNT_NO_TAX	Pay Currency Amount Number Tax	Amount to be paid to the traveler in pay currency without taxes.	NUMBER	FTPREXPS	PAY_APPR_AMOUNT
PAY_CURRENCY_IND	Pay Currency Indicator	Indicates whether the institution supports payment to be made in this currency.	VARCHAR2(1)	FTTVCURR	PAY_CURRENCY_IND
PAY_CURRENCY_TAX_AMOUNT	Pay Currency Tax Amount	Summarized tax amount calculated in pay currency.	NUMBER	FUNCTION	MEKFUNC.F_GET_TAX_AMOUNT(E.EXPENSE_ITEM_KEY,'P')
PAY_EXCHANGE_RATE	Pay Exchange Rate	Conversion rate used in converting receipt amount to pay amount.	NUMBER	FTPREXPS	RECEIPT_TO_PAY_EXCHNG_RATE
PERSONAL_CREDIT_CARD_IND	Personal Credit Card Indicator	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
PORTFOLIO	Portfolio	System generated code identifying the portfolio. The prefix is defined by the client for system ID TRAVPORT in the table fobfseq.	VARCHAR2(63)	FTPBPORT	PORTFOLIO_NUMBER
PORTFOLIO_KEY	Portfolio KEY	Unique internal identification number of the portfolio record.	NUMBER	FTRBREMB	FTPBPORT_ID
PORTFOLIO_NAME	Portfolio Name	Name assigned to the Portfolio. As an example, Office expenses for year 2008 or Recruiting Trip in Southern California.	VARCHAR2(63)	FTPBPORT	NAME
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROVIDER_NAME	Provider Name	Name of a provider for an expense that is used instead of a predefined provider name.	VARCHAR2(255)	FTPREXPS	ALT_PROVIDER_NAME
PURCHASE_CARD_ID	Purchase Card ID	Information only. The last four digits of the institution procurement card used in Banner Finance. The procurement card is maintained by the institution and billed to the institution. It may be used to assist in client developed reconciliation with Banner PCARD functionality.	VARCHAR2(63)	FTTVPAYM	NVL(PCARD_ID)
REIMBURSABLE_IND	Reimbursable Indicator	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	Reimbursement	System generated code identifying the reimbursement. The prefix is defined by the client for system ID TRAVREIM in the table fobfseq.	VARCHAR2(63)	FTRBREMB	DOC_CODE
REIMBURSEMENT_DESC	Reimbursement Description	Reimbursement request description.	VARCHAR2(255)	FTRBREMB	DESCRIPTION
REIMBURSEMENT_KEY	Reimbursement KEY	Unique internal identification number of the reimbursement record.	NUMBER	FTPREXPS	FTRBREMB_ID
REIMBURSEMENT_STATUS	Reimbursement Status	Reimbursement request status.	VARCHAR2(63)	FTRBREMB	REQUEST_STATUS
REIMBURSEMENT_STATUS_DESC	Reimbursement Status Description	Reimbursement request status description.	VARCHAR2(255)	FUNCTION	SELECT SUBSTR(VALUE_DESCRIPTION,1,255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'REQUEST_STATUS' AND VALUE = REIMBURSEMENT_STATUS
REIMBURSE_CURRENCY	Reimburse Currency	Currency code used to indicate the currency in which to be reimbursed.	VARCHAR2(63)	FTTVCURR	CURRENCY_CODE
REIMBURSE_CURRENCY_DESC	Reimburse Currency Description	Currency code description or title.	VARCHAR2(255)	GUACURR	GTVCURR_TITLE
TAX_GROUP	Tax Group	Tax group associated with the expense type and tax locale.	VARCHAR2(63)	FTPREXPS	TGRP_CODE
TAX_GROUP_DESC	Tax Group Description	Tax group associated with the tax locale.	VARCHAR2(255)	FTVTGRP	FTVTGRP_TITLE
TAX_LOCALE	Tax Locale	Tax Locale unique name indentification.	VARCHAR2(63)	FTTVTLOC	TAX_LOCALE
TAX_LOCALE_DESC	Tax Locale Description	Tax Locale description.	VARCHAR2(255)	FTTVTLOC	DESCRIPTION
TAX_LOCALE_KEY	Tax Locale KEY	Unique internal identification number of the Tax Locale record.	NUMBER	FTPREXPS	FTTVTLOC_ID
TRANSACTION_DATE	Transaction Date	Date used to post the invoice into the ledgers for payment, determining the fiscal year and posting period. Represents the create date of the reimbursement.	DATE	FTRBREMB	TRANSACTION_DATE
UNITS	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	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	Unit Rate End Date	End date that applies to the rate.	DATE	FTTVDRAT	END_DATE
UNIT_RATE_KEY	Unit Rate KEY	Unique internal identification number of the unit rate record.	NUMBER	FTPREXPS	FTTVDRAT_ID
UNIT_RATE_LONG_DESC	Unit Rate Long Description	Unit rate long description.	VARCHAR2(255)	FTTVDRAT	DESCRIPTION
UNIT_RATE_NAME	Unit Rate Name	Unit rate name.	VARCHAR2(255)	FTTVDRAT	NAME
UNIT_RATE_START_DATE	Unit Rate Start Date	Effective date that applies to the rate.	DATE	FTTVDRAT	START_DATE

Ver: 9.2