rv_cof_taxes

SELECT lbr_taxdefinition.ad_client_id,

    lbr_taxdefinition.ad_org_id,

    lbr_taxdefinition.created,

    lbr_taxdefinition.createdby,

    lbr_taxdefinition.updated,

    lbr_taxdefinition.updatedby,

    lbr_taxdefinition.lbr_taxdefinition_id AS record_id,

    'LBR_TaxDefinition'::text AS table_name,

    lbr_taxdefinition.lbr_tax_id,

    'C'::text AS tax_type

   FROM lbr_taxdefinition

UNION

 SELECT lbr_issmatrix.ad_client_id,

    lbr_issmatrix.ad_org_id,

    lbr_issmatrix.created,

    lbr_issmatrix.createdby,

    lbr_issmatrix.updated,

    lbr_issmatrix.updatedby,

    lbr_issmatrix.lbr_issmatrix_id AS record_id,

    'LBR_ISSMatrix'::text AS table_name,

    lbr_issmatrix.lbr_tax_id,

    'C'::text AS tax_type

   FROM lbr_issmatrix

UNION

 SELECT lbr_ncm.ad_client_id,

    lbr_ncm.ad_org_id,

    lbr_ncm.created,

    lbr_ncm.createdby,

    lbr_ncm.updated,

    lbr_ncm.updatedby,

    lbr_ncm.lbr_ncm_id AS record_id,

    'LBR_NCM'::text AS table_name,

    lbr_ncm.lbr_tax_id,

    'C'::text AS tax_type

   FROM lbr_ncm

UNION

 SELECT m_movementline.ad_client_id,

    m_movementline.ad_org_id,

    m_movementline.created,

    m_movementline.createdby,

    m_movementline.updated,

    m_movementline.updatedby,

    m_movementline.m_movementline_id AS record_id,

    'M_MovementLine'::text AS table_name,

    m_movementline.lbr_tax_id,

    'T'::text AS tax_type

   FROM m_movementline

UNION

 SELECT lbr_cfopline.ad_client_id,

    lbr_cfopline.ad_org_id,

    lbr_cfopline.created,

    lbr_cfopline.createdby,

    lbr_cfopline.updated,

    lbr_cfopline.updatedby,

    lbr_cfopline.lbr_cfopline_id AS record_id,

    'LBR_CFOPLine'::text AS table_name,

    lbr_cfopline.lbr_tax_id,

    'C'::text AS tax_type

   FROM lbr_cfopline

UNION

 SELECT test.ad_client_id,

    test.ad_org_id,

    test.created,

    test.createdby,

    test.updated,

    test.updatedby,

    test.test_id AS record_id,

    'Test'::text AS table_name,

    test.lbr_tax_id,

    'C'::text AS tax_type

   FROM test

UNION

 SELECT c_orderline.ad_client_id,

    c_orderline.ad_org_id,

    c_orderline.created,

    c_orderline.createdby,

    c_orderline.updated,

    c_orderline.updatedby,

    c_orderline.c_orderline_id AS record_id,

    'C_OrderLine'::text AS table_name,

    c_orderline.lbr_tax_id,

    'T'::text AS tax_type

   FROM c_orderline

UNION

 SELECT lbr_icmsmatrix.ad_client_id,

    lbr_icmsmatrix.ad_org_id,

    lbr_icmsmatrix.created,

    lbr_icmsmatrix.createdby,

    lbr_icmsmatrix.updated,

    lbr_icmsmatrix.updatedby,

    lbr_icmsmatrix.lbr_icmsmatrix_id AS record_id,

    'LBR_ICMSMatrix'::text AS table_name,

    lbr_icmsmatrix.lbr_tax_id,

    'C'::text AS tax_type

   FROM lbr_icmsmatrix

UNION

 SELECT ad_orginfo.ad_client_id,

    ad_orginfo.ad_org_id,

    ad_orginfo.created,

    ad_orginfo.createdby,

    ad_orginfo.updated,

    ad_orginfo.updatedby,

    ad_orginfo.ad_org_id AS record_id,

    'AD_OrgInfo'::text AS table_name,

    ad_orginfo.lbr_tax_id,

    'C'::text AS tax_type

   FROM ad_orginfo

UNION

 SELECT c_invoiceline.ad_client_id,

    c_invoiceline.ad_org_id,

    c_invoiceline.created,

    c_invoiceline.createdby,

    c_invoiceline.updated,

    c_invoiceline.updatedby,

    c_invoiceline.c_invoiceline_id AS record_id,

    'C_InvoiceLine'::text AS table_name,

    c_invoiceline.lbr_tax_id,

    'T'::text AS tax_type

   FROM c_invoiceline

UNION

 SELECT m_rmaline.ad_client_id,

    m_rmaline.ad_org_id,

    m_rmaline.created,

    m_rmaline.createdby,

    m_rmaline.updated,

    m_rmaline.updatedby,

    m_rmaline.m_rmaline_id AS record_id,

    'M_RMALine'::text AS table_name,

    m_rmaline.lbr_tax_id,

    'T'::text AS tax_type

   FROM m_rmaline;