Mapping Accounting Information

To map accounting information, use the following components:

  • Adv Source - Payroll (EX_PY_MAP_AS.GBL).

  • Expense Type - Benchmark (EX_BMXPNTP_MAP_PNG.GBL).

  • Expense Type - Payroll (EX_PY_MAP_TBL.GBL).

Page Name

Definition Name

Usage

Advance Source - Payroll Page

EX_PY_MAP_AS

Map cash advance sources to payroll earnings codes.

Expense Type - Benchmark Page

EX_BMXPNTP_MAP_PNL

Map benchmark expense types to expense types.

Expense Type - Payroll Page

EX_PY_MAP_TBL

Map expense types to payroll earnings codes.

Use the Advance Source - Payroll page (EX_PY_MAP_AS) to map cash advance sources to payroll earnings codes.

Navigation:

  • Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Cash Advance Payroll Mapping

  • Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Map Accounting Information > Adv Source - Payroll

This example illustrates the fields and controls on the Advance Source - Payroll page. You can find definitions for the fields and controls later on this page.

Advance Source - Payroll page

This table maps a cash advance source to an earnings code. When PeopleSoft Expenses publishes expense reimbursement data to Payroll for North America, this table prevents the payroll system from processing cash advances as payroll items.

Mapping Table

Mapping From

Mapping To

EX_PY_MAP_AS

EX_ADV_SRC_TBL

EARNINGS_TBL

Use the Expense Type - Benchmark page (EX_BMXPNTP_MAP_PNL) to map benchmark expense types to expense types.

Navigation:

  • Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Load Expense Type Benchmarks

  • Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Map Accounting Information > Expense Type - Benchmark

This example illustrates the fields and controls on the Expense Type - Benchmark page. You can find definitions for the fields and controls later on this page.

Expense Type - Benchmark page

This table maps benchmark expenses in an external data file to an expense type in PeopleSoft Expenses. Mapping ensures that the system uses the correct associated benchmark amount when employees select an expense type for processing.

Mapping Table

Mapping From

Mapping To

EX_BMXPNSTP_MAP

External data file

EX_TYPES_TBL

Use the Expense Type - Payroll page (EX_PY_MAP_TBL) to map expense types to payroll earnings codes.

Navigation:

  • Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Expense Type - Payroll

  • Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Map Accounting Information > Expense Type - Payroll

This example illustrates the fields and controls on the Expense Type - Payroll page. You can find definitions for the fields and controls later on this page.

Expense Type - Payroll page

This table maps expense types to earnings codes. When PeopleSoft Expenses publishes expense reimbursement data to PeopleSoft Payroll for North America, this table identifies expenses to prevent the payroll system from processing them as payroll items.

Mapping Table

Mapping from

Mapping to

EX_PY_MAP_TBL

EX_TYPES_TBL

EARNINGS_TBL