Tables
The driver models the data in Reckon Accounts Hosted into a list of tables that can be queried using standard SQL statements.
Generally, querying Reckon Accounts Hosted tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
CData JDBC Driver for Reckon Accounts Hosted Tables
| Name | Description |
| Accounts | Create, update, delete, and query Reckon Accounts. |
| BillExpenseItems | Create, update, delete, and query Reckon Bill Expense Line Items. |
| BillLineItems | Create, update, delete, and query Reckon Bill Line Items. |
| BillPaymentChecks | Create, update, delete, and query Reckon Bill Payment Checks. |
| BillPaymentChecksAppliedTo | Create, update, delete, and query Reckon Bill Payment AppliedTo aggregates. In a Bill Payment, each AppliedTo aggregate represents the Bill transaction to which this part of the payment is being applied. |
| BillPaymentCreditCards | Create, update, delete, and query Reckon Bill Payments. |
| BillPaymentCreditCardsAppliedTo | Create, update, delete, and query Reckon Bill Payment AppliedTo aggregates. In a Bill Payment, each AppliedTo aggregate represents the Bill transaction to which this part of the payment is being applied. |
| Bills | Create, update, delete, and query Reckon Bills. |
| BuildAssemblies | Delete and query Reckon Build Assembly transactions. |
| BuildAssemblyLineItems | Create and query Reckon Build Assembly transactions. |
| CheckExpenseItems | Create, update, delete, and query Reckon Check Expense Line Items. |
| CheckLineItems | Create, update, delete, and query Reckon Check Line Items. |
| Checks | Create, update, delete, and query Reckon Checks. |
| Class | Create, delete, and query Reckon Classes. |
| CreditCardChargeExpenseItems | Create, update, delete, and query Reckon Credit Card Charge Expense Line Items. |
| CreditCardChargeLineItems | Create, update, delete, and query Reckon Credit Card Charge Line Items. |
| CreditCardCharges | Create, update, delete, and query Reckon Credit Card Charges. |
| CreditCardCreditExpenseItems | Create, update, delete, and query Reckon Credit Card Credit Expense Line Items. |
| CreditCardCreditLineItems | Create, update, delete, and query Reckon Credit Card Credit Line Items. |
| CreditCardCredits | Create, update, delete, and query Reckon Credit Card Credits. |
| CreditMemoLineItems | Create, update, delete, and query Reckon Credit Memo Line Items. |
| CreditMemos | Create, update, delete, and query Reckon Credit Memos. |
| CustomerMessages | Create, delete, and query Customer Messages. |
| Customers | Create, update, delete, and query Reckon Customers. |
| CustomerTypes | Create, update, delete, and query Reckon Customer Types. |
| DateDrivenTerms | Create, delete, and query Reckon Date Driven Terms. |
| DepositLineItems | Create, update, delete, and query Reckon Deposit Line Items. |
| Deposits | Create, update, delete, and query Reckon Deposits. |
| EmployeeEarnings | Create, update, delete, and query Reckon Employee Earnings. |
| Employees | Create, update, delete, and query Reckon Employees. |
| EstimateLineItems | Create, update, delete, and query Reckon Estimate Line Items. |
| Estimates | Create, update, delete, and query Reckon Estimates. |
| InventoryAdjustmentLineItems | Create and query ReckonAccountsHosted Inventory Adjustment Line Items. |
| InventoryAdjustments | Create, query, and delete ReckonAccountsHosted Inventory Adjustments. |
| InvoiceLineItems | Create, update, delete, and query Reckon Invoice Line Items. |
| Invoices | Create, update, delete, and query Reckon Invoices. |
| ItemLineItems | Create, update, delete, and query Reckon Item Line Items. |
| ItemReceiptExpenseItems | Create, update, delete, and query Reckon Item Receipt Expense Line Items. |
| ItemReceiptLineItems | Create, update, delete, and query Reckon Item Receipt Line Items. |
| ItemReceipts | Create, update, delete, and query Reckon Item Receipts. |
| Items | Create, update, delete, and query Reckon Items. |
| JournalEntries | Create, update, delete, and query Reckon Journal Entries. Note that while Journal Entry Lines can be created with a new Journal Entry, they cannot be added or removed from an existing Journal Entry. |
| JournalEntryLines | Create, update, delete, and query Reckon Journal Entries. Note that while Journal Entry Lines can be created with a new Journal Entry, they cannot be added or removed from an existing Journal Entry. |
| OtherNames | Create, update, delete, and query Reckon Other Name entities. |
| PaymentMethods | Create, update, delete, and query Reckon Payment Methods. |
| PayrollNonWageItems | Query Reckon Non-Wage Payroll Items. |
| PayrollWageItems | Create and query Reckon Wage Payroll Items. |
| PriceLevelPerItem | Create and query Reckon Price Levels Per Item. Only Reckon Premier and Enterprise support Per-Item Price Levels. Note that while Price Levels can be added from this table, you may only add Per-Item Price Levels from this table. Price Levels may be deleted from the PriceLevels table. |
| PriceLevels | Create, delete, and query Reckon Price Levels. Note that while Price Levels can be added and deleted from this table, you may add only fixed-percentage Price Levels from this table. Per-Item Price Levels may be added via the PriceLevelPerItem table. |
| PurchaseOrderLineItems | Create, update, delete, and query Reckon Purchase Order Line Items. |
| PurchaseOrders | Create, update, delete, and query Reckon Purchase Orders. |
| ReceivePayments | Create, update, delete, and query Reckon Receive Payment transactions. |
| ReceivePaymentsAppliedTo | Create, update, and query Reckon Receive Payment AppliedTo aggregates. In a Receive Payment, each AppliedTo aggregate represents the transaction to which this part of the payment is being applied. |
| SalesOrderLineItems | Create, update, delete, and query Reckon Sales Order Line Items. |
| SalesOrders | Create, update, delete, and query Reckon Sales Orders. |
| SalesReceiptLineItems | Create, update, delete, and query Reckon Sales Receipt Line Items. |
| SalesReceipts | Create, update, delete, and query Reckon Sales Receipts. |
| SalesReps | Create, update, delete, and query Reckon Sales Rep entities. |
| SalesTaxCodes | Create, update, delete, and query Reckon Sales Tax Codes. |
| SalesTaxItems | Create, update, delete, and query Reckon Sales Tax Items. |
| ShippingMethods | Create, update, delete, and query Reckon Shipping Methods. |
| StandardTerms | Create, update, delete, and query Reckon Standard Terms. |
| StatementCharges | Create, update, delete, and query Reckon Statement Charges. |
| TimeTracking | Create, update, delete, and query Reckon Time Tracking events. |
| ToDo | Create, update, delete, and query Reckon To Do entries. |
| VehicleMileage | Create, update, delete, and query Reckon Vehicle Mileage entities. |
| VendorCreditExpenseItems | Create, update, delete, and query Reckon Vendor Credit Expense Line Items. |
| VendorCreditLineItems | Create, update, delete, and query Reckon Vendor Credit Line Items. |
| VendorCredits | Create, update, delete, and query Reckon Vendor Credits. |
| Vendors | Create, update, delete, and query Reckon Vendors. |
| VendorTypes | Create, update, delete, and query Reckon Vendor Types. |