1. Base Currency Conversion Implementation Guide
  2. Completing the Electronic Commerce Purge Checklist

Completing the Electronic Commerce Purge Checklist

These purge programs apply to the JD Edwards EnterpriseOne Electronic Commerce system from Oracle:

Purge Program

Description

√

Purge EDI Purchase Order In (R47018)

This program removes inbound transactions from these tables:

  • Purchase Order Header - Inbound (F47011)

  • EDI Purchase Order Detail - Inbound (F47012)

  • EDI Purchase Order Detail (SDQ) - Inbound (F47013)

  • EDI Order Address Information (F4706)

  • EDI Order Text Lines - Header (F4714)

  • EDI Order Text Lines Detail (F4715)

If you use taxed prices, the system deletes records from the EDI Purchase Order Header Tax - Inbound (F47011TX) and EDI Purchase Order Detail Tax - Inbound (F47012TX) tables.

Purge EDI Purchase Order Out (R47019)

This program removes outbound transactions from these tables:

  • EDI Purchase Order Header - Outbound (F47016)

  • EDI Purchase Order Additional Header - Outbound (F470161)

  • F47017

  • EDI Purchase Order Additional Detail - Outbound (F470171)

  • F4706

  • F4714

  • F4715

Purge EDI P.O. Acknowledgement In (R47028)

This program removes inbound transactions from these tables:

  • EDI P.O. Acknowledgement Header - Inbound (F47021)

  • F47022

Purge EDI P.O. Acknowledgement Out (R47029)

This program removes outbound transactions from these tables:

  • EDI P.O. Acknowledgement Header - Outbound (F47026)

  • EDI P.O. Acknowledgement Detail - Outbound (F47027)

  • F4706

  • F4714

  • F4715

If you use taxed prices, the system deletes records from the EDI Order Header - Outbound Tax (F47006) and the EDI Order Detail - Outbound Tax (F47007) tables, that were created with the EDI Invoice Header (Sales) - Outbound (F47046) and EDI Invoice Detail (Sales) - Outbound (F47047) tables.

Purge EDI Shipping Notice Out (R47039)

This program removes outbound transactions from these tables:

  • EDI Shipping Notice Header - Outbound (F47036)

  • F47037

  • F4706

  • F4714

  • F4715

If you use taxed prices, the system deletes records from the EDI Shipping Notice Header Tax - Outbound (F47036X) and the EDI Shipping Notice Detail Tax - Outbound (F470371X) tables.

Purge EDI Voucher In (R47041P)

This program removes inbound voucher transactions from these tables:

  • EDI Invoice Header - Inbound (F47041)

  • F47042

  • EDI Invoice Summary - Inbound (F47044)

Purge EDI Invoice In (R47048)

This program removes inbound invoice transactions from these tables:

  • F47041

  • F47042

  • F47044

Purge EDI Invoice Out (R47049)

This program removes outbound invoice transactions from these tables:

  • EDI Invoice Header (Sales) - Outbound (F47046)

  • F470461

  • EDI Invoice Detail (Sales) - Outbound (F47047)

  • EDI Invoice Additional Detail - Outbound (F470471)

  • F4706

  • F4714

  • F4715

If you use taxed prices, the system deletes records from the EDI Order Header - Outbound Tax (F47006) and the EDI Order Detail - Outbound Tax (F47007) tables.

Purge EDI Payment Order Out (R47059)

This program removes outbound payment transactions from these tables:

  • EDI Payment Order Header - Outbound (F47056)

  • EDI Payment Order Bank N & A - Outbound (F470561)

  • EDI Payment Order Bank Vendor N & A Outbound (F470562)

  • EDI Payment Order Payee N & A - Outbound (F470563)

  • EDI Payment Order Remittance Advice - Outbound (F47057)

Purge EDI Planning Schedule In (R47068)

This program removes inbound transactions from these tables:

  • EDI Planning Schedule Header - Inbound (F47061)

  • EDI Planning Schedule Detail - Inbound (F47062)

