[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 belowSp_report Name Sp_report -> Columns in sp_report <==> Related Table . ColumnName List of Relationships between QuickBooks Tables and Sp_reportsAPAgingDetail 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 | |
|