This a basic table showing the table relationships used in sp_report reports:-

 

Report Name	Report Field	Related Field
APAgingDetail	AccountFullName	Account.FullName
APAgingDetail	AccountListID	Account.ListID
ARAgingDetail	AccountFullName	Account.FullName
ARAgingDetail	AccountListID	Account.ListID
CollectionsReport	AccountFullName	Account.FullName
CollectionsReport	AccountListID	Account.ListID
ProfitAndLossBudgetOverview	AccountFullName	Account.FullName
ProfitAndLossBudgetOverview	AccountListID	Account.ListID
ProfitAndLossBudgetPerformance	AccountFullName	Account.FullName
ProfitAndLossBudgetPerformance	AccountListID	Account.ListID
ProfitAndLossBudgetVsActual	AccountFullName	Account.FullName
ProfitAndLossBudgetVsActual	AccountListID	Account.ListID
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	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	AccountFullName	Account.FullName
Detail1099	AccountListID	Account.ListID
AuditTrail	AccountFullName	Account.FullName
AuditTrail	AccountListID	Account.ListID
BalanceSheetDetail	AccountFullName	Account.FullName
BalanceSheetDetail	AccountListID	Account.ListID
CheckDetail	AccountFullName	Account.FullName
CheckDetail	AccountListID	Account.ListID
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	AccountFullName	Account.FullName
DepositDetail	AccountListID	Account.ListID
EstimatesByJob	AccountFullName	Account.FullName
EstimatesByJob	AccountListID	Account.ListID
ExpenseByVendorDetail	AccountFullName	Account.FullName
ExpenseByVendorDetail	AccountListID	Account.ListID
GeneralLedger	AccountFullName	Account.FullName
GeneralLedger	AccountListID	Account.ListID
IncomeByCustomerDetail	AccountFullName	Account.FullName
IncomeByCustomerDetail	AccountListID	Account.ListID
IncomeTaxDetail	AccountFullName	Account.FullName
IncomeTaxDetail	AccountListID	Account.ListID
JobProgressInvoicesVsEstimates	AccountFullName	Account.FullName
JobProgressInvoicesVsEstimates	AccountListID	Account.ListID
MissingChecks	AccountFullName	Account.FullName
MissingChecks	AccountListID	Account.ListID
OpenInvoices	AccountFullName	Account.FullName
OpenInvoices	AccountListID	Account.ListID
OpenPOs	AccountFullName	Account.FullName
OpenPOs	AccountListID	Account.ListID
OpenPOsByJob	AccountFullName	Account.FullName
OpenPOsByJob	AccountListID	Account.ListID
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	AccountFullName	Account.FullName
ProfitAndLossDetail	AccountListID	Account.ListID
PurchaseByItemDetail	AccountFullName	Account.FullName
PurchaseByItemDetail	AccountListID	Account.ListID
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	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	AccountFullName	Account.FullName
SalesByItemDetail	AccountListID	Account.ListID
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	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	AccountFullName	Account.FullName
TxnListByCustomer	AccountListID	Account.ListID
TxnListByDate	AccountFullName	Account.FullName
TxnListByDate	AccountListID	Account.ListID
TxnListByVendor	AccountFullName	Account.FullName
TxnListByVendor	AccountListID	Account.ListID