11.5.9 Prepayment SQL

user12193359

Cheryl Riniker-Oracle

This is a discussion, not a document, so I can only comment on the document.
Prepayments are in the ap_invoices_all table. To find them, do the following:

Select * from ap_invoices_all
where invoice_type_lookup_code = 'PREPAYMENT';