I am wanting to find a way to identify the target table that built-in function is magically joining to. I understand that status "G" is "Sales Order : Billed" but i can't figure out where that friendly name is derived from . . . where does that friendly string or the data that is pulled in to create it actually live? we have a system with some custom order statuses and so forth and i'm trying to understand this basic mystery . . . i bet @tdietrich has some insight . . . i've read your blog which is awesome, but i want (need) to understand under the covers in order to reverse engineer some things with live system

_Transaction_ _Statuses_ for SuiteScript Search Filters if you just want a list

thanks @battk but i'm trying to get at the underlying mechanism . . . sometimes it's obvious the name of the target table DF would target but

status

is not clear and it stands as an example of me wanting to understand not only what is the target table(s) for status but finding that out whenever such a mystery is encountered

@smoke raven I wish I fully understood the logic behind the BUILTIN functions when it comes to the transaction status column. The best I can do is share this query with you that might shed some light on it...

SELECT DISTINCT
	Type,
	BUILTIN.DF( Type ) AS TypeDF,
	Status,
	BUILTIN.DF( Status ) AS StatusDF,
	<http://BUILTIN.CF|BUILTIN.CF>( Status ) AS StatusCF
FROM
	Transaction
ORDER BY
	Type,
	Status

That query might take awhile to resolve. Depends on the number of transactions that you have in your account.

ooohh, that is a nice advancement of the mystery @tdietrich thanks so much!