Purge EDI Planning Schedule Out (R47069)

This program removes outbound transactions from these tables:

  • EDI Planning Schedule Header - Outbound (F47066).

  • EDI Planning Schedule Detail - Outbound (F47067).

Purge EDI Receiving Advice In (R47078)

This program removes inbound transactions from these tables in the Procurement and Sales Order Management systems:

  • EDI Receiving Advice Header - Inbound (F47071)

  • F47072

Purge EDI Receiving Advice Out (R47079)

This program removes outbound transactions from these tables:

  • EDI Receiving Advice Header - Outbound (F47076)

  • F47077

  • F4706

  • F4714

  • F4715

Purge EDI Request for Quote Inbound Quote (R47098)

This program removes inbound transactions from these tables:

  • EDI Request for Quote Header - Inbound (F47091).

  • EDI Request for Quote Detail - Inbound (F47092).

  • EDI Request for Quote Detail (SDQ) - Inbound (F47093).

If you use taxed prices, the system deletes records from the EDI Request for Quote Header Tax – Inbound (F47091TX) and EDI Request for Quote Detail Tax – Inbound (F47092TX) tables.

Purge EDI Request for Quote Out (R47099)

This program removes outbound transactions from these tables:

  • EDI Response to RFQ Header - Outbound (F47106)

  • F471061

  • F47107

  • EDI Response to RFQ Additional Detail - Outbound (F471071)

  • F4706

  • F4714

  • F4715

Purge EDI Response to RFQ Out (R47109)

This program removes outbound transactions from these tables:

  • EDI Request for Quote Header - Outbound (F47096)

  • F47097

  • F4706

  • F4714

  • F4715

If you use taxed prices, the system deletes records from the EDI Order Header - Outbound Tax (F47006) and EDI Order Detail - Outbound Tax (F47007) tables.

Purge EDI Product Activity Data In (R47128A)

This program removes inbound transactions from these tables:

  • EDI Product Activity Data Header - Inbound (F47121)

  • EDI Product Activity Data Detail - Inbound (F47122)

  • EDI Product Activity Data (SDQ) - Inbound (F47123)

Purge EDI Product Activity Data Out (R47129A)

This program removes outbound transactions from these tables:

  • EDI Product Activity Data Header - Outbound (F47126)

  • EDI Product Activity Data Detail - Outbound (F47127)

  • EDI Product Activity Data (SDQ) - Outbound (F47128)

Purge EDI Purchase Order Change In (R47138)

This program removes inbound transactions from these tables:

  • EDI Purchase Order Change Header - Inbound (F47131)

  • F47132

  • F4706

  • F4714

  • F4715

If you use taxed prices, the system deletes records from the EDI Purchase Order Change Header Tax - Inbound (F47131TX) and EDI Purchase Order Change Detail Tax - Inbound (F47132TX) tables.

Purge EDI Purchase Order Change Out (R47139)

This program removes outbound transactions from these tables:

  • EDI Purchase Order Change Header - Outbound (F47136)

  • F47137

  • F4706

  • F4714

  • F4715

Purge EDI P.O. Change Acknowledgement In (R47148)

This program removes inbound transactions from theses tables:

  • EDI P.O. Change Acknowledgement Header - Inbound (F47141)

  • F47142

Purge EDI P.O. Change Acknowledgement Out (R47149)

This program removes outbound transactions from these tables:

  • EDI P.O. Change Acknowledgement Header - Outbound (F47146)

  • F47147

  • F4706

  • F4714

  • F4715

If you use taxed prices, the system deletes records from the EDI Order Header - Outbound Tax (F47006) and EDI Order Detail - Outbound Tax (F47007) tables.

Purge EDI Shipping Scheduler Out (R47156)

This program removes outbound transactions from these tables:

  • EDI Shipping Schedule Header - Outbound (F47156)

  • EDI Shipping Schedule Detail - Outbound (F47157)