/
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:
In Tyler Menu, navigate to Munis > Property Revenue > Business Licenses > License Processing and Reports > Business Accounts
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
, multiple selections available,
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