BizTalk Adapter for NetSuite

Build 20.0.7606

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. To find out more about tables and stored procedures, please navigate to their corresponding entries in this help document.

CData BizTalk Adapter 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) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7606