<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
              select distinct
              t.bp_id    code,
             t.bp_name  code_name,
            
             to_char(t.founded_date,'yyyy-mm-dd') founded_date,
             t.registered_capital,
             t.tax_registry_num,
           
             t.work_unit_phone,
           
           
             t.business_license_num
        from hls_bp_master t, hls_bp_master_role_lv ro
         where ro.bp_type = 'GUTA_ORG'
          and  t.bp_id(+) = ro.bp_id
         and   t.bp_class = 'ORG'
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CODE" required="true"/>
        <bm:field name="code_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NAME"/>
        <bm:field name="founded_date"/>
        <bm:field name="registered_capital"/>
        <bm:field name="work_unit_phone"/>
        <bm:field name="business_license_num"/>
        <bm:field name="tax_registry_num"/>
    </bm:fields>
</bm:model>
