my $sql = "SELECT * FROM Cust_act_da WHERE CustomerNumber = $CustomerNumber AND #TransType = P";
print $sql;
$db->SQL( $sql );