| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| ACTIVITY_DATE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM AUTHORIZATION_ITEM |
ITEM_ACTIVITY_DATE ITEM_ACTIVITY_DATE |
NO NO |
|
| ACTUAL_AMOUNT |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
ENTERED_AMOUNT ENTERED_AMOUNT |
NO NO |
|
| ALT_PROVIDER_NAME |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
ALTERNATE_PROVIDER_NAME PROVIDER_NAME |
NO NO |
|
| CALCULATED_AMOUNT |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
CALCULATED_AMOUNT CALCULATED_AMOUNT |
NO NO |
|
| CALCULATED_APPR_AMOUNT |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
CALCULATED_AMOUNT_NO_TAX CALCULATED_AMOUNT_NO_TAX |
NO NO |
|
| CREATE_DATE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
ITEM_CREATE_DATE ITEM_CREATE_DATE |
NO NO |
|
| CREATE_SOURCE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
ITEM_CREATE_SOURCE ITEM_CREATE_SOURCE |
NO NO |
|
| CREATE_USER |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
ITEM_CREATE_USER ITEM_CREATE_USER |
NO NO |
|
| CURRENCY_CODE |
NA |
NO |
|
|
|
|
|
| CURRENCY_CONVERSION_RATE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
CURRENCY_RATE CURRENCY_RATE |
NO NO |
|
| DATA_ORIGIN |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM AUTHORIZATION_ITEM |
ITEM_DATA_ORIGIN ITEM_DATA_ORIGIN |
NO NO |
|
| DESCRIPTION |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
ITEM_DESC ITEM_DESC |
NO NO |
|
| DISTANCE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM PORTFOLIO_SUMMARY REIMBURSEMENT_ITEM |
UNITS UNITS UNITS |
NO NO NO |
|
| EXPENSE_RECEIPT_DATE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
EXPECTED_EXPENSE_DATE EXPENSE_RECEIPT_DATE |
NO NO |
|
| FTPRITIN_ID |
NA |
NO |
|
|
|
|
|
| FTRBAUTH_ID |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING AUTHORIZATION_ITEM |
AUTHORIZATION_KEY AUTHORIZATION_KEY |
NO NO |
|
| FTRBREMB_ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM REIMBURSEMENT_ACCOUNTING |
REIMBURSEMENT_KEY REIMBURSEMENT_KEY |
NO NO |
|
| FTTVCURR_ID |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
CURRENCY_KEY CURRENCY_KEY |
NO NO |
|
| FTTVDRAT_ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM AUTHORIZATION_ITEM |
UNIT_RATE_KEY UNIT_RATE_KEY |
NO NO |
|
| FTTVEXPT_ID |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
EXPENSE_TYPE_KEY EXPENSE_TYPE_KEY |
NO NO |
|
| FTTVPAYM_ID |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
PAYMENT_METHOD_KEY PAYMENT_METHOD_KEY |
NO NO |
|
| FTTVPROV_ID |
NA |
NO |
|
|
|
|
|
| FTTVTLOC_ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM AUTHORIZATION_ITEM |
TAX_LOCALE_KEY TAX_LOCALE_KEY |
NO NO |
|
| ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM AUTHORIZATION_ITEM |
EXPENSE_ITEM_KEY EXPENSE_ITEM_KEY |
NO NO |
|
| LOCATION |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM AUTHORIZATION_ITEM |
EXPENSE_LOCATION EXPENSE_LOCATION |
NO NO |
|
| PAY_AMOUNT |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM AUTHORIZATION_ITEM |
PAY_CURRENCY_AMOUNT PAY_CURRENCY_AMOUNT |
NO NO |
|
| PAY_APPR_AMOUNT |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
PAY_CURRENCY_AMOUNT_NO_TAX PAY_CURRENCY_AMOUNT_NO_TAX |
NO NO |
|
| PCARD_ID |
NA |
NO |
|
|
|
|
|
| PER_DIEM_IND |
NA |
NO |
|
|
|
|
|
| RECEIPT_TO_PAY_EXCHNG_RATE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
PAY_EXCHANGE_RATE PAY_EXCHANGE_RATE |
NO NO |
|
| TGRP_CODE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITEM_TAX REIMBURSEMENT_ITEM AUTHORIZATION_ITEM AUTHORIZATION_ITEM_TAX |
TAX_GROUP TAX_GROUP TAX_GROUP TAX_GROUP |
NO NO NO NO |
|
| USER_ID |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITEM REIMBURSEMENT_ITEM |
ITEM_USER_ID ITEM_USER_ID |
NO NO |
|