テーブル
本製品 はQuickBooks のデータを、標準のSQL ステートメントを使用してクエリできるリレーショナルデータベースのテーブルのリストとしてモデル化します。
CData Power BI Connector for QuickBooks テーブル
Name | Description |
Accounts | Create, update, delete, and query QuickBooks Accounts. To update Accounts, set the QBXMLVersion to 6.0 or higher. |
BillExpenseItems | Create, update, delete, and query QuickBooks Bill Expense Line Items. |
BillLineItems | Create, update, delete, and query QuickBooks Bill Line Items. |
BillPaymentChecks | Create, update, delete, and query QuickBooks Bill Payment Checks. QBXMLVersion must be set to 6.0 or higher to update a BillPaymentCheck. |
BillPaymentChecksAppliedTo | Create, update, delete, and query QuickBooks 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 QuickBooks Bill Payments. |
BillPaymentCreditCardsAppliedTo | Create, update, delete, and query QuickBooks 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 QuickBooks Bills. |
BuildAssemblies | Insert, Update, delete, and query QuickBooks Build Assembly transactions. |
BuildAssemblyLineItems | Create and query QuickBooks Build Assembly transactions. |
CheckExpenseItems | Create, update, delete, and query QuickBooks Check Expense Line Items. |
CheckLineItems | Create, update, delete, and query QuickBooks Check Line Items. |
Checks | Create, update, delete, and query QuickBooks Checks. |
Class | Create, update, delete, and query QuickBooks Classes. QuickBooks requires QBXML version 8.0 or higher for updates to a Class. |
CreditCardChargeExpenseItems | Create, update, delete, and query QuickBooks Credit Card Charge Expense Line Items. |
CreditCardChargeLineItems | Create, update, delete, and query QuickBooks Credit Card Charge Line Items. |
CreditCardCharges | Create, update, delete, and query QuickBooks Credit Card Charges. |
CreditCardCreditExpenseItems | Create, update, delete, and query QuickBooks Credit Card Credit Expense Line Items. |
CreditCardCreditLineItems | Create, update, delete, and query QuickBooks Credit Card Credit Line Items. |
CreditCardCredits | Create, update, delete, and query QuickBooks Credit Card Credits. |
CreditCardRefunds | Query and Insert QuickBooks AR Credit Card Refund transactions. |
CreditMemoLineItems | Create, update, delete, and query QuickBooks Credit Memo Line Items. |
CreditMemos | Create, update, delete, and query QuickBooks Credit Memos. |
Currency | Create, update, delete, and query QuickBooks Currencies. This table requires QBXML version 8.0 or higher, and you will need to enable multiple Currencies in your QuickBooks company file to use it. |
CustomerContacts | Create, update, delete, and query QuickBooks Customer Contacts. This table requires QBXML version 12.0 or higher, and is only available in QuickBooks editions 2016 and above. |
CustomerMessages | Create, delete, and query Customer Messages. |
CustomerNotes | Create, update, and query QuickBooks Customer Notes. This table requires QBXML version 12.0 or higher. |
Customers | Create, update, delete, and query QuickBooks Customers. |
CustomerShippingAddresses | Create, update, delete, and query QuickBooks Customer Shipping Addresses. Multiple Customer Shipping Addresses are supported in only QuickBooks 2013 and higher. Additionally, this table requires QBXML version 12.0 or higher. |
CustomerTypes | Create, update, delete, and query QuickBooks Customer Types. |
DateDrivenTerms | Create, delete, and query QuickBooks Date Driven Terms. |
DepositLineItems | Create, update, delete, and query QuickBooks Deposit Line Items. QBXMLVersion must be set to 7.0 or higher to update a deposit. |
Deposits | Create, update, delete, and query QuickBooks Deposits. QBXMLVersion must be set to 7.0 or higher to update a deposit. |
EmployeeEarnings | Create, update, delete, and query QuickBooks Employee Earnings. |
Employees | Create, update, delete, and query QuickBooks Employees. |
EstimateLineItems | Create, update, delete, and query QuickBooks Estimate Line Items. |
Estimates | Create, update, delete, and query QuickBooks Estimates. |
InventoryAdjustmentLineItems | Create and query QuickBooks Inventory Adjustment Line Items. |
InventoryAdjustments | Create, query, and delete QuickBooks Inventory Adjustments. |
InventorySites | Create, update, delete, and query QuickBooks Inventory Sites. Inventory Sites are only available in QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
InvoiceLineItems | Create, update, delete, and query QuickBooks Invoice Line Items. |
Invoices | Create, update, delete, and query QuickBooks Invoices. |
ItemLineItems | Create, update, delete, and query QuickBooks Item Line Items. |
ItemReceiptExpenseItems | Create, update, delete, and query QuickBooks Item Receipt Expense Line Items. |
ItemReceiptLineItems | Create, update, delete, and query QuickBooks Item Receipt Line Items. |
ItemReceipts | Create, update, delete, and query QuickBooks Item Receipts. |
Items | Create, update, delete, and query QuickBooks Items. |
JobTypes | Create and query QuickBooks JobTypes. |
JournalEntries | Create, update, delete, and query QuickBooks 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 QuickBooks 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 QuickBooks Other Name entities. |
PaymentMethods | Create, update, delete, and query QuickBooks Payment Methods. |
PayrollNonWageItems | Query QuickBooks Non-Wage Payroll Items. |
PayrollWageItems | Create and query QuickBooks Wage Payroll Items. |
PriceLevelPerItem | Create and query QuickBooks Price Levels Per Item. Only QuickBooks 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. This table requires QBXML version 4.0 or later. |
PriceLevels | Create, delete, and query QuickBooks 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. This table requires QBXML version 4.0 or higher. |
PurchaseOrderLineItems | Create, update, delete, and query QuickBooks Purchase Order Line Items. |
PurchaseOrders | Create, update, delete, and query QuickBooks Purchase Orders. |
ReceivePayments | Create, update, delete, and query QuickBooks Receive Payment transactions. QBXMLVersion must be set to 6.0 or higher to update a ReceivePayment. |
ReceivePaymentsAppliedTo | Create, update, and query QuickBooks Receive Payment AppliedTo aggregates. In a Receive Payment, each AppliedTo aggregate represents the transaction to which this part of the payment is being applied. QBXMLVersion must be set to 6.0 or higher to update a ReceivePayment. |
SalesOrderLineItems | Create, update, delete, and query QuickBooks Sales Order Line Items. |
SalesOrders | Create, update, delete, and query QuickBooks Sales Orders. |
SalesReceiptLineItems | Create, update, delete, and query QuickBooks Sales Receipt Line Items. |
SalesReceipts | Create, update, delete, and query QuickBooks Sales Receipts. |
SalesReps | Create, update, delete, and query QuickBooks Sales Rep entities. |
SalesTaxCodes | Create, update, delete, and query QuickBooks Sales Tax Codes. |
SalesTaxItems | Create, update, delete, and query QuickBooks Sales Tax Items. |
ShippingMethods | Create, update, delete, and query QuickBooks Shipping Methods. |
StandardTerms | Create, update, delete, and query QuickBooks Standard Terms. |
StatementCharges | Create, update, delete, and query QuickBooks Statement Charges. |
TimeTracking | Create, update, delete, and query QuickBooks Time Tracking events. |
ToDo | Create, update, delete, and query QuickBooks To Do entries. |
TransferInventory | Query and delete QuickBooks Transfer Inventory transactions. Transfer Inventory is available in only QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
TransferInventoryLineItems | Create and query QuickBooks Transfer Inventory Line Items. Transfer Inventory is available in only QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on. |
Transfers | Create, update, and query QuickBooks transfers. Requires QBXML version 12.0 or higher. |
UnitOfMeasure | Create, update, delete, and query QuickBooks units of measure. QuickBooks requires QBXML version 7.0 or higher to use this table. |
UnitOfMeasureDefaultUnits | Create and query QuickBooks unit-of-measure default units. QuickBooks requires QBXML version 7.0 or higher to use this table. |
UnitOfMeasureRelatedUnits | Create and query QuickBooks unit-of-measure related units. QuickBooks requires QBXML version 7.0 or higher to use this table. |
VehicleMileage | Create, update, delete, and query QuickBooks Vehicle Mileage entities. QuickBooks requires QBXML version 6.0 or higher to use this table. |
VendorCreditExpenseItems | Create, update, delete, and query QuickBooks Vendor Credit Expense Line Items. |
VendorCreditLineItems | Create, update, delete, and query QuickBooks Vendor Credit Line Items. |
VendorCredits | Create, update, delete, and query QuickBooks Vendor Credits. |
Vendors | Create, update, delete, and query QuickBooks Vendors. |
VendorTypes | Create, update, delete, and query QuickBooks Vendor Types. |
WorkersCompCodeLines | Query QuickBooks Workers Comp Code entries by line. Requires QBXML Version 7.0 or higher. |
WorkersCompCodes | Query QuickBooks Workers Comp Code entries. Requires QBXML Version 7.0 or higher. |