@stalbert This will give you a list of the IDs and names for all statuses for Sales Order transactions.

SELECT DISTINCT

Status,

BUILTIN.DF( Transaction.Status ) AS Status_Name

FROM

Transaction

WHERE

Type = 'SalesOrd'