How do we determined which objects use 'lastmodifi...
# ask-stanley-ai
l
How do we determined which objects use 'lastmodified' and 'lastmodifieddate' in their schemas? Are there any other objects that use 'lastmodified' other than custom fields/custom records?
c
AI generated answer (using internal Slack threads):
In NetSuite, the 'lastmodified' and 'lastmodifieddate' fields are system fields that are automatically updated whenever a record is modified. These fields are available in most of the standard and custom record types in NetSuite. To determine which objects use 'lastmodified' and 'lastmodifieddate' in their schemas, you can refer to the NetSuite Records Browser. This tool provides a list of all the standard record types in NetSuite and their fields. You can search for a record type and check its fields to see if it includes 'lastmodified' or 'lastmodifieddate'. In addition to custom fields and custom records, many other standard record types in NetSuite also use 'lastmodified'. For example, entities like customers, vendors, employees, and transactions like sales orders, purchase orders, invoices, etc., all have 'lastmodified' field. However, it's important to note that the 'lastmodified' field may not always reflect the exact time when the record was created. This is because the 'lastmodified' field is updated whenever the record is saved, even if no changes were made to the record. Also, the 'lastmodified' field is updated by system processes and scripts, but the 'lastmodifiedby' field may not always reflect the user who triggered the system process or script. This is because NetSuite uses the user of the task submitter as the user for scheduled scripts started by N/task. If you need more control over the 'lastmodified' and 'lastmodifiedby' fields for auditing purposes, you could create your own custom fields and use a UserEvent script or workflow to update them upon record submit/save. For filtering records based on the time they were last modified, you can use the 'Last Modified' field in a saved search and select the relative date filter. This allows you to filter records that have been modified since a certain time, like 1:00 PM. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.826831162
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.8188802
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.812239707
Please provide your feedback on this answer.