How do I fetch all the custom fields from vendor b...
# suiteql
b
How do I fetch all the custom fields from vendor bill record type (or any native record type) using SuiteQL?
m
This will return all transaction columns and fields
Copy code
SELECT
  *
FROM
  CustomField
WHERE
  FIELDTYPE IN ('BODY', 'COLUMN')
  AND ISSTORED = 'T'
b
Is there no way to restrict that to specific transaction type like vendor bills?
I think I can use
visibleontransactions
field to filter results in JS get fields specific to vendor bills. Thanks @Matt Bernstein for the help