Invoice Release Date Field
Hello everyone - I'm working on a report that will show when an invoice went on hold and when it was released. I'm having some problems finding the 'release date' field.
In Oracle using the 'AP Inquiry' responsibility, the path is Invoices>Inquiry>Invoices - query an invoice and select the '3 Holds' tab. The field I'm trying to locate in the tables is labeled 'Release Date' here. Looking under record history, the AP_HOLD_V table is referenced but is empty when I do a SELECT * on it.
I've searched all Oracle tables for a field named many variations of 'Release Date' using the query below and have come up empty.
In Oracle using the 'AP Inquiry' responsibility, the path is Invoices>Inquiry>Invoices - query an invoice and select the '3 Holds' tab. The field I'm trying to locate in the tables is labeled 'Release Date' here. Looking under record history, the AP_HOLD_V table is referenced but is empty when I do a SELECT * on it.
I've searched all Oracle tables for a field named many variations of 'Release Date' using the query below and have come up empty.
Tagged:
0