Transaction with a transaction type of adjustment posted to a hospital account by contractual agreement, agreement with the guarantor, or hospital policy which modifies the balance. Adjustments cannot be payments or charges.

TRANSACTIONS.TX_TYPE in (3,4) -- debit and credit adjustments
 AND
TRANSACTIONS.IS_SYSTEM_ADJ_YN <> Y
 AND
 TRANSACTIONS.BAD_DEBT_FLAG_YN <> Y
 AND
TRANSACTIONS.EXTERN_AR_FLAG_YN,<> Y