The SuiteQL built in function BUILTIN.CONSOLIDATE accepts a number of parameters: Amount, View Type (LEDGER/INCOME), Consolidation Rate Type (DEFAULT/STANDARD/BUDGET), Subsidiary Rate Type (DEFAULT/CURRENT,HISTORICAL,AVERAGE), Target Subsidiary, Period and Book. Can you explain what the second parameter (View Type) means, and how it is different from the Subsidiary Rate Type parameter?

AI generated answer (using internal Slack threads):

The View Type parameter in the SuiteQL built-in function BUILTIN.CONSOLIDATE refers to the perspective from which the data is being viewed. It can be either LEDGER or INCOME. The LEDGER view type refers to the general ledger view, which includes all financial transactions. The INCOME view type refers to the income statement view, which only includes revenue and expense transactions. On the other hand, the Subsidiary Rate Type parameter refers to the type of exchange rate used for currency conversion in a multi-currency environment. It can be DEFAULT, CURRENT, HISTORICAL, or AVERAGE. DEFAULT uses the exchange rate set in the system settings. CURRENT uses the exchange rate at the time of the transaction. HISTORICAL uses the exchange rate at a specific past date. AVERAGE uses the average exchange rate over a specified period. In summary, the View Type parameter determines the scope of the data being consolidated, while the Subsidiary Rate Type parameter determines the exchange rate used for currency conversion in a multi-currency environment. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******