Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.
CData MuleSoft Connector for NetSuite Views
|BudgetExchangeRate||Retrieves the budget expense rate from NetSuite.|
|ConsolidatedExchangeRate||Gets the consolidated exchange rate, by default for each month of the actual year . You can also filter the result by PeriodName (ex. WHERE PeriodName = 'Q2 2008') or by Period_InternalId (ex. WHERE Period_InternalId = '166') .|
|CustomFields||Returns information about the custom fields in NetSuite. CustomFields may be retrieved by CustomFieldType, or by a combination of CustomFieldType and InternalId. If no CustomFieldType is specified, all custom fields will be returned.|
|CustomRecords||Returns information about the custom records in NetSuite.|
|EnumerationValues||Retrieves enumeration values for a given table. Will only return values if the TableName is specified. Only available for native tables within NetSuite and not Custom tables.|
|MyRoles||Returns the roles available for the authenticated user. This may include information for additional accounts the user is authorized to access.|
|PostingTransactionSummary||Retrieves a posting transaction summary from NetSuite. This is the reporting mechanism available from NetSuite. All record reference columns may be used in filter using either either the = or IN operator. Other operator types are not available. For NetSuite OneWorld customers, ConvertToSubsidiary may also be specified as the subsidiary all response values should be converted to.|
|SavedSearches||Returns the saved searches in NetSuite. A SearchType must be specified in order to retrieve saved searches.|
|SavedSearchRawXML||Returns the raw XML from a saved search.|
|Transactions||A view for transactions on NetSuite.|