TABLES - ALL
(USA VERSION)
NAME CATEGORY DESCRIPTION TABLE RELATIONS JUMPINS TABLE DETAILS
AccountListsChart of Accounts List TableTable Relation Jumpins Detail
AccountTaxLineInfoListsAccount Tax Line InfoTable Relation Jumpins Detail
ARRefundCreditCardTransactionsAccounts Receivable Refund CreditCardTable Relation Jumpins Detail
ARRefundCreditCardRefundAppliedToTransactionsAccounts Receivable Refund CreditCardTable Relation Jumpins Detail
BarCodeMiscBarCode DetailsTable Relation Jumpins Detail
BillPurchasesMain Bill Table; used to pay bills, or write checks that do not apply to existing billsTable Relation Jumpins Detail
BillExpenseLinePurchasesProvides expense line detail for a bill expense; contains all the information included in the Main Bill Expense TableTable Relation Jumpins Detail
BillingRateListsBilling Rate HeaderTable Relation Jumpins Detail
BillingRateLineListsBilling Rate Lines - Per itemTable Relation Jumpins Detail
BillItemLinePurchasesProvides line item detail for a bill expense; contains all the information included in the Main Bill Expense TableTable Relation Jumpins Detail
BillLinkedTxnPurchasesBills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill; directly tied to the Main Bill TableTable Relation Jumpins Detail
BillPaymentCheckPurchasesMain table of Bill Payments paid by ChecksTable Relation Jumpins Detail
BillPaymentCheckLinePurchasesProvides line detail for a bill payment by check; contains all the information included in the Main Bill Payment Check Table Relation Jumpins Detail
BillPaymentCheckLineLinkedTxnPurchasesProvides Linked Txn line detail for a bill payment by check; contains all the information included in the Main Bill PayTable Relation Jumpins Detail
BillPaymentCreditCardPurchasesMain table of Bill Payments paid by Credit CardTable Relation Jumpins Detail
BillPaymentCreditCardLinePurchasesProvides line detail for a bill payment by credit card; contains all the information included in the Main Bill Payment Table Relation Jumpins Detail
BillPaymentCreditCardLineLinkedTxnPurchasesProvides Linked Txnline detail for a bill payment by credit card; contains all the information included in the Main BilTable Relation Jumpins Detail
BillToPayPurchasesList of Bills to PayTable Relation Jumpins Detail
BuildAssemblyInventoryBuildAssemblyTable Relation Jumpins Detail
BuildAssemblyComponentItemLineInventoryBuild Assembly ComponentTable Relation Jumpins Detail
ChargePurchasesStatement Charges TableTable Relation Jumpins Detail
ChargeLinkedTxnPurchasesStatement Charge Linked TransactionsTable Relation Jumpins Detail
CheckPurchasesManual Checks NOT used to pay bills ONLYTable Relation Jumpins Detail
CheckApplyCheckToTxnPurchasesInsert Only table to create a check to pay off a credit memoTable Relation Jumpins Detail
CheckExpenseLineVendors & PayablesProvides expense line detail for a check; contains all the information included in the Main Check TableTable Relation Jumpins Detail
CheckItemLineVendors & PayablesProvides line item detail for a check; contains all the information included in the Main Check TableTable Relation Jumpins Detail
ClassListsClass List TableTable Relation Jumpins Detail
ClearedStatusVendors & PayablesInsert Only Cleared Status TableTable Relation Jumpins Detail
CompanyCompany & FinancialCompany Information TableTable Relation Jumpins Detail
CompanyActivityCompany & FinancialUsed to Determine Last Restore OperationTable Relation Jumpins Detail
CreditCardChargeVendors & PayablesMain Credit Card Table - Charges OnlyTable Relation Jumpins Detail
CreditCardChargeExpenseLinePurchasesProvides expense line detail for a credit card charge; contains all the information included in the Main Credit Card ChTable Relation Jumpins Detail
CreditCardChargeItemLinePurchasesProvides line item detail for a credit card charge; contains all the information included in the Main Credit Card ChargTable Relation Jumpins Detail
CreditCardCreditPurchasesMain Credit Card Table - Credits OnlyTable Relation Jumpins Detail
CreditCardCreditExpenseLinePurchasesProvides expense line detail for a credit card credit; contains all the information included in the Main Credit Card CrTable Relation Jumpins Detail
CreditCardCreditItemLinePurchasesProvides line item detail for a credit card credit; contains all the information included in the Main Credit Card CrediTable Relation Jumpins Detail
CreditMemoTransactionsMain Customer Credit Memo TableTable Relation Jumpins Detail
CreditMemoLineTransactionsProvides line item detail for a customer credit memo; contains all the information included in the Main Customer CreditTable Relation Jumpins Detail
CreditMemoLinkedTxnTransactionsCredit Memo apply, etc.Table Relation Jumpins Detail
CurrencyListsCurrencyTable Relation Jumpins Detail
CustomerListsCustomer List TableTable Relation Jumpins Detail
CustomerAddtionalNoteListsCustomer Addtional Notes TableTable Relation Jumpins Detail
CustomerContactsListsCustomer Contacts TableTable Relation Jumpins Detail
CustomerMsgListsCustomer Messages List Table (on Invoices)Table Relation Jumpins Detail
CustomerShipToAddressListsCustomer Ship to AddressTable Relation Jumpins Detail
CustomerTypeListsCustomer Type List TableTable Relation Jumpins Detail
CustomFieldMiscInsert Only Custom Field TableTable Relation Jumpins Detail
DateDrivenTermsListsTerms List Table (Date Driven Option)Table Relation Jumpins Detail
DepositPurchasesMain Deposit TableTable Relation Jumpins Detail
DepositLinePurchasesProvides line detail for a deposit; contains all the information included in the Main Deposit TableTable Relation Jumpins Detail
EmployeeListsEmployee List TableTable Relation Jumpins Detail
EmployeeAddtionalNoteListsEmployee Addtional Notes TableTable Relation Jumpins Detail
EmployeeEarningListsEmployee Payroll InformationTable Relation Jumpins Detail
EntityListsCombined list of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityAdditionalNoteListsAdditional Notes of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityContactsListsContacts of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityShipToAddressListsShip-To-Address for all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EstimateListsMain Estimate TableTable Relation Jumpins Detail
EstimateLineListsProvides line item detail for an estimate; contains all the information included in the Main Estimate TableTable Relation Jumpins Detail
EstimateLinkedTxnListsEstimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to POTable Relation Jumpins Detail
Form1099ListsMain Form 1099 TableTable Relation Jumpins Detail
Form1099CategoryAccountMappingListsProvides detail information about Mapping between Category & Account; contains all the information included in the MaiTable Relation Jumpins Detail
HostMiscInternal Table used to check for QuickBooks VersionTable Relation Jumpins Detail
HostMetaDataMiscInternal Table used to check for QuickBooks VersionTable Relation Jumpins Detail
HostSupportedVersionsMiscInternal Table used to check for Supported QuickBooks SDK VersionTable Relation Jumpins Detail
InventoryAdjustmentInventoryMain Inventory Adjustment TableTable Relation Jumpins Detail
InventoryAdjustmentLineInventoryProvides line item detail for an inventory adjustment; contains all the information included in the Main Inventory AdjuTable Relation Jumpins Detail
InventorySiteInventoryInventorySite List TableTable Relation Jumpins Detail
InvoiceSalesMain Invoice TableTable Relation Jumpins Detail
InvoiceLineSalesProvides line item detail for a customer invoice; contains all the information included in the Main Invoice TableTable Relation Jumpins Detail
InvoiceLinkedTxnSalesPayments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or EstimatesTable Relation Jumpins Detail
ItemListsCombined list of all Items with minimum common fieldsTable Relation Jumpins Detail
ItemAssembliesCanBuildInventoryList of assemblies that can be builtTable Relation Jumpins Detail
ItemDiscountListsItem Discount List TableTable Relation Jumpins Detail
ItemFixedAssetListsFixed Asset List TableTable Relation Jumpins Detail
ItemGroupListsMain Item Group List TableTable Relation Jumpins Detail
ItemGroupLineListsDetailed Group information; directly tied to the Main Item Group List TableTable Relation Jumpins Detail
ItemInventoryListsInventory Items List TableTable Relation Jumpins Detail
ItemInventoryAssemblyListsMain Inventory Assembly TableTable Relation Jumpins Detail
ItemInventoryAssemblyLineListsProvides detail assembly information; directly tied to the Main Inventory Assembly TableTable Relation Jumpins Detail
ItemNonInventoryListsNon Inventory Items List TableTable Relation Jumpins Detail
ItemOtherChargeListsOther Charge Items List TableTable Relation Jumpins Detail
ItemPaymentListsPayment Items List TableTable Relation Jumpins Detail
ItemReceiptSalesMain Purchase Order Receipts TableTable Relation Jumpins Detail
ItemReceiptExpenseLineSalesProvides expense line detail for an item receipt; contains all the information included in the Main Item Receipt TableTable Relation Jumpins Detail
ItemReceiptItemLineCustomers & ReceivablesProvides line item detail for a purchase order receipt; contains all the information included in the Main Item Receipt Table Relation Jumpins Detail
ItemReceiptLinkedTxnCustomers & ReceivablesContains all receipts associated with a particular purchase orderTable Relation Jumpins Detail
ItemSalesTaxListsSales Tax Items List TableTable Relation Jumpins Detail
ItemSalesTaxGroupListsMain Sales Tax Group TableTable Relation Jumpins Detail
ItemSalesTaxGroupLineInventoryProvides detail tax code information for a sales tax group; directly tied to the Main Sales Tax Group TableTable Relation Jumpins Detail
ItemServiceInventoryService Items List TableTable Relation Jumpins Detail
ItemSitesInventoryItems Site List TableTable Relation Jumpins Detail
ItemSubtotalInventorySubtotal Items List TableTable Relation Jumpins Detail
JobTypeListsJob Type List TableTable Relation Jumpins Detail
JournalEntryAccounting & TaxesMain Journal Entry TableTable Relation Jumpins Detail
JournalEntryCreditLineAccounting & TaxesProvides credit entry line detail information; contains all the information included in the Main Journal Entry TableTable Relation Jumpins Detail
JournalEntryDebitLineAccounting & TaxesProvides debit entry line detail information; contains all the information included in the Main Journal Entry TableTable Relation Jumpins Detail
JournalEntryLineAccounting & TaxesProvides credit and debit entry line detail information; contains all the information included in the Main Journal EntrTable Relation Jumpins Detail
ListDeletedMiscList of Items that have been DeletedTable Relation Jumpins Detail
OtherNameCustomers & ReceivablesOther Names List TableTable Relation Jumpins Detail
PaymentMethodListsPayment Methods List TableTable Relation Jumpins Detail
PayrollItemNonWageListsPayroll Non Wage Items List TableTable Relation Jumpins Detail
PayrollItemWageListsPayroll Wage Items List TableTable Relation Jumpins Detail
PreferencesMiscQuickBooks Preferences TableTable Relation Jumpins Detail
PriceLevelCustomers & ReceivablesMain Price Levels ListTable Relation Jumpins Detail
PriceLevelPerItemCustomers & ReceivablesPrice Levels List Item DetailsTable Relation Jumpins Detail
PurchaseOrderPurchasesMain Purchase Order TableTable Relation Jumpins Detail
PurchaseOrderLinePurchasesProvides line item detail for a purchase order; contains all the information included in the Main Purchase Order TableTable Relation Jumpins Detail
PurchaseOrderLinkedTxnPurchasesShows Linked Purchase Order Receipts; does NOT include transfers from SO or EstimatesTable Relation Jumpins Detail
ReceivePaymentCustomers & ReceivablesMain Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineCustomers & ReceivablesProvides line item detail for a payment; contains all the information included in the Main Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineLinkedTxnCustomers & ReceivablesProvides Linked Txn line item detail for a payment; contains all the information included in the Main Receive Payments Table Relation Jumpins Detail
ReceivePaymentToDepositBankingList of Payments Received to Undeposited Funds; ready for DepositTable Relation Jumpins Detail
SalesCustomers & ReceivablesCustom QODBC table that includes invoices, credit memos and sales receipts informationTable Relation Jumpins Detail
SalesLineCustomers & ReceivablesCustom QODBC table that includes invoice lines, credit memo lines and sales receipt line informationTable Relation Jumpins Detail
SalesOrderCustomers & ReceivablesMain Sales Order TableTable Relation Jumpins Detail
SalesOrderLineCustomers & ReceivablesProvides line item detail for a sales order; contains all the information included in the Main Sales Order TableTable Relation Jumpins Detail
SalesOrderLinkedTxnCustomers & ReceivablesSales Order Linked TransactionsTable Relation Jumpins Detail
SalesReceiptCustomers & ReceivablesMain Sales Receipts TableTable Relation Jumpins Detail
SalesReceiptLineCustomers & ReceivablesProvides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts TableTable Relation Jumpins Detail
SalesRepListsSales Rep List TableTable Relation Jumpins Detail
SalesTaxCodeListsSales Tax Codes List TableTable Relation Jumpins Detail
SalesTaxPaymentCheckBankingMain Sales Tax Payments TableTable Relation Jumpins Detail
SalesTaxPaymentCheckLineBankingProvides line detail for a sales tax payment check; contains all the information included in the Main Sales Tax PaymentTable Relation Jumpins Detail
ShipMethodListsShipping Methods List TableTable Relation Jumpins Detail
SpecialAccountAccounting & TaxesInsert Only Special Account TableTable Relation Jumpins Detail
SpecialItemListsInsert Only Special Item TableTable Relation Jumpins Detail
StandardTermsListsTerms List Table (Default Term Option)Table Relation Jumpins Detail
TaxCodeListsCustomer and Line Item Tax Codes; i.e. taxable, exemptTable Relation Jumpins Detail
TemplateMiscTemplate InformationTable Relation Jumpins Detail
TermsListsMain Terms ListTable Relation Jumpins Detail
TimeTrackingJobs, Time & MileageTime Tracking TableTable Relation Jumpins Detail
ToDoCompany & FinancialTo Do Information TableTable Relation Jumpins Detail
TransactionTransactionsTransaction List TableTable Relation Jumpins Detail
TransferMiscTransfer TableTable Relation Jumpins Detail
TransferInventoryInventoryTransferInventory Transaction TableTable Relation Jumpins Detail
TransferInventoryLineInventoryTransferInventory Transaction TableTable Relation Jumpins Detail
TxnDeletedMiscDeleted TransactionsTable Relation Jumpins Detail
UnitOfMeasureSetListsUnit of Measure SetTable Relation Jumpins Detail
UnitOfMeasureSetDefaultUnitListsUnit of Measure SetTable Relation Jumpins Detail
UnitOfMeasureSetRelatedUnitListsUnit of Measure SetTable Relation Jumpins Detail
VehicleListsVehicle List TableTable Relation Jumpins Detail
VehicleMileageJobs, Time & MileageVehicleMileage TableTable Relation Jumpins Detail
VendorListsVendors List TableTable Relation Jumpins Detail
VendorContactsListsVendor Contacts List TableTable Relation Jumpins Detail
VendorCreditPurchasesMain Vendor Credit TableTable Relation Jumpins Detail
VendorCreditExpenseLinePurchasesProvides expense line detail for a vendor credit; contains all the information included in the Main Vendor Credit TableTable Relation Jumpins Detail
VendorCreditItemLineVendors & PayablesProvides line item detail for a vendor credit; contains all the information included in the Main Vendor Credit TableTable Relation Jumpins Detail
VendorCreditLinkedTxnVendors & PayablesCredits Taken, Re-imbursed Expense Used or Not Used - directly tied to the Main Vendor Credit TableTable Relation Jumpins Detail
VendorTypeListsVendor Types List TableTable Relation Jumpins Detail
WorkersCompCodeListsWorkersCompCodes List TableTable Relation Jumpins Detail
WorkersCompCodeRateHistoryListsWorkersCompCodes List TableTable Relation Jumpins Detail