Which Office Connector module should I use to send data from Excel to Sage 300 CRE?

Click an application title below (e.g., "Accounts Payable") to view a list of the tables that you can send data to from Excel via Office Connector. Click on a specific table (e.g., "AP Invoice") to see which Office Connector modules can be used to create and/or update records. Refer to the following resources for more details (including the specific fields that can be updated) -

Event 1 Quick Aim Database Reference for Sage 300 CRE
Sage application help on importing
Sage Report Designer - Tools / Print Available Fields
Knowledgebase Article - How to send data from Excel to Sage 300 CRE

Address Book

AB Company

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AB Company Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AB Person

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AB Person Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

Accounts Payable

AP Allocation

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Allocation Distribution

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Amortization

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Amortization Detail

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Authorization

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Check

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Check Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Credit Card

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Credit Card Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Credit Card Payment

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Dist Payment

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Distribution

Office Connector Write
Update selected fields

Office Connector Import
Create new records via AP - Import Invoices

AP Electronic Payment

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Invoice

Office Connector Write
Update selected fields

Office Connector Import
Create new records via AP - Import Invoices

AP Invoice Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Invoice Lw Quick Receive

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Invoice Payment

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Lien Waiver

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Prefix Total

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Recurring Distribution

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Recurring Invoice

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AP Tax Distribution

Office Connector Write
Not applicable

Office Connector Import
Create new records via AP - Import Invoices

AP Vendor

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Vendor Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Vendor Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AP Vendor Misc Compliance

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

Accounts Receivable

AR Activity

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Activity Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Batch

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Cash Receipt View

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Contact

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Contact Custom Fields

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Contact Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Corresp Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Correspondence

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Correspondence Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Customer

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Customer Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Customer History Totals

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Customer Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Customer Totals

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Deposit

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Deposit Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Deposit Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Distribution

Office Connector Write
Update selected fields

Office Connector Import
Create new records via AR - Import Invoices

AR Electronic Payment

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Invoice View

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

AR Status (Invoice)

Office Connector Write
Update selected fields

Office Connector Import
Create new records via AR - Import Invoices

AR Status Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

AR Transaction

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

Billing

BL Add on Table

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

BL Invoice

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

BL Invoice Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

BL Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

BL Markup Table

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

BL Rate Table

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

BL Standard Add on

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

BL Standard Item

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

BL Work in progress

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

BL Worksheet Entry

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

Cash Management

CM Bank Account

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

CM Bank Account Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CM Transaction

Office Connector Write
Update selected fields

Office Connector Import
Update "Cleared" status via CM - Import Cleared Checks

CM Transaction Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

Contracts

CN Batch

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

CN Change Order Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Change Order Item Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

CN Contract Change Order

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

CN Contract Change Order Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

CN Contract Checklist

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Contact

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

CN Contract Item Checklist

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Item Contact

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Item Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Item Reference Num

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Item Text

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Reference Number

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Supporting Document

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Contract Text

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

CN Transaction

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

Equipment

EQ Cost Code

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Cost Code Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Cost Code Tran

Office Connector Write
Not applicable

Office Connector Import
Create new records via EQ - Import Entries

EQ Cost Rate Table

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Cost View

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Equipment

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Equipment Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Equipment Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Equipment Other

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Equipment Ownership

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Equipment Rental

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Equipment Specifications

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Equipment Type

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Equipment Type Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ License Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ License Permit

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Meter Tran

Office Connector Write
Not applicable

Office Connector Import
Create new records via EQ - Import Entries

EQ Misc Entry

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Misc Entry Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Misc Entry View

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Misc Entry Tran

Office Connector Write
Not applicable

Office Connector Import
Create new records via EQ - Import Entries

EQ Revenue Code

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Revenue Code Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Revenue Code Tran

Office Connector Write
Not applicable

Office Connector Import
Create new records via EQ - Import Entries

EQ Revenue Rate Table

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Revenue View

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

EQ Standard Cost Code

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Standard Misc Entry

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Standard Revenue Code

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

EQ Transaction

Office Connector Write
Update selected fields

Office Connector Import
Create new records via EQ - Import Entries

General Ledger

GL Account

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

GL Account Activity History

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Account Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Account Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Prefix A

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

GL Prefix A Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Prefix A Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Prefix B

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

GL Prefix B Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Prefix B Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Prefix C

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

GL Prefix C Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Prefix C Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Allocation

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Auto reverse Transaction

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Base Account

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Base Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Budget

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via GL - Import Budgets

GL Fiscal Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

GL Journal

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Partner

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Partner Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Recurring Transaction

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

GL Transaction

Office Connector Write
Update selected fields

Office Connector Import
Create new records via GL - Import Transactions

Information Assistant

IA Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

Job Cost

JC Category

Office Connector Write
Update selected fields

Office Connector Import
Create new records via JC - Import Estimates

JC Category Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Estimates

JC Category Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Certified Report

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Change Order

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

JC Change Order Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Change Order Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Change Order Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

JC Change Order Item Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Commitment

Office Connector Write
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

JC Commitment Co

Office Connector Write
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

JC Commitment Co Cstm Flds

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

JC Commitment Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

JC Commitment Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

JC Commitment Item

Office Connector Write
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

JC Commitment Item Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

JC Commitment Item Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

JC Cost Code

Office Connector Write
Update selected fields

Office Connector Import
Create new records via JC - Import Estimates

