TABLES - ALL
(Online VERSION)
v18.0.0.325, Last Updated: 2017-12-27
NAME CATEGORY DESCRIPTION TABLE RELATIONS JUMPINS TABLE DETAILS
AccountCompany & FinancialChart of Accounts List TableTable Relation Jumpins Detail
AttachableCompany & FinancialChart of Attachables List TableTable Relation Jumpins Detail
AttachableReferenceCompany & FinancialChart of AttachablesReferences List TableTable Relation Jumpins Detail
BillVendors & PayablesMain Bill Table; used to pay bills, or write checks that do not apply to existing billsTable Relation Jumpins Detail
BillExpenseLineVendors & PayablesProvides expense line detail for a bill expense; contains all the information included in the Main Bill Expense TableTable Relation Jumpins Detail
BillItemLineVendors & PayablesProvides line item detail for a bill expense; contains all the information included in the Main Bill Expense TableTable Relation Jumpins Detail
BillLinkedTxnVendors & PayablesBills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill; directly tied to the Main Bill TableTable Relation Jumpins Detail
BillPaymentVendors & PayablesMain Bill Payment TableTable Relation Jumpins Detail
BillPaymentAppliedToTxnVendors & PayablesPaymnet Bills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Payment Bill; directly tied to the Main BillPaymeTable Relation Jumpins Detail
BillPaymentLineVendors & PayablesProvides expense line detail for a bill payment expense; contains all the information included in the Main Bill PaymentTable Relation Jumpins Detail
BudgetAccounting & TaxesChart of Budget List TableTable Relation Jumpins Detail
BudgetDetailLineAccounting & TaxesChart of Budget Detail List TableTable Relation Jumpins Detail
CheckVendors & PayablesManual Checks NOT used to pay bills ONLYTable Relation Jumpins Detail
CheckExpenseLineVendors & PayablesProvides expense line detail for a check; contains all the information included in the Main Check TableTable Relation Jumpins Detail
ClassAccounting & TaxesClass List TableTable Relation Jumpins Detail
CompanyCompany & FinancialCompany Information TableTable Relation Jumpins Detail
CompanyCurrencyCompany & FinancialCompany Currency Information TableTable Relation Jumpins Detail
CompanyCurrencyAttachableCompany & FinancialCompany Currency Attachable Information TableTable Relation Jumpins Detail
CreditCardChargeVendors & PayablesMain Credit Card Table - Charges OnlyTable Relation Jumpins Detail
CreditCardChargeExpenseLineTransactionsProvides expense line detail for a credit card charge; contains all the information included in the Main Credit Card ChTable Relation Jumpins Detail
CreditCardCreditVendors & PayablesMain Credit Card Table - Credits OnlyTable Relation Jumpins Detail
CreditCardCreditExpenseLineVendors & PayablesProvides expense line detail for a credit card credit; contains all the information included in the Main Credit Card CrTable 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
CustomerCustomers & ReceivablesCustomer List TableTable Relation Jumpins Detail
CustomFieldMiscInsert Only Custom Field TableTable Relation Jumpins Detail
DateDrivenTermsListsTerms List Table (Date Driven Option)Table Relation Jumpins Detail
DepartmentListsDepartment List TableTable Relation Jumpins Detail
DepositVendors & PayablesMain Deposit TableTable Relation Jumpins Detail
DepositAppliedToTxnVendors & PayablesProvides Txn detail for a deposit; contains all the information included in the Main Deposit TableTable Relation Jumpins Detail
DepositAttachableVendors & PayablesProvides Attachable detail for a deposit; contains all the information included in the Main Deposit TableTable Relation Jumpins Detail
DepositLineVendors & PayablesProvides line detail for a deposit; contains all the information included in the Main Deposit TableTable Relation Jumpins Detail
EmployeeEmployees & PayrollEmployee List TableTable Relation Jumpins Detail
EntitlementsListsEntitlements InformationTable Relation Jumpins Detail
EntityListsCombined list of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EstimateVendors & PayablesMain Estimate TableTable Relation Jumpins Detail
EstimateLineVendors & PayablesProvides line item detail for an estimate; contains all the information included in the Main Estimate TableTable Relation Jumpins Detail
EstimateLinkedTxnVendors & PayablesEstimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to POTable Relation Jumpins Detail
HostMiscInternal Table used to check for Quickbooks VersionTable Relation Jumpins Detail
HostSupportedVersionsMiscInternal Table used to check for Supported Quickbooks SDK VersionTable Relation Jumpins Detail
InvoiceTransactionsMain Invoice TableTable Relation Jumpins Detail
InvoiceLineTransactionsProvides line item detail for a customer invoice; contains all the information included in the Main Invoice TableTable Relation Jumpins Detail
InvoiceLinkedTxnTransactionsPayments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or EstimatesTable Relation Jumpins Detail
ItemGroupInventoryService ItemsGroup List TableTable Relation Jumpins Detail
ItemGroupLineInventoryService ItemsGroupLine List TableTable Relation Jumpins Detail
ItemServiceInventoryService Items List TableTable Relation Jumpins Detail
JournalEntryTransactionsMain Journal Entry TableTable Relation Jumpins Detail
JournalEntryCreditLineTransactionsProvides credit entry line detail information; contains all the information included in the Main Journal Entry TableTable Relation Jumpins Detail
JournalEntryDebitLineTransactionsProvides debit entry line detail information; contains all the information included in the Main Journal Entry TableTable Relation Jumpins Detail
JournalEntryLineTransactionsProvides credit and debit entry line detail information; contains all the information included in the Main Journal EntrTable Relation Jumpins Detail
PaymentTransactionsMain Payment TableTable Relation Jumpins Detail
PaymentAppliedToTxnTransactionsTable Provides Linked item detail for Payment; contains all the information included in the Main Payment TableTable Relation Jumpins Detail
PaymentLineTransactionsProvides line item detail for Payment; contains all the information included in the Main Payment TableTable Relation Jumpins Detail
PaymentMethodListsPayment Methods List TableTable Relation Jumpins Detail
PreferencesListsPreferences List TableTable Relation Jumpins Detail
PreferencesPOCustomFieldListsPreferences List TableTable Relation Jumpins Detail
PurchaseTransactionsMain Purchase TableTable Relation Jumpins Detail
PurchaseExpenseLineTransactionsProvides expense item detail for a Purchase expense; contains all the information included in the Main Purchase ExpenseTable Relation Jumpins Detail
PurchaseItemLineTransactionsProvides line item detail for a Purchase expense; contains all the information included in the Main Purchase Expense TaTable Relation Jumpins Detail
PurchaseLineTransactionsProvides Expense and Item entry line detail information; contains all the information included in the Main Purchase EntTable Relation Jumpins Detail
PurchaseOrderTransactionsMain Purchase Order TableTable Relation Jumpins Detail
PurchaseOrderLineTransactionsProvides line item detail for a purchase order; contains all the information included in the Main Purchase Order TableTable Relation Jumpins Detail
PurchaseOrderLinkedTxnTransactionsShows Linked Purchase Order Receipts; does NOT include transfers from SO or EstimatesTable Relation Jumpins Detail
PurchaseOrderTxnLineDetailTransactionsShows TxnTax Detail TaxLine Purchase Order Receipts; does NOT include transfers from SO or EstimatesTable Relation Jumpins Detail
PurchaseTxnLineDetailTransactionsPurchase Txn Line Details - Includes transfers to Invoice or Sales Order; does NOT include transfer to POTable Relation Jumpins Detail
ReceivePaymentTransactionsMain Receive Payments TableTable Relation Jumpins Detail
ReceivePaymentLineTransactionsProvides line item detail for a payment; contains all the information included in the Main Receive Payments TableTable Relation Jumpins Detail
RefundReceiptTransactionsMain Refund Receipt Order TableTable Relation Jumpins Detail
RefundReceiptLineTransactionsProvides line item detail for a payment; contains all the information included in the Main Receive Payments TableTable Relation Jumpins Detail
SalesReceiptTransactionsMain Sales Receipts TableTable Relation Jumpins Detail
SalesReceiptLineTransactionsProvides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts TableTable Relation Jumpins Detail
StandardTermsListsTerms List Table (Default Term Option)Table Relation Jumpins Detail
TaxAgencyListsTax Agency List TableTable Relation Jumpins Detail
TaxCodeListsTaxCode List TableTable Relation Jumpins Detail
TaxCodePurchaseTaxRateDetailListsPurchase Tax related details of the Tax CodeTable Relation Jumpins Detail
TaxCodeSalesTaxRateDetailListsSales Tax related details of the Tax CodeTable Relation Jumpins Detail
TaxRateListsTax Rate List TableTable Relation Jumpins Detail
TaxRateEffectiveTaxRateListsTax Rate Effective Tax Rate List TableTable Relation Jumpins Detail
TaxServiceListsTax Service List TableTable Relation Jumpins Detail
TimeTrackingTransactionsTime Tracking TableTable Relation Jumpins Detail
TransferTransactionsTransfer TableTable Relation Jumpins Detail
VendorListsVendors 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
VendorCreditItemLinePurchasesProvides line item detail for a vendor credit; contains all the information included in the Main Vendor Credit TableTable Relation Jumpins Detail
VendorCreditLinePurchasesProvides Expense and Item entry line detail information; contains all the information included in the Main Vendor CrediTable Relation Jumpins Detail
VendorCreditLinkedTxnPurchasesCredits Taken, Re-imbursed Expense Used or Not Used - directly tied to the Main Vendor Credit TableTable Relation Jumpins Detail