Tables
The provider models the data in Reckon as a list of tables in a relational database that can be queried using standard SQL statements.
CData ADO.NET Provider for Reckon 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. |
| CreditCardRefunds | Query and Insert Reckon AR Credit Card Refund transactions. |
| CreditMemoLineItems | Create, update, delete, and query Reckon Credit Memo Line Items. |
| CreditMemos | Create, update, delete, and query Reckon Credit Memos. |
| Currency | Create, update, delete, and query Reckon Currencies. This table requires QBXML version 8.0 or higher, and you will need to enable multiple Currencies in your Reckon company file to use it. |
| CustomerContacts | Create, update, delete, and query Reckon Customer Contacts. This table requires QBXML version 12.0 or higher, and is only available in Reckon editions 2016 and above. |
| CustomerMessages | Create, delete, and query Customer Messages. |
| CustomerNotes | Create, update, and query Reckon Customer Notes. This table requires QBXML version 12.0 or higher. |
| Customers | Create, update, delete, and query Reckon Customers. |
| CustomerShippingAddresses | Create, update, delete, and query Reckon Customer Shipping Addresses. Multiple Customer Shipping Addresses are supported in only Reckon 2013 and higher. Additionally, this table requires QBXML version 12.0 or higher. |
| 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 Reckon Inventory Adjustment Line Items. |
| InventoryAdjustments | Create, query, and delete Reckon Inventory Adjustments. |
| InventorySites | Create, update, delete, and query Reckon Inventory Sites. Inventory Sites are only available in Reckon Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
| 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. |
| JobTypes | Create and query Reckon JobTypes. |
| 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. |
| TransferInventory | Query and delete Reckon Transfer Inventory transactions. Transfer Inventory is available in only Reckon Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
| TransferInventoryLineItems | Create and query Reckon Transfer Inventory Line Items. Transfer Inventory is available in only Reckon Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
| Transfers | Create, update, and query Reckon transfers. Requires QBXML version 12.0 or higher. |
| UnitOfMeasure | Create, update, delete, and query Reckon units of measure. Reckon requires QBXML version 7.0 or higher to use this table. |
| UnitOfMeasureDefaultUnits | Create and query Reckon unit-of-measure default units. Reckon requires QBXML version 7.0 or higher to use this table. |
| UnitOfMeasureRelatedUnits | Create and query Reckon unit-of-measure related units. Reckon requires QBXML version 7.0 or higher to use this table. |
| 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. |
| WorkersCompCodeLines | Query Reckon Workers Comp Code entries by line. Requires QBXML Version 7.0 or higher. |
| WorkersCompCodes | Query Reckon Workers Comp Code entries. Requires QBXML Version 7.0 or higher. |