/
What database view references bldetail table

What database view references bldetail table

Owned by Knowledge Assistant
Last updated: Jul 10, 2024 by Moriah Yorkey
1 min read
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

 

Related content

Database view for comment fields in Business Accounts
Database view for comment fields in Business Accounts
Knowledge Assistant
More like this
How to join TRS views bq_contract_header and bq_contract_detail
How to join TRS views bq_contract_header and bq_contract_detail
Knowledge Assistant
More like this
Database view and column containing purchase order notes
Database view and column containing purchase order notes
Knowledge Assistant
More like this
Database view containing user defined fields in position control
Database view containing user defined fields in position control
Knowledge Assistant
More like this
Database view containing P-Card Invoice vendor name
Database view containing P-Card Invoice vendor name
Knowledge Assistant
More like this
Database view containing supervisor details of an employee
Database view containing supervisor details of an employee
Knowledge Assistant
More like this