Associating the reconciliation history table with system transactions
In the CE_RECON_HISTORY_ITEMS table stores the bank statements reconcile record.
The field RECON_SOURCE shows where the matching item comes from. And I believe field SOURCE_ID populate the identifier of the corresponding system transactions. So, I want to know where I can match this SOURCE_ID and the corresponding record?
I want to know, like when the RECON_SOURCE is GL or AP or AR, from which table this SOURCE_ID populate?
If the SOURCE_ID is not for matching with the reconciled item, then how can I link the CE_RECON_HISTORY_ITEMS table with the corresponding system transactions?
Tagged:
0