Generic Inquiry for Reclassify payments in Cash Management
Ah, I've never used this screen before.
It looks to me like the Reclassify Payments (CA506500) screen is showing transactions from the Transaction Details tab on the Transactions (CA304000) screen. You can use the Inspect Element trick (click here for more info) on the Transactions (CA304000) screen to see that the two tables involved are CAAdj for the header fields and CASplit for the line fields.
You can join CASplit to CAAdj on CASplit.AdjTranType=CAAdj.AdjTranType and CASplit.AdjRefNbr=CAAdj.AdjRefNbr.
If you use Inspect Element on the Document Ref. field on the Transactions (CA304000) screen, you can see that it can be found in the CAAdj.ExtRefNbr.
But if you just want one field added to the grid on the Reclassify Payments (CA506500) screen, you'd probably be better off just customizing the screen because then you could still use the PROCESS and PROCESS ALL buttons which you wouldn't be able to do in a Generic Inquiry.
I've already use the inspect element. My problem is that I want to see the reclassification Ref nbr. but when I use the inspect element it tells me to use CASplitExt and the field is ChildOrigRefNbr. But when I join the two tables (CASplitExt to CAAdj on CASplitExt.AdjTranType=CAAdj.AdjTranType and CASplitExt.AdjRefNbr=CAAdj.AdjRefNbr) there's an error. Please the attached files.