Supported Field Mapping Templates

The following tables show the field mappings supported in each field mapping template. Select the appropriate flow type, object, field mapping template, and corresponding synchronization in Primavera Gatewayto share data between applications:

Supply Mapping for Project from VCP to P6

This field mapping template can be used in an import project data business flow to update the project object in the destination application. The following fields are mapped in each application:

From VCP

To P6

PROJECT_NAME

Name

PROJECT_NUMBER

Id

Supply Mapping for Activity from VCP to P6

This field mapping template can be used in an import project data business flow to create a new activity object or update the existing activity object in the destination application. The following fields are mapped in each application:

From VCP

To P6

ITEM_SELECTION

VCPActItemSelection

ITEM_SELECTION_CODE

VCPActItemSelectionCode

SUPPLY_PEGGED_ORDER_NUMBER

VCPActSupplyPeggedOrderNumber

SUPPLY_ORDER_TYPE

VCPActSupplyOrderType

SUPPLY_ORDER_NUMBER

VCPActSupplyOrderNumber

SUPPLY_ORDER_DATE

VCPActSupplyOrderDate

SUPPLY_START_DATE

PlannedStartDate

SUPPLY_ACTUAL_START_DATE

VCPActSupplyActualStartDate

SUPPLY_SHIP_DATE

VCPActSupplyShipDate

SUPPLY_DOCK_DATE

VCPActSupplyDockDate

SUPPLY_DUE_DATE

VCPActSupplyDueDate

SUPPLY_UPDATED_ARRIVAL_DATE

VCPActSupplyUpdatedArrivalDate

SUPPLY_ITEM_ID

VCPActSupplyItemId

SUPPLY_ITEM_NAME

VCPActSupplyItemName

SUPPLY_ORGANIZATION

VCPActSupplyOrganization

SUPPLY_QUANTITY

PlannedDuration

Supply Mapping for WBS from VCP to P6

This field mapping template can be used in an import project data business flow to create a new WBS object or update the existing WBS object in the destination application. The following fields are mapped in each application:

From VCP

To P6

PARENTTASK_SOURCE_VCP_ID

ObjectId

Supply Mapping for Resource from VCP to P6

This field mapping template can be used in an import project data business flow to create a new Resource object in the destination application. The following fields are mapped in each application:

From VCP

To P6

ITEM_TYPE

ResourceType

Supply Mapping for Resource Assignment from VCP to P6

This field mapping template can be used in an import project data business flow to create a new Resource Assignment object or update the existing Resource Assignment object in the destination application. The following fields are mapped in each application:

From VCP

To P6

ITEM_ID

ResourceId

ITEM_TYPE

ResourceType

ITEM_SELECTION

VCPRasSelection

ITEM_SELECTION_CODE

VCPRasSelectionCode

DEMAND_PEGGED_AVL_DATE

VCPRasDemandPeggedAvlDate

DEMAND_PEGGED_ORDER_DATE

VCPRasDemandPeggedOrderType

DEMAND_PEGGED_ORDER_NUMBER

VCPRasDemandPeggedOrderNumber

SUPPLY_PEGGED_ORDER_NUMBER

VCPRasSupplyPeggedOrderNumber

SUPPLY_ORDER_TYPE

VCPRasSupplyOrderType

SUPPLY_ORDER_NUMBER

VCPRasSupplyOrderNumber

SUPPLY_ORDER_DATE

VCPRasSupplyOrderDate

SUPPLY_START_DATE

VCPRasSupplyStartDate

SUPPLY_ACTUAL_START_DATE

VCPRasSupplyActualStartDate

SUPPLY_SHIP_DATE

VCPRasSupplyShipDate

SUPPLY_DOCK_DATE

VCPRasSupplyDockDate

SUPPLY_DUE_DATE

VCPRasSupplyDueDate

SUPPLY_UPDATED_ARRIVAL_DATE

VCPRasSupplyUpdatedArrivalDate

SUPPLY_ITEM_ID

VCPRasSupplyItemId

SUPPLY_ITEM_NAME

VCPRasSupplyItemName

SUPPLY_ORGANIZATION

VCPRasSupplyOrganization

SUPPLY_QUANTITY

VCPRasSupplyQuantity

Demand Mapping for Project from P6 to VCP

This field mapping template can be used in an export project data business flow to refer the project object in the destination application. The following fields are mapped in each application:

From P6

To VCP

Id

PROJECT_NUMBER

ObjectId

PROJECT_SOURCE_VCP_ID

Demand Mapping for Activity from P6 to VCP

This field mapping template can be used in an export project data business flow to refer the activity object in the destination application. The following fields are mapped in each application:

From P6

To VCP

Name

TASK_NAME

ObjectId

TASK_SOURCE_VCP_ID

Demand Mapping for WBS from P6 to VCP

This field mapping template can be used in an export project data business flow to refer the ParentTask object in the destination application. The following fields are mapped in each application:

From P6

To VCP

ProjectObjectId

PROJECT_ID

ParentObjectId

PARENT_TASK_ID

ObjectId

PARENTTASK_SOURCE_VCP_ID

Demand Mapping for Resource Assignment from P6 to VCP

This field mapping template can be used in an export project data business flow to create a new Resource Assignment object and to update the existing Resource Assignment object in the destination application. The following fields are mapped in each application:

From P6

To VCP

ObjectId

IAS_SOURCE_VCP_ID

PlannedUnits

PLANNED_UNITS

PlannedStartDate

SUGGESTED_DUE_DATE

ResourceId

ITEM_NUMBER

ResourceName

ITEM_NAME

ResourceType

ITEM_TYPE

VCPRasInventoryOrgName

ITEM_INVENTORY_ORGNAME

VCPRasSelection

ITEM_SELECTION

VCPRasSelectionCode

ITEM_SELECTION_CODE

Related Topics

Configuring the Gateway User Interface

Configuring Primavera Gateway Settings

Adding an Application Deployment Connection

Supported Business Flows



Legal Notices
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, March 25, 2015