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).

Pages Used to Map Accounting Information

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.

Advance Source - Payroll Page

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, and then Product Related, and then Expenses, and then Mapping, and then Cash Advance Payroll Mapping

  • Travel and Expenses, and then Travel and Exp Admin Center, and then Define Expense System, and then Map Accounting Information, and then 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

Expense Type - Benchmark Page

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

Navigation:

  • Set Up Financials/Supply Chain, and then Product Related, and then Expenses, and then Mapping, and then Load Expense Type Benchmarks

  • Travel and Expenses, and then Travel and Exp Admin Center, and then Define Expense System, and then Map Accounting Information, and then 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

Expense Type - Payroll Page

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

Navigation:

  • Set Up Financials/Supply Chain, and then Product Related, and then Expenses, and then Mapping, and then Expense Type - Payroll

  • Travel and Expenses, and then Travel and Exp Admin Center, and then Define Expense System, and then Map Accounting Information, and then 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