Field-Mapping Templates for Project Data Flows

This section lists the project data field-mapping templates delivered in Primavera Gateway for each integration scenario.

File-P6 Field Mapping Templates

The following table lists the out-of-the-box field-mapping templates delivered for each project data business object supported by the File provider in Gateway for a File-P6 integration scenario. Each business object can be supported by more than one field-mapping template. You can create business flows by selecting business objects and their corresponding field-mapping templates listed below or create your own field-mapping templates if these templates don't fit your organization's needs. For a detailed list of the fields mapped in each template, select the following links or see Appendix A: Fields Supported in Mapping Templates.

File Business Object	Associated Field-Mapping Template
Activity	File-P6 Activity Mapping
ActivityCode	File-P6 ActivityCode Fields
ActivityCodeType	File-P6 ActivityCodeType Fields
ActivityExpense	File-P6 Activity Expense Fields
ActivityRisk	File-P6 Activity Risk Fields
CBS	File-P6 Export CBS Codes to P6
CBSDurationSummary	File-P6 CBS Duration Summary Fields
CBSExpenseSpread	File-P6 CBS Expense Spread Fields
Calendar	File-P6 Calendar Fields
Project	File-P6 Update P6 Project Header File-P6 Sync P6 Projects to ERP File-P6 Sync P6 Project settings to ERP
ProjectResource	File-P6 Project Resource Fields
Relationship	File-P6 Activity Relationship Fields
Resource	File-P6 Resource Fields
ResourceAssignment	File-P6 Assignment Mapping
Risk	File-P6 Risk field mappings
RiskImpact	File-P6 Risk Impact Fields
RiskMatrix	File-P6 Risk Matrix Score Fields
RiskMatrixScore	File-P6 Risk Matrix Threshold Fields
RiskMatrixThreshold	File-P6 Risk Matrix Threshold Fields
RiskResponseAction	File-P6 Risk Response Action Fields
RiskResponseActionImpact	File-P6 Risk Response Action Impact Fields
RiskResponsePlan	File-P6 Risk Response Plan Fields
RiskThreshold	File-P6 Risk Threshold Fields
RiskThresholdLevel	File-P6 Risk Threshold Level Fields
Role	File-P6 WBS Field Mapping
WBS	File-P6 WBS Field Mapping File-P6 WBS Field Mapping Example
WBSExpnseSpread	File-P6 WBS Expense Spread Fields
WBSResourceSpread	File-P6 Resource Cost and Unit Spread Fields

File-Unifier Field-Mapping Templates

The following table lists the out-of-the-box field-mapping templates delivered for each project data business object supported by the File provider in Gateway for an File-Unifier integration scenario. Each business object can be also be supported by more than one field-mapping template. You can create business flows by selecting business objects and their corresponding field-mapping templates listed below or create your own field-mapping templates if these templates don't fit your organization's needs. For a detailed list of the fields mapped in each template, select the following links or see Appendix A: Fields Supported in Mapping Templates.

File Business Object	Associated Field-Mapping Template
Activity	File-Unifier Activity Fields For Activity Sheet File-Unifier Activity Fields
BudgetApproval	File-Unifier BudgetApproval Fields
BudgetApprovalDetail	File-Unifier BudgetApprovalDetail Fields
BudgetChange	File-Unifier BudgetChange Fields
BudgetChangeDetail	File-Unifier BudgetChangeDetail Fields
BudgetTransfer	File-Unifier BudgetTransfer Fields
BudgetTransferDetail	File-Unifier BudgetTransferDetail Fields
CBS	File-Unifier CBS Fields
ChangeOrder	File-Unifier ChangeOrder Fields
ChangeOrderDetail	File-Unifier ChangeOrderDetail Fields
Contract	File-Unifier Contract Fields
ContractDetail	File-Unifier ContractDetail Fields
Estimate	File-Unifier Estimate Fields
EstimateDetail	File-Unifier EstimateDetail Fields
FundAppropriation	File-Unifier FundAppropriation Fields
FundAppropriationDetail	File-Unifier FundAppropriationDetail Fields
Invoice	File-Unifier Invoice Fields
InvoiceDetail	File-Unifier InvoiceDetail Fields
JournalEntry	File-Unifier JournalEntry Fields
JournalEntryDetail	File-Unifier JournalEntryDetail Fields
Payment	File-Unifier Payment Fields
PaymentApplication	File-Unifier PaymentApplication Fields
PaymentApplicationDetail	File-Unifier PaymentApplicationDetail Fields
PaymentDetail	File-Unifier PaymentDetail Fields
POAmendment	File-Unifier POAmendment Fields
POAmendmentDetail	File-Unifier POAmendmentDetail Fields
PotentialChangeOrder	File-Unifier PotentialChangeOrder Fields
PotentialChangeOrderDetail	File-Unifier PotentialChangeOrderDetail Fields
Project	File-Unifier Project Fields
ProjectInformation	File-Unifier ProjectInformation Fields
PurchaseOrder	File-Unifier PurchaseOrder Fields
PurchaseOrderDetail	File-Unifier PurchaseOrderDetail Fields
ResourceAssignment	none delivered
RequestforSubstitution	File-Unifier RequestforSubstitution Fields
RequestforSubstitutionDetail	File-Unifier RequestforSubstitutionDetail Fields
RiskAndIssue	File-Unifier RiskAndIssue Fields
RiskAndIssueDetail	File-Unifier RiskAndIssueDetail Fields
WBS	File-Unifier WBS Fields
WorkRelease	File-Unifier WorkRelease Fields
WorkReleaseDetail	File-Unifier WorkReleaseDetail Fields

