CFR11 column "ISDELETE" does not indicate deleted records?
Hi all,
I am turning off the cfr11 audit on table CRPDTA.F1201 in Oracle database with the document below:
E1: CFR11: How to Delete an Audit Table from the System (Doc ID 1492517.1)
In the task, I found that column ISDELETE had two values, blank and N.
> SELECT FAISDELETE,COUNT(*) FROM CRPDTA.F1201_ADT GROUP BY FAISDELETE ORDER BY 1;
> 48008
> N 29484
Does it indicate whether the records is deleted?
If so, I think that I should delete blank records or "N" records. Is it correct?
If not, what do the column and values indicate?
Any information is appreciated.
Regards,
Koichi
JD Edwards EnterpriseOne 9.1, tools 9.1.4.7