JDBC Driver for Exact Online

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 Exact Online Views

Name Description
AbsenceRegistrations Usage information for the operation AbsenceRegistrations.rsd.
AbsenceRegistrationTransactions Usage information for the operation AbsenceRegistrationTransactions.rsd.
AccountantInfo Usage information for the operation AccountantInfo.rsd.
AccountClasses Usage information for the operation AccountClasses.rsd.
AccountClassificationNames Usage information for the operation AccountClassificationNames.rsd.
AccountClassifications Usage information for the operation AccountClassifications.rsd.
ActiveEmployments Usage information for the operation ActiveEmployments.rsd.
AddressStates Usage information for the operation AddressStates.rsd.
AgingOverview Usage information for the operation AgingOverview.rsd.
AgingPayablesList Usage information for the operation AgingPayablesList.rsd.
AgingReceivablesList Usage information for the operation AgingReceivablesList.rsd.
AssetGroups Usage information for the operation AssetGroups.rsd.
Assets Usage information for the operation Assets.rsd.
AvailableFeatures Usage information for the operation AvailableFeatures.rsd.
Banks Usage information for the operation Banks.rsd.
BatchNumbers Usage information for the operation BatchNumbers.rsd.
Budgets Usage information for the operation Budgets.rsd.
CRMDocuments Usage information for the operation CRMDocuments.rsd.
Currencies Usage information for the operation Currencies.rsd.
CurrentYear_AfterEntry Usage information for the operation CurrentYear_AfterEntry.rsd.
CurrentYear_Processed Usage information for the operation CurrentYear_Processed.rsd.
DefaultMailbox Usage information for the operation DefaultMailbox.rsd.
Departments Usage information for the operation Departments.rsd.
Divisions Usage information for the operation Divisions.rsd.
DocumentCategories Usage information for the operation DocumentCategories.rsd.
DocumentsAttachments Usage information for the operation DocumentsAttachments.rsd.
DocumentTypeCategories Usage information for the operation DocumentTypeCategories.rsd.
DocumentTypes Usage information for the operation DocumentTypes.rsd.
Employees Usage information for the operation Employees.rsd.
EmploymentContractFlexPhases Usage information for the operation EmploymentContractFlexPhases.rsd.
EmploymentContracts Usage information for the operation EmploymentContracts.rsd.
EmploymentEndReasons Usage information for the operation EmploymentEndReasons.rsd.
EmploymentOrganizations Usage information for the operation EmploymentOrganizations.rsd.
Employments Usage information for the operation Employments.rsd.
EmploymentSalaries Usage information for the operation EmploymentSalaries.rsd.
FinancialPeriods Usage information for the operation FinancialPeriods.rsd.
GLAccountClassificationMappings Usage information for the operation GLAccountClassificationMappings.rsd.
GLClassifications Usage information for the operation GLClassifications.rsd.
GLSchemes Usage information for the operation GLSchemes.rsd.
GLTransactionTypes Usage information for the operation GLTransactionTypes.rsd.
HourCostTypes Usage information for the operation HourCostTypes.rsd.
ItemChargeRelation Usage information for the operation ItemChargeRelation.rsd.
ItemGroups Usage information for the operation ItemGroups.rsd.
ItemsExtraFields Get the values of extra fields (custom fields) for Items.
ItemVersions Usage information for the operation ItemVersions.rsd.
ItemWarehousePlanningDetails Usage information for the operation ItemWarehousePlanningDetails.rsd.
ItemWarehouseStorageLocations Usage information for the operation ItemWarehouseStorageLocations.rsd.
JobGroups Usage information for the operation JobGroups.rsd.
JobTitles Usage information for the operation JobTitles.rsd.
JournalStatusList Usage information for the operation JournalStatusList.rsd.
Layouts Usage information for the operation Layouts.rsd.
LeadSources Usage information for the operation LeadSources.rsd.
LeaveBuildUpRegistrations Usage information for the operation LeaveBuildUpRegistrations.rsd.
LeaveRegistrations Usage information for the operation LeaveRegistrations.rsd.
MailMessagesReceived Usage information for the operation MailMessagesReceived.rsd.
Me Usage information for the operation Me.rsd.
OpportunityContacts Usage information for the operation OpportunityContacts.rsd.
OutstandingInvoicesOverview Usage information for the operation OutstandingInvoicesOverview.rsd.
PayablesList Usage information for the operation PayablesList.rsd.
Payments Usage information for the operation Payments.rsd.
PaymentTerms Usage information for the operation PaymentTerms.rsd.
PayrollComponents Usage information for the operation PayrollComponents.rsd.
PayrollTransactions Usage information for the operation PayrollTransactions.rsd.
PreferredMailbox Usage information for the operation PreferredMailbox.rsd.
PreviousYear_AfterEntry Usage information for the operation PreviousYear_AfterEntry.rsd.
PreviousYear_Processed Usage information for the operation PreviousYear_Processed.rsd.
PriceListPeriods Usage information for the operation PriceListPeriods.rsd.
PriceLists Usage information for the operation PriceLists.rsd.
PriceListsLinkedAccounts Usage information for the operation PriceListsLinkedAccounts.rsd.
PriceListVolumeDiscounts Usage information for the operation PriceListVolumeDiscounts.rsd.
ProfitLossOverview Usage information for the operation ProfitLossOverview.rsd.
ProjectBudgetTypes Usage information for the operation ProjectBudgetTypes.rsd.
ProjectWBS Usage information for the operation ProjectWBS.rsd.
PurchaseOrderLines Usage information for the operation PurchaseOrderLines.rsd.
PurchaseOrders Usage information for the operation PurchaseOrders.rsd.
QuotationHeaders Usage information for the operation QuotationHeaders.rsd.
ReasonCodes Usage information for the operation ReasonCodes.rsd.
Receivables Usage information for the operation Receivables.rsd.
ReceivablesList Usage information for the operation ReceivablesList.rsd.
RecentCosts Usage information for the operation RecentCosts.rsd.
RecentHours Usage information for the operation RecentHours.rsd.
ReportingBalance Usage information for the operation ReportingBalance.rsd.
Returns Usage information for the operation Returns.rsd.
RevenueList Usage information for the operation RevenueList.rsd.
Schedules Usage information for the operation Schedules.rsd.
SerialNumbers Usage information for the operation SerialNumbers.rsd.
ShippingMethods Usage information for the operation ShippingMethods.rsd.
StockBatchNumbers Usage information for the operation StockBatchNumbers.rsd.
StockPositions Usage information for the operation StockPositions.rsd.
StockSerialNumbers Usage information for the operation StockSerialNumbers.rsd.
StorageLocations Usage information for the operation StorageLocations.rsd.
StorageLocationStockPositions Usage information for the operation StorageLocationStockPositions.rsd.
SubscriptionLineTypes Usage information for the operation SubscriptionLineTypes.rsd.
SubscriptionReasonCodes Usage information for the operation SubscriptionReasonCodes.rsd.
SubscriptionTypes Usage information for the operation SubscriptionTypes.rsd.
TaxComponentRates Usage information for the operation TaxComponentRates.rsd.
TaxEmploymentEndFlexCodes Usage information for the operation TaxEmploymentEndFlexCodes.rsd.
TaxScheduleComponents Usage information for the operation TaxScheduleComponents.rsd.
TaxSchedules Usage information for the operation TaxSchedules.rsd.
TimeAndBillingAccountDetails Usage information for the operation TimeAndBillingAccountDetails.rsd.
TimeAndBillingActivitiesAndExpenses Usage information for the operation TimeAndBillingActivitiesAndExpenses.rsd.
TimeAndBillingEntryAccounts Usage information for the operation TimeAndBillingEntryAccounts.rsd.
TimeAndBillingEntryProjects Usage information for the operation TimeAndBillingEntryProjects.rsd.
TimeAndBillingEntryRecentAccounts Usage information for the operation TimeAndBillingEntryRecentAccounts.rsd.
TimeAndBillingEntryRecentActivitiesAndExpenses Usage information for the operation TimeAndBillingEntryRecentActivitiesAndExpenses.rsd.
TimeAndBillingEntryRecentHourCostTypes Usage information for the operation TimeAndBillingEntryRecentHourCostTypes.rsd.
TimeAndBillingEntryRecentProjects Usage information for the operation TimeAndBillingEntryRecentProjects.rsd.
TimeAndBillingItemDetails Usage information for the operation TimeAndBillingItemDetails.rsd.
TimeAndBillingProjectDetails Usage information for the operation TimeAndBillingProjectDetails.rsd.
TimeCostTransactions Usage information for the operation TimeCostTransactions.rsd.
TransactionLines Usage information for the operation TransactionLines.rsd.
Units Usage information for the operation Units.rsd.
UserRoles Usage information for the operation UserRoles.rsd.
UserRolesPerDivision Usage information for the operation UserRolesPerDivision.rsd.
Users Usage information for the operation Users.rsd.
VatPercentages Usage information for the operation VatPercentages.rsd.

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