What table stores the system transactions reference number for Bank Statement (CE) reconciled items
Summary:
We are attempting to replicate the Cash Management Bank Statements>Manual Reconciliation page>Reconciled tab in a custom OTBI Report. For system transactions lines, we cannot find the Reference number (i.e., check number from Payables) within the CE reconciled items tables. Navigation to the page we want to replicate is Cash Management>Bank Statements and Reconciliation>Manual Reconciliation>Search up specific bank statement id>Reconciled tab. We are getting all the right results with our query but the CE_RECON_HISTORY_ITEMS table, which has the system transactions in it, returns null for the Reference field on all system transactions. Again, these are for RECONCILED items - not items available