Views
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.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
CData JDBC Driver for NetSuite Views
| Name | Description |
| 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. |