This chapter provides an overview of expense data mapping and discusses how to:
Map accounting information.
Map location information.
Map corporate card data.
See Also
PeopleSoft Expenses provides mapping of data sources to expense system tables, such as corporate cards, payroll, and benchmark providers. You can remap data, create mapping tables, and map tables to correct credit card errors that your system detects during the loading process.
Each mapping page displays the current mapping between data source files and PeopleSoft Expenses tables. Select or enter data in each column, and delete or add rows.
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).
Expense Type - Wizard Type (EX_WIZARD_TBL.GBL).
This section discusses how to:
Map cash advance sources to payroll earnings codes.
Map benchmark expense types to expense types.
Map expense types to payroll earnings codes.
Map Hotel Wizard types to expense types.
Page Name |
Definition Name |
Navigation |
Usage |
EX_PY_MAP_AS |
|
Map cash advance sources to payroll earnings codes. |
|
EX_BMXPNTP_MAP_PNL |
|
Map benchmark expense types to expense types. |
|
EX_PY_MAP_TBL |
|
Map expense types to payroll earnings codes. |
|
EX_WIZARD_TBL |
|
Map Hotel Wizard types to expense types. |
Access the Advance Source - Payroll page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Adv Source - Payroll).
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 |
Access the Expense Type - Benchmark page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Expense Type - Benchmark).
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 |
Access the Expense Type - Payroll page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Expense Type - Payroll).
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 |
Access the Expense Type - Wizard Type page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Expense Type - Wizard Type).
This table maps a wizard type (an expense type that comes with Hotel Wizard) to an expense type. When an employee selects a wizard type, PeopleSoft Expenses processes the charge using the associated expense type to ensure correct accounting.
Mapping Table |
Mapping from |
Mapping to |
EX_WIZARD_TBL |
PSXLATITEM |
EX_TYPES_TBL |
To map location information, use the following components:
Country Code (EX_COUNTRY_MAP_PNG.GBL).
Currency Code (EX_CURRNCY_MAP_PNG.GBL).
Expense Location (EX_LOCTION_MAP_PNG.GBL).
State Code (EX_STATE_MAP.GBL).
This section discusses how to:
Map country codes.
Map currency codes.
Map expense locations.
Map state codes.
Page Name |
Definition Name |
Navigation |
Usage |
|
Map external source country names to country codes. |
||
EX_CURRNCY_MAP_PNL |
|
Map external source currency abbreviations to currency codes. |
|
EX_LOCTION_MAP_PNL |
|
Map external data source locations to expense locations. |
|
EX_STATE_MAP |
|
Map external data source state names to state codes. |
Access the Country Code page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Country Code).
This table maps country names used by external data sources to country codes in PeopleSoft Expenses. It works with the Expense Location map to associate external data location details with expense locations.
Mapping Table |
Mapping from |
Mapping to |
EX_COUNTRY_MAP |
External data file |
COUNTRY_TBL |
Access the Currency Code page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Currency Code).
This table maps the currency abbreviation from an external data file to a PeopleSoft Expenses currency code. Mapping associates a currency code with each expense item in the data file.
Mapping Table |
Mapping from |
Mapping to |
EX_CURRENCY_MAP |
External data file |
CURRENCY_CD_TBL |
Access the Expense Location page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Expense Location).
This table maps location details from an external data file to a PeopleSoft Expenses expense location. The table works with the Country Code and State Code maps to associate specific country details—such as state, city, or postal code—with an expense location.
Note. Although you are not required to set up State, PeopleSoft Expenses looks at this field to automatically supply the state for VAT processing during expense report entry.
Mapping Table |
Mapping from |
Mapping to |
EX_LOCATION_MAP |
External data files |
EX_LOCATION_TBL |
Access the State Code page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, State Code).
This table maps state names from external data files to the State field in PeopleSoft Expenses. It works with the Expense Location map to associate external data location details with expense locations.
Mapping Table |
Mapping from |
Mapping to |
EX_STATE_MAP |
External data files |
STATE_TBL |
To map corporate card data, use the following components:
Adv Source - Corporate Card (EX_ADV_SRC_MAP.GBL).
Expense Type - Corporate Card (EX_CCET_MAP_TBL.GBL).
Data Source - SetID (EX_SETID_MAP_PNG.GBL).
Payment Type - Corporate Card (EX_EM_MAP_TBL.GBL).
Merchant Category Group (EX_VIS_MCG_MAP.GBL).
This section discusses how to:
Map data sources to setIDs.
Map credit card codes to payment types.
Map merchant category groups to expense types.
Map credit card cash advance codes to cash advance sources.
Map merchant category groups.
Map credit card level 3 data to expense types.
Page Name |
Definition Name |
Navigation |
Usage |
EX_SETID_MAP_PNL |
|
Map external data sources to setIDs. |
|
EX_EM_MAP_TBL |
|
Map credit card codes to payment types. |
|
EX_CCET_MAP_TBL |
|
Map a credit card vendor's merchant category group to expense types. |
|
EX_ADV_SRC_MAP |
|
Map credit card cash advance codes to cash advance sources. |
|
EX_VIS_MCG_MAP |
|
Map merchant category codes to merchant category groups. |
|
EX_CCET_LV3_MAP |
Click the Level 3 Expense Type link on the Expense Type - Corporate Card page. |
Map credit card level 3 data to expense types. |
Access the Data Source - SetID page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Data Source - SetID).
This table maps external data sources to setIDs that are used in mapping other expenses information, such as benchmark expenses.
Mapping Table |
Mapping from |
Mapping to |
EX_BNCHMRKSETID |
External file |
SETID_TBL |
Access the Payment Type - Corporate Card page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Payment Type - Corporate Card).
This table maps credit card codes from external data files to PeopleSoft Expenses payment types. This enables you to associate a credit card code with a reimbursement recipient that is designated in the Payment Type definition.
Mapping Table |
Mapping from |
Mapping to |
EX_EM_MAP_TBL |
External data files |
EX_EXP_MTHD_TBL |
Access the Expense Type - Corporate Card page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Expense Type - Corporate Card).
This table maps the credit card vendor's merchant category group to an expense type in PeopleSoft Expenses. Mapping enables credit card feeds to populate expense lines automatically when an employee selects credit card transactions to process an expense report.
Level 3 Expense Type |
Click to access the Expense Type - Level 3 page. |
Mapping Table |
Mapping from |
Mapping to |
EX_CCET_MAP_TBL |
Credit card vendor files |
EX_TYPES_TBL |
Access the Advance Source - Corporate Card page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Adv Source - Corporate Card).
This table maps the credit card vendor's industry cash advance code to a cash advance source in PeopleSoft Expenses. Because cash advance line items require an advance source, mapping enables automatic population of cash advance lines by credit card feeds when employees process credit card transactions.
Mapping Table |
Mapping from |
Mapping to |
EX_ADV_MAP_TBL |
Credit card vendor file |
EX_ADV_SRC_TBL |
Access the Merchant Category Group page (Set Up Financials/Supply Chain, Product Related, Expenses, Mapping, Merchant Category Group).
This table maps standard industry merchant category codes to merchant category groups. The mapping table works with the Expense Type - Corporate Card map to associate credit card transactions with expense types through the Merchant Category Group field. This mapping is used by Visa International, Diners Club, MasterCard, and US Bank.
Mapping Table |
Mapping from |
Mapping to |
EX_VIS_MCG_MAP |
Standard industry codes provided by the vendor |
EX_CCET_MAP_TBL |
See Also
Access the Expense Type - Level 3 page (click the Level 3 Expense Type link on the Expense Type - Corporate Card page).
If you are using level 3 credit card data for hotel transactions, you must map the fields that are available in the detail and summary records to an expense type.
This table maps the credit card vendor's level 3 data to an expense type in PeopleSoft Expenses. Mapping enables credit card feeds to populate expense lines when an employee selects credit card transactions to process an expense report.
Note. If the setup of level 3 expense type is not correct or is incomplete, the expense type of the level 3 row that is created is updated with the expense type from the original financial transaction. For example, if there is not an expense type set up for MiniBar, the level 3 rows are assigned an expense type of Lodging, which is the expense type associated with the original financial transaction