<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: chenlingfeng  
    $Date: 2017-7-25 下午5:45:56  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="SDIC_OTHER_CONTRACT">
    <bm:fields>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="SDIC_OTHER_CONTRACT.CONTRACT_ID"/>
        <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="SDIC_OTHER_CONTRACT.COMPANY_ID"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="CONTRACT_NUMBER" prompt="合同编号"/>
        <bm:field name="contract_name" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="CONTRACT_NAME" prompt="合同名称"/>
        <bm:field name="document_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_CATEGORY" prompt="SDIC_OTHER_CONTRACT.DOCUMENT_CATEGORY"/>
        <bm:field name="document_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_TYPE" prompt="SDIC_OTHER_CONTRACT.DOCUMENT_TYPE"/>
        <bm:field name="con_bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CON_BP_ID" prompt="SDIC_OTHER_CONTRACT.CON_BP_ID"/>
        <bm:field name="lease_terms" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_TERMS" prompt="SDIC_OTHER_CONTRACT.LEASE_TERMS"/>
        <bm:field name="contract_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_AMOUNT" prompt="SDIC_OTHER_CONTRACT.CONTRACT_AMOUNT"/>
        <bm:field name="contract_start_date" databaseType="DATE" datatype="java.util.Date" physicalName="CONTRACT_START_DATE" prompt="SDIC_OTHER_CONTRACT.CONTRACT_START_DATE"/>
        <bm:field name="contract_end_date" databaseType="DATE" datatype="java.util.Date" physicalName="CONTRACT_END_DATE" prompt="SDIC_OTHER_CONTRACT.CONTRACT_END_DATE"/>
        <bm:field name="owner_user_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OWNER_USER_ID" prompt="SDIC_OTHER_CONTRACT.OWNER_USER_ID"/>
        <bm:field name="employee_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EMPLOYEE_ID" prompt="SDIC_OTHER_CONTRACT.EMPLOYEE_ID"/>
        <bm:field name="employee_id_of_manager" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EMPLOYEE_ID_OF_MANAGER" prompt="SDIC_OTHER_CONTRACT.EMPLOYEE_ID_OF_MANAGER"/>
        <bm:field name="instance_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INSTANCE_ID" prompt="SDIC_OTHER_CONTRACT.INSTANCE_ID"/>
        <bm:field name="wfl_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WFL_STATUS" prompt="SDIC_OTHER_CONTRACT.WFL_STATUS"/>
        <bm:field name="contract_source" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_SOURCE" prompt="SDIC_OTHER_CONTRACT.CONTRACT_SOURCE"/>
        <bm:field name="financing_purpose" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FINANCING_PURPOSE" prompt="SDIC_OTHER_CONTRACT.FINANCING_PURPOSE"/>
        <bm:field name="tarde_plan_note" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TARDE_PLAN_NOTE" prompt="SDIC_OTHER_CONTRACT.TARDE_PLAN_NOTE"/>
        <bm:field name="descriptions" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTIONS" prompt="SDIC_OTHER_CONTRACT.DESCRIPTIONS"/>
        <bm:field name="unit_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="UNIT_ID" prompt="SDIC_OTHER_CONTRACT.UNIT_ID"/>
        <bm:field name="is_group_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="IS_GROUP_FLAG" prompt="SDIC_OTHER_CONTRACT.IS_GROUP_FLAG"/>
        <bm:field name="cdd_list_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CDD_LIST_ID" prompt="SDIC_OTHER_CONTRACT.CDD_LIST_ID"/>
        <bm:field name="closed_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CLOSED_FLAG" prompt="SDIC_OTHER_CONTRACT.CLOSED_FLAG"/>
        <bm:field name="base_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BASE_RATE_TYPE" prompt="SDIC_OTHER_CONTRACT.BASE_RATE_TYPE"/>
        <bm:field name="base_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BASE_RATE" prompt="SDIC_OTHER_CONTRACT.BASE_RATE"/>
        <bm:field name="int_rate_fixing_way" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INT_RATE_FIXING_WAY" prompt="SDIC_OTHER_CONTRACT.INT_RATE_FIXING_WAY"/>
        <bm:field name="int_rate_fixing_range" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INT_RATE_FIXING_RANGE" prompt="SDIC_OTHER_CONTRACT.INT_RATE_FIXING_RANGE"/>
        <bm:field name="interest_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INTEREST_PERIOD" prompt="SDIC_OTHER_CONTRACT.INTEREST_PERIOD"/>
        <bm:field name="adjust_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADJUST_RATE_TYPE" prompt="SDIC_OTHER_CONTRACT.ADJUST_RATE_TYPE"/>
        <bm:field name="lease_charge" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_CHARGE" prompt="SDIC_OTHER_CONTRACT.LEASE_CHARGE"/>
        <bm:field name="other_fee" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OTHER_FEE" prompt="SDIC_OTHER_CONTRACT.OTHER_FEE"/>
        <bm:field name="assignee" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ASSIGNEE" prompt="SDIC_OTHER_CONTRACT.ASSIGNEE"/>
        <bm:field name="loan_con_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOAN_CON_TYPE" prompt="SDIC_OTHER_CONTRACT.LOAN_CON_TYPE"/>
        <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="SDIC_OTHER_CONTRACT.CURRENCY"/>
        <bm:field name="bank_account_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BANK_ACCOUNT_ID" prompt="SDIC_OTHER_CONTRACT.BANK_ACCOUNT_ID"/>
        <bm:field name="int_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INT_RATE" prompt="SDIC_OTHER_CONTRACT.INT_RATE"/>
        <bm:field name="data_class" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DATA_CLASS" prompt="SDIC_OTHER_CONTRACT.DATA_CLASS"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="contract_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field name="contract_number" queryExpression="t1.contract_number like ${@contract_number}"/>
        <bm:query-field name="contract_name" queryExpression="t1.contract_name like &apos;%&apos;||${@contract_name}||&apos;%&apos;"/>
        <bm:query-field name="wfl_status" queryExpression="t1.wfl_status = ${@wfl_status}"/>
    </bm:query-fields>
    <bm:data-filters>
        <bm:data-filter name="data_class" expression="t1.data_class = &apos;NORMAL&apos;"/>
    </bm:data-filters>
</bm:model>
