Purging Data from the EDI Interface Tables
From the applicable EDI transaction menu (G47xxx), select the applicable purge program.
To purge data in the EDI interface tables, you select a purge program. Run the purge program to remove obsolete and unnecessary data from the inbound or outbound EDI interface tables. The system is more efficient when you keep these tables as small as possible.
Use the EDI Standard document transaction menus for the tables to purge. Each EDI Standard document transaction menu contains a Purge option for both inbound transactions and outbound transactions.
You can also purge EDI transmission values from the system. Use the F47800 Purge EDI Transmission program (R47810) to purge records from the EDI Transmission Values table (F47800). The record included transmission values, such as record type, document type and number, transmission set, translation format, transmission date, and send/receive indicator.
You must use third-party software to back up the appropriate system 47 tables before running the system 47 purge program.
This table lists purge programs that remove data from EDI interface tables:
Purge Program |
Table |
---|---|
R47098 |
F47091 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. |
R47109 |
F47106 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. |
R47018 |
F47011 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. |
R47029 |
F47026 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. |
R47138 |
F47131 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. |
R47149 |
F47146 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. |
R47078 |
F47071 |
R47039 |
F47036 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. |
R47049 |
F47046 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. |
R47099 |
F47096 |
R47021 |
F47021 |
R47028 |
F47021 |
R47019 |
F47016 |
R47148 |
F47141 |
R47139 |
F47136 |
R47078 |
F47071 |
R47079 |
F47076 |
R47048 |
F47041 |
R47038 |
F47031 |
R47128A |
F47121 |
R47129A |
F47126 |
R47068 |
F47061 |
R47069 |
F47066 |
R47156 |
F47156 |
R47041P |
F47041 |
R0411Z1P |
F0411Z1 |
R47118 |
F47111 |
R47059 |
F47056 |
R47188 |
F47191 |
R47189 |
F47181 |
R47190 |
F47171 |
R47810 |
F47800 |