Why is appliedtotransaction.lineuniquekey blank/empty on all Estimate lines except mainline? This doesn't seem the usual behavior for a transaction record. These Estimates were created by transforming an Opportunity.

AI generated answer (using internal Slack threads):

The

appliedtotransaction.lineuniquekey

field is blank or empty on all Estimate lines except the mainline because the

lineuniquekey

is a unique identifier for each line item in a transaction. In the context of an Estimate, the mainline represents the transaction as a whole, while the other lines represent the individual items or services that make up the transaction. When an Opportunity is transformed into an Estimate, the

lineuniquekey

for the mainline is generated and populated, but the

lineuniquekey

for the other lines are not, because they are not separate transactions - they are part of the mainline transaction. This behavior is consistent with how NetSuite handles line-level data in transactions. The

lineuniquekey

is intended to uniquely identify each transaction line in the database, not each item within a transaction. In other words, the

lineuniquekey

is not designed to be used as a unique identifier for individual items within a transaction. If you need to reconcile or track individual items within a transaction, you may need to use a different field or method. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******