Database view containing deposit number of a receipt

Owned by Knowledge Assistant
Mar 31, 2023
1 min read



Description of Issue

Client needs database view that contains deposit number for a given receipt



Context

  • Munis

  • SSRS reports

  • Crystal Reports

  • Accounts Receivable

  • Receipt Inquiry



Cause

The view database column option shows database information as derived



Resolution

To view this deposit number in Munis, follow the steps below:

  1. Navigate to Munis Menu > General Revenue > Payment Processing > Receipts

  2. Click on TENDERS tab to view the Deposit field.

This Deposit number is located in TRS view AccountsReceivableReportingServices.Tenders under column DepositNumber.


To get Deposit number for a given Receipt:

SELECT TransactionId

FROM

AccountsReceivableReportingServices.Receipts

WHERE ReceiptNumber = XXXX


SELECT DepositNumber

FROM AccountsReceivableReportingServices.Tenders

WHERE TransactionId = XXXX



Additional Information