Hello all,
I am working on a report for scheduled order payments, and need to indicate whether there is an Account (shown in screenshot in blue) connected with the schedule. Does anybody know in which table this is stored? I don't want to display the actual account, just need to be able to report on if there is one connected to the schedule or not.
Thank you!
Hi Jeff - that's coming from the act_id column in T_ORDER. (There is also an act_no column in that table, but it has been deprecated.)
Thanks,
Patrick