Tables
The driver models the data in Sage 50 UK as a list of tables in a relational database that can be queried using standard SQL statements.
CData JDBC Driver for Sage 50 UK Tables
| Name | Description |
| Commodities | Create, Update and Query Commodities (Products and Services) within Sage UK 50 Accounts. |
| Contacts | Create, Update, Delete, and Query Contacts within Sage UK 50 Accounts. |
| PurchaseOrders | Create, Update, Delete, and Query PurchaseOrders within Sage UK 50 Accounts. |
| SalesCredits | Query SalesCredits within Sage UK 50 Accounts. |
| SalesInvoices | Query SalesInvoices within Sage UK 50 Accounts. |
| SalesOrders | Create, Update, Delete, and Query SalesOrders within Sage UK 50 Accounts. |
| TradingAccounts | Create, Update, Delete, and Query TradingAccounts within Sage UK 50 Accounts. |