JC Cost Code Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Estimates

JC Cost Code Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Draw

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

JC Draw Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Exclusion

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

JC Extra

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Estimates

JC Extra Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Estimates

JC Extra Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Import Table

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Inclusion

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

JC Cost Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

JC Job

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Estimates

JC Job Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Create new records via JC - Import Estimates

JC Job Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Job Misc Compliance

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Lien Waiver

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Secondary Vendor

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Standard Cost Code

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

JC Transaction

Office Connector Write
Update selected fields

Office Connector Import
Create new records via

JC - Import Commitments
JC - Import Direct Costs
JC - Import Estimates
E1 - Import Misc Worksheets

JC View

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

Project Management

PJ Add on

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Change Order

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Change Request

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Change Request Detail

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Commitment Co

Office Connector Write
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

PJ Commitment Co Detail

Office Connector Write
Update selected fields

Office Connector Import
Create new records via JC - Import Commitments

PJ Correspondence Log

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 1

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 10

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 11

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 12

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 13

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 14

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 15

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 16

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 17

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 18

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 19

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 2

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 20

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 3

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 4

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 5

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 6

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 7

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 8

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Custom Log 9

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Drawing

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Equipment

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Event

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Extra

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Fr Weather Site Conditions

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Job

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Job Contact List

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Job Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PJ Job Spec Section

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PJ Journal Entry

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Labor

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Material

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Meeting Minutes

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Meeting Minutes Attendee

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Meeting Minutes Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PJ Meeting Minutes Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Payroll Time

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ RFI

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ RFI Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PJ Settings

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Spec Section

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Subcontractor

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Submittal

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Submittal By Spec Section

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Submittal Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PJ Submittal Sbm Revision

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Submittal Totals By Job

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Transmittal

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Transmittal Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PJ Transmittal Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Visitor

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PJ Work Activities

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

Property Management

PM Accumulator Control

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Bank Deposit

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Charge Type

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Corporation

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM CPI

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Interest Rate

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Late Charge Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Lease Accum Calendar Yr

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Accum Fiscal Yr

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Breakpoint Table

Office Connector Write
Create new records

Office Connector Import
Not applicable

PM Lease Charge Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Lease Checklist Item

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Deposit

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Lease Insur Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Insurance

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Late Charge Control

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Lease Modification

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Lease Offset

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Lease Option

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Option Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Pct Rent Controls

Office Connector Write
Create new records

Office Connector Import
Not applicable

PM Lease Recov Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Lease Recurring Chg Log

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Lease Sales Category

Office Connector Write
Create new records

Office Connector Import
Not applicable

PM Ledger Adjust Transaction

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Manager Broker

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Mgmt Fee Custom Fields

Office Connector Write
Create new records

Office Connector Import
Not applicable

PM Mgr broker Custom Fields

Office Connector Write
Create new records

Office Connector Import
Not applicable

PM Misc Inc Src

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Misc Inc Src Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Misc Inc Transaction

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Open Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Payment

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Porters Wage

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Property Accum Calendar Yr

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Accum Fiscal Yr

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Addr Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Address

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Charge Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Property Checklist Item

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Insur Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Insurance

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Late Charge Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Property Mgmt Fee Cntls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Property Recov Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Property Tax

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Property Tax Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Recur Chg Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Sales Volume Transaction

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Sic Code

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM System Controls

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Tenant

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Tenant Addr Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Tenant Address

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Tenant Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Tenant Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Transaction

Office Connector Write
Update selected fields

Office Connector Import
Create new records via

PM - Import Charges
PM - Import Payments

PM Unit

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PM Unit Accum Calendar Yr

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Unit Accum Fiscal Yr

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Unit Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PM Unit Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

Payroll

PR Certified Class

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Check

Office Connector Write
Update selected fields

Office Connector Import
Create new records via PR - Import Time

PR Check Form

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Check Form Earnings Detail

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Check Form Ytd Total Detail

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Check Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Check Tax

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Company Tax Rate

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Deduction

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Employee

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee Aca Alloc Hours

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee Aca Dependent

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee Deduct

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee Fringe

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee Pay

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee State

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Employee Tax

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Eq Detail

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Federal Employer Id

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Federal Tax Group

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Fringe

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Fund

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Job Local

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Local Employer Id

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Local Tax Group

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Pay

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Pay Group

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Pay Rate Setting

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Pay Rate Table

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Quarterly Form

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Roe Settings

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR State Employer Id

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR State Tax Group

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR T4 Forms

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Tax

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Tax Account

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Time

Office Connector Write
Update selected fields

Office Connector Import
Create new records via PR - Import Time

PR Time Entry View

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Union

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR Union Class

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Union Item

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Union Local

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Union Local Issue

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

PR W2 Form

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

PR Workers Comp Rate

Office Connector Write
Update selected fields

Office Connector Import
Not applicable

Remote Time

RT Category

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Category Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Cost Code

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Cost Code Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Employee

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Employee Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Employee Timesheet Control

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Extra

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Extra Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Job

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Job Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Job Timesheet Control

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Pay Id

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Pay Id Custom Fields

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

RT Timesheet Detail

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

Tax

TX Tax Group

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

TX Tax Rate

Office Connector Write
Create new records
Update selected fields

Office Connector Import
Not applicable

Join WebEx	Download
Get Help	Knowledgebase