Account Tags

Purpose

The tags and tag_associations tables store the filter tags for both chart_master (GL Accounts) and dimensions table records. Field tags.type = 1 for chart_master table records.

Procedure

Banking and General Ledger -> Account Tags

Tips and Tricks

ERD Diagram

SQL of View

# GL Account Tag View

SELECT
    tags.name AS tag_name
    , description
    , tags.inactive AS tag_inactive
    , account_code
    , account_code2
    , account_name
    , account_type
    , chart_master.inactive
FROM
    0_tags AS tags
    INNER JOIN 0_tag_associations 
        ON (tags.id = tag_id)
    INNER JOIN 0_chart_master AS chart_master
        ON (record_id = account_code)
WHERE (tags.type = 1);