alien4u
CASE WHEN ({type} = 'Transfer Order' OR {type} = 'Return Authorization') AND {transactionlinetype} != 'Item' THEN 'N' ELSE 'Y' END