Mapping Corporate Card Data

Use the Data Source - SetID page (EX_SETID_MAP_PNL) to map external data sources to SetIDs.

Navigation:

• Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Map Cred Card Source to SetID

• Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Map Corporate Card Data > Data Source - SetID

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

This table maps external data sources to SetIDs that are used in mapping other expenses information, such as benchmark expenses.

Use the Payment Type - Corporate Card page (EX_EM_MAP_TBL) to select corporate card issuer and map corresponding credit card codes to payment types.

Navigation:

• Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Payment Type - Corporate Card

• Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Map Corporate Card Data > Payment Type - Corporate Card

This example illustrates the fields and controls on the Payment Type - Corporate Card page.

Select the data source, SetID for the corporate card issuer, and corporate card issuer for making a payment. Based on this information, the credit card code maps to the payment type.

Use the Expense Type - Corporate Card page (EX_CCET_MAP_TBL) to map a credit card supplier's merchant category group to expense types.

Navigation:

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

• Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Map Corporate Card Data > Expense Type - Corporate Card

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

This table maps the credit card supplier'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.

Use the Advance Source - Corporate Card page (EX_ADV_SRC_MAP) to map credit card cash advance codes to cash advance sources.

Navigation:

• Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Define Credit Card Sources

• Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Map Corporate Card Data > Adv Source - Corporate Card

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

This table maps the credit card supplier'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.

Use the Merchant Category Group page (EX_VIS_MCG_MAP) to map merchant category codes to merchant category groups.

Navigation:

• Set Up Financials/Supply Chain > Product Related > Expenses > Mapping > Define Merchant Cat Group

• Travel and Expenses > Travel and Exp Admin Center > Define Expense System > Map Corporate Card Data > Merchant Category Group

This example illustrates the fields and controls on the Merchant Category Group page. You can find definitions for the fields and controls later on this page.

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, MasterCard, and US Bank.

Use the Expense Type - Enhanced Data American Express / Visa 4.4 page (EX_ENHC_DATA2) to map credit card enhanced data to expense types.

Navigation:

Click the Enhanced Data: Supplier link on the Expense Type - Corporate Card page.

This example illustrates the fields and controls on the Expense Type - Enhanced Data American Express / Visa 4.4 page. You can find definitions for the fields and controls later on this page.

This example illustrates the fields and controls on the Expense Type - Enhanced Data MasterCard 3.0 / Visa 4.0 page.

If you are using enhanced 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 supplier's enhanced 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.