Columns | Field Name in XLSX |
---|---|
Activity ID | task_id |
Actual Cost | act_cost |
Actual Finish | act_end_date |
Actual Start | act_start_date |
Actual This Period Cost | act_this_per_cost |
Actual This Period Units | act_this_per_qty |
Actual Units | act_qty |
At Completion Cost | total_cost |
At Completion Units | total_qty |
Cost Account ID | acct_id |
Curve | curv_id |
Planned Cost (P6 EPPM) Budgeted Cost or Planned Cost (P6 Professional) | target_cost |
Planned Duration (P6 EPPM) Original Duration or Planned Duration (P6 Professional) | target_drtn_hr_cnt |
Planned Units (P6 EPPM) Budgeted Units or Planned Units (P6 Professional) | target_qty |
Remaining Cost | remain_cost |
Remaining Duration | remain_drtn_hr_cnt |
Remaining Lag | remain_lag_drtn_hr_cnt |
Remaining Units | remain_qty |
Remaining Units/Time | remain_qty_per_hr |
Resource ID | rsrc_id |
Role ID | role_id |
Unit of Measure | unit_of_measure |
Units % Complete | effort_complete_pct |
Assignment Codes | asgnmnt_catg_XXXX_id |
Resource Codes | rsrc_catg_XXXXX_id |
All UDFs |
|
Note: Hierarchical information relating to cost accounts is not exported to Excel. Ensure that Cost Account IDs are unique throughout the entire dictionary. Any cost accounts that do not have unique Cost Account IDs may be overwritten during the import process.