nextransactionlink table a linktype of ‘OrdRvCom’

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that the

nexttransactionlinelink

and

previoustransactionlinelink

tables are used to link transactions and transaction lines in NetSuite. These tables can be accessed via the NetSuite ODBC, and they exist in both the legacy and analytics schemas. The

nexttransactionlinelink

table links the lines from the

salesorder

to the

invoice

. However, there might be instances where a line is missing, possibly due to manual modifications made to the invoice after its creation. In the analytics schema, the equivalent tables might be

NextTransactionLink

and

PreviousTransactionLink

. These tables also contain a link type, which can be used to identify the type of transaction being linked. In addition to the transaction link tables, the

transaction_links

table in the legacy schema can also be used to link transactions. This table contains a

link_type

field, which can be used to identify the type of transaction being linked. It's also mentioned that you can build a workbook in the UI using the same fields as in the ODBC. This might be helpful for visualizing the data and understanding the relationships between different transactions. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******