This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Where can I find the fields "totvar" and "variance", related to "FxReval" type. I need to find the table where they are referenced in order to create a SuiteQL query

&gt;*AI generated answer (using internal Slack threads):*
Based on the conversations, it seems that the fields "totvar" and "variance" related to "FxReval" type are not directly mentioned. However, you can find the fields in NetSuite by using the Records Catalog. You can navigate to it via SETUP &gt; Records Catalog. This will give you an overview of what fields are available on the table.

Additionally, you can use SuiteQL to query the database and find the fields. Here is a sample query that you can modify to suit your needs: 

```SELECT * FROM item WHERE ROWNUM &lt; 3```

Please replace 'item' with the appropriate table name for your case. This query will give you an idea of what fields are available on the table.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1632234928261300|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.807625115

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1593472856039400|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.795109

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1616440983271600|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.790389538



Please provide your feedback on this answer.