<?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_PSR3060_O">
    <bm:fields>
        <bm:field name="record_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RECORD_ID" prompt="CUS_RPT_PSR3060_O.RECORD_ID"/>
        <bm:field name="control_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTROL_ID" prompt="CUS_RPT_PSR3060_O.CONTROL_ID"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER" prompt="CUS_RPT_PSR3060_O.CONTRACT_NUMBER"/>
        <bm:field name="search_term_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEARCH_TERM_1" prompt="CUS_RPT_PSR3060_O.SEARCH_TERM_1"/>
        <bm:field name="bp_id_tenant" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_TENANT" prompt="CUS_RPT_PSR3060_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_PSR3060_O.BP_ID_TENANT_N"/>
        <bm:field name="division_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION_N" prompt="CUS_RPT_PSR3060_O.DIVISION_N"/>
        <bm:field name="brand_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BRAND_ID" prompt="CUS_RPT_PSR3060_O.BRAND_ID"/>
        <bm:field name="brand_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BRAND_ID_N" prompt="CUS_RPT_PSR3060_O.BRAND_ID_N"/>
        <bm:field name="license_plate_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LICENSE_PLATE_NUMBER" prompt="CUS_RPT_PSR3060_O.LICENSE_PLATE_NUMBER"/>
        <bm:field name="aircraft_category_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AIRCRAFT_CATEGORY_N" prompt="CUS_RPT_PSR3060_O.AIRCRAFT_CATEGORY_N"/>
        <bm:field name="serial_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SERIAL_NUMBER" prompt="CUS_RPT_PSR3060_O.SERIAL_NUMBER"/>
        <bm:field name="valid_to" databaseType="DATE" datatype="java.util.Date" physicalName="VALID_TO" prompt="CUS_RPT_PSR3060_O.VALID_TO"/>
        <bm:field name="quantity" databaseType="NUMBER" datatype="java.lang.Long" physicalName="QUANTITY" prompt="CUS_RPT_PSR3060_O.QUANTITY"/>
        <bm:field name="employee_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMPLOYEE_ID" prompt="CUS_RPT_PSR3060_O.EMPLOYEE_ID"/>
        <bm:field name="employee_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMPLOYEE_ID_N" prompt="CUS_RPT_PSR3060_O.EMPLOYEE_ID_N"/>
        <bm:field name="collector_user_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COLLECTOR_USER_ID" prompt="CUS_RPT_PSR3060_O.COLLECTOR_USER_ID"/>
        <bm:field name="collector_user_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COLLECTOR_USER_ID_N" prompt="CUS_RPT_PSR3060_O.COLLECTOR_USER_ID_N"/>
        <bm:field name="lease_start_date" databaseType="DATE" datatype="java.util.Date" physicalName="LEASE_START_DATE" prompt="CUS_RPT_PSR3060_O.LEASE_START_DATE"/>
        <bm:field name="month_due_date" databaseType="DATE" datatype="java.util.Date" physicalName="MONTH_DUE_DATE" prompt="CUS_RPT_PSR3060_O.MONTH_DUE_DATE"/>
        <bm:field name="max_due_date" databaseType="DATE" datatype="java.util.Date" physicalName="MAX_DUE_DATE" prompt="CUS_RPT_PSR3060_O.MAX_DUE_DATE"/>
        <bm:field name="times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TIMES" prompt="CUS_RPT_PSR3060_O.TIMES"/>
        <bm:field name="overdue_times" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_TIMES" prompt="CUS_RPT_PSR3060_O.OVERDUE_TIMES"/>
        <bm:field name="overdue_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_AMOUNT" prompt="CUS_RPT_PSR3060_O.OVERDUE_AMOUNT"/>
        <bm:field name="overdue_amount_1_30" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_AMOUNT_1_30" prompt="CUS_RPT_PSR3060_O.OVERDUE_AMOUNT_1_30"/>
        <bm:field name="overdue_amount_31_60" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_AMOUNT_31_60" prompt="CUS_RPT_PSR3060_O.OVERDUE_AMOUNT_31_60"/>
        <bm:field name="overdue_amount_61_90" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_AMOUNT_61_90" prompt="CUS_RPT_PSR3060_O.OVERDUE_AMOUNT_61_90"/>
        <bm:field name="overdue_amount_91_120" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_AMOUNT_91_120" prompt="CUS_RPT_PSR3060_O.OVERDUE_AMOUNT_91_120"/>
        <bm:field name="overdue_amount_121_360" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_AMOUNT_121_360" prompt="CUS_RPT_PSR3060_O.OVERDUE_AMOUNT_121_360"/>
        <bm:field name="overdue_amount_360" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_AMOUNT_360" prompt="CUS_RPT_PSR3060_O.OVERDUE_AMOUNT_360"/>
        <bm:field name="last_received_date" databaseType="DATE" datatype="java.util.Date" physicalName="LAST_RECEIVED_DATE" prompt="CUS_RPT_PSR3060_O.LAST_RECEIVED_DATE"/>
        <bm:field name="promised_repay_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PROMISED_REPAY_AMOUNT" prompt="CUS_RPT_PSR3060_O.PROMISED_REPAY_AMOUNT"/>
        <bm:field name="month_received_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="MONTH_RECEIVED_AMOUNT" prompt="CUS_RPT_PSR3060_O.MONTH_RECEIVED_AMOUNT"/>
        <bm:field name="npa" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NPA" prompt="CUS_RPT_PSR3060_O.NPA"/>
        <bm:field name="unreceived_principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="UNRECEIVED_PRINCIPAL" prompt="CUS_RPT_PSR3060_O.UNRECEIVED_PRINCIPAL"/>
        <bm:field name="overdue_interest_4" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_INTEREST_4" prompt="CUS_RPT_PSR3060_O.OVERDUE_INTEREST_4"/>
        <bm:field name="deposit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DEPOSIT" prompt="CUS_RPT_PSR3060_O.DEPOSIT"/>
        <bm:field name="thrid_party_deposit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="THRID_PARTY_DEPOSIT" prompt="CUS_RPT_PSR3060_O.THRID_PARTY_DEPOSIT"/>
        <bm:field name="gps_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GPS_FLAG" prompt="CUS_RPT_PSR3060_O.GPS_FLAG"/>
        <bm:field name="lock_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOCK_FLAG" prompt="CUS_RPT_PSR3060_O.LOCK_FLAG"/>
        <bm:field name="bp_id_vender" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_VENDER" prompt="CUS_RPT_PSR3060_O.BP_ID_VENDER"/>
        <bm:field name="tenant_contract_person_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TENANT_CONTRACT_PERSON_1" prompt="CUS_RPT_PSR3060_O.TENANT_CONTRACT_PERSON_1"/>
        <bm:field name="tenant_cell_phone_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TENANT_CELL_PHONE_1" prompt="CUS_RPT_PSR3060_O.TENANT_CELL_PHONE_1"/>
        <bm:field name="tenant_contract_person_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TENANT_CONTRACT_PERSON_2" prompt="CUS_RPT_PSR3060_O.TENANT_CONTRACT_PERSON_2"/>
        <bm:field name="tenant_cell_phone_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TENANT_CELL_PHONE_2" prompt="CUS_RPT_PSR3060_O.TENANT_CELL_PHONE_2"/>
        <bm:field name="tenant_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TENANT_ADDRESS" prompt="CUS_RPT_PSR3060_O.TENANT_ADDRESS"/>
        <bm:field name="guarantee_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_1" prompt="CUS_RPT_PSR3060_O.GUARANTEE_1"/>
        <bm:field name="guarantee_cell_phone_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_CELL_PHONE_1" prompt="CUS_RPT_PSR3060_O.GUARANTEE_CELL_PHONE_1"/>
        <bm:field name="guarantee_address_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_ADDRESS_1" prompt="CUS_RPT_PSR3060_O.GUARANTEE_ADDRESS_1"/>
        <bm:field name="guarantee_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_2" prompt="CUS_RPT_PSR3060_O.GUARANTEE_2"/>
        <bm:field name="guarantee_cell_phone_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_CELL_PHONE_2" prompt="CUS_RPT_PSR3060_O.GUARANTEE_CELL_PHONE_2"/>
        <bm:field name="guarantee_address_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_ADDRESS_2" prompt="CUS_RPT_PSR3060_O.GUARANTEE_ADDRESS_2"/>
        <bm:field name="guarantee_3" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_3" prompt="CUS_RPT_PSR3060_O.GUARANTEE_3"/>
        <bm:field name="guarantee_cell_phone_3" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_CELL_PHONE_3" prompt="CUS_RPT_PSR3060_O.GUARANTEE_CELL_PHONE_3"/>
        <bm:field name="guarantee_address_3" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_ADDRESS_3" prompt="CUS_RPT_PSR3060_O.GUARANTEE_ADDRESS_3"/>
        <bm:field name="guarantee_4" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_4" prompt="CUS_RPT_PSR3060_O.GUARANTEE_4"/>
        <bm:field name="guarantee_cell_phone_4" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_CELL_PHONE_4" prompt="CUS_RPT_PSR3060_O.GUARANTEE_CELL_PHONE_4"/>
        <bm:field name="guarantee_address_4" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GUARANTEE_ADDRESS_4" prompt="CUS_RPT_PSR3060_O.GUARANTEE_ADDRESS_4"/>
        <bm:field name="vender_contract_person" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VENDER_CONTRACT_PERSON" prompt="CUS_RPT_PSR3060_O.VENDER_CONTRACT_PERSON"/>
        <bm:field name="vender_ceel_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VENDER_CEEL_PHONE" prompt="CUS_RPT_PSR3060_O.VENDER_CEEL_PHONE"/>
        <bm:field name="vender_email" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VENDER_EMAIL" prompt="CUS_RPT_PSR3060_O.VENDER_EMAIL"/>
        <bm:field name="bp_id_control" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_CONTROL" prompt="CUS_RPT_PSR3060_O.BP_ID_CONTROL"/>
        <bm:field name="city_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CITY_ID" prompt="CUS_RPT_PSR3060_O.CITY_ID"/>
        <bm:field name="city_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CITY_ID_N" prompt="CUS_RPT_PSR3060_O.CITY_ID_N"/>
        <bm:field name="province_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROVINCE_ID" prompt="CUS_RPT_PSR3060_O.PROVINCE_ID"/>
        <bm:field name="province_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROVINCE_ID_N" prompt="CUS_RPT_PSR3060_O.PROVINCE_ID_N"/>
        <bm:field name="contract_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_STATUS" prompt="CUS_RPT_PSR3060_O.CONTRACT_STATUS"/>
        <bm:field name="legal_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEGAL_STATUS" prompt="CUS_RPT_PSR3060_O.LEGAL_STATUS"/>
        <bm:field name="penalty" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PENALTY" prompt="CUS_RPT_PSR3060_O.PENALTY"/>
        <bm:field name="legal_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEGAL_FEE" prompt="CUS_RPT_PSR3060_O.LEGAL_FEE"/>
        <bm:field name="external_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="EXTERNAL_FEE" prompt="CUS_RPT_PSR3060_O.EXTERNAL_FEE"/>
        <bm:field name="company_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_ID" prompt="CUS_RPT_PSR3060_O.COMPANY_ID"/>
        <bm:field name="company_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_ID_N" prompt="CUS_RPT_PSR3060_O.COMPANY_ID_N"/>
        <bm:field name="division" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DIVISION" prompt="CUS_RPT_PSR3060_O.DIVISION"/>
        <bm:field name="contract_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_STATUS_N" prompt="CUS_RPT_PSR3060_O.CONTRACT_STATUS_N"/>
        <bm:field name="legal_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEGAL_STATUS_N" prompt="CUS_RPT_PSR3060_O.LEGAL_STATUS_N"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="CONTRACT_ID" prompt="CUS_RPT_PSR3060_O.CONTRACT_ID"/>
        <bm:field name="lease_item_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_ITEM_AMOUNT" prompt="CUS_RPT_PSR3060_O.LEASE_ITEM_AMOUNT"/>
        <bm:field name="total_rental" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TOTAL_RENTAL" prompt="CUS_RPT_PSR3060_O.TOTAL_RENTAL"/>
        <bm:field name="received_rental" databaseType="NUMBER" datatype="java.lang.Double" physicalName="RECEIVED_RENTAL" prompt="CUS_RPT_PSR3060_O.RECEIVED_RENTAL"/>
        <bm:field name="unreceived_rental" databaseType="NUMBER" datatype="java.lang.Double" physicalName="UNRECEIVED_RENTAL" prompt="CUS_RPT_PSR3060_O.UNRECEIVED_RENTAL"/>
        <bm:field name="province_id_tenant_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROVINCE_ID_TENANT_N" prompt="CUS_RPT_PSR3060_O.PROVINCE_ID_TENANT_N"/>
        <bm:field name="city_id_tenant_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CITY_ID_TENANT_N" prompt="CUS_RPT_PSR3060_O.CITY_ID_TENANT_N"/>
        <bm:field name="bp_id_vender_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_ID_VENDER_N" prompt="CUS_RPT_PSR3060_O.BP_ID_VENDER_N"/>
        <bm:field name="lawsuit_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAWSUIT_STATUS" prompt="CUS_RPT_PSR3060_O.LAWSUIT_STATUS"/>
        <bm:field name="due_amount_current_month" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT_CURRENT_MONTH" prompt="CUS_RPT_PSR3060_O.DUE_AMOUNT_CURRENT_MONTH"/>
        <bm:field name="business_type_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSINESS_TYPE_N" prompt="CUS_RPT_PSR3060_O.BUSINESS_TYPE_N"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="record_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field field="contract_number" queryOperator="like"/>
        <bm:query-field field="division_n" queryOperator="like"/>
        <bm:query-field field="province_id_n" queryOperator="like"/>
        <bm:query-field field="contract_status_n" queryOperator="like"/>
        <bm:query-field field="legal_status" queryOperator="like"/>
        <bm:query-field field="employee_id_n" queryOperator="like"/>
        <bm:query-field field="collector_user_id_n" queryOperator="like"/>
        <bm:query-field field="bp_id_control" queryOperator="like"/>
        <bm:query-field name="times_from" queryExpression="t1.times &gt;= ${@times_from}"/>
        <bm:query-field name="times_to" queryExpression="t1.times &lt;= ${@times_to}"/>
        <bm:query-field name="lease_start_date_from" queryExpression="t1.lease_start_date &gt;= to_date(${@lease_start_date_from},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field name="lease_start_date_to" queryExpression="t1.lease_start_date &lt;= to_date(${@lease_start_date_to},&apos;yyyy-mm-dd&apos;)"/>
    </bm:query-fields>
    <bm:data-filters>
        <bm:data-filter name="init" enforceOperations="query" expression="t1.control_id=${@control_id}"/>
    </bm:data-filters>
</bm:model>
