SuiteQL Supported Built-in Functions
You can use built-in functions to perform certain operations in SuiteQL queries. These functions extend the capabilities that are provided by the SQL-92 specification. For example, you can use the CONSOLIDATE built-in function to convert a currency amount stored in a field to a target currency.
To use a built-in function, you must add BUILTIN. before the function name. For example, to call the CONSOLIDATE built-in function, you must use BUILTIN.CONSOLIDATE in your SuiteQL query.
The following list describes the built-in functions that are supported in SuiteQL and provides examples of each function. Some parameters are optional and are documented as such in the table, but all other parameters are required.
Some parameters include descriptions that apply to the N/query module only.