AP_HOLDS_ALL record deleted from the table

Summary:

Hi All,

we are trying to build a dashboard for AP invoices and related holds. During some tests, we notices that some record in the table ap_holds_all disappeared. We are using invoice_id as key to find holds lines on the ap_holds_all table.

Do you know any scenarios in AP when an hold it's phisically canceld from the database ? Most of the cases the hold it's always visible in the table ( when relerased - a release code it's applied), but seems that sometimes are just cancelled from the table.

Thanks,

Carlo

Content (please ensure you mask any confidential information):