<?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="CUS_RPT_CUS350_O" defaultOrderBy="t1.search_term_1,t1.times">
    <bm:fields>
        <bm:field name="record_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RECORD_TYPE" prompt="CUS_RPT_CUS350_O.RECORD_TYPE"/>
        <bm:field name="period_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PERIOD_NAME" prompt="CUS_RPT_CUS350_O.PERIOD_NAME"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="CUS_RPT_CUS350_O.CONTRACT_ID"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER" prompt="CUS_RPT_CUS350_O.CONTRACT_NUMBER"/>
        <bm:field name="search_term_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEARCH_TERM_1" prompt="CUS_RPT_CUS350_O.SEARCH_TERM_1"/>
        <bm:field name="document_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_CATEGORY" prompt="CUS_RPT_CUS350_O.DOCUMENT_CATEGORY"/>
        <bm:field name="document_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_TYPE" prompt="CUS_RPT_CUS350_O.DOCUMENT_TYPE"/>
        <bm:field name="document_type_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_TYPE_N" prompt="CUS_RPT_CUS350_O.DOCUMENT_TYPE_N"/>
        <bm:field name="document_type_acc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_TYPE_ACC" prompt="CUS_RPT_CUS350_O.DOCUMENT_TYPE_ACC"/>
        <bm:field name="business_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSINESS_TYPE" prompt="CUS_RPT_CUS350_O.BUSINESS_TYPE"/>
        <bm:field name="bp_id_tenant" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_TENANT" prompt="CUS_RPT_CUS350_O.BP_ID_TENANT"/>
        <bm:field name="bp_id_tenant_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_TENANT_N" prompt="CUS_RPT_CUS350_O.BP_ID_TENANT_N"/>
        <bm:field name="inception_of_lease" databaseType="DATE" datatype="java.util.Date" physicalName="INCEPTION_OF_LEASE" prompt="CUS_RPT_CUS350_O.INCEPTION_OF_LEASE"/>
        <bm:field name="times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TIMES" prompt="CUS_RPT_CUS350_O.TIMES"/>
        <bm:field name="due_date" databaseType="DATE" datatype="java.util.Date" physicalName="DUE_DATE" prompt="CUS_RPT_CUS350_O.DUE_DATE"/>
        <bm:field name="due_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT" prompt="CUS_RPT_CUS350_O.DUE_AMOUNT"/>
        <bm:field name="principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL" prompt="CUS_RPT_CUS350_O.PRINCIPAL"/>
        <bm:field name="interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST" prompt="CUS_RPT_CUS350_O.INTEREST"/>
        <bm:field name="cashflow_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CASHFLOW_ID" prompt="CUS_RPT_CUS350_O.CASHFLOW_ID"/>
        <bm:field name="control_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTROL_ID" prompt="CUS_RPT_CUS350_O.CONTROL_ID"/>
        <bm:field name="transaction_date" databaseType="DATE" datatype="java.util.Date"/>
        <bm:field name="company_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_ID_N" prompt="CUS_RPT_CUS350_O.COMPANY_ID_N"/>
        <bm:field name="division" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION" prompt="CUS_RPT_CUS350_O.DIVISION"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:data-filters>
        <bm:data-filter name="init" enforceOperations="query" expression="t1.control_id=${@control_id}"/>
    </bm:data-filters>
    <bm:query-fields>
        <bm:query-field name="transaction_date_from" queryExpression="t1.transaction_date &gt;= to_date(${@transaction_date_from},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field name="transaction_date_to" queryExpression="t1.transaction_date &lt;= to_date(${@transaction_date_to},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field field="record_type" queryOperator="like"/>
    </bm:query-fields>
</bm:model>
