Detailed Data Mapping

Overview

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

PROJECTS

Erp Green Arrows

JOBS

COMPANIES

Erp Green Arrows

CREDITORS

PROJECT WBS CODES 1 COST CODES + COST TYPES

Erp Green Arrows

PROJECT COST CENTRE PROJECT COST TYPES

BUDGET LINE ITEMS

Erp Green Arrows

PROJECT COST CENTRES

COMMITMENTS SUBCONTRACTS & PURCHASE ORDERS COMMITMENT CHANGE ORDERS (CCOs)

Erp Orange Arrows

SUBCONTRACTS PURCHASE ORDERS VARIATIONS

COSTS

Erp Green Arrows

COSTS

SUBCONTRACTOR INVOICES 2 FOR SUBCONTRACTS & PURCHASE ORDERS

Erp Orange Arrows

SUBCONTRACTOR INVOICES SUBCONTRACT CLAIMS AP INVOICES

PRIME CONTRACTS

Erp Green Arrows

HEAD CONTRACTS

PRIME CONTRACT CHANGE ORDERS

Erp Orange Arrows

HEAD CONTRACT VARIATIONS

1 Custom WBS segments are not supported at this time.

2 Subcontractor invoices with negative values do not export.

Cost Codes

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Cost Code + Cost Type

Erp Green Arrows

Cost Code

Description

Erp Green Arrows

Description

Projects/Jobs

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Project Name

Erp Green Arrows

Job

Companies

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Name

Erp Green Arrows

Creditor

Address City State ZIP

Erp Green Arrows

Address City State Postal Code

Business Phone

Erp Green Arrows

Telephone

Business Fax

Erp Green Arrows

Fax No.

Budget Line Items

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Original Budget

Erp Green Arrows

Budget

Cost Code/Cost Type

Erp Green Arrows

Cost Centre

Commitments

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Commitment Header

Commitment Header

Project

Erp Orange Arrows

Job

Title (General tab)

Erp Orange Arrows

Description

Date Created

Erp Orange Arrows

Date

Default Retainage

Erp Orange Arrows

Retention

Commitment Item (Subcontracts)

Commitment Item

Commitment #

Erp Orange Arrows

Agreement

Contract Company

Erp Orange Arrows

Subcontractor

Cost Code \ Code Type

Erp Orange Arrows

Cost Centre

Qty (Schedule of Values tab)

Erp Orange Arrows

Quantity

UOM

Erp Orange Arrows

UOM

Contract Amount or Subtotal

Erp Orange Arrows

Nett Contract Sum

Commitment Item (Purchase Orders)

Commitment Item

Commitment #

Erp Orange Arrows

Order Number

Contract Company

Erp Orange Arrows

Supplier

Cost Code \ Cost Type

Erp Orange Arrows

Cost Centre

Qty

Erp Orange Arrows

Quantity

UOM

Erp Orange Arrows

Unit

Contract Amount or Subtotal

Erp Orange Arrows

Order Amount

Commitment Change Orders

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Commitment Change Order Header

Variation Header (Group Code 1)

Change Order Number

Erp Orange Arrows

Variation

Title

Erp Orange Arrows

Description

Date Created

Erp Orange Arrows

Date

Commitment Change Order Item ( Subcontract)

Commitment Change Order Item

Cost Code (Schedule of Values tab)

Erp Orange Arrows

Cost Centre

UOM

Erp Orange Arrows

UOM

Unit Cost

Erp Orange Arrows

Rate

Amount

Erp Orange Arrows

Value

Commitment Change Order Item (Purchase Order)

Commitment Change Order Item

Cost Code (Schedule of Values tab)

Erp Orange Arrows

Cost Centre

Qty

Erp Orange Arrows

Quantity

Unit Cost (Schedule of Values tab)

Erp Orange Arrows

Unit

Amount

Erp Orange Arrows

Value

Job Costs

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Original Budget

Erp Green Arrows

Original Costs

Approved Budget Changes

Erp Green Arrows

'A' transferred Status

Commitment Invoiced

Erp Green Arrows

Subcontract Claims to Date

Job to Date Cost

Erp Green Arrows

Cost

Subcontractor Invoices

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Header

Contractor Company

Erp Orange Arrows

Creditor

ERP ID1

Erp Orange Arrows

Invoice #

Description

Erp Orange Arrows

Description

Billing Date

Erp Orange Arrows

Invoice Date

Total Completed and Stored to Date

Erp Orange Arrows

Nett Amount

Distributions

Project #

Erp Orange Arrows

Job

WBS Code (Schedule of Values)

Erp Orange Arrows

Cost Centre

QTY (Schedule of Values)

Erp Orange Arrows

Quantity, Cost

Unit Price (Schedule of Values)

Erp Orange Arrows

Unit

Work Retainage

Erp Orange Arrows

Maximum Retention

Prime Contracts

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Prime Contract

Erp Green Arrows

Head Contract

Prime Contract Change Orders

PROCORE

Exports data from Procore to

Jobpac™

Imports data from

Jobpac™

to Procore

Jobpac™

Prime Contract Change Order

Erp Orange Arrows

Head Contract Variation