What is the difference between the lastmodifieddate from a transaction and the linelastmodifieddate from a transactionline? When should I use each?

AI generated answer (using internal Slack threads):

The

lastmodifieddate

from a transaction and the

linelastmodifieddate

from a transaction line represent two different aspects of a transaction in NetSuite. The

lastmodifieddate

is a timestamp that indicates the last time any part of the transaction record was modified. This could be due to a change in the header information, a change in one or more line items, or any other modification to the transaction record. On the other hand, the

linelastmodifieddate

is a timestamp that indicates the last time a specific line item within the transaction was modified. This could be due to a change in the quantity, price, or any other attribute of the line item. You should use

lastmodifieddate

when you want to know the last time any part of the transaction was modified. This is useful for delta loads, where you want to sync only the transactions that have changed since the last load. You should use

linelastmodifieddate

when you want to know the last time a specific line item was modified. This is useful when you are tracking changes at the line item level, for example, when you want to know when a specific product was added or removed from a transaction. Please note that the

lastmodifieddate

may not always be updated when a line item is modified, especially if the modification is due to an external event such as inventory landing in the warehouse. In such cases, you may need to rely on the

linelastmodifieddate

or other means to track the changes. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******