it returns the shortname but I need the ui name such as vendor bill. this is for the transaction type

Have you tried BUILTIN.DF(fieldname)

so we have to use the suiteql queries to transform data?

not sure what you mean by that?

we get the following error when trying to query data: OpenAccess SDK SQL Engine]Failed to retrieve data. Error ticket# m84xamhr1aacumatdngef[400]

at a loss as to what you are looking for, query example may help

select BUILTIN.DF(type) from transaction

worked for me, if your not defining WHERE then it's probably returned too much data, which may be why you are getting that error

did you add a where clause to the query?

i did not,just copied and pasted yours but im running directly on NS through a suitelet, seems like your trying to run it on JDBC?

yes. we are trying to query with JDBC

Try this. SELECT BUILTIN.DF(type) FROM Transaction GROUP BY BUILTIN.DF(type)