<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:ns2="leaf.database.local.oracle" xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="HLS_ACR_EBANK_OUTPUT_TEMP" defaultOrderBy="t1.ebank_tmp_id">
    <bm:fields>
        <bm:field name="ebank_tmp_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="EBANK_TMP_ID" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.EBANK_TMP_ID"/>
        <bm:field name="session_id" databaseType="NUMBER" datatype="java.lang.Double" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.SESSION_ID"/>
        <bm:field name="sequence_no" databaseType="NUMBER" datatype="java.lang.Double" physicalName="SEQUENCE_NO" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.SEQUENCE_NO"/>
        <bm:field name="bp_id_tenant" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BP_ID_TENANT" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.CUSTOMER_ID"/>
        <bm:field name="due_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.RECEIVABLE_AMOUNT"/>
        <bm:field name="limit_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LIMIT_AMOUNT" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.LIMIT_AMOUNT"/>
        <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.CUSTOMER_NAME"/>
        <bm:field name="dd_bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_ACCOUNT_NUM" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.CUSTOMER_ACCOUNT_NUMBER"/>
        <bm:field name="id_card_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_CARD_NO" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.IDENTITY_NO"/>
        <bm:field name="process_result" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROCESS_RESULT" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.PROCESS_RESULT"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER"/>
        <bm:field name="times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TIMES"/>
        <bm:field name="due_date" databaseType="DATE" datatype="java.lang.String" expression="to_char(due_date,&apos;yyyy-mm-dd&apos;)" physicalName="DUE_DATE"/>
        <bm:field name="pay_type" databaseType="VARCHAR2" datatype="java.lang.String" expression="&apos;7&apos;" physicalName="PAY_TYPE"/>
        <bm:field name="transaction_type" databaseType="VARCHAR2" datatype="java.lang.String" expression="&apos;1&apos;" physicalName="TRANSACTION_TYPE"/>
        <bm:field name="account_no" databaseType="VARCHAR2" datatype="java.lang.String" expression="&apos;03399500040009165&apos;" physicalName="ACCOUNT_NO"/>
        <bm:field name="account_name" databaseType="VARCHAR2" datatype="java.lang.String" expression="&apos;宏菱融资租赁（上海）有限公司&apos;" physicalName="ACCOUNT_NAME"/>
        <bm:field name="dd_bank_branch_name" databaseType="VARCHAR2" datatype="java.lang.String" expression="(select dd_bank_branch_name from con_contract t where t.data_class=&apos;NORMAL&apos; and t.dd_bank_account_num=t1.dd_bank_account_num and rownum=1)" physicalName="DD_BANK_BRANCH_NAME"/>
        <bm:field name="usage" databaseType="VARCHAR2" datatype="java.lang.String" expression="&apos;代收用途&apos;" physicalName="USAGE"/>
        <bm:field name="fen_code" databaseType="VARCHAR2" datatype="java.lang.String" expression="&apos;01&apos;" physicalName="FEN_CODE"/>
        <bm:field name="curr_flag" databaseType="VARCHAR2" datatype="java.lang.String" expression="&apos;0&apos;" physicalName="CURR_FLAG"/>
        <bm:field name="serial_no" databaseType="VARCHAR2" datatype="java.lang.String" expression="to_char(rownum,&apos;0000&apos;)" physicalName="SERIAL-NO"/>
        <bm:field name="mark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MARK" prompt="HLS_ACR_EBANK_OUTPUT_TEMP.MARK"/>
        <bm:field name="apply_amount"  databaseType="NUMBER" datatype="java.lang.Double" physicalName="APPLY_AMOUNT" ></bm:field>
        <bm:field name="due_amount_his"  databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT_HIS" ></bm:field>
        <bm:field name="division" databaseType="VARCHAR2" datatype="java.lang.String" expression="(select cc.division from con_contract cc where cc.data_class=&apos;NORMAL&apos; and cc.division!=&apos;95&apos; and cc.dd_bank_account_num=t1.dd_bank_account_num and rownum=1)"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
        <f:multi-language-storage/>
        <ns2:sequence-pk/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="ebank_tmp_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field field="session_id" queryOperator="="/>
        <bm:query-field field="times" queryOperator="="/>
    </bm:query-fields>
    <bm:order-by>
        <bm:field name="sequence_no"/>
    </bm:order-by>
    <bm:data-filters>
        <bm:data-filter enforceOperations="query" expression="t1.due_amount&gt;0"/>
        <bm:data-filter enforceOperations="query" expression="t1.session_id=${/session/@session_id}"/>
        <bm:data-filter enforceOperations="query" expression="t1.output_id=${@output_id}"/>
    </bm:data-filters>
    <bm:operations>
        <bm:operation name="update">
            <bm:update-sql><![CDATA[
             begin
                hls_acr_ebanking_new_pkg.update_ebank_output_temp(
                                                  p_ebank_tmp_id => ${@ebank_tmp_id},
                                                  p_due_amount   => ${@due_amount},
                                                  p_apply_amount => ${@apply_amount},
                                                  p_mark         => ${@mark},
                                                  p_user_id      => ${/session/@user_id});
             end;
            ]]></bm:update-sql>
        </bm:operation>
        <bm:operation name="execute">
            <bm:update-sql><![CDATA[
               begin
                hls_acr_ebanking_new_pkg.abc_adjust_amount_wfl_start(
                p_output_id =>${@output_id} ,
                p_user_id   =>${/session/@user_id} );
               end;
                ]]></bm:update-sql>
        </bm:operation>
    </bm:operations>
</bm:model>
