<?xml version="1.0" encoding="UTF-8"?><!-- $Author: LR $Date: 2014-4-8 下午02:46:50 $Revision: 1.0 $Purpose: --><bm:modelxmlns:o="leaf.database.local.oracle"xmlns:bm="http://www.leaf-framework.org/schema/bm"xmlns:f="leaf.database.features"alias="t1"baseTable="RSC_CONTRACT_COLLECTION"><bm:fields><bm:fieldname="collection_id"databaseType="NUMBER"datatype="java.lang.Long"physicalName="COLLECTION_ID"prompt="RSC_CONTRACT_COLLECTION.COLLECTION_ID"/><bm:fieldname="contract_id"databaseType="NUMBER"datatype="java.lang.Long"physicalName="CONTRACT_ID"prompt="RSC_CONTRACT_COLLECTION.CONTRACT_ID"/><bm:fieldname="bp_id"databaseType="NUMBER"datatype="java.lang.Long"physicalName="BP_ID"prompt="RSC_CONTRACT_COLLECTION.BP_ID"/><bm:fieldname="bp_name"expression="(select hbm.bp_name from hls_bp_master hbm where hbm.bp_id=t1.bp_id)"forInsert="fasle"forUpdate="false"/><bm:fieldname="owner_user_id"databaseType="NUMBER"datatype="java.lang.Long"physicalName="OWNER_USER_ID"prompt="RSC_CONTRACT_COLLECTION.OWNER_USER_ID"/><bm:fieldname="overdue_amount"databaseType="NUMBER"datatype="java.lang.Double"physicalName="OVERDUE_AMOUNT"prompt="RSC_CONTRACT_COLLECTION.OVERDUE_AMOUNT"/><bm:fieldname="collector_user_id"databaseType="NUMBER"datatype="java.lang.Long"physicalName="COLLECTOR_USER_ID"prompt="RSC_CONTRACT_COLLECTION.COLLECTOR_USER_ID"/><bm:fieldname="collector_user_name"expression="(select su.description from sys_user su where su.user_id=t1.collector_user_id)"forInsert="fasle"forUpdate="false"/><bm:fieldname="org_unit_id"databaseType="NUMBER"datatype="java.lang.Long"physicalName="ORG_UNIT_ID"prompt="RSC_CONTRACT_COLLECTION.ORG_UNIT_ID"/><bm:fieldname="org_unit_desc"expression="(select eou.unit_name from exp_org_unit_v eou where eou.unit_id=t1.org_unit_id)"forInsert="fasle"forUpdate="false"/><bm:fieldname="collection_date"databaseType="VARCHAR2"datatype="java.lang.String"expression="(to_char(t1.collection_date,'YYYY-MM-DD'))"insertExpression="to_date(${@collection_date},'YYYY-MM-DD')"physicalName="COLLECTION_DATE"prompt="RSC_CONTRACT_COLLECTION.COLLECTION_DATE"updateExpression="to_date(${@collection_date},'YYYY-MM-DD')"/><bm:fieldname="collection_method"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="COLLECTION_METHOD"prompt="RSC_CONTRACT_COLLECTION.COLLECTION_METHOD"/><bm:fieldname="collection_method_desc"expression="(select sc.code_value_name from sys_code_values_v sc where sc.code = 'RSC_COLLECTION_METHOD' and sc.code_value = t1.collection_method)"forInsert="fasle"forUpdate="false"/><bm:fieldname="collection_result"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="COLLECTION_RESULT"prompt="RSC_CONTRACT_COLLECTION.COLLECTION_RESULT"/><bm:fieldname="follow_up"databaseType="VARCHAR2"datatype="java.lang.String"physicalName="FOLLOW_UP"prompt="RSC_CONTRACT_COLLECTION.FOLLOW_UP"/></bm:fields><bm:features><o:sequence-pk/><f:standard-who/></bm:features><bm:primary-key><bm:pk-fieldname="collection_id"/></bm:primary-key><bm:query-fields><bm:query-fieldname="bp_id"queryExpression="t1.bp_id=${@bp_id}"/><bm:query-fieldname="contract_id"queryExpression="t1.contract_id=${@contract_id}"/><bm:query-fieldname="bp_name"queryExpression="exists(select 1 from hls_bp_master hbm where hbm.bp_id=t1.bp_id and hbm.bp_name like ${@bp_name})"/></bm:query-fields></bm:model>