Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
What are the table relationships used in sp_report reports? |
Author |
Message |
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-17 08:16:17 |
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 |
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-17 08:56:41 |
Report Name |
Report Field |
Related Field |
UnpaidBillsDetail |
AccountFullName |
Account.FullName |
UnpaidBillsDetail |
AccountListID |
Account.ListID |
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 |
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 |
AccountFullName |
Account.FullName |
BalanceSheetPrevYearComp |
AccountListID |
Account.ListID |
BalanceSheetStandard |
AccountFullName |
Account.FullName |
BalanceSheetStandard |
AccountListID |
Account.ListID |
BalanceSheetSummary |
AccountFullName |
Account.FullName |
BalanceSheetSummary |
AccountListID |
Account.ListID |
ProfitAndLossByClass |
AccountFullName |
Account.FullName |
ProfitAndLossByClass |
AccountListID |
Account.ListID |
ProfitAndLossByJob |
AccountFullName |
Account.FullName |
ProfitAndLossByJob |
AccountListID |
Account.ListID |
ProfitAndLossPrevYearComp |
AccountFullName |
Account.FullName |
ProfitAndLossPrevYearComp |
AccountListID |
Account.ListID |
ProfitAndLossStandard |
AccountFullName |
Account.FullName |
ProfitAndLossStandard |
AccountListID |
Account.ListID |
ProfitAndLossYTDComp |
AccountFullName |
Account.FullName |
ProfitAndLossYTDComp |
AccountListID |
Account.ListID |
TrialBalance |
AccountFullName |
Account.FullName |
TrialBalance |
AccountListID |
Account.ListID |
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 |
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 |
AccountFullName |
Account.FullName |
PayrollReviewDetail |
AccountListID |
Account.ListID |
PayrollTransactionDetail |
AccountFullName |
Account.FullName |
PayrollTransactionDetail |
AccountListID |
Account.ListID |
PayrollTransactionsByPayee |
AccountFullName |
Account.FullName |
|
|
|
|
|