Transferring Additional Vendor Data

Both the Shopping Cart Processor (J43E0020) and the PO Dispatch Processor (J43E0030) contain five generic cross-reference fields that you can use to transfer vendor data that does not have a corresponding JD Edwards EnterpriseOne field. These cross-reference fields are part of the built-in extension functionality within the Direct Connect solution. You can customize the inbound Direct Connect Punch-Out Order message and pass these fields through the JD Edwards EnterpriseOne system, where the message is stored in the Shopping Cart Cross Reference table (F43E15). That information is then sent to the PO Dispatch Order Request message. Customizations can leverage these fields to store cross-reference keys for special data.

For example, if your vendor wants to send back a promotion ID number when a JD Edwards EnterpriseOne user checks out of his shopping website, you can use one of these generic fields in the J43E0020 to transport the promotion ID number to the JD Edwards EnterpriseOne system. The data is stored in the F43E15 table. You must work with your vendors to determine their data requirements and then customize both the PunchOutOrderMessage_CXML12016.xsd and the Map_PunchOutOrderMessage_From_CXML12016_To_E1XML.xsl to use the generic fields.

Note: You can find the Map_PunchOutOrderMessage_From_CXML12016_To_E1XML.xsl under J43E0040 in Object Manager Workbench (OMW).

Similarly, if you want to include that promotion ID number when you dispatch purchase orders to your vendors using the J43E0030, you can include the data that is stored in the F43E15 table. Again, you must customize the OrderRequest_CXML12016.xsd and the Map_OrderRequest_From_E1XML_To_CXML12016.xsl to include the generic fields.

These five fields in the F43E15 table are available to store customized vendor data:

  • CrossReference01 (CRSREF01)

  • CrossReference02 (CRSREF02)

  • CrossReference03 (CRSREF03)

  • CrossReference04 (CRSREF04)

  • CrossReference05 (CRSREF05)

Note: If you must customize a business service, Oracle recommends that you copy the existing business service and then customize the copy. Do not change the code of the business service that is delivered with the JD Edwards EnterpriseOne system.