update receivables set payment_type_code = CASE WHEN payment_type_code = 0 THEN 1 WHEN payment_type_code > 0 THEN 2 ELSE NULL END;
update payables set payment_type_code = CASE WHEN payment_type_code = 0 THEN 1 WHEN payment_type_code > 0 THEN 2 ELSE NULL END;

