I'm trying to get a custbody field on the transactions SQL table, I have one in there currently but can't figure out how that was done. Any ideas?

Can't you see it there when using SELECT * transaction?

No, cannot. Can't use it at all

I don't fully understand your question. You know the name of the custom field, and you can see it in the User Interface, but when you create a query what is the result? Null values? An error?

Sorry, let me re-write. I'm trying to get a custbody field to show up in suiteql on the transaction table, it's on and visible in transaction forms (invoice etc). I know this is possible because we have one (of many) custom fields that show up, though that came from a package, so not sure how. I tried to set the field I want exactly how that one was set and no dice.

Let's say your field ID is

custbody_my_field

, so you create this query

SELECT custbody_my_field FROM transaction WHERE id = 20804269

What happens next when you run the query?

Fails with error about input

Can you share the error message?

OK I think I got this -- that field does not show up in suiteql results if it's not set. I did a where custbody_field = <valid> and it gave me a transaction, then queried on the transaction.id and it gave me custbody. bangs head on desk