Anyone know how to get just the status portion of the transaction, or do you need to use string replacement? Field: t.status Looking for “Paid in Full” instead of “Bill : Paid In Full”

It's a bit of a pain, but you could SUBSTR(BUILTIN.DF(t.status), INSTR(BUILTIN.DF(t.status), ':')+2,99). This would at least give you what you want from the SuiteQL statement without have to do processing after the fact.

@Cory Weiner Here's what I've been using:

REPLACE( BUILTIN.DF( Transaction.Status ), BUILTIN.DF( Transaction.Type ) || ' : ', '' ) AS StatusClean

And this returns all status codes, for all transaction types - including the "clean" status value.

SELECT DISTINCT
	Transaction.Type,
	BUILTIN.DF( Transaction.Type ) AS TypeName,
	Transaction.Status,
	BUILTIN.DF( Transaction.Status ) AS StatusName,
	REPLACE( BUILTIN.DF( Transaction.Status ), BUILTIN.DF( Transaction.Type ) || ' : ', '' ) AS StatusClean
FROM
	Transaction
ORDER BY
	Transaction.Type,
	Transaction.Status