PeopleSoft Enterprise Payables 9.1 PeopleBook

Configuring the PeopleSoft Payables Payment Interface

This chapter provides an overview of the PeopleSoft Payables Payment Interface feature, lists common elements, and discusses how to set up the PeopleSoft Payables Payment Interface feature.

Understanding the PeopleSoft Payables Payment Interface

As delivered, the Payment Interface feature supports these payments:

PeopleSoft Payables vouchers.
PeopleSoft Expenses expense sheet and cash advance payments.
PeopleSoft Treasury settlement payments.

In addition, the Payment Interface feature enables you to produce payments from other sources (either PeopleSoft applications or third-party products). By using the Payment Interface feature to make payments from other sources, you can ensure consistent processing of all payments. You can also take advantage of the Pay Cycle Manager component (PYCYCL_MGR) in PeopleSoft Payables, which enables you to view all payments in one place, regardless of the source system of the transaction.

To process payments, PeopleSoft Payables needs certain information—for example, the recipient and the date of the payment. The PeopleSoft system must also indicate whether a payment has been made and, if so, how much was paid. You enable the system to do this by creating a mapping definition that maps the data between the source system of the transaction and PeopleSoft Payables.

For all source definitions that come with the PeopleSoft system, the necessary mapping has already been performed to support the required system functions. When you create new mapping definitions, you map the fields in a staging table to the corresponding fields in the PeopleSoft Payables PS_PYCYCL_DATA table using the Pay Cycle Mapping - Mapping Detail page.

Common Elements Used in This Chapter

Source Transaction	Select the source of the transaction that you are defining; for example, refunds, accounts payable vouchers, expense sheets, and so on.
Map Type	Select the type of map that you are creating for the source transaction.

Setting Up the PeopleSoft Payables Payment Interface

To set up PeopleSoft Payables to process payments from another source, use the Payment Source component (PYMNT_SOURCE) to define the payment source.

To process payments for any new payment source that you define, the Pay Cycle Manager component needs information about where the payment data is staged and how to map the data to the corresponding table in PeopleSoft Payables. You define this information using the Pay Cycle Mapping component (PYCYCL_MAP_DEFN).

After mapping the pay cycle, you can define the pay cycle in the Payment Selection Criteria component (PYCYCL_DEFN).

To set up the PeopleSoft Payables Payment Interface feature, use these components:

Payment Source (PYMNT_SOURCE).
Pay Cycle Mapping (PYCYCL_MAP_DEFN).

This section discusses how to:

Define payment sources.
Enter source search definitions.
Set up pay cycle mapping.
Map fields.

Pages Used to Set Up the PeopleSoft Payables Payment Interface

Page Name	Definition Name	Navigation	Usage
Payment Source	PYMNT_SOURCE_DEFN	Accounts Payable, Payments, Pay Cycle Definition, Payment Source	Add a new payment source.
Source Search Definition	PYMNT_SOURCE_DEFN2	Accounts Payable, Payments, Pay Cycle Definition, Payment Source, Source Search Definition	Enter the search record for the inquiry page that you specify on the Payment Source Definition page.
Paycycle Map	PYCYCL_MAP	Accounts Payable, Payments, Pay Cycle Definition, Mapping, Paycycle Map	Set up the pay cycle mapping for the payment source.
Mapping Detail	PYCYCL_MAP_DTL	Accounts Payable, Payments, Pay Cycle Definition, Mapping, Mapping Detail	Specify the mapping of the fields in the staging table to the corresponding fields in the PeopleSoft Payables PS_PYCYCL_DATA table.

Defining Payment Sources

Access the Payment Source page (Accounts Payable, Payments, Pay Cycle Definition, Payment Source).

Important! Before you establish sources, disable products that you don't have installed on the system on the Installed Products page. Disabling products that you do not have installed on the system improves performance.

Source Type	Select the origin for the source transaction. Options are: External: A third-party product. This identifies the payment source as external to the PeopleSoft system. Use this setting to configure the payment process for source-specific processing needs. PeopleSoft: A supported PeopleSoft product.
Product	Select the applicable PeopleSoft product from the drop-down list if you select PeopleSoft as the source type.
Business Unit Table	Enter a value to set up a business unit table record. To process payments, you must set up a business unit table record before you can add the payment source. This is a required field. Only three fields are required for the business unit table record: BUSINESS_UNIT The value that is used to select the data. For example, in PeopleSoft Payables, this is the accounts payable business unit. LOCATION Contains the address information for the business unit. BUSINESS_UNIT_GL The general ledger business unit.
Menu Name	Enter the menu name for the page that you use to run inquiries on payments if you process payments from another PeopleSoft application or if you use the same database as PeopleSoft Payables. The system uses this field in conjunction with the Menu Bar Name, Item Name, and Page Name fields to identify the page where users can run inquiries on payments for the source transactions.

Entering Source Search Definitions

Access the Source Search Definition page (Accounts Payable, Payments, Pay Cycle Definition, Payment Source, Source Search Definition).

You can define a search definition on this page only if you have entered a menu name, menu bar name, item name, and page name on the Payment Source page. To create a search definition, define the fields on this page.

