The BBMS Disbursement Detail report pulls all transactions from within a disbursement period. These disbursement periods and deposit dates can be seen here.
​This report pulls all credit card transactions and reports the name of the person whose card it is. The dates on this report are also the dates that the payment was added to Altru and not the date listed on the payment (often these two dates are the same but, it is possible to date a payment before the date it was actually added to the database). With that being said we will need to build a query to reflect this information.

To build this query:
  1. From Analysis > Select Information Library > Select Add an ad-hoc query > Choose the source view of Revenue.
  2. In the middle Select Payment Method > Move to Include records where and set equal to credit card
  3. In the middle Select Payment Method > Move to Results fields to display
  4. In the middle Select Date Added > Move to Include records where and set Between the date range of your disbursement period 
  5. In the middle Select Name on Card > Move to Results fields to display
  6. In the middle Select Card Number > Move to Include records where Set this to Not Blank
  7. In the middle Select Authorization code > Move to Include records where and set is Not Blank
  8. On the left Select Application Details > In the middle select Type and move to Results fields to display
  9. On the left Select Application Details > In the middle select Designation Name move to Results fields to display
  10. On the left expand Application Details > Select Membership 
  11. In the middle Select Membership Program and move to Results fields to display
  12. In the middle Select Membership level type > Move to Results fields to display
  13. On the left Select Events > In the middle select Event Name and move to Results fields to display 
  14. On the left Select Program > In the middle Select Name and move to Results fields to display
  15. On the left select Merchandise > In the middle Select Item Details and move to Results fields to display 
You browse out to view the details of these transactions by selecting the Browse feature and selecting Revenue transaction Page.