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
|