Integration Points

The Payroll for North America and General Ledger interface uses two sets of integration points, one to retrieve ChartField and business unit information from General Ledger and one to publish payroll results to General Ledger.

Before using the integration between Payroll for North America and EnterpriseOne General Ledger, configure the Integration Broker nodes and activate the appropriate queues, handlers, and routings for these service operations:

Service Operation Description

BUS_UNIT_GL_FULLSYNC

Initial load of EnterpriseOne companies into the Enterprise Business Units GL table (BUS_UNIT_TBL_GL).

This service operation additionally:

  • Spawns the BUS_UNIT_FS_SYNC service operation.

  • Loads the company code, effective date, effective status, and description into the Controlling Area table (HPYP_CNTRL_AREA).

BUS_UNIT_GL_SYNC

Incremental updates of the Enterprise Business Units GL table. It performs the same additional functions as the corresponding fullsync service operation.

BUS_UNIT_FS_SYNC

Internal Enterprise service operation that is spawned from the subscription to BUS_UNIT_GL_FULLSYNC and BUS_UNIT_GL_SYNC.

Imports or updates the company description into the PS/Financials Business Units table (BUS_UNIT_TBL_FS).

COST_CENTER_FULLSYNC

Initial load of EnterpriseOne business units into the Enterprise Cost Center table (HPYP_CC_TBL).

COST_CENTER_SYNC

Incremental updates of the Enterprise Cost Center table.

ACCOUNT_CHARTFIELD_FULLSYNC

Initial load of the EnterpriseOne Account Master table (F0901) to the Enterprise GL Accounts table (GL_ACCOUNTS_TBL).

ACCOUNT_CHARTFIELD_SYNC

Incremental additions to the Enterprise GL Accounts table.

MARKET_RATE_REQ

Enterprise queries EnterpriseOne for currency exchange rate multiplier or divider.

MARKET_RATE_SYNC

EnterpriseOne replies and Enterprise updates the Market Rate Data table (RT_RATE_TBL).

PAYROLL_ACCTG_TRANSACTION

Enterprise Payroll for North America publishes accounting data to EnterpriseOne.

PAYROLL_TRANSACTION_REPLY

EnterpriseOne notifies Enterprise Payroll for North America of success or error in loading table F0911Z1.