In your example it does not seem possible that a check payment could end up in this table with an ACHID or creditcardID that you would have to check for, are you saying the upstream system that creates these records could enter a check payment with one of these other methods as well? where would that erroneous ID come from?