Knowledgebase
[QODBC-Desktop] Table relationships used in sp_report reports
Posted by brad waddell on 12 March 2009 05:21 PM

Instructions for the essential list below

Sp_report Name

Sp_report -> Columns in sp_report  <==>  Related Table . ColumnName

List of Relationships between QuickBooks Tables and Sp_reports

APAgingDetail Report

APAgingDetail -> AccountFullName <==> Account.FullName

APAgingDetail -> AccountListID <==> Account.ListID

ARAgingDetail Report

ARAgingDetail -> AccountFullName <==> Account.FullName

ARAgingDetail -> AccountListID <==> Account.ListID

Collections Report

Collections -> AccountFullName <==> Account.FullName

Collections -> AccountListID <==> Account.ListID

ProfitAndLossBudgetOverview Report

ProfitAndLossBudgetOverview -> AccountFullName <==> Account.FullName

ProfitAndLossBudgetOverview -> AccountListID <==> Account.ListID

ProfitAndLossBudgetPerformance Report

ProfitAndLossBudgetPerformance -> AccountFullName <==> Account.FullName

ProfitAndLossBudgetPerformance -> AccountListID <==> Account.ListID

ProfitAndLossBudgetVsActual Report

ProfitAndLossBudgetVsActual -> AccountFullName <==> Account.FullName

ProfitAndLossBudgetVsActual -> AccountListID <==> Account.ListID

CustomTxnDetail Report

CustomTxnDetail -> TextAccountName <==> Account.FullName

CustomTxnDetail -> TextClassName <==> Class.Name

CustomTxnDetail -> TextCustomerName <==> Customer.Name

CustomTxnDetail -> TextCustomerTypeName <==> CustomerType.Name

CustomTxnDetail -> TextEmployeeName <==> Employee.Name

CustomTxnDetail -> TextItemName <==> Item.Name

CustomTxnDetail -> TextPaymentMethodName <==> PaymentMethod.Name

CustomTxnDetail -> TextSalesRepInitial <==> SalesRep.Initial

CustomTxnDetail -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

CustomTxnDetail -> TextShipMethodName <==> ShipMethod.Name

CustomTxnDetail -> TextTermsName <==> Terms.Name

CustomTxnDetail -> TextVendorName <==> Vendor.Name

CustomTxnDetail -> TextVendorTypeName <==> VendorType.Name

CustomTxnDetail -> AccountFullName <==> Account.FullName

CustomTxnDetail -> AccountListID <==> Account.ListID

CustomSummary Report

CustomSummary -> LabelAccountName <==> Account.Name

CustomSummary -> LabelClassName <==> Class.Name

CustomSummary -> LabelCustomerName <==> Customer.Name

CustomSummary -> LabelCustomerTypeName <==> CustomerType.Name

CustomSummary -> LabelEmployeeName <==> Employee.Name

CustomSummary -> LabelItemName <==> Item.Name

CustomSummary -> LabelPaymentMethodName <==> PaymentMethod.Name

CustomSummary -> LabelSalesRepInitial <==> SalesRep.Initial

CustomSummary -> LabelSalesTaxCodeDesc <==> SalesTaxCode.Desc

CustomSummary -> LabelShipMethodName <==> ShipMethod.Name

CustomSummary -> LabelTaxCodeDesc <==> TaxCode.Desc

CustomSummary -> LabelTermsName <==> Terms.Name

CustomSummary -> LabelVendorName <==> Vendor.Name

CustomSummary -> LabelVendorTypeName <==> VendorType.Name

CustomSummary -> TextAccountName <==> Account.Name

CustomSummary -> TextCustomerFullName <==> Customer.FullName

CustomSummary -> TextItemFullName <==> Item.FullName

Detail1099 Report

Detail1099 -> AccountFullName <==> Account.FullName

Detail1099 -> AccountListID <==> Account.ListID

AuditTrail Report

AuditTrail -> AccountFullName <==> Account.FullName

AuditTrail -> AccountListID <==> Account.ListID

BalanceSheetDetail Report

BalanceSheetDetail -> AccountFullName <==> Account.FullName

BalanceSheetDetail -> AccountListID <==> Account.ListID

