<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="CUS_DIVISION_COMPANY"> <bm:fields> <bm:field name="div_detail_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DIV_DETAIL_ID" prompt="CUS_DIVISION_COMPANY.DIV_DETAIL_ID"/> <bm:field name="division" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION" prompt="CUS_DIVISION_COMPANY.DIVISION"/> <bm:field name="position_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="POSITION_ID" prompt="CUS_DIVISION_COMPANY.POSITION_ID"/> <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="CUS_DIVISION_COMPANY.COMPANY_ID"/> </bm:fields> <bm:features> <o:sequence-pk/> <f:standard-who/> </bm:features> <bm:relations> <bm:relation name="position" joinType="left outer" refModel="exp.exp_org_position_vl"> <bm:reference foreignField="position_id" localField="position_id"/> </bm:relation> </bm:relations> <bm:ref-fields> <bm:ref-field name="position_code" relationName="position" sourceField="position_code"/> <bm:ref-field name="position_name" relationName="position" sourceField="description"/> </bm:ref-fields> <bm:primary-key> <bm:pk-field name="div_detail_id"/> </bm:primary-key> <bm:data-filters> <bm:data-filter enforceOperations="query" expression="t1.company_id=${/session/@company_id}"/> </bm:data-filters> <bm:query-fields> <bm:query-field field="division" queryOperator="="/> </bm:query-fields> </bm:model>