Netsuite Custom Fields via SuiteQL

I’m working on pulling NS custom fields (List/Record and all options available) and I have a few questions.

  1. Is it possible to query for custom fields that are on the credit card charge forms? And which ones are mandatory?
    1. There’s a visibleontransactions field on the customfield object in SuiteQL that is a comma separated list, and for fields that are on the credit card form, there’s an entry called “CardChrg”. Does anyone know if this is common?
  2. Is it possible to query for custom fields that are on the vendor creation forms? And which ones are mandatory?
  3. Is it possible to fetch the mapping of Native Records to Internal IDs via SuiteQL?
    1. https://netsuite.custhelp.com/app/answers/detail/a_id/35382/kw/record%20type%20id is a hack to do it client-side, but wondering if there’s a way to do it server-side.
Rookie Asked on November 12, 2021 in SuiteScript.
Add Comment
1 Answer(s)

I have been trying to get table and form definitions in detail several ways without major success. I have got minor properties.

Tim’s Sql tool gets custom column definitions in your account and may be a starting point.

https://timdietrich.me/netsuite-suitescripts/suiteql-query-tool/downloads/

Please update this is you find a solution.

 

Rookie Answered 6 hours ago.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Limebox   Become a Sponsor