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

What would be the recommended way to get the deleted records using SuiteQL? I'm assuming `DeletedRecord` table but wanted to double check.

image.png

Yep DeletedRecord
```SELECT
	DeletedRecord.isCustomTransaction,
	DeletedRecord.context,
	DeletedRecord.deletedDate,
	DeletedRecord.deletedBy,
	DeletedRecord.isCustomList,
	DeletedRecord.isCustomRecord,
	DeletedRecord.name,
	DeletedRecord.recordId,
	DeletedRecord.recordTypeId,
	DeletedRecord.scriptId,
	DeletedRecord.type
FROM
	DeletedRecord```


Thats all your fields you get along with the joins you can make