Source Column |
Source Form |
Target Type |
Target |
Target Column |
Calculation Formula |
ACCI_CODE |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING |
ACCOUNT_INDEX ACCOUNT_INDEX ACCOUNT_INDEX_DEFAULT |
|
ACCT_CODE |
NA |
REPORTING VIEW |
PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
ACCOUNT_DEFAULT ACCOUNT ACCOUNT |
|
ACTIVITY_DATE |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
FUNDING_ACTIVITY_DATE PROFILE_FUNDING_ACTIVITY_DATE FUNDING_ACTIVITY_DATE |
|
ACTV_CODE |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING |
ACTIVITY ACTIVITY ACTIVITY_DEFAULT |
|
AMOUNT |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
AMOUNT AMOUNT |
|
APPR_AMOUNT |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
CALCULATED_AMOUNT_NO_TAX CALCULATED_AMOUNT_NO_TAX |
|
BANK_CODE |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING |
BANK |
|
COAS_CODE |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS_DEFAULT CHART_OF_ACCOUNTS |
|
CREATE_DATE |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
FUNDING_CREATE_DATE FUNDING_CREATE_DATE |
|
CREATE_SOURCE |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
FUNDING_CREATE_SOURCE FUNDING_CREATE_SOURCE |
|
CREATE_USER |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
FUNDING_CREATE_USER FUNDING_CREATE_USER |
|
DATA_ORIGIN |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
FUNDING_DATA_ORIGIN PROFILE_FUNDING_DATA_ORIGIN FUNDING_DATA_ORIGIN |
|
FTOBPROF_ID |
TBD |
|
|
|
|
FTPBPORT_ID |
TBD |
|
|
|
|
FTPREXPS_ID |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
EXPENSE_ITEM_KEY EXPENSE_ITEM_KEY |
|
FUND_CODE |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
FUND FUND_DEFAULT FUND |
|
ID |
NA |
|
|
|
|
LOCN_CODE |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING |
LOCATION LOCATION LOCATION_DEFAULT |
|
ORACLE_ID |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
FINANCE_SECURITY_ID FINANCE_SECURITY_ID |
|
ORGN_CODE |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
ORGANIZATION_CODE ORGANIZATION_DEFAULT ORGANIZATION_CODE |
|
PAY_AMOUNT |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
PAY_CURRENCY_AMOUNT PAY_CURRENCY_AMOUNT |
|
PAY_APPR_AMOUNT |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
PAY_CURRENCY_AMOUNT_NO_TAX PAY_CURRENCY_AMOUNT_NO_TAX |
|
PERCENT_OF_TOTAL |
NA |
REPORTING VIEW |
REIMBURSEMENT_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
DISTRIBUTION_PERCENT DISTRIBUTION_PERCENT DISTRIBUTION_PERCENT |
|
PROG_CODE |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
PROGRAM PROGRAM_DEFAULT PROGRAM |
|
PROJ_CODE |
NA |
REPORTING VIEW |
PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING AUTHORIZATION_ACCOUNTING |
PROJECT_DEFAULT PROJECT PROJECT |
|
USER_ID |
NA |
REPORTING VIEW |
AUTHORIZATION_ACCOUNTING PROFILE_DEFAULT_ACCOUNTING REIMBURSEMENT_ACCOUNTING |
FUNDING_USER_ID PROFILE_FUNDING_USER_ID FUNDING_USER_ID |
|