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:
Set up the integration with the EnterpriseOne database.
Set up the ChartFields and ChartField configuration.
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:
|
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. |