This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Morning all. I am trying to fetch a list of all `Custom Item Fields` via SuiteQL. Can't seem to find the appropriate table from the Record Catalog. Does anyone have any idea? Cheers!

Edit: I suspect it's the "CustomList" but my account doesn't have permission.

```SELECT
	CustomField.description,
	CustomField.fieldType,
	CustomField.internalId,
	CustomField.id,
	CustomField.name,
	CustomField.lastModifiedDate,
	CustomField.fieldValueTypeRecord,
	CustomField.isMandatory,
	CustomField.owner,
	CustomField.recordType,
	CustomField.scriptid,
	CustomField.isShowInList,
	CustomField.isStored,
	CustomField.fieldValueType,
FROM
	CustomField
WHERE 
	CustomField.fieldType = 'ITEM'```

I suspected that was the correct Record cheers.