Serious Business Intelligence almost always comes back to SQL Server Reporting Services (SSRS), and that means knowing the Collections Management Tables, Fields, and their relation.
SSRS reports can be used to prepare and deliver a variety of interactive and printed reports, transforming raw data into meaningful and useful information for your business decisions.
The below link is a download to a Table and Field reference guide to Collections Management. You can use it to look up which Collections table holds what information, and what the fields inside those tables mean.
For example, let’s say we want print a report on Collectors, so we need their information. We look in the Table worksheet and see that the Collector Master is CN01400:
We can then go to the Field worksheet, scroll down to CN01400, and see what the fields are:
Download the Collections Management Table and Field Reference Manual today!
Collections Management Table and Field Reference