CheckDetail Report

CheckDetail -> AccountFullName <==> Account.FullName

CheckDetail -> AccountListID <==> Account.ListID

CustomerBalanceDetail Report

CustomerBalanceDetail -> TextAccountName <==> Account.FullName

CustomerBalanceDetail -> TextClassName <==> Class.Name

CustomerBalanceDetail -> TextCustomerName <==> Customer.Name

CustomerBalanceDetail -> TextCustomerTypeName <==> CustomerType.Name

CustomerBalanceDetail -> TextEmployeeName <==> Employee.Name

CustomerBalanceDetail -> TextItemName <==> Item.Name

CustomerBalanceDetail -> TextPaymentMethodName <==> PaymentMethod.Name

CustomerBalanceDetail -> TextSalesRepInitial <==> SalesRep.Initial

CustomerBalanceDetail -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

CustomerBalanceDetail -> TextShipMethodName <==> ShipMethod.Name

CustomerBalanceDetail -> TextTermsName <==> Terms.Name

CustomerBalanceDetail -> TextVendorName <==> Vendor.Name

CustomerBalanceDetail -> TextVendorTypeName <==> VendorType.Name

CustomerBalanceDetail -> AccountFullName <==> Account.FullName

CustomerBalanceDetail -> AccountListID <==> Account.ListID

DepositDetail Report

DepositDetail -> AccountFullName <==> Account.FullName

DepositDetail -> AccountListID <==> Account.ListID

EstimatesByJob Report

EstimatesByJob -> AccountFullName <==> Account.FullName

EstimatesByJob -> AccountListID <==> Account.ListID

ExpenseByVendorDetail Report

ExpenseByVendorDetail -> AccountFullName <==> Account.FullName

ExpenseByVendorDetail -> AccountListID <==> Account.ListID

GeneralLedger Report

GeneralLedger -> AccountFullName <==> Account.FullName

GeneralLedger -> AccountListID <==> Account.ListID

IncomeByCustomerDetail Report

IncomeByCustomerDetail -> AccountFullName <==> Account.FullName

IncomeByCustomerDetail -> AccountListID <==> Account.ListID

IncomeTaxDetail Report

IncomeTaxDetail -> AccountFullName <==> Account.FullName

IncomeTaxDetail -> AccountListID <==> Account.ListID

JobProgressInvoicesVsEstimates Report

JobProgressInvoicesVsEstimates -> AccountFullName <==> Account.FullName

JobProgressInvoicesVsEstimates -> AccountListID <==> Account.ListID

MissingChecks Report

MissingChecks -> AccountFullName <==> Account.FullName

MissingChecks -> AccountListID <==> Account.ListID

open invoices Report

open invoices -> AccountFullName <==> Account.FullName

open invoices -> AccountListID <==> Account.ListID

opens Report

opens -> AccountFullName <==> Account.FullName

opens -> AccountListID <==> Account.ListID

OpenPOsByJob Report

OpenPOsByJob -> AccountFullName <==> Account.FullName

OpenPOsByJob -> AccountListID <==> Account.ListID

PendingSales Report

PendingSales -> TextAccountName <==> Account.FullName

PendingSales -> TextClassName <==> Class.Name

PendingSales -> TextCustomerName <==> Customer.Name

PendingSales -> TextCustomerTypeName <==> CustomerType.Name

PendingSales -> TextEmployeeName <==> Employee.Name

PendingSales -> TextItemName <==> Item.Name

PendingSales -> TextPaymentMethodName <==> PaymentMethod.Name

PendingSales -> TextSalesRepInitial <==> SalesRep.Initial

PendingSales -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

PendingSales -> TextShipMethodName <==> ShipMethod.Name

PendingSales -> TextTermsName <==> Terms.Name

PendingSales -> TextVendorName <==> Vendor.Name

PendingSales -> TextVendorTypeName <==> VendorType.Name

PendingSales -> AccountFullName <==> Account.FullName

PendingSales -> AccountListID <==> Account.ListID

ProfitAndLossDetail Report

ProfitAndLossDetail -> AccountFullName <==> Account.FullName

