JDBC Driver for NetSuite

Build 22.0.8462

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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462