Defining Code Sets

To define code sets, use the following components:

  • Code Set Groups (IB_CODESETGROUP).

  • Code Sets (IB_CODESET).

  • Code Set Values (IB_CODESETVAL).

This section provides an overview of code sets and discusses how to enter match names and values and associate them with buyers, and enter match names and values into code sets. It also discusses how to associate match names and values with PeopleSoft field values.

Page Name

Definition Name

Usage

Code Set Groups Page

IB_CODESETGRPVAL

Enter match names and match values and associate them with buyers.

Code Sets Page

IB_CODESET

Enter the match name and match value that you entered previously into each of the six code sets.

Code Set Values Page

IB_CODESETVAL

Enter a PeopleSoft return name and value and associate them with a match name and value.

Code sets are predefined mappings that translate data values between multiple systems. In PeopleSoft eSettlements, code sets are only relevant for inbound third-party XML invoice integration using the OAG format or cXML and are not applicable to purchase orders or receipts.

An Application Engine Transform program maps the values provided by the supplier in the XML tags in the OAG or cXML -formatted invoice to PeopleSoft invoice fields at the header, line, and distribution levels. When the program encounters an XML tag where code set functionality is employed, it translates the value in the tag into a value appropriate to the receiving application, based on the return values specified on the Code Set Values page.

This table lists six fields that appear on the voucher tables. For data translation, enter code set values for all of these fields:

Field

Code Set Name

VCHR_HDR_QV.BUSINESS_UNIT

BUSINESS_UNIT_AP

VCHR_LINE_QV.BUSINESS_UNIT_PO

BUSINESS_UNIT_PO

VCHR_LINE_QV.BUSINESS_UNIT_RECV

BUSINESS_UNIT_RECV

VCHR_LINE_QV.UNIT_OF_MEASURE

UNIT_OF_MEASURE

VCHR_LINE_QV.TAX_CD_VAT

VAT_TAX_CD

VCHR_HDR_QV.VNDR_LOC

LOCATION

Note: If a supplier can transmit correct XML tag values that correspond with PeopleSoft field values that PeopleSoft eSettlements can identify, then you do not have to enter code set values. For example, if BUY01 were transmitted by a supplier as a business unit, no code set lookup would be necessary, because PeopleSoft recognizes the business unit BUY01. However, you still must enter values for the UNIT_OF_MEASURE and—only if a given buyer operates in a value-added tax (VAT) country—for the TAX_CD_VAT fields.

PeopleSoft eSettlements supports the OAG 8 schema for SyncInvoice and ProcessInvoice BOD formats, as well as the PeopleSoft XML voucher format. The EM_VOUCHER_IN application message is used for the PeopleSoft XML format, and the SelfServiceInvoice can be used if you invoke it as a web service. For the OAG format, you can use the OAG_Invoice application message or the SelfServiceInvoiceOAG web service.

Note: Ensure you do not use special characters—such as the ampersand (&)—in your code sets, because such characters cannot be added to and saved correctly in an XML file.

See the product documentation for PeopleTools: Integration Broker

Use the Code Set Groups page (IB_CODESETGRPVAL) to enter match names and match values and associate them with buyers.

Navigation:

PeopleTools > Integration Broker > Integration Setup > Codesets > Codeset Groups > Code Set Groups

Select EM_SUPPLIER as the code set group name for each of the six fields that require XML OAG data translation.

Note: You do not have to set up code sets or code set values for a field if your system can transmit the correct XML tag value that corresponds with the respective PeopleSoft field value, but you must set up the UNIT_OF_MEASURE, and, if you must use value-added tax (VAT), also set up the VAT_TX_CD code sets.

If the supplier's application populates the OAG XML SyncInvoice BOD with the buyer name in the Header/Parties/BillToParty/PartyID/ID tag, then enter a match name of BUYER and enter the buying organization name as the match value.

Note: Use the delivered EM_SUPPLIER code set group.

Use the Code Sets page (IB_CODESET) to enter the match name and match value that you entered previously into each of the six code sets.

Navigation:

PeopleTools > Integration Broker > Integration Setup > Codesets > Codesets > Code Sets

Note: You access the page by clicking the respective EM_SUPPLIER link on the search page for each of the six fields on which you potentially must implement code set functionality. Here you add the match name and match value pair that you entered previously, to the appropriate code set.

Field or Control

Description

Match Name

Select the name of the field containing a value that you need to match for this code set. Values are: BUYER, LOCATION, PURCHASER, RECEIVING ENTITY, SUPPLIER UOM, or VAT CODE.

Match Value

Enter the value of the field that the translation program must match to initiate a translation in response to the value.

Use the Code Set Values page (IB_CODESETVAL) to enter a PeopleSoft return name and value and associate them with a match name and value.

Navigation:

PeopleTools > Integration Broker > Integration Setup > Codesets > Codeset Values > Code Set Values

Associate your match name and match value pair with the recipient's PeopleSoft field values by selecting the appropriate code set name for the PeopleSoft field that requires the incoming value to be translated.

Field or Control

Description

From Group

Displays the code set group to which the source or sending node belongs. Enter EM_SUPPLIER for PeopleSoft eSettlements.

Ensure that the code set group name is on the third-party supplier's (sending) node (the From Group field value).

Code Set Name

Displays the code set name that you selected on the search page. It contains the match name and match value permutations that you want to match.

To Group

Displays the code set group to which the target or receiving node belongs. Enter PSFT_FINANCIALS for PeopleSoft eSettlements. You do not have to enter any match values for it.

Description

Enter a description to define these code set values.

Match Name

Displays BUYER. for PeopleSoft eSettlements. Select the Select check box that corresponds to the match name, match value, and return value that you enter.

Match Value

Displays the incoming value.

Return Name

Enter a return name to which the match name-match value pair should be translated.

Return Value

Enter the return value.

Currency code is important when providing amounts. This table lists the values that must be provided as currency node attributes:

Level

Field

Tag

Header

vch_hdr_qv.txn_currency_cd

Total Amount

Line

vch_line_qv.txn_currency_cd

Extended Price

Distribution

vch_dist_qv.txn_currency_cd

Actual