File-Sample Field-Mapping Templates

The following table lists the out-of-the-box field-mapping templates delivered for each project data business object supported by the File provider in Gateway for a File-Sample integration scenario. Each business object can be also be supported by more than one field-mapping template. You can create business flows by selecting business objects and their corresponding field-mapping templates listed below or create your own field-mapping templates if these templates don't fit your organization's needs. For a detailed list of the fields mapped in each template, select the following links or see Appendix A: Fields Supported in Mapping Templates.

File Business Object	Associated Field-Mapping Template
Activity	Sample-File Activity Mapping
ActivityCode	Sample-File ActivityCode Fields
ActivityCodeType	Sample-File ActivityCodeType Fields
ActivityExpense	Sample-File Activity Expense Fields
ActivityRisk	none delivered
BudgetApproval	none delivered
BudgetApprovalDetail	none delivered
BudgetChange	none delivered
BudgetChangeDetail	none delivered
BudgetChangeTransfer	none delivered
BudgetTransfer	none delivered
BudgetTransferDetail	none delivered
Calendar	none delivered
ChangeOrder	none delivered
ChangeOrderDetail	none delivered
Contract	none delivered
ContractDetail	none delivered
Estimate	none delivered
EstimateDetail	none delivered
FundAppropriation	none delivered
FundAppropriationDetail	none delivered
Invoice	none delivered
InvoiceDetail	none delivered
JournalEntry	none delivered
JournalEntryDetail	none delivered
POAmendment	none delivered
POAmendmentDetail	none delivered
Payment	none delivered
PaymentApplication	none delivered
PaymentApplicationDetail	none delivered
PaymentDetail	none delivered
PotentialChangeOrder	none delivered
PotentialChangeOrderDetail	none delivered
Project	Sample-File Sync P6 Projects to ERP Sample-File Sync P6 Project settings to ERP Sample-File Update P6 Project Header
ProjectInformation	none delivered
ProjectResource	Sample-File Project Resource Fields
PurchaseOrder	none delivered
PurchaseOrderDetail	none delivered
Relationship	Sample-File Activity Relationship Fields
RequestforSubstitution	none delivered
RequestforSubstitutionDetail	none delivered
Resource	Sample-File Resource Fields
ResourceAssignment	Sample-File Assignment Mapping
Risk	none delivered
RiskAndIssue	none delivered
RiskAndIssueDetail	none delivered
RiskImpact	none delivered
RiskMatrix	Sample-File Risk Matrix Fields
RiskMatrixScore	Sample-File Risk Matrix Score Fields
RiskMatrixThreshold	none delivered
RiskResponseAction	Sample-File Risk Response Action Fields
RiskResponseActionImpact	none delivered
RiskResponsePlan	Sample-File Risk Response Plan Fields
RiskThreshold	Sample-File Risk Threshold Fields
RiskThresholdLevel	Sample-File Risk Threshold Level Fields
Role	Sample-File Role Fields
WBS	Sample-File WBS Field Mapping
WorkRelease	none delivered
WorkReleaseDetail	none delivered

Last Published Tuesday, September 29, 2020