E9.2 Archiving AP tables

[Pat Clarke]

I need to Purge AP records from F0411 based on

RPDGJ<={variable date} and​

RPPOST='D' and​

RPPST='P' and​

RPAAP=0​

however I also need to purge associated F0413 & F0414 records where the GL date <= {variable date} and there is no open amounts. Has anyone done this before and if so could you please supply the SQL statement required to achieve this purge without compromising the integrity of AP?