<?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">
    <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: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-filters>
</bm:model>
