Depending on the destination application, this project data field mapping template creates a Task object in the Microsoft Project provider or an Activity object in Primavera Cloud.
The following fields are mapped in each application:
MSP Fields | Gateway Fields | Primavera Cloud Fields |
|---|---|---|
ActualDuration | ActualDuration | actualDuration |
ActualFinish | ActualFinishDate | actualFinishDate |
ActualStart | ActualStartDate | actualStartDate |
ActualWork | ActualLaborUnits | actualLaborUnits |
CalendarCode | CalendarCode | calendarCode |
CalendarUID | CalendarObjectId | calendarId |
ConstraintDate | PrimaryConstraintDate | constraintDate |
ConstraintType | PrimaryConstraintType | constraintType |
Deadline | ExpectedFinishDate | expectedFinishDate |
Duration | PlannedDuration | plannedDuration |
DurationType | DurationType | durationType |
EarlyFinish | EarlyFinishDate | earlyFinishDate |
EarlyStart | EarlyStartDate | earlyStartDate |
Finish | FinishDate | finishDate |
Finish | PlannedFinishDate | plannedFinishDate |
ID | Id | activityCode |
LateFinish | LateFinishDate | lateFinishDate |
LateStart | LateStartDate | lateStartDate |
Name | Name | activityName |
PercentComplete | DurationPercentComplete | durationPercentComplete |
PercentCompleteType | PercentCompleteType | percentCompleteType |
PercentWorkComplete | UnitsPercentComplete | unitsPercentComplete |
PhysicalPercentComplete | PhysicalPercentComplete | physicalPercentComplete |
Priority | LevelingPriority | activityPriority |
ProjectId | ProjectId | projectCode |
ProjectObjectId | ProjectObjectId | projectId |
RemainingDuration | RemainingDuration | remainingDuration |
RemainingWork | RemainingLaborUnits | remainingLaborUnits |
Start | PlannedStartDate | plannedStartDate |
Start | StartDate | startDate |
Status | Status | activityStatus |
SummaryTaskObjectId | WBSObjectId | wbsId |
Type | Type | activityType |
WBS | WBSCode | wbsCode |
Work | AtCompletionLaborUnits | atCompletionLaborUnits |