There are small differences in the field mapping for Forecast and Baseline imports so separate field mapping tables are provided for both interfaces.
Forecast Import Field Mapping
|
EcoSys |
P6 Resource Assignment |
P6 Expense |
|---|---|---|
|
Cost Object (External Key) |
WBS Object Id |
WBS Object Id |
|
P6 Activity (External Key) |
Activity Object Id |
Activity Object Id |
|
Transaction Cost |
Remaining Cost |
Remaining Cost |
|
Units |
Remaining Units |
Remaining Units |
|
Transaction Date |
Spread Start Date |
Depending on Accrual Type, Activity Start Date, Finish Date or spread evenly between Start and Finish Date |
|
Resource (External Key) |
Resource Object Id |
N/A |
|
P6 Role (External Key) |
Role Object Id |
N/A |
|
P6 Cost Account (External Key) |
Cost Account Object Id |
Cost Account Object Id |
|
Description |
N/A |
Expense Item |
|
P6 Accrual Type (ID) |
"Resource Spread" |
Start of Activity, End of Activity, Uniform Over Activity |
|
P6 Transaction Type (ID) |
"Resource Assignment" |
"Expense" |
Baseline Import Field Mapping
|
EcoSys |
P6 Resource Assignment |
P6 Expense |
|---|---|---|
|
Cost Object Hierarchy Path ID |
Calculated based on the WBS parent/child relationship |
Calculated based on the WBS parent/child relationship |
|
P6 Activity Hierarchy Path ID |
Calculated based on the WBS parent/child relationship, plus Activity ID |
Calculated based on the WBS parent/child relationship, plus Activity ID |
|
Transaction Cost |
Planned Cost |
Planned Cost |
|
Units |
Planned Units |
Planned Units |
|
Transaction Date |
Spread Start Date |
Depending on Accrual Type, Activity Start Date, Finish Date or spread evenly between Start and Finish Date |
|
Resource (External Key) |
Resource Object Id |
N/A |
|
P6 Role (External Key) |
Role Object Id |
N/A |
|
P6 Cost Account (External Key) |
Cost Account Object Id |
Cost Account Object Id |
|
Description |
N/A |
Expense Item |
|
P6 Accrual Type (ID) |
"Resource Spread" |
Start of Activity, End of Activity, Uniform Over Activity |
|
P6 Transaction Type (ID) |
"Resource Assignment" |
"Expense" |