<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[SELECT l.direct_debit_bank_id,
       l.direct_debit_bank_id_n,
       l.withhold_way,
       l.withhold_way_n,
       l.ebank_city,
       l.ebank_city_n,
       l.ebank_province,
       l.ebank_province_n,
       l.dd_remark,
       l.dd_bank_branch_name,
       l.bp_id_tenant,
       l.bp_id_tenant_n,
       c.cell_phone,
       l.contract_id
  FROM con_contract_lv l,
       con_contract_bp c
 WHERE l.contract_id = c.contract_id and l.contract_id=${@contract_id}]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="direct_debit_bank_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DIRECT_DEBIT_BANK_ID"/>
        <bm:field name="direct_debit_bank_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIRECT_DEBIT_BANK_ID_N"/>
        <bm:field name="withhold_way" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITHHOLD_WAY"/>
        <bm:field name="withhold_way_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITHHOLD_WAY_N"/>
        <bm:field name="ebank_city" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EBANK_CITY"/>
        <bm:field name="ebank_city_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_CITY_N"/>
        <bm:field name="ebank_province" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EBANK_PROVINCE"/>
        <bm:field name="ebank_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_PROVINCE_N"/>
        <bm:field name="dd_remark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_REMARK"/>
        <bm:field name="dd_bank_branch_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_BRANCH_NAME"/>
        <bm:field name="bp_id_tenant" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_TENANT"/>
        <bm:field name="bp_id_tenant_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_TENANT_N"/>
        <bm:field name="cell_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CELL_PHONE"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" required="true"/>
    </bm:fields>
</bm:model>
