Dunning notices pulling in non delinquent transactions
We're running staged dunning notices, however we're noticing that non-delinquent transactions are appearing within them and we can't figure out why. The data model is configured to exclude them, is there somewhere else we should be looking?
Copy of the data model:
select distinct *
from
(SELECT idt.dunning_id dunning_id1,
ct.trx_number invoice_number,
hca.account_number accountnumber,
hcsa.location billto,
to_char((ar.due_date),'MM/DD/YYYY') original_due_date,
(ar.amount_due_original) original_amount_due,
(ar.amount_due_remaining) amount_due_remaining,
ar.invoice_currency_code currency,
nvl(ied.financial_charge,0) finance_charges,
LOC2.location_id location_id,