ProfitAndLossDetail -> AccountListID <==> Account.ListID

PurchaseByItemDetail Report

PurchaseByItemDetail -> AccountFullName <==> Account.FullName

PurchaseByItemDetail -> AccountListID <==> Account.ListID

PurchaseByVendorDetail Report

PurchaseByVendorDetail -> TextAccountName <==> Account.FullName

PurchaseByVendorDetail -> TextClassName <==> Class.Name

PurchaseByVendorDetail -> TextCustomerName <==> Customer.Name

PurchaseByVendorDetail -> TextCustomerTypeName <==> CustomerType.Name

PurchaseByVendorDetail -> TextEmployeeName <==> Employee.Name

PurchaseByVendorDetail -> TextItemName <==> Item.Name

PurchaseByVendorDetail -> TextPaymentMethodName <==> PaymentMethod.Name

PurchaseByVendorDetail -> TextSalesRepInitial <==> SalesRep.Initial

PurchaseByVendorDetail -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

PurchaseByVendorDetail -> TextShipMethodName <==> ShipMethod.Name

PurchaseByVendorDetail -> TextTermsName <==> Terms.Name

PurchaseByVendorDetail -> TextVendorName <==> Vendor.Name

PurchaseByVendorDetail -> TextVendorTypeName <==> VendorType.Name

PurchaseByVendorDetail -> AccountFullName <==> Account.FullName

PurchaseByVendorDetail -> AccountListID <==> Account.ListID

SalesByCustomerDetail Report

SalesByCustomerDetail -> TextAccountName <==> Account.FullName

SalesByCustomerDetail -> TextClassName <==> Class.Name

SalesByCustomerDetail -> TextCustomerName <==> Customer.Name

SalesByCustomerDetail -> TextCustomerTypeName <==> CustomerType.Name

SalesByCustomerDetail -> TextEmployeeName <==> Employee.Name

SalesByCustomerDetail -> TextItemName <==> Item.Name

SalesByCustomerDetail -> TextPaymentMethodName <==> PaymentMethod.Name

SalesByCustomerDetail -> TextSalesRepInitial <==> SalesRep.Initial

SalesByCustomerDetail -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

SalesByCustomerDetail -> TextShipMethodName <==> ShipMethod.Name

SalesByCustomerDetail -> TextTermsName <==> Terms.Name

SalesByCustomerDetail -> TextVendorName <==> Vendor.Name

SalesByCustomerDetail -> TextVendorTypeName <==> VendorType.Name

SalesByCustomerDetail -> AccountFullName <==> Account.FullName

SalesByCustomerDetail -> AccountListID <==> Account.ListID

SalesByItemDetail Report

SalesByItemDetail -> AccountFullName <==> Account.FullName

SalesByItemDetail -> AccountListID <==> Account.ListID

SalesByRepDetail Report

SalesByRepDetail -> TextAccountName <==> Account.FullName

SalesByRepDetail -> TextClassName <==> Class.Name

SalesByRepDetail -> TextCustomerName <==> Customer.Name

SalesByRepDetail -> TextCustomerTypeName <==> CustomerType.Name

SalesByRepDetail -> TextEmployeeName <==> Employee.Name

SalesByRepDetail -> TextItemName <==> Item.Name

SalesByRepDetail -> TextPaymentMethodName <==> PaymentMethod.Name

SalesByRepDetail -> TextSalesRepInitial <==> SalesRep.Initial

SalesByRepDetail -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

SalesByRepDetail -> TextShipMethodName <==> ShipMethod.Name

SalesByRepDetail -> TextTermsName <==> Terms.Name

SalesByRepDetail -> TextVendorName <==> Vendor.Name

SalesByRepDetail -> TextVendorTypeName <==> VendorType.Name

SalesByRepDetail -> AccountFullName <==> Account.FullName

SalesByRepDetail -> AccountListID <==> Account.ListID

TxnDetailByAccount Report

TxnDetailByAccount -> TextAccountName <==> Account.FullName

TxnDetailByAccount -> TextClassName <==> Class.Name

TxnDetailByAccount -> TextCustomerName <==> Customer.Name

TxnDetailByAccount -> TextCustomerTypeName <==> CustomerType.Name

