TABLES - ALL

(US VERSION)

NAME CATEGORY DESCRIPTION TABLE RELATIONS JUMPINS TABLE DETAILS
Account List Chart of Accounts List Table
ARRefundCreditCard Transaction Accounts Receivable Refund CreditCard
ARRefundCreditCardRefundAppliedTo Transaction Accounts Receivable Refund CreditCard
Bill Transaction Main Bill Table; used to pay bills, or write checks that do not apply to existing bills
BillExpenseLine Transaction Provides expense line detail for a bill expense; contains all the information included in the Main Bill Expense Table
BillingRate List Billing Rate Header
BillingRateLine List Billing Rate Lines - Per item
BillItemLine Transaction Provides line item detail for a bill expense; contains all the information included in the Main Bill Expense Table
BillLinkedTxn Transaction Bills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill; directly tied to the Main Bill Table
BillPaymentCheck Transaction Main table of Bill Payments paid by Checks
BillPaymentCheckLine Transaction Provides line detail for a bill payment by check; contains all the information included in the Main Bill Payment Check Table
BillPaymentCreditCard Transaction Main table of Bill Payments paid by Credit Card
BillPaymentCreditCardLine Transaction Provides line detail for a bill payment by credit card; contains all the information included in the Main Bill Payment Credit Card Table
BillToPay Transaction List of Bills to Pay
BuildAssembly Transaction BuildAssembly
BuildAssemblyComponentItemLine Transaction Build Assembly Component
Charge Transaction Statement Charges Table
ChargeLinkedTxn Transaction Statement Charge Linked Transactions
Check Transaction Manual Checks NOT used to pay bills ONLY
CheckExpenseLine Transaction Provides expense line detail for a check; contains all the information included in the Main Check Table
CheckItemLine Transaction Provides line item detail for a check; contains all the information included in the Main Check Table
Class List Class List Table
ClearedStatus Transaction Insert Only Cleared Status Table
Company Info Company Information Table
CompanyActivity Info Used to Determine Last Restore Operation
CreditCardCharge Transaction Main Credit Card Table - Charges Only
CreditCardChargeExpenseLine Transaction Provides expense line detail for a credit card charge; contains all the information included in the Main Credit Card Charge Table
CreditCardChargeItemLine Transaction Provides line item detail for a credit card charge; contains all the information included in the Main Credit Card Charge Table
CreditCardCredit Transaction Main Credit Card Table - Credits Only
CreditCardCreditExpenseLine Transaction Provides expense line detail for a credit card credit; contains all the information included in the Main Credit Card Credit Table
CreditCardCreditItemLine Transaction Provides line item detail for a credit card credit; contains all the information included in the Main Credit Card Credit Table
CreditMemo Transaction Main Customer Credit Memo Table
CreditMemoLine Transaction Provides line item detail for a customer credit memo; contains all the information included in the Main Customer Credit Memo Table
CreditMemoLinkedTxn Transaction Credit Memo apply, etc.
Customer List Customer List Table
CustomerMsg List Customer Messages List Table (on Invoices)
CustomerType List Customer Type List Table
CustomField Unknown Insert Only Custom Field Table
DateDrivenTerms List Terms List Table (Date Driven Option)
Deposit Transaction Main Deposit Table
DepositLine Transaction Provides line detail for a deposit; contains all the information included in the Main Deposit Table
Employee List Employee List Table
EmployeeEarning Transaction Employee Payroll Information
Entity List Combined list of all entities: customers, employees, othernames, vendors; minimum common fields
Estimate Transaction Main Estimate Table
EstimateLine Transaction Provides line item detail for an estimate; contains all the information included in the Main Estimate Table
EstimateLinkedTxn Transaction Estimate Linked Transactions - Includes transfers to Invoice or Sales Order; does NOT include transfer to PO
Host Info Internal Table used to check for Quickbooks Version
HostMetaData Info Internal Table used to check for Quickbooks Version
HostSupportedVersions Info Internal Table used to check for Supported Quickbooks SDK Version
InventoryAdjustment Transaction Main Inventory Adjustment Table
InventoryAdjustmentLine Transaction Provides line item detail for an inventory adjustment; contains all the information included in the Main Inventory Adjustment Table
Invoice Transaction Main Invoice Table
InvoiceLine Transaction Provides line item detail for a customer invoice; contains all the information included in the Main Invoice Table
InvoiceLinkedTxn Transaction Payments, Credit Memos, Deposit Line Items; does NOT include reimbursements, transfers from SO or Estimates
Item List Combined list of all Items with minimum common fields
ItemAssembliesCanBuild Transaction List of assemblies that can be built
ItemDiscount List Item Discount List Table
ItemFixedAsset List Fixed Asset List Table
ItemGroup List Main Item Group List Table
ItemGroupLine List Detailed Group information; directly tied to the Main Item Group List Table
ItemInventory List Inventory Items List Table
ItemInventoryAssembly List Main Inventory Assembly Table
ItemInventoryAssemblyLine List Provides detail assembly information; directly tied to the Main Inventory Assembly Table
ItemNonInventory List Non Inventory Items List Table
ItemOtherCharge List Other Charge Items List Table
ItemPayment List Payment Items List Table
ItemReceipt Transaction Main Purchase Order Receipts Table
ItemReceiptExpenseLine Transaction Provides expense line detail for an item receipt; contains all the information included in the Main Item Receipt Table
ItemReceiptItemLine Transaction Provides line item detail for a purchase order receipt; contains all the information included in the Main Item Receipt Table
ItemReceiptLinkedTxn Transaction Contains all receipts associated with a particular purchase order
ItemSalesTax List Sales Tax Items List Table
ItemSalesTaxGroup List Main Sales Tax Group Table
ItemSalesTaxGroupLine List Provides detail tax code information for a sales tax group; directly tied to the Main Sales Tax Group Table
ItemService List Service Items List Table
ItemSubtotal List Subtotal Items List Table
JobType List Job Type List Table
JournalEntry Transaction Main Journal Entry Table
JournalEntryCreditLine Transaction Provides credit entry line detail information; contains all the information included in the Main Journal Entry Table
JournalEntryDebitLine Transaction Provides debit entry line detail information; contains all the information included in the Main Journal Entry Table
JournalEntryLine Transaction Provides credit and debit entry line detail information; contains all the information included in the Main Journal Entry Table
ListDeleted Transaction List of Items that have been Deleted
OtherName List Other Names List Table
PaymentMethod List Payment Methods List Table
PayrollItemNonWage List Payroll Non Wage Items List Table
PayrollItemWage List Payroll Wage Items List Table
Preferences Info QuickBooks Preferences Table
PriceLevel List Main Price Levels List
PriceLevelPerItem List Price Levels List Item Details
PurchaseOrder Transaction Main Purchase Order Table
PurchaseOrderLine Transaction Provides line item detail for a purchase order; contains all the information included in the Main Purchase Order Table
PurchaseOrderLinkedTxn Transaction Shows Linked Purchase Order Receipts; does NOT include transfers from SO or Estimates
ReceivePayment Transaction Main Receive Payments Table
ReceivePaymentLine Transaction Provides line item detail for a payment; contains all the information included in the Main Receive Payments Table
ReceivePaymentToDeposit Transaction List of Payments Received to Undeposited Funds; ready for Deposit
Sales Combination Custom QODBC table that includes invoices, credit memos and sales receipts information
SalesOrder Transaction Main Sales Order Table
SalesOrderLine Transaction Provides line item detail for a sales order; contains all the information included in the Main Sales Order Table
SalesOrderLinkedTxn Transaction Sales Order Linked Transactions
SalesReceipt Transaction Main Sales Receipts Table
SalesReceiptLine Transaction Provides line item detail for a sales receipt, contains all the information included in the Main Sales Receipts Table
SalesRep List Sales Rep List Table
SalesTaxCode List Sales Tax Codes List Table
SalesTaxPaymentCheck Transaction Main Sales Tax Payments Table
SalesTaxPaymentCheckLine Transaction Provides line detail for a sales tax payment check; contains all the information included in the Main Sales Tax Payments Table
ShipMethod List Shipping Methods List Table
SpecialAccount Transaction Insert Only Special Account Table
SpecialItem Transaction Insert Only Special Item Table
StandardTerms List Terms List Table (Default Term Option)
Template List Template Information
Terms List Main Terms List
TimeTracking Transaction Time Tracking Table
ToDo Transaction To Do Information Table
Transaction Transaction Transaction List Table
TxnDeleted Info Deleted Transactions
VehicleMileage List VehicleMileage Table
Vendor List Vendors List Table
VendorCredit Transaction Main Vendor Credit Table
VendorCreditExpenseLine Transaction Provides expense line detail for a vendor credit; contains all the information included in the Main Vendor Credit Table
VendorCreditItemLine Transaction Provides line item detail for a vendor credit; contains all the information included in the Main Vendor Credit Table
VendorCreditLinkedTxn Transaction Credits Taken, Re-imbursed Expense Used or Not Used - directly tied to the Main Vendor Credit Table
VendorType List Vendor Types List Table