What database view references bldetail table

Description of Issue

Need TRS view that contains the columns from bldetail table.

Context
  • SSRS Report

  • Tyler Reporting Services Views

  • Database Views

  • Enterprise ERP all versions

Cause

Need a TRS view to substitute bldetail table in a custom report

Resolution

The following columns in bl_charges view contains the information as seen in bldetail table

  1. License Number: a_bil_lic_no 

  2. Paid date: bd_paid_date

  3. Status: bd_status

  4. Bill code: bd_bill_code

Additional Information

Â