If you use the source search definition default values for PeopleSoft Payables vouchers, the search is based on the business unit and voucher ID.

Note. You only need to add a Payment Document Seq (payment document sequence) field if you are using the Document Sequencing feature.

Setting Up Pay Cycle Mapping

Access the Paycycle Map page (Accounts Payable, Payments, Pay Cycle Definition, Mapping, Paycycle Map).

Input Record

Specify the staging table for the payment data. This is the table from which PeopleSoft Payables selects the payment data.

Output Record

Enter the name of the table that PeopleSoft Payables updates with payment information after the system completes payment processing. You can enter the same table name that you specified in the Record (Table) Name field.

Intermediate Record for Copy

Specify a name for a copy of the output record table. PeopleSoft Payables uses this table to process the updates to the output record table.

Select Where Clause

If the staging table contains transaction records that can be selected for payment as well as transactions that cannot be selected, specify a Where clause to select paying transactions that you want to pay.

Note. You are advised to move only selectable data to your staging table, in which case you do not need to enter a where clause.

Note. Once you set up pay cycle mapping for the source, you can use the payment source at any time without having to redefine it.

Mapping Fields

Access the Mapping Detail page (Accounts Payable, Payments, Pay Cycle Definition, Mapping, Mapping Detail).

Pay Cycle Data Element

Displays the name of the field being mapped.

Mapping Action

Specify the mapping action for each PeopleSoft Payables field name. Options are:

Both: Select if the field is both an input and output field. Selecting this option enables you to complete values in both the Input Fieldname and Output Fieldname fields. Any field marked Both is selected into the pay cycle record and included in the output record.

Input: Select if the field is an input field, and specify a corresponding value in the Input Fieldname field. Any field marked Input is selected into the pay cycle record.

None: Select if the field isn't mapped.

Output: Select if the field is an output field, and specify a corresponding value in the Output Fieldname field. Any field marked Output is included in the output record.

Input Map Type

Select from the following options:

Constant: Enables you to specify a constant field name. You must select a value from the constant type list and enter a value in the Input Constant field.

Field: Select the appropriate field from the record (table) name that you entered on the Pay Cycle Map page. You must enter a value in the Input Fieldname field.

Input Fieldname

Specify the appropriate field name from the staging table if you select the Input mapping action value and also the Field input map type value.

Const Type (constant type)

Specify the type of data that the field contains. Options are:

Character: The values entered into the field are characters.

Numeric: The values entered into the field are numbers.

Input Constant

Enter the constant value that the field displays if you select Constant as the input map type.

Output Field Name

Specify the appropriate output field name from the output record that you specified on the Pay Cycle Map page. You must complete this field when you specify either the Both or Output field values from the Mapping Action field.

Key Field

Select to indicate if the mapped field is a key field in the source system. When you save the mapping, the system generates SQL statements that update the unique key field source information.

Input Record	Specify the staging table for the payment data. This is the table from which PeopleSoft Payables selects the payment data.
Output Record	Enter the name of the table that PeopleSoft Payables updates with payment information after the system completes payment processing. You can enter the same table name that you specified in the Record (Table) Name field.
Intermediate Record for Copy	Specify a name for a copy of the output record table. PeopleSoft Payables uses this table to process the updates to the output record table.
Select Where Clause	If the staging table contains transaction records that can be selected for payment as well as transactions that cannot be selected, specify a Where clause to select paying transactions that you want to pay. Note. You are advised to move only selectable data to your staging table, in which case you do not need to enter a where clause.

Pay Cycle Data Element	Displays the name of the field being mapped.
Mapping Action	Specify the mapping action for each PeopleSoft Payables field name. Options are: Both: Select if the field is both an input and output field. Selecting this option enables you to complete values in both the Input Fieldname and Output Fieldname fields. Any field marked Both is selected into the pay cycle record and included in the output record. Input: Select if the field is an input field, and specify a corresponding value in the Input Fieldname field. Any field marked Input is selected into the pay cycle record. None: Select if the field isn't mapped. Output: Select if the field is an output field, and specify a corresponding value in the Output Fieldname field. Any field marked Output is included in the output record.
Input Map Type	Select from the following options: Constant: Enables you to specify a constant field name. You must select a value from the constant type list and enter a value in the Input Constant field. Field: Select the appropriate field from the record (table) name that you entered on the Pay Cycle Map page. You must enter a value in the Input Fieldname field.
Input Fieldname	Specify the appropriate field name from the staging table if you select the Input mapping action value and also the Field input map type value.
Const Type (constant type)	Specify the type of data that the field contains. Options are: Character: The values entered into the field are characters. Numeric: The values entered into the field are numbers.
Input Constant	Enter the constant value that the field displays if you select Constant as the input map type.
Output Field Name	Specify the appropriate output field name from the output record that you specified on the Pay Cycle Map page. You must complete this field when you specify either the Both or Output field values from the Mapping Action field.
Key Field	Select to indicate if the mapped field is a key field in the source system. When you save the mapping, the system generates SQL statements that update the unique key field source information.