<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Leaf Generator
    $Date: Fri Jul 13 15:06:37 CST 2018  
    $Revision: 1.0  
    $Purpose: 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:e="leaf.service.exception" xmlns:o="leaf.database.local.oracle" xmlns:f="leaf.database.features" alias="t1" baseTable="TRE_LOAN_WITHDRAWAL_PLAN_LV">
    <bm:fields>
        <bm:field name="loan_deposit" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LOAN_DEPOSIT" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_DEPOSIT"/>
        <bm:field name="assets_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ASSETS_NAME" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.ASSETS_NAME"/>
        <bm:field name="deposit" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DEPOSIT" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.DEPOSIT"/>
        <bm:field name="deposit_deduction" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT_DEDUCTION" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.DEPOSIT_DEDUCTION"/>
        <bm:field name="margin_deduction" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MARGIN_DEDUCTION" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.MARGIN_DEDUCTION"/>
        <bm:field name="margin_deduction_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MARGIN_DEDUCTION_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.MARGIN_DEDUCTION_N"/>
        <bm:field name="deposit_deduction_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT_DEDUCTION_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.DEPOSIT_DEDUCTION_N"/>
        <bm:field name="credit_contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CREDIT_CONTRACT_ID" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.CREDIT_CONTRACT_ID"/>
        <bm:field name="widthdrawal_plan_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="WIDTHDRAWAL_PLAN_ID" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.WIDTHDRAWAL_PLAN_ID"/>
        <bm:field name="loan_contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LOAN_CONTRACT_ID" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_CONTRACT_ID"/>
        <bm:field name="widthdrawal_date" databaseType="DATE" datatype="java.util.Date" physicalName="WIDTHDRAWAL_DATE" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.WIDTHDRAWAL_DATE"/>
        <bm:field name="loan_term" databaseType="DATE" datatype="java.util.Date" physicalName="LOAN_TERM" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_TERM"/>
        <bm:field name="cdate" expression="t1.CREATION_DATE" datatype="java.util.Date" databaseType="DATE"/>
        <!--<bm:field name="creation_date" databaseType="DATE" datatype="java.util.Date" physicalName="CREATION_DATE" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.CREATION_DATE"/>-->
        <!--<bm:field name="created_by" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CREATED_BY" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.CREATED_BY"/>-->
        <!--<bm:field name="last_update_date" databaseType="DATE" datatype="java.util.Date" physicalName="LAST_UPDATE_DATE" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LAST_UPDATE_DATE"/>-->
        <!--<bm:field name="last_updated_by" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LAST_UPDATED_BY" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LAST_UPDATED_BY"/>-->
        <bm:field name="ref_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V01" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_V01"/>
        <bm:field name="ref_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V02" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_V02"/>
        <bm:field name="ref_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V03" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_V03"/>
        <bm:field name="ref_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_V04"/>
        <bm:field name="ref_v04_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_V04_N"/>
        <bm:field name="withdrawal_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITHDRAWAL_NUMBER" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.WITHDRAWAL_NUMBER"/>
        <bm:field name="ref_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V05" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_V05"/>
        <bm:field name="ref_n01" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N01" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_N01"/>
        <bm:field name="ref_n01_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_N01_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_N01_N"/>
        <bm:field name="ref_n02" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N02" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_N02"/>
        <bm:field name="ref_n03" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N03" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_N03"/>
        <bm:field name="ref_n04" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N04" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_N04"/>
        <bm:field name="ref_n05" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N05" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_N05"/>
        <bm:field name="ref_d01" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D01" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_D01"/>
        <bm:field name="ref_d02" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D02" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_D02"/>
        <bm:field name="ref_d03" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D03" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_D03"/>
        <bm:field name="ref_d04" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D04" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_D04"/>
        <bm:field name="ref_d05" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D05" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.REF_D05"/>
        <bm:field name="batch_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BATCH_ID" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.BATCH_ID"/>
        <bm:field name="factoring_contract_ln_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FACTORING_CONTRACT_LN_ID" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.FACTORING_CONTRACT_LN_ID"/>
        <bm:field name="quotation_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="QUOTATION_ID" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.QUOTATION_ID"/>
        <bm:field name="times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TIMES" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.TIMES"/>
        <bm:field name="write_off_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WRITE_OFF_FLAG" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.WRITE_OFF_FLAG"/>
        <bm:field name="widthdrawal_wfl_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WIDTHDRAWAL_WFL_STATUS" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.WIDTHDRAWAL_WFL_STATUS"/>
        <bm:field name="widthdrawal_wfl_status_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WIDTHDRAWAL_WFL_STATUS_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.WIDTHDRAWAL_WFL_STATUS_N"/>
        <bm:field name="amount_all" databaseType="NUMBER" datatype="java.lang.Long" physicalName="AMOUNT_ALL" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.AMOUNT_ALL"/>
        <bm:field name="amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="AMOUNT" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.AMOUNT"/>
        <bm:field name="interest" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.INTEREST"/>
        <bm:field name="create_kindee_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CREATE_KINDEE_FLAG" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.CREATE_KINDEE_FLAG"/>
        <bm:field name="note" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTE" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.NOTE"/>
        <bm:field name="account_form" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNT_FORM" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.ACCOUNT_FORM"/>
        <bm:field name="account_form_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACCOUNT_FORM_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.ACCOUNT_FORM_N"/>
        <bm:field name="lease_times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_TIMES" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LEASE_TIMES"/>
        <bm:field name="interest_calc_date" databaseType="DATE" datatype="java.util.Date" physicalName="INTEREST_CALC_DATE" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.INTEREST_CALC_DATE"/>
        <bm:field name="interest_payment_date" databaseType="DATE" datatype="java.util.Date" physicalName="INTEREST_PAYMENT_DATE" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.INTEREST_PAYMENT_DATE"/>
        <bm:field name="loan_contract_id_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOAN_CONTRACT_ID_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_CONTRACT_ID_N"/>
        <bm:field name="loan_contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOAN_CONTRACT_NUMBER" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_CONTRACT_NUMBER"/>
        <bm:field name="loan_contract_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOAN_CONTRACT_NAME" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_CONTRACT_NAME"/>
        <bm:field name="loan_con_bp_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOAN_CON_BP_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_CON_BP_N"/>
        <bm:field name="loan_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LOAN_AMOUNT" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_AMOUNT"/>
        <bm:field name="interest_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST_RATE" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.INTEREST_RATE"/>
        <bm:field name="drawn_amt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DRAWN_AMT" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.DRAWN_AMT"/>
        <bm:field name="residual_amt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RESIDUAL_AMT" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.RESIDUAL_AMT"/>
        <bm:field name="currency_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.CURRENCY_N"/>
        <bm:field name="withdraw_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITHDRAW_ACCOUNT_NAME" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.WITHDRAW_ACCOUNT_NAME"/>
        <bm:field name="withdraw_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WITHDRAW_ACCOUNT_NUM" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.WITHDRAW_ACCOUNT_NUM"/>
        <bm:field name="interest_period_n" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INTEREST_PERIOD_N" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.INTEREST_PERIOD_N"/>
        <bm:field name="loan_date_from" databaseType="DATE" datatype="java.util.Date" physicalName="LOAN_DATE_FROM" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_DATE_FROM"/>
        <bm:field name="loan_date_to" databaseType="DATE" datatype="java.util.Date" physicalName="LOAN_DATE_TO" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.LOAN_DATE_TO"/>
        <bm:field name="change_money" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CHANGE_MONEY" prompt="TRE_LOAN_WITHDRAWAL_PLAN_LV.CHANGE_MONEY"/>
    </bm:fields>
    <bm:features>
        <f:standard-who xmlns:f="leaf.database.features"/>
    </bm:features>
</bm:model>