Notes:
- 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 will be overwritten during the import process. For example, if cost account A and cost account B each have child cost accounts assigned cost account ID 1, cost account A.1 and B.1 are both exported to Excel with the Cost Account ID of 1. Renaming these child cost accounts as A1 and B1 ensures that there will be no conflict when the data is imported.
- The activity status column is included in the Expenses, Resource Assignments, and Activity Relationships sections of the export file only for reference, but is ignored during import. To update the activity status, modify the activity status column in the activities subject area of the import file.
Columns | Field Name in XLSX |
|---|---|
Activity ID | task_id |
Actual Cost | act_cost |
Actual Units | act_units |
At Completion Cost | total_cost |
At Completion Units | at_completion_units |
Cost Account ID | acct_id |
Document Number | po_number |
Expense Description | cost_descr |
Expense Item | cost_name |
Planned Cost (P6 EPPM) Budgeted Cost or Planned Cost (P6 Professional) | target_cost |
Planned Units (P6 EPPM) Budgeted Units or Planned Units (P6 Professional) | target_qty |
Remaining Cost | remain_cost |
Remaining Units | remain_units |
Unit of Measure | qty_name |
Vendor | vendor_name |
All UDFs |
|