Approved QuickConnect IntegrationsAPI Documentation

Sage 100 Integration Overview

Classification

Data Types

  • People
  • Projects

Data Flow

  • Unidirectional; Sage 100 into Workforce Planning only

Sync Frequency

  • Twice daily

Connection Requirements

  • Accessible IP address or URL
  • Set of read-only SQL credentials
  • Database name

Provided

  • Four Workforce Planning outbound IP addresses will be provided during implementation and will need to be whitelisted

Commonly Used Sage 100 Fields and Tables

📘

Note

Your Sage 100 database may feature tables and fields with naming conventions altered slightly from what is listed below. This list is intended to be a baseline/template and the integration will be tailored to match your system exactly.

People

Workforce Planning FieldSage FieldSage Table
First Namefstnmeemploy
Last Namelstnmeemploy
Status (Active, Pending, or Inactive)statusemploy
Employee IDrecnumemploy
Address 1addrs1employ
Address 2addrs2employ
Cityctynmeemploy
Statestate_employ
Zipcodezipcdeemploy
Phone Numberphnnumemploy
Emaile_mailemploy
Hourly Wagepayrt1employ
Date of Birthdtebthemploy
Emergency Contact Namecntnmeempcnt
Emergency Contact Phone Numberphnnumempcnt
Emergency Contact Emaile_mailempcnt
Emergency Contact Relationrelateempcnt
Hired Datedtehreemploy
Gendergenderemploy
Job Titlepaypstpaypst

Projects

Workforce Planning FieldSage FieldSage Table
Project Namejobnmeactrec
Status (Active, Pending, or Inactive)statusactrec
Project IDrecnumactrec
Address 1addrs1actrec
Address 2addrs2actrec
Cityctynmeactrec
Statestate_actrec
Zipcodezipcdeactrec
Start Datesttdteactrec
Est. End Datecmpdteactrec
Project Typejobtypjobtyp
Customerclnnumreccln
Project Managersprvsractrec

Have questions? Reach out to us at [email protected]