TABLES - ALL
(USA VERSION)
| NAME | CATEGORY | DESCRIPTION | TABLE RELATIONS | JUMPINS | TABLE DETAILS |
|---|---|---|---|---|---|
| Account | Accounting & Taxes | Chart of Accounts List Table | Table Relation | Jumpins | Detail |
| AccountTaxLineInfo | Accounting & Taxes | Account Tax Line Info | Table Relation | Jumpins | Detail |
| ARRefundCreditCard | Customers & Receivables | Accounts Receivable Refund CreditCard | Table Relation | Jumpins | Detail |
| ARRefundCreditCardRefundAppliedTo | Customers & Receivables | Accounts Receivable Refund CreditCard | Table Relation | Jumpins | Detail |
| BarCode | Misc | BarCode Details | Table Relation | Jumpins | Detail |
| Bill | Purchases | Main Bill Table; used to pay bills, or write checks that do not apply to existing bills | Table Relation | Jumpins | Detail |
| BillExpenseLine | Purchases | Provides expense line detail for a bill expense; contains all the information included in the Main Bill Expense Table | Table Relation | Jumpins | Detail |
| BillingRate | Employees & Payroll | Billing Rate Header | Table Relation | Jumpins | Detail |
| BillingRateLine | Employees & Payroll | Billing Rate Lines - Per item | Table Relation | Jumpins | Detail |
| BillItemLine | Purchases | Provides line item detail for a bill expense; contains all the information included in the Main Bill Expense Table | Table Relation | Jumpins | Detail |
| BillLinkedTxn | Purchases | Bills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill; directly tied to the Main Bill Table | Table Relation | Jumpins | Detail |
| BillPaymentCheck | Vendors & Payables | Main table of Bill Payments paid by Checks | Table Relation | Jumpins | Detail |
| BillPaymentCheckLine | Purchases | Provides line detail for a bill payment by check; contains all the information included in the Main Bill Payment Check | Table Relation | Jumpins | Detail |
| BillPaymentCheckLineLinkedTxn | Purchases | Provides Linked Txn line detail for a bill payment by check; contains all the information included in the Main Bill Pay | Table Relation | Jumpins | Detail |
| BillPaymentCreditCard | Purchases | Main table of Bill Payments paid by Credit Card | Table Relation | Jumpins | Detail |
| BillPaymentCreditCardLine | Purchases | Provides line detail for a bill payment by credit card; contains all the information included in the Main Bill Payment | Table Relation | Jumpins | Detail |
| BillPaymentCreditCardLineLinkedTxn | Purchases | Provides Linked Txnline detail for a bill payment by credit card; contains all the information included in the Main Bil | Table Relation | Jumpins | Detail |
| BillToPay | Purchases | List of Bills to Pay | Table Relation | Jumpins | Detail |
| BuildAssembly | Inventory | BuildAssembly | Table Relation | Jumpins | Detail |
| BuildAssemblyComponentItemLine | Inventory | Build Assembly Component | Table Relation | Jumpins | Detail |
| Charge | Purchases | Statement Charges Table | Table Relation | Jumpins | Detail |
| ChargeLinkedTxn | Purchases | Statement Charge Linked Transactions | Table Relation | Jumpins | Detail |
| Check | Purchases | Manual Checks NOT used to pay bills ONLY | Table Relation | Jumpins | Detail |
| CheckApplyCheckToTxn | Purchases | Insert Only table to create a check to pay off a credit memo | Table Relation | Jumpins | Detail |
| CheckExpenseLine | Purchases | Provides expense line detail for a check; contains all the information included in the Main Check Table | Table Relation | Jumpins | Detail |
| CheckItemLine | Purchases | Provides line item detail for a check; contains all the information included in the Main Check Table | Table Relation | Jumpins | Detail |
| Class | Accounting & Taxes | Class List Table | Table Relation | Jumpins | Detail |
| ClearedStatus | Purchases | Insert Only Cleared Status Table | Table Relation | Jumpins | Detail |
| Company | Company & Financial | Company Information Table | Table Relation | Jumpins | Detail |
| CompanyActivity | Company & Financial | Used to Determine Last Restore Operation | Table Relation | Jumpins | Detail |
| CreditCardCharge | Purchases | Main Credit Card Table - Charges Only | Table Relation | Jumpins | Detail |
| CreditCardChargeExpenseLine | Purchases | Provides expense line detail for a credit card charge; contains all the information included in the Main Credit Card Ch | Table Relation | Jumpins | Detail |
| CreditCardChargeItemLine | Purchases | Provides line item detail for a credit card charge; contains all the information included in the Main Credit Card Charg | Table Relation | Jumpins | Detail |
| CreditCardCredit | Purchases | Main Credit Card Table - Credits Only | Table Relation | Jumpins | Detail |
| CreditCardCreditExpenseLine | Purchases | Provides expense line detail for a credit card credit; contains all the information included in the Main Credit Card Cr | Table Relation | Jumpins | Detail |
| CreditCardCreditItemLine | Transactions | Provides line item detail for a credit card credit; contains all the information included in the Main Credit Card Credi | Table Relation | Jumpins | Detail |
| CreditMemo | Customers & Receivables | Main Customer Credit Memo Table | Table Relation | Jumpins | Detail |
| CreditMemoLine | Customers & Receivables | Provides line item detail for a customer credit memo; contains all the information included in the Main Customer Credit | Table Relation | Jumpins | Detail |
| CreditMemoLinkedTxn | Customers & Receivables | Credit Memo apply, etc. | Table Relation | Jumpins | Detail |
| Currency | Banking | Currency | Table Relation | Jumpins | Detail |
| Customer | Customers & Receivables | Customer List Table | Table Relation | Jumpins | Detail |
| CustomerAddtionalNote | Lists | Customer Addtional Notes Table | Table Relation | Jumpins | Detail |
| CustomerContacts | Lists | Customer Contacts Table | Table Relation | Jumpins | Detail |
| CustomerMsg | Lists | Customer Messages List Table (on Invoices) | Table Relation | Jumpins | Detail |
| CustomerNoShippingAddr | Customers & Receivables | Customer List Table | Table Relation | Jumpins | Detail |
| CustomerShipToAddress | Customers & Receivables | Customer Ship to Address | Table Relation | Jumpins | Detail |
| CustomerType | Lists | Customer Type List Table | Table Relation | Jumpins | Detail |
| CustomField | Misc | Insert Only Custom Field Table | Table Relation | Jumpins | Detail |
| DateDrivenTerms | Lists | Terms List Table (Date Driven Option) | Table Relation | Jumpins | Detail |
| Deposit | Purchases | Main Deposit Table | Table Relation | Jumpins | Detail |
| DepositLine | Purchases | Provides line detail for a deposit; contains all the information included in the Main Deposit Table | Table Relation | Jumpins | Detail |
| Employee | Employees & Payroll | Employee List Table | Table Relation | Jumpins | Detail |
| EmployeeAddtionalNote | Employees & Payroll | Employee Addtional Notes Table | Table Relation | Jumpins | Detail |
| EmployeeEarning | Employees & Payroll | Employee Payroll Information | Table Relation | Jumpins | Detail |
| Entity | Customers & Receivables | Combined list of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
| EntityAdditionalNote | Customers & Receivables | Additional Notes of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
| EntityContacts | Customers & Receivables | Contacts of all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
| EntityShipToAddress | Customers & Receivables | Ship-To-Address for all entities: customers, employees, othernames, vendors; minimum common fields | Table Relation | Jumpins | Detail |
| Estimate | Customers & Receivables | Main Estimate Table | Table Relation | Jumpins | Detail |
| EstimateLine | Customers & Receivables | Provides line item detail for an estimate; contains all the information included in the Main Estimate Table | Table Relation | Jumpins | Detail |
| EstimateLinkedTxn | Customers & Receivables | Estimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO | Table Relation | Jumpins | Detail |
| Form1099 | Accounting & Taxes | Main Form 1099 Table | Table Relation | Jumpins | Detail |
| Form1099CategoryAccountMapping | Accounting & Taxes | Provides detail information about Mapping between Category & Account; contains all the information included in the Mai | Table Relation | Jumpins | Detail |
| Host | Misc | Internal Table used to check for QuickBooks Version | Table Relation | Jumpins | Detail |
| HostMetaData | Misc | Internal Table used to check for QuickBooks Version | Table Relation | Jumpins | Detail |
| HostSupportedVersions | Misc | Internal Table used to check for Supported QuickBooks SDK Version | Table Relation | Jumpins | Detail |
| InventoryAdjustment | Inventory | Main Inventory Adjustment Table | Table Relation | Jumpins | Detail |
| InventoryAdjustmentLine | Inventory | Provides line item detail for an inventory adjustment; contains all the information included in the Main Inventory Adju | Table Relation | Jumpins | Detail |
| InventorySite | Inventory | InventorySite List Table | Table Relation | Jumpins | Detail |
| Invoice | Customers & Receivables | Main Invoice Table | Table Relation | Jumpins | Detail |
| InvoiceLine | Customers & Receivables | Provides line item detail for a customer invoice; contains all the information included in the Main Invoice Table | Table Relation | Jumpins | Detail |
| InvoiceLinkedTxn | Customers & Receivables | Payments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or Estimates | Table Relation | Jumpins | Detail |
| Item | Inventory | Combined list of all Items with minimum common fields | Table Relation | Jumpins | Detail |
| ItemAssembliesCanBuild | Inventory | List of assemblies that can be built | Table Relation | Jumpins | Detail |
| ItemDiscount | Inventory | Item Discount List Table | Table Relation | Jumpins | Detail |
| ItemFixedAsset | Inventory | Fixed Asset List Table | Table Relation | Jumpins | Detail |
| ItemGroup | Inventory | Main Item Group List Table | Table Relation | Jumpins | Detail |
| ItemGroupLine | Inventory | Detailed Group information; directly tied to the Main Item Group List Table | Table Relation | Jumpins | Detail |
| ItemInventory | Inventory | Inventory Items List Table | Table Relation | Jumpins | Detail |
| ItemInventoryAssembly | Inventory | Main Inventory Assembly Table | Table Relation | Jumpins | Detail |
| ItemInventoryAssemblyLine | Inventory | Provides detail assembly information; directly tied to the Main Inventory Assembly Table | Table Relation | Jumpins | Detail |
| ItemNonInventory | Inventory | Non Inventory Items List Table | Table Relation | Jumpins | Detail |
| ItemOtherCharge | Inventory | Other Charge Items List Table | Table Relation | Jumpins | Detail |
| ItemPayment | Inventory | Payment Items List Table | Table Relation | Jumpins | Detail |
| ItemReceipt | Customers & Receivables | Main Purchase Order Receipts Table | Table Relation | Jumpins | Detail |
| ItemReceiptExpenseLine | Sales | Provides expense line detail for an item receipt; contains all the information included in the Main Item Receipt Table | Table Relation | Jumpins | Detail |
| ItemReceiptItemLine | Customers & Receivables | Provides line item detail for a purchase order receipt; contains all the information included in the Main Item Receipt | Table Relation | Jumpins | Detail |
| ItemReceiptLinkedTxn | Customers & Receivables | Contains all receipts associated with a particular purchase order | Table Relation | Jumpins | Detail |
| ItemSalesTax | Inventory | Sales Tax Items List Table | Table Relation | Jumpins | Detail |
| ItemSalesTaxGroup | Inventory | Main Sales Tax Group Table | Table Relation | Jumpins | Detail |
| ItemSalesTaxGroupLine | Inventory | Provides detail tax code information for a sales tax group; directly tied to the Main Sales Tax Group Table | Table Relation | Jumpins | Detail |
| ItemService | Inventory | Service Items List Table | Table Relation | Jumpins | Detail |
| ItemSites | Inventory | Items Site List Table | Table Relation | Jumpins | Detail |
| ItemSubtotal | Inventory | Subtotal Items List Table | Table Relation | Jumpins | Detail |
| JobType | Lists | Job Type List Table | Table Relation | Jumpins | Detail |
| JournalEntry | Accounting & Taxes | Main Journal Entry Table | Table Relation | Jumpins | Detail |
| JournalEntryCreditLine | Transactions | Provides credit entry line detail information; contains all the information included in the Main Journal Entry Table | Table Relation | Jumpins | Detail |
| JournalEntryDebitLine | Accounting & Taxes | Provides debit entry line detail information; contains all the information included in the Main Journal Entry Table | Table Relation | Jumpins | Detail |
| JournalEntryLine | Accounting & Taxes | Provides credit and debit entry line detail information; contains all the information included in the Main Journal Entr | Table Relation | Jumpins | Detail |
| ListDeleted | Misc | List of Items that have been Deleted | Table Relation | Jumpins | Detail |
| ModifyInwardGroupLine | Customers & Receivables | Insert/Modify Only table to create/update item in Group | Table Relation | Jumpins | Detail |
| ModifyOutwardGroupLine | Sales | Insert/Modify Only table to create/update item in Group | Table Relation | Jumpins | Detail |
| OtherName | Customers & Receivables | Other Names List Table | Table Relation | Jumpins | Detail |
| PaymentMethod | Lists | Payment Methods List Table | Table Relation | Jumpins | Detail |
| PayrollItemNonWage | Employees & Payroll | Payroll Non Wage Items List Table | Table Relation | Jumpins | Detail |
| PayrollItemWage | Employees & Payroll | Payroll Wage Items List Table | Table Relation | Jumpins | Detail |
| Preferences | Misc | QuickBooks Preferences Table | Table Relation | Jumpins | Detail |
| PriceLevel | Customers & Receivables | Main Price Levels List | Table Relation | Jumpins | Detail |
| PriceLevelPerItem | Customers & Receivables | Price Levels List Item Details | Table Relation | Jumpins | Detail |
| PurchaseOrder | Purchases | Main Purchase Order Table | Table Relation | Jumpins | Detail |
| PurchaseOrderLine | Purchases | Provides line item detail for a purchase order; contains all the information included in the Main Purchase Order Table | Table Relation | Jumpins | Detail |
| PurchaseOrderLinkedTxn | Transactions | Shows Linked Purchase Order Receipts; does NOT include transfers from SO or Estimates | Table Relation | Jumpins | Detail |
| ReceivePayment | Customers & Receivables | Main Receive Payments Table | Table Relation | Jumpins | Detail |
| ReceivePaymentLine | Customers & Receivables | Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table | Table Relation | Jumpins | Detail |
| ReceivePaymentLineLinkedTxn | Customers & Receivables | Provides Linked Txn line item detail for a payment; contains all the information included in the Main Receive Payments | Table Relation | Jumpins | Detail |
| ReceivePaymentToDeposit | Banking | List of Payments Received to Undeposited Funds; ready for Deposit | Table Relation | Jumpins | Detail |
| Sales | Customers & Receivables | Custom QODBC table that includes invoices, credit memos and sales receipts information | Table Relation | Jumpins | Detail |
| SalesLine | Customers & Receivables | Custom QODBC table that includes invoice lines, credit memo lines and sales receipt line information | Table Relation | Jumpins | Detail |
| SalesOrder | Customers & Receivables | Main Sales Order Table | Table Relation | Jumpins | Detail |
| SalesOrderLine | Sales | Provides line item detail for a sales order; contains all the information included in the Main Sales Order Table | Table Relation | Jumpins | Detail |
| SalesOrderLinkedTxn | Customers & Receivables | Sales Order Linked Transactions | Table Relation | Jumpins | Detail |
| SalesReceipt | Customers & Receivables | Main Sales Receipts Table | Table Relation | Jumpins | Detail |
| SalesReceiptLine | Customers & Receivables | Provides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts Table | Table Relation | Jumpins | Detail |
| SalesRep | Lists | Sales Rep List Table | Table Relation | Jumpins | Detail |
| SalesTaxCode | Lists | Sales Tax Codes List Table | Table Relation | Jumpins | Detail |
| SalesTaxPaymentCheck | Banking | Main Sales Tax Payments Table | Table Relation | Jumpins | Detail |
| SalesTaxPaymentCheckLine | Banking | Provides line detail for a sales tax payment check; contains all the information included in the Main Sales Tax Payment | Table Relation | Jumpins | Detail |
| ShipMethod | Lists | Shipping Methods List Table | Table Relation | Jumpins | Detail |
| SpecialAccount | Accounting & Taxes | Insert Only Special Account Table | Table Relation | Jumpins | Detail |
| SpecialItem | Lists | Insert Only Special Item Table | Table Relation | Jumpins | Detail |
| StandardTerms | Lists | Terms List Table (Default Term Option) | Table Relation | Jumpins | Detail |
| TaxCode | Lists | Customer and Line Item Tax Codes; i.e. taxable, exempt | Table Relation | Jumpins | Detail |
| Template | Misc | Template Information | Table Relation | Jumpins | Detail |
| Terms | Lists | Main Terms List | Table Relation | Jumpins | Detail |
| TimeTracking | Employees & Payroll | Time Tracking Table | Table Relation | Jumpins | Detail |
| ToDo | Company & Financial | To Do Information Table | Table Relation | Jumpins | Detail |
| Transaction | Transactions | Transaction List Table | Table Relation | Jumpins | Detail |
| Transfer | Misc | Transfer Table | Table Relation | Jumpins | Detail |
| TransferInventory | Inventory | TransferInventory Transaction Table | Table Relation | Jumpins | Detail |
| TransferInventoryLine | Inventory | TransferInventory Transaction Table | Table Relation | Jumpins | Detail |
| TxnDeleted | Misc | Deleted Transactions | Table Relation | Jumpins | Detail |
| UnitOfMeasureSet | Lists | Unit of Measure Set | Table Relation | Jumpins | Detail |
| UnitOfMeasureSetDefaultUnit | Lists | Unit of Measure Set | Table Relation | Jumpins | Detail |
| UnitOfMeasureSetRelatedUnit | Lists | Unit of Measure Set | Table Relation | Jumpins | Detail |
| Vehicle | Lists | Vehicle List Table | Table Relation | Jumpins | Detail |
| VehicleMileage | Jobs, Time & Mileage | VehicleMileage Table | Table Relation | Jumpins | Detail |
| Vendor | Lists | Vendors List Table | Table Relation | Jumpins | Detail |
| VendorContacts | Lists | Vendor Contacts List Table | Table Relation | Jumpins | Detail |
| VendorCredit | Purchases | Main Vendor Credit Table | Table Relation | Jumpins | Detail |
| VendorCreditExpenseLine | Purchases | Provides expense line detail for a vendor credit; contains all the information included in the Main Vendor Credit Table | Table Relation | Jumpins | Detail |
| VendorCreditItemLine | Purchases | Provides line item detail for a vendor credit; contains all the information included in the Main Vendor Credit Table | Table Relation | Jumpins | Detail |
| VendorCreditLinkedTxn | Transactions | Credits Taken, Re-imbursed Expense Used or Not Used - directly tied to the Main Vendor Credit Table | Table Relation | Jumpins | Detail |
| VendorType | Lists | Vendor Types List Table | Table Relation | Jumpins | Detail |
| WorkersCompCode | Employees & Payroll | WorkersCompCodes List Table | Table Relation | Jumpins | Detail |
| WorkersCompCodeRateHistory | Employees & Payroll | WorkersCompCodes List Table | Table Relation | Jumpins | Detail |