Do not include records with a valid department number in tender
total for subtotaling. These are typically manufacturer coupons.
Because they're flipped to trans_subtype='T' after completing a
transaction they alter the subtotal on reprinted receipts in
a confusing way.
MySQL strings aren't zero-indexed because of course they aren't...