| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| FTVACCT_ACCT_CLASS_CODE |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY AF_GRANT_LEDGER AF_ACCOUNT_HIERARCHY_FISCAL |
ACCOUNT_CLASS ACCOUNT_CLASS ACCOUNT_CLASS |
NO NO NO |
NA |
| FTVACCT_ACCT_CODE |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY |
ACCOUNT ACCOUNT |
NO NO |
NA |
| FTVACCT_ATYP_CODE |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY |
ACCOUNT_TYPE ACCOUNT_TYPE |
NO NO |
NA |
| FTVACCT_COAS_CODE |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY |
CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS |
NO NO |
NA |
| FTVACCT_DATA_ENTRY_IND |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY_FISCAL AF_VALIDATION AF_ACCOUNT_HIERARCHY |
DATA_ENTRY_PERMITTED DATA_ENTRY_IND DATA_ENTRY_PERMITTED |
NO NO NO |
NA |
| FTVACCT_EFF_DATE |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY_FISCAL |
EFFECTIVE_DATE |
NO |
|
| FTVACCT_NCHG_DATE |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY_FISCAL |
NEXT_CHANGE_DATE |
NO |
NA |
| FTVACCT_NORMAL_BAL |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY |
NORMAL_BALANCE NORMAL_BALANCE |
NO NO |
NA |
| FTVACCT_STATUS_IND |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL |
ACCOUNT_STATUS ACCOUNT_STATUS |
NO NO |
NA |
| FTVACCT_TERM_DATE |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_HIERARCHY_FISCAL AF_ACCOUNT_HIERARCHY |
TERMINATION_DATE TERMINATION_DATE |
NO NO |
NA |
| FTVACCT_TITLE |
FTMACCT |
NO |
COMPOSITE VIEW |
AF_ACCOUNT_ATTRIBUTES_ODS AF_ACCOUNT_HIERARCHY
AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY
AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY
AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY
AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY
AF_ACCOUNT_HIERARCHY AN_PERSONNEL_ACTION_LABOR_DIST
AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY
AF_ACCOUNT_HIERARCHY AF_ACCOUNT_HIERARCHY_FISCAL
AP_PAYROLL_LABOR_DIST_OVERRIDE
|
ACCOUNT_DESC ACCOUNT_DESC
CTRL_ACTUAL_ACTIVITY_DESC CTRL_ADOPTED_BUDGET_PY_DESC
CTRL_ENCUMBRANCE_DESC CTRL_ACTUAL_ACTIVITY_PY_DESC
CTRL_BUDGET_RESERVE_PY_DESC CTRL_TEMPORARY_BUDGET_DESC
CTRL_ENCUMBRANCE_PY_DESC CTRL_TEMPORARY_BUDGET_PY_DESC
CTRL_BUDGET_RESERVE_DESC ACCOUNT_DESC
CTRL_BUDGET_ADJUSTMENT_PY_DESC CTRL_ADOPTED_BUDGET_DESC
CTRL_BUDGET_ADJUSTMENT_DESC ACCOUNT_DESC
POSITION_ACCOUNT_DESC
|
NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO |
NA |