<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: Leaf Generator
    $Date: Wed Aug 15 15:36:36 GMT+08:00 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" defaultOrderBy="t1.times asc" baseTable="CONTRACT_ET_CASHFLOW_LN">
    <bm:fields>
        <bm:field name="et_agreement_line_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ET_AGREEMENT_LINE_ID" prompt="CONTRACT_ET_CASHFLOW_LN.ET_AGREEMENT_LINE_ID"/>
        <bm:field name="et_agreement_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ET_AGREEMENT_ID" prompt="CONTRACT_ET_CASHFLOW_LN.ET_AGREEMENT_ID"/>
        <bm:field name="cashflow_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CASHFLOW_ID" prompt="CONTRACT_ET_CASHFLOW_LN.CASHFLOW_ID"/>
        <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="CONTRACT_ET_CASHFLOW_LN.CONTRACT_ID"/>
        <bm:field name="cf_item" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CF_ITEM" prompt="CONTRACT_ET_CASHFLOW_LN.CF_ITEM"/>
        <bm:field name="cf_item_n" expression="(select hci.description from hls_cashflow_item hci where hci.cf_item = t1.cf_item)" forInsert="false" forUpdate="false"/>
        <bm:field name="cf_type" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CF_TYPE" prompt="CONTRACT_ET_CASHFLOW_LN.CF_TYPE"/>
        <bm:field name="cf_direction" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CF_DIRECTION" prompt="CONTRACT_ET_CASHFLOW_LN.CF_DIRECTION"/>
        <bm:field name="cf_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CF_STATUS" prompt="CONTRACT_ET_CASHFLOW_LN.CF_STATUS"/>
        <bm:field name="cf_status_n" expression="(decode(t1.cf_status,'BLOCK','冻结','OUTFLOW','流出','流入'))"/>
        <bm:field name="times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TIMES" prompt="CONTRACT_ET_CASHFLOW_LN.TIMES"/>
        <bm:field name="calc_date" databaseType="DATE" datatype="java.util.Date" physicalName="CALC_DATE" prompt="CONTRACT_ET_CASHFLOW_LN.CALC_DATE"/>
        <bm:field name="due_date" databaseType="DATE" datatype="java.util.Date" physicalName="DUE_DATE" prompt="CONTRACT_ET_CASHFLOW_LN.DUE_DATE"/>
        <bm:field name="fin_income_date" databaseType="DATE" datatype="java.util.Date" physicalName="FIN_INCOME_DATE" prompt="CONTRACT_ET_CASHFLOW_LN.FIN_INCOME_DATE"/>
        <bm:field name="due_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DUE_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.DUE_AMOUNT"/>
        <bm:field name="net_due_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NET_DUE_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.NET_DUE_AMOUNT"/>
        <bm:field name="vat_due_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_DUE_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.VAT_DUE_AMOUNT"/>
        <bm:field name="principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL" prompt="CONTRACT_ET_CASHFLOW_LN.PRINCIPAL"/>
        <bm:field name="net_principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NET_PRINCIPAL" prompt="CONTRACT_ET_CASHFLOW_LN.NET_PRINCIPAL"/>
        <bm:field name="vat_principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_PRINCIPAL" prompt="CONTRACT_ET_CASHFLOW_LN.VAT_PRINCIPAL"/>
        <bm:field name="interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST"/>
        <bm:field name="net_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NET_INTEREST" prompt="CONTRACT_ET_CASHFLOW_LN.NET_INTEREST"/>
        <bm:field name="vat_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_INTEREST" prompt="CONTRACT_ET_CASHFLOW_LN.VAT_INTEREST"/>
        <bm:field name="principal_implicit_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINCIPAL_IMPLICIT_RATE" prompt="CONTRACT_ET_CASHFLOW_LN.PRINCIPAL_IMPLICIT_RATE"/>
        <bm:field name="net_principal_implicit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NET_PRINCIPAL_IMPLICIT" prompt="CONTRACT_ET_CASHFLOW_LN.NET_PRINCIPAL_IMPLICIT"/>
        <bm:field name="vat_principal_implicit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_PRINCIPAL_IMPLICIT" prompt="CONTRACT_ET_CASHFLOW_LN.VAT_PRINCIPAL_IMPLICIT"/>
        <bm:field name="interest_implicit_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_IMPLICIT_RATE" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_IMPLICIT_RATE"/>
        <bm:field name="net_interest_implicit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NET_INTEREST_IMPLICIT" prompt="CONTRACT_ET_CASHFLOW_LN.NET_INTEREST_IMPLICIT"/>
        <bm:field name="vat_interest_implicit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_INTEREST_IMPLICIT" prompt="CONTRACT_ET_CASHFLOW_LN.VAT_INTEREST_IMPLICIT"/>
        <bm:field name="outstanding_rental" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OUTSTANDING_RENTAL" prompt="CONTRACT_ET_CASHFLOW_LN.OUTSTANDING_RENTAL"/>
        <bm:field name="outstanding_principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OUTSTANDING_PRINCIPAL" prompt="CONTRACT_ET_CASHFLOW_LN.OUTSTANDING_PRINCIPAL"/>
        <bm:field name="outstanding_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OUTSTANDING_INTEREST" prompt="CONTRACT_ET_CASHFLOW_LN.OUTSTANDING_INTEREST"/>
        <bm:field name="interest_accrual_balance" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTEREST_ACCRUAL_BALANCE" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_ACCRUAL_BALANCE"/>
        <bm:field name="accumulated_unpaid_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="ACCUMULATED_UNPAID_INTEREST" prompt="CONTRACT_ET_CASHFLOW_LN.ACCUMULATED_UNPAID_INTEREST"/>
        <bm:field name="interest_period_days" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST_PERIOD_DAYS" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_PERIOD_DAYS"/>
        <bm:field name="discounting_days" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DISCOUNTING_DAYS" prompt="CONTRACT_ET_CASHFLOW_LN.DISCOUNTING_DAYS"/>
        <bm:field name="fix_principal_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIX_PRINCIPAL_FLAG" prompt="CONTRACT_ET_CASHFLOW_LN.FIX_PRINCIPAL_FLAG"/>
        <bm:field name="fix_rental_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIX_RENTAL_FLAG" prompt="CONTRACT_ET_CASHFLOW_LN.FIX_RENTAL_FLAG"/>
        <bm:field name="interest_only_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INTEREST_ONLY_FLAG" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_ONLY_FLAG"/>
        <bm:field name="equal_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EQUAL_FLAG" prompt="CONTRACT_ET_CASHFLOW_LN.EQUAL_FLAG"/>
        <bm:field name="manual_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MANUAL_FLAG" prompt="CONTRACT_ET_CASHFLOW_LN.MANUAL_FLAG"/>
        <bm:field name="beginning_of_lease_year" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BEGINNING_OF_LEASE_YEAR" prompt="CONTRACT_ET_CASHFLOW_LN.BEGINNING_OF_LEASE_YEAR"/>
        <bm:field name="salestax" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SALESTAX" prompt="CONTRACT_ET_CASHFLOW_LN.SALESTAX"/>
        <bm:field name="generated_source" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GENERATED_SOURCE" prompt="CONTRACT_ET_CASHFLOW_LN.GENERATED_SOURCE"/>
        <bm:field name="generated_source_doc_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="GENERATED_SOURCE_DOC_ID" prompt="CONTRACT_ET_CASHFLOW_LN.GENERATED_SOURCE_DOC_ID"/>
        <bm:field name="colour_scheme" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COLOUR_SCHEME" prompt="CONTRACT_ET_CASHFLOW_LN.COLOUR_SCHEME"/>
        <bm:field name="alert_scheme" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ALERT_SCHEME" prompt="CONTRACT_ET_CASHFLOW_LN.ALERT_SCHEME"/>
        <bm:field name="calc_line_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CALC_LINE_ID" prompt="CONTRACT_ET_CASHFLOW_LN.CALC_LINE_ID"/>
        <bm:field name="overdue_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OVERDUE_STATUS" prompt="CONTRACT_ET_CASHFLOW_LN.OVERDUE_STATUS"/>
        <bm:field name="overdue_book_date" databaseType="DATE" datatype="java.util.Date" physicalName="OVERDUE_BOOK_DATE" prompt="CONTRACT_ET_CASHFLOW_LN.OVERDUE_BOOK_DATE"/>
        <bm:field name="overdue_max_days" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OVERDUE_MAX_DAYS" prompt="CONTRACT_ET_CASHFLOW_LN.OVERDUE_MAX_DAYS"/>
        <bm:field name="overdue_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.OVERDUE_AMOUNT"/>
        <bm:field name="overdue_principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_PRINCIPAL" prompt="CONTRACT_ET_CASHFLOW_LN.OVERDUE_PRINCIPAL"/>
        <bm:field name="overdue_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OVERDUE_INTEREST" prompt="CONTRACT_ET_CASHFLOW_LN.OVERDUE_INTEREST"/>
        <bm:field name="overdue_remark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OVERDUE_REMARK" prompt="CONTRACT_ET_CASHFLOW_LN.OVERDUE_REMARK"/>
        <bm:field name="received_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="RECEIVED_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.RECEIVED_AMOUNT"/>
        <bm:field name="received_principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="RECEIVED_PRINCIPAL" prompt="CONTRACT_ET_CASHFLOW_LN.RECEIVED_PRINCIPAL"/>
        <bm:field name="received_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="RECEIVED_INTEREST" prompt="CONTRACT_ET_CASHFLOW_LN.RECEIVED_INTEREST"/>
        <bm:field name="write_off_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WRITE_OFF_FLAG" prompt="CONTRACT_ET_CASHFLOW_LN.WRITE_OFF_FLAG"/>
        <bm:field name="last_received_date" databaseType="DATE" datatype="java.util.Date" physicalName="LAST_RECEIVED_DATE" prompt="CONTRACT_ET_CASHFLOW_LN.LAST_RECEIVED_DATE"/>
        <bm:field name="full_write_off_date" databaseType="DATE" datatype="java.util.Date" physicalName="FULL_WRITE_OFF_DATE" prompt="CONTRACT_ET_CASHFLOW_LN.FULL_WRITE_OFF_DATE"/>
        <bm:field name="penalty_process_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PENALTY_PROCESS_STATUS" prompt="CONTRACT_ET_CASHFLOW_LN.PENALTY_PROCESS_STATUS"/>
        <bm:field name="billing_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BILLING_STATUS" prompt="CONTRACT_ET_CASHFLOW_LN.BILLING_STATUS"/>
        <bm:field name="billing_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BILLING_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.BILLING_AMOUNT"/>
        <bm:field name="billing_principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BILLING_PRINCIPAL" prompt="CONTRACT_ET_CASHFLOW_LN.BILLING_PRINCIPAL"/>
        <bm:field name="billing_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BILLING_INTEREST" prompt="CONTRACT_ET_CASHFLOW_LN.BILLING_INTEREST"/>
        <bm:field name="rental_eq_pymt_raw" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RENTAL_EQ_PYMT_RAW" prompt="CONTRACT_ET_CASHFLOW_LN.RENTAL_EQ_PYMT_RAW"/>
        <bm:field name="rental_eq_pymt_adj" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RENTAL_EQ_PYMT_ADJ" prompt="CONTRACT_ET_CASHFLOW_LN.RENTAL_EQ_PYMT_ADJ"/>
        <bm:field name="interest_eq_pymt_raw" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST_EQ_PYMT_RAW" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_EQ_PYMT_RAW"/>
        <bm:field name="interest_eq_pymt_adj" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST_EQ_PYMT_ADJ" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_EQ_PYMT_ADJ"/>
        <bm:field name="principal_eq_pymt_raw" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRINCIPAL_EQ_PYMT_RAW" prompt="CONTRACT_ET_CASHFLOW_LN.PRINCIPAL_EQ_PYMT_RAW"/>
        <bm:field name="principal_eq_pymt_adj" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRINCIPAL_EQ_PYMT_ADJ" prompt="CONTRACT_ET_CASHFLOW_LN.PRINCIPAL_EQ_PYMT_ADJ"/>
        <bm:field name="rental_eq_prin_raw" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RENTAL_EQ_PRIN_RAW" prompt="CONTRACT_ET_CASHFLOW_LN.RENTAL_EQ_PRIN_RAW"/>
        <bm:field name="rental_eq_prin_adj" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RENTAL_EQ_PRIN_ADJ" prompt="CONTRACT_ET_CASHFLOW_LN.RENTAL_EQ_PRIN_ADJ"/>
        <bm:field name="interest_eq_prin_raw" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST_EQ_PRIN_RAW" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_EQ_PRIN_RAW"/>
        <bm:field name="interest_eq_prin_adj" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST_EQ_PRIN_ADJ" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_EQ_PRIN_ADJ"/>
        <bm:field name="principal_eq_prin_raw" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRINCIPAL_EQ_PRIN_RAW" prompt="CONTRACT_ET_CASHFLOW_LN.PRINCIPAL_EQ_PRIN_RAW"/>
        <bm:field name="principal_eq_prin_adj" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRINCIPAL_EQ_PRIN_ADJ" prompt="CONTRACT_ET_CASHFLOW_LN.PRINCIPAL_EQ_PRIN_ADJ"/>
        <bm:field name="ln_user_col_d01" databaseType="DATE" datatype="java.util.Date" physicalName="LN_USER_COL_D01" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_D01"/>
        <bm:field name="ln_user_col_d02" databaseType="DATE" datatype="java.util.Date" physicalName="LN_USER_COL_D02" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_D02"/>
        <bm:field name="ln_user_col_d03" databaseType="DATE" datatype="java.util.Date" physicalName="LN_USER_COL_D03" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_D03"/>
        <bm:field name="ln_user_col_d04" databaseType="DATE" datatype="java.util.Date" physicalName="LN_USER_COL_D04" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_D04"/>
        <bm:field name="ln_user_col_d05" databaseType="DATE" datatype="java.util.Date" physicalName="LN_USER_COL_D05" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_D05"/>
        <bm:field name="ln_user_col_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LN_USER_COL_V01" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_V01"/>
        <bm:field name="ln_user_col_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LN_USER_COL_V02" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_V02"/>
        <bm:field name="ln_user_col_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LN_USER_COL_V03" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_V03"/>
        <bm:field name="ln_user_col_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LN_USER_COL_V04" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_V04"/>
        <bm:field name="ln_user_col_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LN_USER_COL_V05" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_V05"/>
        <bm:field name="ln_user_col_n01" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N01" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N01"/>
        <bm:field name="ln_user_col_n02" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N02" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N02"/>
        <bm:field name="ln_user_col_n03" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N03" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N03"/>
        <bm:field name="ln_user_col_n04" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N04" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N04"/>
        <bm:field name="ln_user_col_n05" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N05" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N05"/>
        <bm:field name="ln_user_col_n06" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N06" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N06"/>
        <bm:field name="ln_user_col_n07" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N07" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N07"/>
        <bm:field name="ln_user_col_n08" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N08" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N08"/>
        <bm:field name="ln_user_col_n09" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N09" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N09"/>
        <bm:field name="ln_user_col_n10" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N10" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N10"/>
        <bm:field name="ln_user_col_n11" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N11" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N11"/>
        <bm:field name="ln_user_col_n12" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N12" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N12"/>
        <bm:field name="ln_user_col_n13" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N13" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N13"/>
        <bm:field name="ln_user_col_n14" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N14" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N14"/>
        <bm:field name="ln_user_col_n15" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N15" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N15"/>
        <bm:field name="ln_user_col_n16" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N16" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N16"/>
        <bm:field name="ln_user_col_n17" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N17" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N17"/>
        <bm:field name="ln_user_col_n18" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N18" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N18"/>
        <bm:field name="ln_user_col_n19" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N19" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N19"/>
        <bm:field name="ln_user_col_n20" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LN_USER_COL_N20" prompt="CONTRACT_ET_CASHFLOW_LN.LN_USER_COL_N20"/>
        <bm:field name="outstanding_rental_tax_incld" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OUTSTANDING_RENTAL_TAX_INCLD" prompt="CONTRACT_ET_CASHFLOW_LN.OUTSTANDING_RENTAL_TAX_INCLD"/>
        <bm:field name="outstanding_prin_tax_incld" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OUTSTANDING_PRIN_TAX_INCLD" prompt="CONTRACT_ET_CASHFLOW_LN.OUTSTANDING_PRIN_TAX_INCLD"/>
        <bm:field name="outstanding_int_tax_incld" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OUTSTANDING_INT_TAX_INCLD" prompt="CONTRACT_ET_CASHFLOW_LN.OUTSTANDING_INT_TAX_INCLD"/>
        <bm:field name="interest_accrual_bal_tax_incl" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST_ACCRUAL_BAL_TAX_INCL" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_ACCRUAL_BAL_TAX_INCL"/>
        <bm:field name="accumulated_unpd_int_tax_incl" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ACCUMULATED_UNPD_INT_TAX_INCL" prompt="CONTRACT_ET_CASHFLOW_LN.ACCUMULATED_UNPD_INT_TAX_INCL"/>
        <bm:field name="exchange_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_TYPE" prompt="CONTRACT_ET_CASHFLOW_LN.EXCHANGE_RATE_TYPE"/>
        <bm:field name="exchange_rate_quotation" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_QUOTATION" prompt="CONTRACT_ET_CASHFLOW_LN.EXCHANGE_RATE_QUOTATION"/>
        <bm:field name="exchange_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EXCHANGE_RATE" prompt="CONTRACT_ET_CASHFLOW_LN.EXCHANGE_RATE"/>
        <bm:field name="due_amount_func" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DUE_AMOUNT_FUNC" prompt="CONTRACT_ET_CASHFLOW_LN.DUE_AMOUNT_FUNC"/>
        <bm:field name="main_business_income" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MAIN_BUSINESS_INCOME" prompt="CONTRACT_ET_CASHFLOW_LN.MAIN_BUSINESS_INCOME"/>
        <bm:field name="main_business_cost" databaseType="NUMBER" datatype="java.lang.Long" physicalName="MAIN_BUSINESS_COST" prompt="CONTRACT_ET_CASHFLOW_LN.MAIN_BUSINESS_COST"/>
        <bm:field name="financing_cost" databaseType="NUMBER" datatype="java.lang.Long" physicalName="FINANCING_COST" prompt="CONTRACT_ET_CASHFLOW_LN.FINANCING_COST"/>
        <bm:field name="due_amount_cny" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DUE_AMOUNT_CNY" prompt="CONTRACT_ET_CASHFLOW_LN.DUE_AMOUNT_CNY"/>
        <bm:field name="principal_cny" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PRINCIPAL_CNY" prompt="CONTRACT_ET_CASHFLOW_LN.PRINCIPAL_CNY"/>
        <bm:field name="interest_cny" databaseType="NUMBER" datatype="java.lang.Long" physicalName="INTEREST_CNY" prompt="CONTRACT_ET_CASHFLOW_LN.INTEREST_CNY"/>
        <bm:field name="received_amount_cny" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RECEIVED_AMOUNT_CNY" prompt="CONTRACT_ET_CASHFLOW_LN.RECEIVED_AMOUNT_CNY"/>
        <bm:field name="received_principal_cny" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RECEIVED_PRINCIPAL_CNY" prompt="CONTRACT_ET_CASHFLOW_LN.RECEIVED_PRINCIPAL_CNY"/>
        <bm:field name="received_interest_cny" databaseType="NUMBER" datatype="java.lang.Long" physicalName="RECEIVED_INTEREST_CNY" prompt="CONTRACT_ET_CASHFLOW_LN.RECEIVED_INTEREST_CNY"/>
        <bm:field name="lease_year" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_YEAR" prompt="CONTRACT_ET_CASHFLOW_LN.LEASE_YEAR"/>
        <bm:field name="quarter_num" databaseType="NUMBER" datatype="java.lang.Long" physicalName="QUARTER_NUM" prompt="CONTRACT_ET_CASHFLOW_LN.QUARTER_NUM"/>
        <bm:field name="period_num" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PERIOD_NUM" prompt="CONTRACT_ET_CASHFLOW_LN.PERIOD_NUM"/>
        <bm:field name="tt_bank_account_id_1" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TT_BANK_ACCOUNT_ID_1" prompt="CONTRACT_ET_CASHFLOW_LN.TT_BANK_ACCOUNT_ID_1"/>
        <bm:field name="tt_bank_account_num_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TT_BANK_ACCOUNT_NUM_1" prompt="CONTRACT_ET_CASHFLOW_LN.TT_BANK_ACCOUNT_NUM_1"/>
        <bm:field name="tt_account_1_amt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TT_ACCOUNT_1_AMT" prompt="CONTRACT_ET_CASHFLOW_LN.TT_ACCOUNT_1_AMT"/>
        <bm:field name="tt_bank_account_id_2" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TT_BANK_ACCOUNT_ID_2" prompt="CONTRACT_ET_CASHFLOW_LN.TT_BANK_ACCOUNT_ID_2"/>
        <bm:field name="tt_bank_account_num_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TT_BANK_ACCOUNT_NUM_2" prompt="CONTRACT_ET_CASHFLOW_LN.TT_BANK_ACCOUNT_NUM_2"/>
        <bm:field name="tt_account_2_amt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TT_ACCOUNT_2_AMT" prompt="CONTRACT_ET_CASHFLOW_LN.TT_ACCOUNT_2_AMT"/>
        <bm:field name="tt_bank_account_id_3" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TT_BANK_ACCOUNT_ID_3" prompt="CONTRACT_ET_CASHFLOW_LN.TT_BANK_ACCOUNT_ID_3"/>
        <bm:field name="tt_bank_account_num_3" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TT_BANK_ACCOUNT_NUM_3" prompt="CONTRACT_ET_CASHFLOW_LN.TT_BANK_ACCOUNT_NUM_3"/>
        <bm:field name="tt_account_3_amt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TT_ACCOUNT_3_AMT" prompt="CONTRACT_ET_CASHFLOW_LN.TT_ACCOUNT_3_AMT"/>
        <bm:field name="estimated_due_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ESTIMATED_DUE_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.ESTIMATED_DUE_AMOUNT"/>
        <bm:field name="estimated_net_due_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ESTIMATED_NET_DUE_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.ESTIMATED_NET_DUE_AMOUNT"/>
        <bm:field name="estimated_vat_due_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ESTIMATED_VAT_DUE_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.ESTIMATED_VAT_DUE_AMOUNT"/>
        <bm:field name="payment_deduction_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PAYMENT_DEDUCTION_FLAG" prompt="CONTRACT_ET_CASHFLOW_LN.PAYMENT_DEDUCTION_FLAG"/>
        <bm:field name="payment_deduction_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PAYMENT_DEDUCTION_AMOUNT" prompt="CONTRACT_ET_CASHFLOW_LN.PAYMENT_DEDUCTION_AMOUNT"/>
        <bm:field name="cashflow_extend_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CASHFLOW_EXTEND_ID" prompt="CONTRACT_ET_CASHFLOW_LN.CASHFLOW_EXTEND_ID"/>
        <bm:field name="tax_type_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TAX_TYPE_ID" prompt="CONTRACT_ET_CASHFLOW_LN.TAX_TYPE_ID"/>
        <bm:field name="tax_type_rate" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TAX_TYPE_RATE" prompt="CONTRACT_ET_CASHFLOW_LN.TAX_TYPE_RATE"/>
        <bm:field name="receivables_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RECEIVABLES_TYPE" prompt="CONTRACT_ET_CASHFLOW_LN.RECEIVABLES_TYPE"/>
    </bm:fields>
    <bm:features>
        <f:standard-who xmlns:f="leaf.database.features"/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="et_agreement_line_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field name="et_agreement_id" queryExpression="et_agreement_id = ${@et_agreement_id}"/>
    </bm:query-fields>
</bm:model>