<?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 '%' || upper(${@project_number}) || '%'"/> <bm:query-field name="contract_number" queryExpression="upper(t1.contract_number) like '%' || upper(${@contract_number}) || '%'"/> <bm:query-field name="item_frame_number" queryExpression="upper(t1.item_frame_number) like '%' || upper(${@item_frame_number}) || '%'"/> <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)) >= to_date(${@approved_date_from},'yyyy-mm-dd')"/> <bm:query-field name="approved_date_to" queryexpression="trunc(to_date(t1.approved_date)) <= to_date(${@approved_date_to},'yyyy-mm-dd')"/> <bm:query-field name="inception_of_lease_from" queryexpression="trunc(t1.inception_of_lease) >= to_date(${@inception_of_lease_from},'yyyy-mm-dd')"/> <bm:query-field name="inception_of_lease_to" queryexpression="trunc(t1.inception_of_lease) <= to_date(${@inception_of_lease_to},'yyyy-mm-dd')"/> <bm:query-field name="closed_date_from" queryexpression="trunc(t1.closed_date) >= to_date(${@closed_date_from},'yyyy-mm-dd')"/> <bm:query-field name="closed_date_to" queryexpression="trunc(t1.closed_date) <= to_date(${@closed_date_to},'yyyy-mm-dd')"/> </bm:query-fields> </bm:model>