<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: gaoyang 
    $Date: 2014-12-9 下午04:33:42  
    $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_ITFC_V">
    <bm:fields>
        <bm:field name="tl_itfc_header_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TL_ITFC_HEADER_ID" prompt="YONDA_HLS_TL_ITFC_V.TL_ITFC_HEADER_ID"/>
        <bm:field name="trx_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRX_CODE" prompt="YONDA_HLS_TL_ITFC_V.TRX_CODE"/>
        <bm:field name="trx_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRX_STATUS" prompt="YONDA_HLS_TL_ITFC_V.TRX_STATUS"/>
        <bm:field name="version" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VERSION" prompt="YONDA_HLS_TL_ITFC_V.VERSION"/>
        <bm:field name="data_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DATA_TYPE" prompt="YONDA_HLS_TL_ITFC_V.DATA_TYPE"/>
        <bm:field name="tl_level" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TL_LEVEL" prompt="YONDA_HLS_TL_ITFC_V.TL_LEVEL"/>
        <bm:field name="req_sn" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REQ_SN" prompt="YONDA_HLS_TL_ITFC_V.REQ_SN"/>
        <bm:field name="signed_msg" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SIGNED_MSG" prompt="YONDA_HLS_TL_ITFC_V.SIGNED_MSG"/>
        <bm:field name="business_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSINESS_CODE" prompt="YONDA_HLS_TL_ITFC_V.BUSINESS_CODE"/>
        <bm:field name="merchant_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MERCHANT_ID" prompt="YONDA_HLS_TL_ITFC_V.MERCHANT_ID"/>
        <bm:field name="settday" databaseType="DATE" datatype="java.util.Date" physicalName="SETTDAY" prompt="YONDA_HLS_TL_ITFC_V.SETTDAY"/>
        <bm:field name="submit_time" databaseType="DATE" datatype="java.util.Date" physicalName="SUBMIT_TIME" prompt="YONDA_HLS_TL_ITFC_V.SUBMIT_TIME"/>
        <bm:field name="due_date" databaseType="DATE" datatype="java.util.Date" physicalName="DUE_DATE" prompt="YONDA_HLS_TL_ITFC_V.DUE_DATE"/>
        <bm:field name="total_item" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TOTAL_ITEM" prompt="YONDA_HLS_TL_ITFC_V.TOTAL_ITEM"/>
        <bm:field name="total_sum" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TOTAL_SUM" prompt="YONDA_HLS_TL_ITFC_V.TOTAL_SUM"/>
        <bm:field name="tl_itfc_line_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TL_ITFC_LINE_ID" prompt="YONDA_HLS_TL_ITFC_V.TL_ITFC_LINE_ID"/>
        <bm:field name="sn" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SN" prompt="YONDA_HLS_TL_ITFC_V.SN"/>
        <bm:field name="e_user_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="E_USER_CODE" prompt="YONDA_HLS_TL_ITFC_V.E_USER_CODE"/>
        <bm:field name="bank_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_CODE" prompt="YONDA_HLS_TL_ITFC_V.BANK_CODE"/>
        <bm:field name="account_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNT_TYPE" prompt="YONDA_HLS_TL_ITFC_V.ACCOUNT_TYPE"/>
        <bm:field name="account_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNT_NO" prompt="YONDA_HLS_TL_ITFC_V.ACCOUNT_NO"/>
        <bm:field name="account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNT_NAME" prompt="YONDA_HLS_TL_ITFC_V.ACCOUNT_NAME"/>
        <bm:field name="receipt_accout_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RECEIPT_ACCOUT_ID" prompt="YONDA_HLS_TL_ITFC_V.RECEIPT_ACCOUT_ID"/>
        <bm:field name="receipt_accout_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RECEIPT_ACCOUT_CODE" prompt="YONDA_HLS_TL_ITFC_V.RECEIPT_ACCOUT_CODE"/>
        <bm:field name="receipt_accout_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RECEIPT_ACCOUT_NO" prompt="YONDA_HLS_TL_ITFC_V.RECEIPT_ACCOUT_NO"/>
        <bm:field name="receipt_accout_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RECEIPT_ACCOUT_NAME" prompt="YONDA_HLS_TL_ITFC_V.RECEIPT_ACCOUT_NAME"/>
        <bm:field name="province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROVINCE" prompt="YONDA_HLS_TL_ITFC_V.PROVINCE"/>
        <bm:field name="city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CITY" prompt="YONDA_HLS_TL_ITFC_V.CITY"/>
        <bm:field name="bank_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_NAME" prompt="YONDA_HLS_TL_ITFC_V.BANK_NAME"/>
        <bm:field name="account_prop" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNT_PROP" prompt="YONDA_HLS_TL_ITFC_V.ACCOUNT_PROP"/>
        <bm:field name="amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="AMOUNT" prompt="YONDA_HLS_TL_ITFC_V.AMOUNT"/>
        <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="YONDA_HLS_TL_ITFC_V.CURRENCY"/>
        <bm:field name="protocol" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROTOCOL" prompt="YONDA_HLS_TL_ITFC_V.PROTOCOL"/>
        <bm:field name="protocol_userid" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROTOCOL_USERID" prompt="YONDA_HLS_TL_ITFC_V.PROTOCOL_USERID"/>
        <bm:field name="id_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_TYPE" prompt="YONDA_HLS_TL_ITFC_V.ID_TYPE"/>
        <bm:field name="id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID" prompt="YONDA_HLS_TL_ITFC_V.ID"/>
        <bm:field name="tel" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TEL" prompt="YONDA_HLS_TL_ITFC_V.TEL"/>
        <bm:field name="cust_userid" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CUST_USERID" prompt="YONDA_HLS_TL_ITFC_V.CUST_USERID"/>
        <bm:field name="settacct" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SETTACCT" prompt="YONDA_HLS_TL_ITFC_V.SETTACCT"/>
        <bm:field name="remark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REMARK" prompt="YONDA_HLS_TL_ITFC_V.REMARK"/>
        <bm:field name="settgroupflag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SETTGROUPFLAG" prompt="YONDA_HLS_TL_ITFC_V.SETTGROUPFLAG"/>
        <bm:field name="summary" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SUMMARY" prompt="YONDA_HLS_TL_ITFC_V.SUMMARY"/>
        <bm:field name="union_bank" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UNION_BANK" prompt="YONDA_HLS_TL_ITFC_V.UNION_BANK"/>
        <bm:field name="cashflow_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CASHFLOW_ID" prompt="YONDA_HLS_TL_ITFC_V.CASHFLOW_ID"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="YONDA_HLS_TL_ITFC_V.CONTRACT_ID"/>
        <bm:field name="csh_transaction_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CSH_TRANSACTION_ID" prompt="YONDA_HLS_TL_ITFC_V.CSH_TRANSACTION_ID"/>
        <bm:field name="line_trx_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LINE_TRX_STATUS" prompt="YONDA_HLS_TL_ITFC_V.LINE_TRX_STATUS"/>
        <bm:field name="fin_account_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIN_ACCOUNT_NO" prompt="YONDA_HLS_TL_ITFC_V.FIN_ACCOUNT_NO"/>
        <bm:field name="fin_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIN_ACCOUNT_NAME" prompt="YONDA_HLS_TL_ITFC_V.FIN_ACCOUNT_NAME"/>
        <bm:field name="fin_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="FIN_AMOUNT" prompt="YONDA_HLS_TL_ITFC_V.FIN_AMOUNT"/>
        <bm:field name="fintime" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FINTIME" prompt="YONDA_HLS_TL_ITFC_V.FINTIME"/>
        <bm:field name="ret_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RET_CODE" prompt="YONDA_HLS_TL_ITFC_V.RET_CODE"/>
        <bm:field name="write_off_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WRITE_OFF_FLAG" prompt="YONDA_HLS_TL_ITFC_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_ITFC_V.WRITE_OFF_FLAG_DESC"/>
        <bm:field name="cf_item" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CF_ITEM" prompt="YONDA_HLS_TL_ITFC_V.CF_ITEM"/>
        <bm:field name="cf_item_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CF_ITEM_DESC" prompt="YONDA_HLS_TL_ITFC_V.CF_ITEM_DESC"/>
        <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" prompt="YONDA_HLS_TL_ITFC_V.BP_ID"/>
        <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME" prompt="YONDA_HLS_TL_ITFC_V.BP_NAME"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER" prompt="YONDA_HLS_TL_ITFC_V.CONTRACT_NUMBER"/>
        <bm:field name="ebank_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EBANK_ID" prompt="YONDA_HLS_TL_ITFC_V.EBANK_ID"/>
        <bm:field name="ebank_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_TYPE" prompt="YONDA_HLS_TL_ITFC_V.EBANK_TYPE"/>
        <bm:field name="ebank_type_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_TYPE_DESC" prompt="YONDA_HLS_TL_ITFC_V.EBANK_TYPE_DESC"/>
        <bm:field name="ebank_account_prop" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_ACCOUNT_PROP" prompt="YONDA_HLS_TL_ITFC_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_ITFC_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_ITFC_V.EBANK_ACCOUNT_NAME"/>
        <bm:field name="ebank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_ACCOUNT_NUM" prompt="YONDA_HLS_TL_ITFC_V.EBANK_ACCOUNT_NUM"/>
        <bm:field name="ebank_protocol_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_PROTOCOL_STATUS" prompt="YONDA_HLS_TL_ITFC_V.EBANK_PROTOCOL_STATUS"/>
        <bm:field name="times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TIMES" prompt="YONDA_HLS_TL_ITFC_V.TIMES"/>
        <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="YONDA_HLS_TL_ITFC_V.COMPANY_ID"/>
        <bm:field name="company_short_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_SHORT_NAME" prompt="YONDA_HLS_TL_ITFC_V.COMPANY_SHORT_NAME"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:query-fields>
        <bm:query-field field="tl_itfc_header_id" queryOperator="="/>
        <bm:query-field field="trx_code" queryOperator="="/>
        <bm:query-field field="line_trx_status" queryOperator="="/>
        <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-field name="line_trx_status_end_flag" queryExpression="t1.line_trx_status in (&apos;FAILURE&apos;,&apos;COMPLETE&apos;)"/>
    </bm:query-fields>
    <bm:data-filters>
        <bm:data-filter enforceOperations="query" expression="t1.company_id=${/session/@company_id}"/>
    </bm:data-filters>
</bm:model>
