<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="HLS_BP_MASTER">
<bm:fields>
<bm:field name="bp_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_CATEGORY" prompt="HLS_BP_MASTER.BP_CATEGORY"/>
<bm:field name="bp_category_n" expression="(select bc.description from hls_bp_category bc where bc.bp_category = t1.bp_category)" forInsert="false" forUpdate="false"/>
<bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" prompt="HLS_BP_MASTER.BP_ID"/>
<bm:field name="bp_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_CODE" prompt="HLS_BP_MASTER.BP_CODE"/>
<bm:field name="bp_class" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_CLASS" prompt="HLS_BP_MASTER.BP_CLASS"/>
<bm:field name="bp_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_TYPE" prompt="HLS_BP_MASTER.BP_TYPE"/>
<bm:field name="bp_class_n" expression="(SELECT v.code_value_name FROM sys_code_values_v v WHERE v.code = 'HLS211_BP_CLASS' AND v.code_enabled_flag = 'Y' AND v.code_value_enabled_flag = 'Y' AND v.code_value = t1.bp_class)" forInsert="false" forUpdate="false"/>
<bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME" prompt="HLS_BP_MASTER.BP_NAME"/>
<bm:field name="kingdee_bp_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="KINGDEE_BP_CODE" prompt="HLS_BP_MASTER.KINGDEE_BP_CODE"/>
</bm:fields>
<bm:features>
<f:standard-who/>
</bm:features>
<bm:primary-key>
<bm:pk-field name="bp_id"/>
</bm:primary-key>
<bm:query-fields>
<bm:query-field field="bp_name" queryExpression="t1.bp_name like ${@bp_name}"/>
<bm:query-field field="bp_code" queryExpression="t1.bp_code like upper('%'||${@bp_code}||'%')"/>
<bm:query-field field="bp_category" queryExpression="t1.bp_category like ${@bp_category}"/>
<bm:query-field field="bp_class" queryExpression="t1.bp_class like ${@bp_class}"/>
</bm:query-fields>
<bm:data-filters>
<!-- <bm:data-filter enforceOperations="query" expression=" exists (SELECT 1 FROM con_contract cc WHERE cc.bp_id_tenant = t1.bp_id) "/> -->
<!-- <bm:data-filter enforceOperations="query" expression="t1.bp_type = 'TENANT'"/> --><![CDATA[
]]></bm:data-filters>
</bm:model>
-
Spencer Chang authoredbfd31bca