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
Hi Jeff! The credit card and the schedule are both linked to the order, rather than the card being linked to the schedule record. The column "act_id" in T_ORDER stores the credit card that is being used for the payment schedule on that particular order. Act_id is a foreign key to T_ACCOUNT_DATA.
Thank you both for the help with this!!
Jeff