| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| ACTIVITY_DATE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
ITINERARY_ACTIVITY_DATE ITINERARY_ACTIVITY_DATE |
NO NO |
|
| CREATE_DATE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
ITINERARY_CREATE_DATE ITINERARY_CREATE_DATE |
NO NO |
|
| CREATE_SOURCE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY |
ITINERARY_CREATE_SOURCE ITINERARY_CREATE_SOURCE |
NO NO |
|
| CREATE_USER |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
ITINERARY_CREATE_USER ITINERARY_CREATE_USER |
NO NO |
|
| DATA_ORIGIN |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
DATA_ORIGIN DATA_ORIGIN |
NO NO |
|
| END_DATE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
TRAVEL_END_DATE TRAVEL_END_DATE |
NO NO |
|
| FROM_CITY |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
TRAVEL_FROM_CITY TRAVEL_FROM_CITY |
NO NO |
|
| FROM_NATN_CODE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY |
TRAVEL_FROM_NATION TRAVEL_FROM_NATION |
NO NO |
|
| FROM_STAT_CODE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
TRAVEL_FROM_STATE_PROVINCE TRAVEL_FROM_STATE_PROVINCE |
NO NO |
|
| FTPBPORT_ID |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
PORTFOLIO_KEY PORTFOLIO_KEY |
NO NO |
|
| FTRBAUTH_ID |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY |
AUTHORIZATION_KEY |
NO |
|
| FTRBREMB_ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY |
REIMBURSEMENT_KEY |
NO |
|
| ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY |
ITINERARY_KEY ITINERARY_KEY |
NO NO |
|
| START_DATE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
TRAVEL_START_DATE TRAVEL_START_DATE |
NO NO |
|
| TO_CITY |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY |
TRAVEL_TO_CITY TRAVEL_TO_CITY |
NO NO |
|
| TO_NATN_CODE |
NA |
NO |
REPORTING VIEW |
AUTHORIZATION_ITINERARY REIMBURSEMENT_ITINERARY |
TRAVEL_TO_NATION TRAVEL_TO_NATION |
NO NO |
|
| TO_STAT_CODE |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY |
TRAVEL_TO_STATE_PROVINCE TRAVEL_TO_STATE_PROVINCE |
NO NO |
|
| USER_ID |
NA |
NO |
REPORTING VIEW |
REIMBURSEMENT_ITINERARY AUTHORIZATION_ITINERARY |
ITINERARY_USER_ID ITINERARY_USER_ID |
NO NO |
|