what is the amount_linked field in the transaction_links table meant to represent?

AI generated answer (using internal Slack threads):

The

amount_linked

field in the

transaction_links

table represents the amount that is linked between two transactions. In the context of NetSuite, this could be the amount that is linked between an invoice and a payment, or between a sales order and an invoice, for example. This field is used to track the amount of money that has been applied from one transaction to another. For instance, if you have an invoice of $100 and a payment of $50 has been applied to that invoice, the

amount_linked

field in the

transaction_links

table for these two transactions would be $50. In the provided SQL query, the

amount_linked

field is used in the calculation of the

Amount

and

Amount OC

fields. The

Amount

field is calculated as the maximum amount of the transaction minus the sum of the linked amounts for payments and invoices. The

Amount OC

field is calculated in a similar way, but using the foreign currency amounts. Please note that the

amount_linked

field is used in conjunction with the

link_type

field in the

transaction_links

table, which indicates the type of link between the transactions (e.g., 'Payment'). ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******