TxnDetailByAccount -> TextEmployeeName <==> Employee.Name

TxnDetailByAccount -> TextItemName <==> Item.Name

TxnDetailByAccount -> TextPaymentMethodName <==> PaymentMethod.Name

TxnDetailByAccount -> TextSalesRepInitial <==> SalesRep.Initial

TxnDetailByAccount -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

TxnDetailByAccount -> TextShipMethodName <==> ShipMethod.Name

TxnDetailByAccount -> TextTermsName <==> Terms.Name

TxnDetailByAccount -> TextVendorName <==> Vendor.Name

TxnDetailByAccount -> TextVendorTypeName <==> VendorType.Name

TxnDetailByAccount -> AccountFullName <==> Account.FullName

TxnDetailByAccount -> AccountListID <==> Account.ListID

TxnListByCustomer Report

TxnListByCustomer -> AccountFullName <==> Account.FullName

TxnListByCustomer -> AccountListID <==> Account.ListID

TxnListByDate -> AccountFullName <==> Account.FullName

TxnListByDate -> AccountListID <==> Account.ListID

TxnListByVendor -> AccountFullName <==> Account.FullName

TxnListByVendor -> AccountListID <==> Account.ListID

UnpaidBillsDetail Report

UnpaidBillsDetail -> AccountFullName <==> Account.FullName

UnpaidBillsDetail -> AccountListID <==> Account.ListID

UnbilledCostsByJob Report

UnbilledCostsByJob -> TextAccountName <==> Account.FullName

UnbilledCostsByJob -> TextClassName <==> Class.Name

UnbilledCostsByJob -> TextCustomerName <==> Customer.Name

UnbilledCostsByJob -> TextCustomerTypeName <==> CustomerType.Name

UnbilledCostsByJob -> TextEmployeeName <==> Employee.Name

UnbilledCostsByJob -> TextItemName <==> Item.Name

UnbilledCostsByJob -> TextPaymentMethodName <==> PaymentMethod.Name

UnbilledCostsByJob -> TextSalesRepInitial <==> SalesRep.Initial

UnbilledCostsByJob -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

UnbilledCostsByJob -> TextShipMethodName <==> ShipMethod.Name

UnbilledCostsByJob -> TextTermsName <==> Terms.Name

UnbilledCostsByJob -> TextVendorName <==> Vendor.Name

UnbilledCostsByJob -> TextVendorTypeName <==> VendorType.Name

UnbilledCostsByJob -> AccountFullName <==> Account.FullName

UnbilledCostsByJob -> AccountListID <==> Account.ListID

VendorBalanceDetail Report

VendorBalanceDetail -> TextAccountName <==> Account.FullName

VendorBalanceDetail -> TextClassName <==> Class.Name

VendorBalanceDetail -> TextCustomerName <==> Customer.Name

VendorBalanceDetail -> TextCustomerTypeName <==> CustomerType.Name

VendorBalanceDetail -> TextEmployeeName <==> Employee.Name

VendorBalanceDetail -> TextItemName <==> Item.Name

VendorBalanceDetail -> TextPaymentMethodName <==> PaymentMethod.Name

VendorBalanceDetail -> TextSalesRepInitial <==> SalesRep.Initial

VendorBalanceDetail -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

VendorBalanceDetail -> TextShipMethodName <==> ShipMethod.Name

VendorBalanceDetail -> TextTermsName <==> Terms.Name

VendorBalanceDetail -> TextVendorName <==> Vendor.Name

VendorBalanceDetail -> TextVendorTypeName <==> VendorType.Name

VendorBalanceDetail -> AccountFullName <==> Account.FullName

VendorBalanceDetail -> AccountListID <==> Account.ListID

BalanceSheetPrevYearComp Report

BalanceSheetPrevYearComp -> AccountFullName <==> Account.FullName

BalanceSheetPrevYearComp -> AccountListID <==> Account.ListID

BalanceSheetStandard Report

BalanceSheetStandard -> AccountFullName <==> Account.FullName

BalanceSheetStandard -> AccountListID <==> Account.ListID

BalanceSheetSummary Report

