Understanding the EnterpriseOne General Ledger Interface

This topic discusses:

  • Prerequisites.

  • Description of the interface with General Ledger.

  • Integration Points.

Note: This topic covers only the tasks performed in the Enterprise database. The EnterpriseOne documentation discusses setting up the integration on the EnterpriseOne side and loading EnterpriseOne data into the Enterprise database. You must work closely with your general ledger staff to use this interface.

See “Integrating PeopleSoft Enterprise Payroll Applications with PeopleSoft EnterpriseOne General Ledger” in PeopleSoft EnterpriseOne Application Integrations with PeopleSoft Enterprise Applications product documentation

These setup tasks must be completed before you begin the tasks in this topic:

  1. Set up the integration with the EnterpriseOne database.

    See Enterprise Components

  2. Set up the ChartFields and ChartField configuration.

    See Understanding PeopleSoft ChartFields.

With Payroll for North America you can send payroll accounting transactions to General Ledger. The payroll data that is sent to General Ledger includes the following expense and liability account data:

  • Earnings.

  • Deductions.

  • Federal, state/provincial, and local tax and insurance deductions.

  • Net pay and direct deposit data.

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.