Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Tableau Connector for Reckon Views
| Name | Description |
| BalanceSheetDetail | Balance Sheet Detail Report. |
| BalanceSheetStandard | Balance Sheet Standard Report. |
| BalanceSheetSummary | Balance Sheet Summary Report. |
| BillingRate | Query Reckon Billing Rate. Requires QBXML Version 6.0 or higher. |
| BillLinkedTransactions | Query Reckon Bill Linked Transactions. |
| CompanyInfo | Query the company information from Reckon. |
| CreditMemoLinkedTransactions | Query Reckon Credit Memo Linked Transactions. |
| CustomColumns | Query Reckon Custom Columns. |
| DeletedEntities | Query deleted Entities. |
| DeletedTransactions | Query deleted Transactions. |
| EmployeeStateTaxesDetail | Returns information of employee state taxes detail report. |
| EstimateLinkedTransactions | Query Reckon Estimate Linked transactions. |
| Host | Query the Reckon host process. The Host represents information about the Reckon process currently being executed. |
| InvoiceLinkedTransactions | Query Reckon Invoice Linked Transactions. |
| ItemReceiptLinkedTransactions | Query Reckon Item Receipt Linked Transactions. |
| ItemSites | Create, update, delete, and query Reckon Item Sites. Item sites are only available in Reckon Enterprise 2010 and above, and only with the Advanced Inventory add-on. This table requires a minimum of QBXML version 10.0. |
| PayrollItemDetail | Returns information of Payroll item detail report (lists the payroll transactions on which each payroll item appears). |
| PayrollReviewDetail | Returns information of Payroll detail review report (provides detailed information about how Reckon calculates tax amounts on employee paychecks and in year-to-date transactions). |
| PayrollTransactionDetail | Returns information of Payroll transaction detail report (shows the line-item detail that appears on each payroll transaction). |
| PayrollTransactionsByPayee | Payroll transactions by payee report (lists payroll transactions, grouping them by payee). |
| Preferences | Query information about many of the preferences the Reckon user has set in the company file. |
| ProfitAndLossDetail | Profit & Loss Prev Year Comparison Report. |
| ProfitAndLossStandard | Profit & Loss YTD Comparison Report. |
| PurchaseOrderLinkedTransactions | Query Reckon Purchase Order Linked Transactions. |
| ReceivePaymentToDeposit | Returns information about payments that have been received and are ready to deposit. |
| SalesOrderLinkedTransactions | Query Reckon Sales Order Linked Transactions. |
| StatementChargeLinkedTransactions | Query Reckon Statement Charge Linked Transactions. |
| Templates | Query Reckon templates. |
| Transactions | Query Reckon transactions. You may search the Transactions using a number of values including Type, Entity, Account, ReferenceNumber, Item, Class, Date, and TimeModified. |
| VendorCreditLinkedTransactions | Query Reckon Vendor Credit Linked Transactions. |