Naomi,
, cast(.null. as C(16)) as cBounced_check_payer_code_fk,

guessing that this is a foreign key:
is your RI *safe* to work with .null. ?
Might explain some of the SchroedingBug behaviour.

BTW: have a look at your mail account...

regards

thomas