/
Database view for comment fields in Business Accounts

Database view for comment fields in Business Accounts



Description of Issue

Client needs TRS view containing Comment1 and Comment2 fields in Business Accounts



Context
  • All Munis versions

  • SSRS reports

  • Crystal reports

  • Business Accounts



Cause

The View Database Columns overlay for comment fields show comment fields as derived



Resolution

To view these comment fields in Munis, follow the steps below:

  1. In Tyler Menu, navigate to Munis > Property Revenue > Business Licenses > License Processing and Reports > Business Accounts

  2. Click TEXT/COMMENTS tab to view comment fields.

In the following sample query, replace XXXX with the Account ID to view COMMENT 1. Replace blmstcm1 with blmstcm2 to view COMMENT 2.

SELECT td_text FROM mu_text WHERE th_program = 'blmstcm1' AND th_index_value = 'XXXX'



Additional Information












Related content

Database view containing comments for a work order
Database view containing comments for a work order
More like this
Database view and column containing purchase order notes
Database view and column containing purchase order notes
More like this
Database view containing comment for property master restrictions
Database view containing comment for property master restrictions
More like this
Database view for comment field in application plan review
Database view for comment field in application plan review
More like this
What database view references bldetail table
What database view references bldetail table
More like this
Database view containing deposit number of a receipt
Database view containing deposit number of a receipt
More like this