I've seen this sort of things before. I think what's really going on is that the underlying value is being mapped to something else automatically. Give this a try:

SELECT DISTINCT

ID,

TranID,

Status,

FROM

Transaction

WHERE

Type = 'SalesOrd'

AND Status = 'SalesOrd:B'