| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| ACTIVITY_DATE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_ACTIVITY_DATE |
NO |
|
| COMPLETE_USER |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_COMPLETE_USER |
NO |
|
| CREATE_DATE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_CREATE_DATE |
NO |
|
| CREATE_SOURCE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_CREATE_SOURCE |
NO |
|
| CREATE_USER |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_CREATE_USER |
NO |
|
| CURRENCY_CODE |
NA |
NO |
|
|
|
|
|
| DATA_ORIGIN |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_DATA_ORIGIN |
NO |
|
| DESCRIPTION |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY REIMBURSEMENT_STATUS_HISTORY REIMBURSEMENT_ITEM REIMBURSEMENT_ACCOUNTING REIMBURSEMENT REIMBURSEMENT_APPROVAL_HISTORY |
REIMBURSEMENT_DESC REIMBURSEMENT_DESC REIMBURSEMENT_DESC REIMBURSEMENT_DESC REIMBURSEMENT_DESC REIMBURSEMENT_DESC |
NO NO NO NO NO NO |
|
| DIRECT_DEPOSIT_OVERRIDE_IND |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
DIRECT_DEPOSIT_OVERRIDE_IND |
NO |
|
| DOC_CODE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_STATUS_HISTORY REIMBURSEMENT REIMBURSEMENT_ACCOUNTING REIMBURSEMENT_ITINERARY REIMBURSEMENT_APPROVAL_HISTORY REIMBURSEMENT_ITEM |
REIMBURSEMENT REIMBURSEMENT REIMBURSEMENT REIMBURSEMENT REIMBURSEMENT REIMBURSEMENT |
NO NO NO NO NO NO |
|
| EMAIL_ADDRESS |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
OWNER_EMAIL |
NO |
|
| FTPBPORT_ID |
TBD |
NO |
REPORTING VIEW |
REIMBURSEMENT_STATUS_HISTORY REIMBURSEMENT REIMBURSEMENT_ACCOUNTING REIMBURSEMENT_ITEM |
PORTFOLIO_KEY PORTFOLIO_KEY PORTFOLIO_KEY PORTFOLIO_KEY |
NO NO NO NO |
|
| FTRBREMB_OWNER_PIDM |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_APPROVAL_HISTORY |
OWNER_UID |
NO |
|
| FTTVAFFL_ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
AFFILIATION_KEY |
NO |
|
| FTTVCURR_ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
CURRENCY_KEY |
NO |
|
| ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_KEY |
NO |
|
| NAME |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REPORT_NAME |
NO |
|
| OWNER_ADDRESS_SEQ_NUM |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
OWNER_ADDRESS_NUMBER |
NO |
|
| OWNER_ADDRESS_TYPE_CODE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
OWNER_ADDRESS_TYPE |
NO |
|
| OWNER_PIDM |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
OWNER_UID |
NO |
|
| PAYEE_ADDRESS_SEQ_NUM |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
PAYEE_ADDRESS_NUMBER |
NO |
|
| PAYEE_ADDRESS_TYPE_CODE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
PAYEE_ADDRESS_TYPE |
NO |
|
| PAYEE_PIDM |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
PAYEE_UID |
NO |
|
| PAY_BY_WIRE_IND |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
WIRE_REIMBURSEMENT_IND |
NO |
|
| PAY_TO_BASE_EXCHNG_RATE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
PAY_CURRENCY_EXCHANGE_RATE |
NO |
|
| REQUEST_STATUS |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY REIMBURSEMENT_ACCOUNTING REIMBURSEMENT REIMBURSEMENT_ITEM |
REIMBURSEMENT_STATUS REIMBURSEMENT_STATUS REIMBURSEMENT_STATUS REIMBURSEMENT_STATUS |
NO NO NO NO |
|
| SENT_TO_TRAVELER_BY |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
DELEGATE_UID |
NO |
|
| SENT_TO_TRAVELER_DATE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REVIEW_SUBMIT_DATE |
NO |
|
| STATUS_DATE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_STATUS_DATE |
NO |
|
| TRANSACTION_DATE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING REIMBURSEMENT_ITEM REIMBURSEMENT |
TRANSACTION_DATE TRANSACTION_DATE TRANSACTION_DATE |
NO NO NO |
|
| USER_COMMENT |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_COMMENT |
NO |
|
| USER_ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
REIMBURSEMENT_USER_ID |
NO |
|
| WIRE_BASE_AMOUNT |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
WIRE_AMOUNT |
NO |
|
| WIRE_DATE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
WIRE_DATE |
NO |
|
| WIRE_REF_NUM |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT |
WIRE_REFERENCE_NUMBER |
NO |
|