Database view containing deposit number of a receipt

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

• Munis

• SSRS reports

• Crystal Reports

• Accounts Receivable

• Receipt Inquiry

The view database column option shows database information as derived

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