BalanceSheetSummary -> AccountFullName <==> Account.FullName

BalanceSheetSummary -> AccountListID <==> Account.ListID

ProfitAndLossByClass Report

ProfitAndLossByClass -> AccountFullName <==> Account.FullName

ProfitAndLossByClass -> AccountListID <==> Account.ListID

ProfitAndLossByJob Report

ProfitAndLossByJob -> AccountFullName <==> Account.FullName

ProfitAndLossByJob -> AccountListID <==> Account.ListID

ProfitAndLossPrevYearComp Report

ProfitAndLossPrevYearComp -> AccountFullName <==> Account.FullName

ProfitAndLossPrevYearComp -> AccountListID <==> Account.ListID

ProfitAndLossStandard Report

ProfitAndLossStandard -> AccountFullName <==> Account.FullName

ProfitAndLossStandard -> AccountListID <==> Account.ListID

ProfitAndLossYTDComp Report

ProfitAndLossYTDComp -> AccountFullName <==> Account.FullName

ProfitAndLossYTDComp -> AccountListID <==> Account.ListID

TrialBalance Report

TrialBalance -> AccountFullName <==> Account.FullName

TrialBalance -> AccountListID <==> Account.ListID

EmployeeStateTaxesDetail Report

EmployeeStateTaxesDetail -> TextAccountName <==> Account.FullName

EmployeeStateTaxesDetail -> TextClassName <==> Class.Name

EmployeeStateTaxesDetail -> TextCustomerName <==> Customer.Name

EmployeeStateTaxesDetail -> TextCustomerTypeName <==> CustomerType.Name

EmployeeStateTaxesDetail -> TextEmployeeName <==> Employee.Name

EmployeeStateTaxesDetail -> TextItemName <==> Item.Name

EmployeeStateTaxesDetail -> TextPaymentMethodName <==> PaymentMethod.Name

EmployeeStateTaxesDetail -> TextSalesRepInitial <==> SalesRep.Initial

EmployeeStateTaxesDetail -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

EmployeeStateTaxesDetail -> TextShipMethodName <==> ShipMethod.Name

EmployeeStateTaxesDetail -> TextTermsName <==> Terms.Name

EmployeeStateTaxesDetail -> TextVendorName <==> Vendor.Name

EmployeeStateTaxesDetail -> TextVendorTypeName <==> VendorType.Name

EmployeeStateTaxesDetail -> AccountFullName <==> Account.FullName

EmployeeStateTaxesDetail -> AccountListID <==> Account.ListID

PayrollItemDetail Report

PayrollItemDetail -> TextAccountName <==> Account.FullName

PayrollItemDetail -> TextClassName <==> Class.Name

PayrollItemDetail -> TextCustomerName <==> Customer.Name

PayrollItemDetail -> TextCustomerTypeName <==> CustomerType.Name

PayrollItemDetail -> TextEmployeeName <==> Employee.Name

PayrollItemDetail -> TextItemName <==> Item.Name

PayrollItemDetail -> TextPaymentMethodName   <==> PaymentMethod.Name

PayrollItemDetail -> TextSalesRepInitial <==> SalesRep.Initial

PayrollItemDetail -> TextSalesTaxCodeDesc <==> SalesTaxCode.Desc

PayrollItemDetail -> TextShipMethodName <==> ShipMethod.Name

PayrollItemDetail -> TextTermsName <==> Terms.Name

PayrollItemDetail -> TextVendorName <==> Vendor.Name

PayrollItemDetail -> TextVendorTypeName <==> VendorType.Name

PayrollItemDetail -> AccountFullName <==> Account.FullName

PayrollItemDetail -> AccountListID <==> Account.ListID

PayrollReviewDetail Report

PayrollReviewDetail -> AccountFullName <==> Account.FullName

PayrollReviewDetail -> AccountListID <==> Account.ListID

PayrollTransactionDetail Report

PayrollTransactionDetail -> AccountFullName <==> Account.FullName

PayrollTransactionDetail -> AccountListID <==> Account.ListID

PayrollTransactionsByPayee Report

PayrollTransactionsByPayee -> AccountFullName <==> Account.FullName

(218 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).