10
ShelbyDB Views
vw_APInvoices vw_GBNames vw_MBLifeEvents
vw_APTransactions vw_GBOtherRelations vw_MBNames
vw_APVendors vw_GBOtherRelationsLowerNames vw_PRCheckDetails
vw_ARBillToNames vw_GBOtherRelationsUpperNames vw_PRChecks
vw_ARCustomerNames vw_GBProfileInformation vw_PREmployees
vw_ARInvoices vw_GLAccounts ^ vw_SGAttendanceHistory ^
vw_ARTransactions vw_GLActualsByPeriod vw_SGAttendees
vw_CNGifts vw_GLBudgetEntries vw_SGEnrollmentCustomFields
vw_CNNames vw_GLBudgetsAndActualsByPeriodAndProject vw_SGEnrollments
vw_GFGifts vw_GLBudgetsByPeriod vw_SGGroupCustomFields
vw_GFNames vw_GLClosingAccountActivity vw_SGGroups
vw_GLJournalEntries vw_SGGroupStatistics
vw_GLSpecialReports
More information is available for these views. Just search the Shelby Community for the view name
minus the opening vw_, and you should find information about the contents of the view.
The CN (Contributions) and GF (Donors & Gifts) views have been improved since these were added to
the database. The revised views can be downloaded from the Shelby Community, under the
Downloads/ShelbyQUERY/Data Views path. I recommend using these views instead.
^ The GLAccounts and SGAttendanceHistory views can take a very long time to populate if you have a
large number of records or a long history of related information in ShelbyDB. There is a new
GLAccounts view available in the Shelby Community in the same Data Views path mentioned above,
and the new GLAccounts view should not take so long to load. For the SGAttendanceHistory view,
always filter it to only the necessary date range for your reports. That will help it run more quickly.
If you have trouble using any of these views, feel free to contact
[email protected] for
assistance.