Tables

The driver models the data in Reckon Accounts Hosted as a list of tables in a relational database that can be queried using standard SQL statements.

CData ODBC 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.