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 |
---|---|---|
IB_CODESETGRPVAL |
Enter match names and match values and associate them with buyers. |
|
IB_CODESET |
Enter the match name and match value that you entered previously into each of the six code sets. |
|
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:
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:
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:
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 |