JDBC Driver for Sage 50 UK

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 Sage 50 UK Views

Name Description
BankAccounts Query BankAccounts within Sage UK 50 Accounts.
FinancialAccounts Query Financial Accounts within Sage UK 50 Accounts.
Interactions Query Interactions within Sage UK 50 Accounts.
Prices Query Prices within Sage UK 50 Accounts.
Projects Query Projects within Sage UK 50 Accounts.
PurchaseOrderDeliveries Query PurchaseOrderDeliveries within Sage UK 50 Accounts.
PurchaseOrderDeliveryLineItems Query PurchaseOrderDeliveryLineItems within Sage UK 50 Accounts.
PurchaseOrderLineItems Query PurchaseOrderLines within Sage UK 50 Accounts.
Receipts Query Receipts within Sage UK 50 Accounts.
SalesCreditLineItems Query SalesCreditLineItems within Sage UK 50 Accounts.
SalesInvoiceLineItems Query SalesInvoiceLineItems within Sage UK 50 Accounts.
SalesOrderDeliveries Query SalesOrderDeliveries within Sage UK 50 Accounts.
SalesOrderDeliveryLineItems Query SalesOrderDeliveryLineItems within Sage UK 50 Accounts.
SalesOrderLineItems Query SalesOrderLineItems within Sage UK 50 Accounts.
TaxCodes Query Tax Codes within Sage UK 50 Accounts.
TradingActivities Query TradingActivities within Sage UK 50 Accounts.

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