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 |
|
|
|