CData BizTalk Adapter for Reckon 2019 - Online Help
Questions / Feedback?

Tables

CData BizTalk Adapter for Reckon 2019 - Build 19.0.7354

The adapter models the data in Reckon into a list of tables that can be queried using standard SQL statements.

Generally, querying Reckon 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 BizTalk Adapter for Reckon 2019 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 QuickBooks Inventory Adjustment Line Items.
InventoryAdjustments Create, query, and delete QuickBooks 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.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0