<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: gaoyang 
    $Date: 2015-1-2 下午05:37:46  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="YONDA_HLS_TL_CASHFLOW_V" defaultOrderBy="t1.contract_number,to_number(t1.times) asc">
    <bm:fields>
        <bm:field name="write_off_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WRITE_OFF_FLAG" prompt="YONDA_HLS_TL_CASHFLOW_V.WRITE_OFF_FLAG"/>
        <bm:field name="write_off_flag_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WRITE_OFF_FLAG_DESC" prompt="YONDA_HLS_TL_CASHFLOW_V.WRITE_OFF_FLAG_DESC"/>
        <bm:field name="cf_item" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CF_ITEM" prompt="YONDA_HLS_TL_CASHFLOW_V.CF_ITEM"/>
        <bm:field name="due_date" databaseType="DATE" datatype="java.util.Date" physicalName="DUE_DATE" prompt="YONDA_HLS_TL_CASHFLOW_V.DUE_DATE"/>
        <bm:field name="cf_item_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CF_ITEM_DESC" prompt="YONDA_HLS_TL_CASHFLOW_V.CF_ITEM_DESC"/>
        <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" prompt="YONDA_HLS_TL_CASHFLOW_V.BP_ID"/>
        <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME" prompt="YONDA_HLS_TL_CASHFLOW_V.BP_NAME"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER" prompt="YONDA_HLS_TL_CASHFLOW_V.CONTRACT_NUMBER"/>
        <bm:field name="ebank_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EBANK_ID" prompt="YONDA_HLS_TL_CASHFLOW_V.EBANK_ID"/>
        <bm:field name="ebank_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_TYPE" prompt="YONDA_HLS_TL_CASHFLOW_V.EBANK_TYPE"/>
        <bm:field name="ebank_type_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_TYPE_DESC" prompt="YONDA_HLS_TL_CASHFLOW_V.EBANK_TYPE_DESC"/>
        <bm:field name="ebank_account_prop" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_ACCOUNT_PROP" prompt="YONDA_HLS_TL_CASHFLOW_V.EBANK_ACCOUNT_PROP"/>
        <bm:field name="ebank_account_prop_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_ACCOUNT_PROP_DESC" prompt="YONDA_HLS_TL_CASHFLOW_V.EBANK_ACCOUNT_PROP_DESC"/>
        <bm:field name="ebank_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_ACCOUNT_NAME" prompt="YONDA_HLS_TL_CASHFLOW_V.EBANK_ACCOUNT_NAME"/>
        <bm:field name="ebank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_ACCOUNT_NUM" prompt="YONDA_HLS_TL_CASHFLOW_V.EBANK_ACCOUNT_NUM"/>
        <bm:field name="ebank_protocol_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_PROTOCOL_STATUS" prompt="YONDA_HLS_TL_CASHFLOW_V.EBANK_PROTOCOL_STATUS"/>
        <bm:field name="times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TIMES" prompt="YONDA_HLS_TL_CASHFLOW_V.TIMES"/>
        <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="YONDA_HLS_TL_CASHFLOW_V.COMPANY_ID"/>
        <bm:field name="company_short_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_SHORT_NAME" prompt="YONDA_HLS_TL_CASHFLOW_V.COMPANY_SHORT_NAME"/>
        <bm:field name="un_received_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="UN_RECEIVED_AMOUNT" prompt="YONDA_HLS_TL_CASHFLOW_V.UN_RECEIVED_AMOUNT"/>
        <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="YONDA_HLS_TL_CASHFLOW_V.CURRENCY"/>
        <bm:field name="currency_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY_NAME" prompt="YONDA_HLS_TL_CASHFLOW_V.CURRENCY_NAME"/>
        <bm:field name="cashflow_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CASHFLOW_ID" prompt="YONDA_HLS_TL_CASHFLOW_V.CASHFLOW_ID"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="YONDA_HLS_TL_CASHFLOW_V.CONTRACT_ID"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:query-fields>
        <bm:query-field field="write_off_flag" queryOperator="="/>
        <bm:query-field field="contract_number" queryOperator="like"/>
        <bm:query-field field="bp_name" queryOperator="like"/>
        <bm:query-field field="ebank_account_num" queryOperator="like"/>
    </bm:query-fields>
    <bm:data-filters>
        <bm:data-filter enforceOperations="query" expression="t1.company_id=${/session/@company_id}"/>
    </bm:data-filters>
</bm:model>
