T_AUTO_REJECTS (what populates this table)

The version 14 document states that  -- The T_AUTO_REJECTS table contains a row for each credit card decline or other error that occurs during a autobill run.

The document doesn't state where the table is populated from. I'm at a loss because AP_RAISE_BILLS_1 has no mention what so ever of T_AUTO_REJECTS table. 

Yet somehow with the pledge bills it gets populated. 

I ask cause we built a report of the T_AUTO_REJECTS and t_pledge_bill2 table joining them the following way (see below). The report worked great until v14 got implemented and that is because the amount and bill amounts respectively no longer matched. 

select *
from T_AUTO_REJECTS x
join t_pledge_bill2 b on x.pb_no = b.pb_no and x.customer_no = b.customer_no and x.act_id = b.act_id and x.Amount = b.bill_amt

I have been searching high and low in an effort to find where the Rejects table gets populated and what may have changed and to no avail. (is there a Master document in tessitura that states what tables/triggers/processes populate what tables?)

Now what happens is the Amount in T_AUTO_REJECTS is always coming back as zero (0) and the bill_amount in t_pledge_bill2 comes back as the billed amount. Where has this changed, how do i remedy this? will this affect past data. 

Thank you

Parents Reply Children
  • Yes, I found the exact same Procedure. That updates on value, and doesn't affect anything useful. I have a script too and did a search throughout impresario and couldn't find something. Thanks for the reply. I am hoping someone from Tessitura can help shed some light on this or maybe there is someone out there who stumbled on this before.