テーブル
本製品 はReckon Accounts Hosted のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。
CData Python Connector for Reckon Accounts Hosted テーブル
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. |