<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="BASIC_DATA" needAccessControl="false">
    <bm:fields>
        <bm:field name="project_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROJECT_NUMBER" prompt="BASIC_DATA.PROJECT_NUMBER"/>
        <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER" prompt="BASIC_DATA.CONTRACT_NUMBER"/>
        <bm:field name="business_type_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSINESS_TYPE_N" prompt="BASIC_DATA.BUSINESS_TYPE_N"/>
        <bm:field name="lease_channel_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_CHANNEL_N" prompt="BASIC_DATA.LEASE_CHANNEL_N"/>
        <bm:field name="division_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION_N" prompt="BASIC_DATA.DIVISION_N"/>
        <bm:field name="car_type_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CAR_TYPE_N" prompt="BASIC_DATA.CAR_TYPE_N"/>
        <bm:field name="invoice_agent_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_AGENT_ID_N" prompt="BASIC_DATA.INVOICE_AGENT_ID_N"/>
        <bm:field name="province_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROVINCE_SP" prompt="BASIC_DATA.PROVINCE_SP"/>
        <bm:field name="city_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CITY_SP" prompt="BASIC_DATA.CITY_SP"/>
        <bm:field name="bp_info" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_INFO" prompt="BASIC_DATA.BP_INFO"/>
        <bm:field name="unbrand" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UNBRAND" prompt="BASIC_DATA.UNBRAND"/>
        <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME" prompt="BASIC_DATA.BP_NAME"/>
        <bm:field name="bp_class_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_CLASS_N" prompt="BASIC_DATA.BP_CLASS_N"/>
        <bm:field name="cell_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CELL_PHONE" prompt="BASIC_DATA.CELL_PHONE"/>
        <bm:field name="id_card_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_CARD_NO" prompt="BASIC_DATA.ID_CARD_NO"/>
        <bm:field name="gender_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GENDER_N" prompt="BASIC_DATA.GENDER_N"/>
        <bm:field name="age" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AGE" prompt="BASIC_DATA.AGE"/>
        <bm:field name="academic_background_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACADEMIC_BACKGROUND_N" prompt="BASIC_DATA.ACADEMIC_BACKGROUND_N"/>
        <bm:field name="marital_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MARITAL_STATUS_N" prompt="BASIC_DATA.MARITAL_STATUS_N"/>
        <bm:field name="add_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_PROVINCE_N" prompt="BASIC_DATA.ADD_PROVINCE_N"/>
        <bm:field name="add_city_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_CITY_N" prompt="BASIC_DATA.ADD_CITY_N"/>
        <bm:field name="liv_province_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIV_PROVINCE_N" prompt="BASIC_DATA.LIV_PROVINCE_N"/>
        <bm:field name="liv_city_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIV_CITY_N" prompt="BASIC_DATA.LIV_CITY_N"/>
        <bm:field name="industry_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_N" prompt="BASIC_DATA.INDUSTRY_N"/>
        <bm:field name="ownship_of_house_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OWNSHIP_OF_HOUSE_N" prompt="BASIC_DATA.OWNSHIP_OF_HOUSE_N"/>
        <bm:field name="annual_income" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ANNUAL_INCOME" prompt="BASIC_DATA.ANNUAL_INCOME"/>
        <bm:field name="industry_work_experience" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_WORK_EXPERIENCE" prompt="BASIC_DATA.INDUSTRY_WORK_EXPERIENCE"/>
        <bm:field name="direct_debit_bank_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIRECT_DEBIT_BANK_ID_N" prompt="BASIC_DATA.DIRECT_DEBIT_BANK_ID_N"/>
        <bm:field name="dd_bank_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_ACCOUNT_NAME" prompt="BASIC_DATA.DD_BANK_ACCOUNT_NAME"/>
        <bm:field name="dd_bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_ACCOUNT_NUM" prompt="BASIC_DATA.DD_BANK_ACCOUNT_NUM"/>
        <bm:field name="ebank_account_prop_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EBANK_ACCOUNT_PROP_N" prompt="BASIC_DATA.EBANK_ACCOUNT_PROP_N"/>
        <bm:field name="withhold_way_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITHHOLD_WAY_N" prompt="BASIC_DATA.WITHHOLD_WAY_N"/>
        <bm:field name="dd_remark" databaseType="VARCHAR2" datatype="java.lang.String"/>
        <bm:field name="objective_buy_car" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OBJECTIVE_BUY_CAR" prompt="BASIC_DATA.OBJECTIVE_BUY_CAR"/>
        <bm:field name="brand_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BRAND_ID_N" prompt="BASIC_DATA.BRAND_ID_N"/>
        <bm:field name="series_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SERIES_ID_N" prompt="BASIC_DATA.SERIES_ID_N"/>
        <bm:field name="model_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MODEL_ID_N" prompt="BASIC_DATA.MODEL_ID_N"/>
        <bm:field name="item_frame_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ITEM_FRAME_NUMBER" prompt="BASIC_DATA.ITEM_FRAME_NUMBER"/>
        <bm:field name="item_engine_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ITEM_ENGINE_NUMBER" prompt="BASIC_DATA.ITEM_ENGINE_NUMBER"/>
        <bm:field name="car_from_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CAR_FROM_ID" prompt="BASIC_DATA.CAR_FROM_ID"/>
        <bm:field name="gps_provider" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GPS_PROVIDER" prompt="BASIC_DATA.GPS_PROVIDER"/>
        <bm:field name="product_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRODUCT_TYPE" prompt="BASIC_DATA.PRODUCT_TYPE"/>
        <bm:field name="product_plan_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRODUCT_PLAN_ID_N" prompt="BASIC_DATA.PRODUCT_PLAN_ID_N"/>
        <bm:field name="lease_times" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_TIMES" prompt="BASIC_DATA.LEASE_TIMES"/>
        <bm:field name="finance_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FINANCE_AMOUNT" prompt="BASIC_DATA.FINANCE_AMOUNT"/>
        <bm:field name="invoice_price" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_PRICE" prompt="BASIC_DATA.INVOICE_PRICE"/>
        <bm:field name="int_rate_display" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INT_RATE_DISPLAY" prompt="BASIC_DATA.INT_RATE_DISPLAY"/>
        <bm:field name="btb_int_rate_implicit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BTB_INT_RATE_IMPLICIT" prompt="BASIC_DATA.BTB_INT_RATE_IMPLICIT"/>
        <bm:field name="irr" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="IRR" prompt="BASIC_DATA.IRR"/>
        <bm:field name="total_rental" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TOTAL_RENTAL" prompt="BASIC_DATA.TOTAL_RENTAL"/>
        <bm:field name="contract_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_AMOUNT" prompt="BASIC_DATA.CONTRACT_AMOUNT"/>
        <bm:field name="down_payment" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOWN_PAYMENT" prompt="BASIC_DATA.DOWN_PAYMENT"/>
        <bm:field name="down_payment_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOWN_PAYMENT_RATIO" prompt="BASIC_DATA.DOWN_PAYMENT_RATIO"/>
        <bm:field name="deposit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT" prompt="BASIC_DATA.DEPOSIT"/>
        <bm:field name="deposit_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT_RATIO" prompt="BASIC_DATA.DEPOSIT_RATIO"/>
        <bm:field name="balloon" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BALLOON" prompt="BASIC_DATA.BALLOON"/>
        <bm:field name="balloon_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BALLOON_RATIO" prompt="BASIC_DATA.BALLOON_RATIO"/>
        <bm:field name="lease_charge" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_CHARGE" prompt="BASIC_DATA.LEASE_CHARGE"/>
        <bm:field name="lease_charge_ratio" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_CHARGE_RATIO" prompt="BASIC_DATA.LEASE_CHARGE_RATIO"/>
        <bm:field name="insurance_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INSURANCE_AMOUNT" prompt="BASIC_DATA.INSURANCE_AMOUNT"/>
        <bm:field name="travel_tax" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TRAVEL_TAX" prompt="BASIC_DATA.TRAVEL_TAX"/>
        <bm:field name="deferred_premium" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEFERRED_PREMIUM" prompt="BASIC_DATA.DEFERRED_PREMIUM"/>
        <bm:field name="gps_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GPS_AMOUNT" prompt="BASIC_DATA.GPS_AMOUNT"/>
        <bm:field name="purchase_tax" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PURCHASE_TAX" prompt="BASIC_DATA.PURCHASE_TAX"/>
        <bm:field name="other_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OTHER_AMOUNT" prompt="BASIC_DATA.OTHER_AMOUNT"/>
        <bm:field name="charge_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CHARGE_AMOUNT" prompt="BASIC_DATA.CHARGE_AMOUNT"/>
        <bm:field name="pmt" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PMT" prompt="BASIC_DATA.PMT"/>
        <bm:field name="total_principal" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TOTAL_PRINCIPAL" prompt="BASIC_DATA.TOTAL_PRINCIPAL"/>
        <bm:field name="total_interest" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TOTAL_INTEREST" prompt="BASIC_DATA.TOTAL_INTEREST"/>
        <bm:field name="unreceived_totle_rental" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UNRECEIVED_TOTLE_RENTAL" prompt="BASIC_DATA.UNRECEIVED_TOTLE_RENTAL"/>
        <bm:field name="due_date" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DUE_DATE" prompt="BASIC_DATA.DUE_DATE"/>
        <bm:field name="lease_end_date" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_END_DATE" prompt="BASIC_DATA.LEASE_END_DATE"/>
        <bm:field name="overdue_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OVERDUE_STATUS" prompt="BASIC_DATA.OVERDUE_STATUS"/>
        <bm:field name="now_overdue_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOW_OVERDUE_STATUS" prompt="BASIC_DATA.NOW_OVERDUE_STATUS"/>
        <bm:field name="overdue_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OVERDUE_AMOUNT" prompt="BASIC_DATA.OVERDUE_AMOUNT"/>
        <bm:field name="due_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DUE_AMOUNT" prompt="BASIC_DATA.DUE_AMOUNT"/>
        <bm:field name="project_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROJECT_STATUS_N" prompt="BASIC_DATA.PROJECT_STATUS_N"/>
        <bm:field name="contract_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_STATUS_N" prompt="BASIC_DATA.CONTRACT_STATUS_N"/>
        <bm:field name="submit_date" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SUBMIT_DATE" prompt="BASIC_DATA.SUBMIT_DATE"/>
        <bm:field name="approved_date" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="APPROVED_DATE" prompt="BASIC_DATA.APPROVED_DATE"/>
        <bm:field name="refuse_date" databaseType="DATE" datatype="java.util.Date" physicalName="REFUSE_DATE" prompt="BASIC_DATA.REFUSE_DATE"/>
        <!--  <bm:field name="project_refuse_date" databaseType="DATE" datatype="java.util.Date" physicalName="PROJECT_REFUSE_DATE" prompt="BASIC_DATA.PROJECT_REFUSE_DATE"/> -->
        <bm:field name="print_date" databaseType="DATE" datatype="java.util.Date" physicalName="PRINT_DATE" prompt="BASIC_DATA.PRINT_DATE"/>
        <bm:field name="closed_date" databaseType="DATE" datatype="java.util.Date" physicalName="CLOSED_DATE" prompt="BASIC_DATA.CLOSED_DATE"/>
        <bm:field name="payment_completed_date" databaseType="VARCHAR2" datatype="java.lang.String"/>
        <bm:field name="inception_of_lease" databaseType="DATE" datatype="java.util.Date" physicalName="INCEPTION_OF_LEASE" prompt="BASIC_DATA.INCEPTION_OF_LEASE"/>
        <bm:field name="termination_date" databaseType="DATE" datatype="java.util.Date" physicalName="TERMINATION_DATE" prompt="BASIC_DATA.TERMINATION_DATE"/>
        <bm:field name="cc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CC" prompt="BASIC_DATA.CC"/>
        <bm:field name="ca" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CA" prompt="BASIC_DATA.CA"/>
        <bm:field name="cs" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CS" prompt="BASIC_DATA.CS"/>
        <bm:field name="concs" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONCS" prompt="BASIC_DATA.CONCS"/>
        <bm:field name="confs" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFS" prompt="BASIC_DATA.CONFS"/>
        <bm:field name="cc_arrive_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CC_ARRIVE_TIME" prompt="BASIC_DATA.CC_ARRIVE_TIME"/>
        <bm:field name="ca_arrive_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CA_ARRIVE_TIME" prompt="BASIC_DATA.CA_ARRIVE_TIME"/>
        <bm:field name="cs_arrive_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CS_ARRIVE_TIME" prompt="BASIC_DATA.CS_ARRIVE_TIME"/>
        <bm:field name="concs_arrive_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONCS_ARRIVE_TIME" prompt="BASIC_DATA.CONCS_ARRIVE_TIME"/>
        <bm:field name="confs_arrive_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFS_ARRIVE_TIME" prompt="BASIC_DATA.CONFS_ARRIVE_TIME"/>
        <bm:field name="cc_approve_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CC_APPROVE_TIME" prompt="BASIC_DATA.CC_APPROVE_TIME"/>
        <bm:field name="ca_approve_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CA_APPROVE_TIME" prompt="BASIC_DATA.CA_APPROVE_TIME"/>
        <bm:field name="cs_approve_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CS_APPROVE_TIME" prompt="BASIC_DATA.CS_APPROVE_TIME"/>
        <bm:field name="concs_approve_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONCS_APPROVE_TIME" prompt="BASIC_DATA.CONCS_APPROVE_TIME"/>
        <bm:field name="confs_approve_time" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFS_APPROVE_TIME" prompt="BASIC_DATA.CONFS_APPROVE_TIME"/>
        <bm:field name="ca_advise" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CA_ADVISE" prompt="BASIC_DATA.CA_ADVISE"/>
        <bm:field name="cs_advise" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CS_ADVISE" prompt="BASIC_DATA.CS_ADVISE"/>
        <bm:field name="concs_advise" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONCS_ADVISE" prompt="BASIC_DATA.CONCS_ADVISE"/>
        <bm:field name="confs_advise" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONFS_ADVISE" prompt="BASIC_DATA.CONFS_ADVISE"/>
        <bm:field name="basic_data_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BASIC_DATA_ID" prompt="BASIC_DATA.BASIC_DATA_ID"/>
    </bm:fields>
    <bm:features>
        <f:standard-who/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="basic_data_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field name="project_number" queryExpression="upper(t1.project_number) like &apos;%&apos; || upper(${@project_number}) || &apos;%&apos;"/>
        <bm:query-field name="contract_number" queryExpression="upper(t1.contract_number) like &apos;%&apos; || upper(${@contract_number}) || &apos;%&apos;"/>
        <bm:query-field name="item_frame_number" queryExpression="upper(t1.item_frame_number) like &apos;%&apos; || upper(${@item_frame_number}) || &apos;%&apos;"/>
        <bm:query-field name="bp_name" queryExpression="t1.bp_name=${@bp_name}"/>
        <bm:query-field name="division_n" queryExpression="t1.division_n=${@division_n}"/>
        <bm:query-field name="project_status_n" queryExpression="t1.project_status_n=${@project_status_n}"/>
        <bm:query-field name="contract_status_n" queryExpression="t1.contract_status_n=${@contract_status_n}"/>
        <bm:query-field name="business_type_n" queryExpression="t1.business_type_n=${@business_type_n}"/>
        <bm:query-field name="lease_channel_n" queryExpression="t1.lease_channel_n=${@lease_channel_n}"/>
        <bm:query-field name="invoice_agent_id_n" queryExpression="t1.invoice_agent_id_n=${@invoice_agent_id_n}"/>
        <bm:query-field name="approved_date_from" queryexpression="trunc(to_date(t1.approved_date)) &gt;= to_date(${@approved_date_from},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field name="approved_date_to" queryexpression="trunc(to_date(t1.approved_date)) &lt;= to_date(${@approved_date_to},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field name="inception_of_lease_from" queryexpression="trunc(t1.inception_of_lease) &gt;= to_date(${@inception_of_lease_from},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field name="inception_of_lease_to" queryexpression="trunc(t1.inception_of_lease) &lt;= to_date(${@inception_of_lease_to},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field name="closed_date_from" queryexpression="trunc(t1.closed_date) &gt;= to_date(${@closed_date_from},&apos;yyyy-mm-dd&apos;)"/>
        <bm:query-field name="closed_date_to" queryexpression="trunc(t1.closed_date) &lt;= to_date(${@closed_date_to},&apos;yyyy-mm-dd&apos;)"/>
    </bm:query-fields>
</bm:model>
