TABLES - ALL
(USA 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
AccountTaxLineInfoAccounting & TaxesAccount 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
BillTransactionsMain Bill Table; used to pay bills, or write checks that do not apply to existing billsTable Relation Jumpins Detail
BillExpenseLineTransactionsProvides expense line detail for a bill expense; contains all the information included in the Main Bill Expense TableTable Relation Jumpins Detail
BillingRateVendors & PayablesBilling Rate HeaderTable Relation Jumpins Detail
BillingRateLineVendors & PayablesBilling Rate Lines - Per itemTable Relation Jumpins Detail
BillItemLineTransactionsProvides line item detail for a bill expense; contains all the information included in the Main Bill Expense TableTable Relation Jumpins Detail
BillLinkedTxnTransactionsBills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill; directly tied to the Main Bill TableTable Relation Jumpins Detail
BillPaymentCheckTransactionsMain table of Bill Payments paid by ChecksTable Relation Jumpins Detail
BillPaymentCheckLineTransactionsProvides line detail for a bill payment by check; contains all the information included in the Main Bill Payment Check Table Relation Jumpins Detail
BillPaymentCheckLineLinkedTxnTransactionsProvides Linked Txn line detail for a bill payment by check; contains all the information included in the Main Bill PayTable Relation Jumpins Detail
BillPaymentCreditCardTransactionsMain table of Bill Payments paid by Credit CardTable Relation Jumpins Detail
BillPaymentCreditCardLineTransactionsProvides line detail for a bill payment by credit card; contains all the information included in the Main Bill Payment Table Relation Jumpins Detail
BillPaymentCreditCardLineLinkedTxnTransactionsProvides Linked Txnline detail for a bill payment by credit card; contains all the information included in the Main BilTable Relation Jumpins Detail
BillToPayVendors & PayablesList of Bills to PayTable Relation Jumpins Detail
BuildAssemblyInventoryBuildAssemblyTable Relation Jumpins Detail
BuildAssemblyComponentItemLineInventoryBuild Assembly ComponentTable Relation Jumpins Detail
ChargeTransactionsStatement Charges TableTable Relation Jumpins Detail
ChargeLinkedTxnTransactionsStatement Charge Linked TransactionsTable Relation Jumpins Detail
CheckTransactionsManual Checks NOT used to pay bills ONLYTable Relation Jumpins Detail
CheckApplyCheckToTxnTransactionsInsert Only table to create a check to pay off a credit memoTable Relation Jumpins Detail
CheckExpenseLineTransactionsProvides expense line detail for a check; contains all the information included in the Main Check TableTable Relation Jumpins Detail
CheckItemLineTransactionsProvides line item detail for a check; contains all the information included in the Main Check TableTable Relation Jumpins Detail
ClassAccounting & TaxesClass List TableTable Relation Jumpins Detail
ClearedStatusTransactionsInsert Only Cleared Status TableTable Relation Jumpins Detail
CompanyCompany & FinancialCompany Information TableTable Relation Jumpins Detail
CompanyActivityCompany & FinancialUsed to Determine Last Restore OperationTable Relation Jumpins Detail
CreditCardChargeTransactionsMain 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
CreditCardChargeItemLineVendors & PayablesProvides line item detail for a credit card charge; contains all the information included in the Main Credit Card ChargTable 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
CreditCardCreditItemLineVendors & PayablesProvides 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
CurrencyBankingCurrencyTable Relation Jumpins Detail
CustomerCustomers & ReceivablesCustomer 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
CustomerShipToAddressCustomers & ReceivablesCustomer 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
DepositVendors & PayablesMain 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
EmployeeAddtionalNoteEmployees & PayrollEmployee Addtional Notes TableTable Relation Jumpins Detail
EmployeeEarningEmployees & PayrollEmployee Payroll InformationTable Relation Jumpins Detail
EntityVendors & PayablesCombined list of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityAdditionalNoteVendors & PayablesAdditional Notes of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityContactsVendors & PayablesContacts of all entities: customers, employees, othernames, vendors; minimum common fieldsTable Relation Jumpins Detail
EntityShipToAddressVendors & PayablesShip-To-Address for 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
Form1099Accounting & TaxesMain Form 1099 TableTable Relation Jumpins Detail
Form1099CategoryAccountMappingAccounting & TaxesProvides 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
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
ItemInventoryCombined list of all Items with minimum common fieldsTable Relation Jumpins Detail
ItemAssembliesCanBuildInventoryList of assemblies that can be builtTable Relation Jumpins Detail
ItemDiscountInventoryItem Discount List TableTable Relation Jumpins Detail
ItemFixedAssetInventoryFixed Asset List TableTable Relation Jumpins Detail
ItemGroupInventoryMain Item Group List TableTable Relation Jumpins Detail
ItemGroupLineInventoryDetailed Group information; directly tied to the Main Item Group List TableTable Relation Jumpins Detail
ItemInventoryInventoryInventory Items List TableTable Relation Jumpins Detail
ItemInventoryAssemblyInventoryMain Inventory Assembly TableTable Relation Jumpins Detail
ItemInventoryAssemblyLineInventoryProvides detail assembly information; directly tied to the Main Inventory Assembly TableTable Relation Jumpins Detail
ItemNonInventoryInventoryNon Inventory Items List TableTable Relation Jumpins Detail
ItemOtherChargeInventoryOther Charge Items List TableTable Relation Jumpins Detail
ItemPaymentInventoryPayment Items List TableTable Relation Jumpins Detail
ItemReceiptTransactionsMain Purchase Order Receipts TableTable Relation Jumpins Detail
ItemReceiptExpenseLineTransactionsProvides expense line detail for an item receipt; contains all the information included in the Main Item Receipt TableTable Relation Jumpins Detail
ItemReceiptItemLineTransactionsProvides line item detail for a purchase order receipt; contains all the information included in the Main Item Receipt Table Relation Jumpins Detail
ItemReceiptLinkedTxnTransactionsContains all receipts associated with a particular purchase orderTable Relation Jumpins Detail
ItemSalesTaxInventorySales Tax Items List TableTable Relation Jumpins Detail
ItemSalesTaxGroupInventoryMain 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
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
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
PayrollItemNonWageEmployees & PayrollPayroll Non Wage Items List TableTable Relation Jumpins Detail
PayrollItemWageEmployees & PayrollPayroll 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
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
PurchaseOrderLinkedTxnVendors & PayablesShows Linked Purchase Order Receipts; does NOT include transfers from SO or EstimatesTable 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
ReceivePaymentLineLinkedTxnTransactionsProvides Linked Txn line item detail for a payment; contains all the information included in the Main Receive Payments Table Relation Jumpins Detail
ReceivePaymentToDepositTransactionsList of Payments Received to Undeposited Funds; ready for DepositTable Relation Jumpins Detail
SalesTransactionsCustom QODBC table that includes invoices, credit memos and sales receipts informationTable Relation Jumpins Detail
SalesLineTransactionsCustom QODBC table that includes invoice lines, credit memo lines and sales receipt line informationTable Relation Jumpins Detail
SalesOrderTransactionsMain 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
SalesTaxPaymentCheckLineTransactionsProvides 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
TimeTrackingTransactionsTime 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
VehicleMileageTransactionsVehicleMileage TableTable Relation Jumpins Detail
VendorVendors & PayablesVendors List TableTable Relation Jumpins Detail
VendorContactsVendors & PayablesVendor Contacts List TableTable Relation Jumpins Detail
VendorCreditVendors & PayablesMain Vendor Credit TableTable Relation Jumpins Detail
VendorCreditExpenseLineVendors & PayablesProvides 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
WorkersCompCodeEmployees & PayrollWorkersCompCodes List TableTable Relation Jumpins Detail
WorkersCompCodeRateHistoryEmployees & PayrollWorkersCompCodes List TableTable Relation Jumpins Detail