<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: gaoyang $Date: 2013-6-24 下午04:30:53 $Revision: 1.0 $Purpose: --> <bm:model xmlns:s="leaf.plugin.script" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" alias="t1" baseTable="CON_CONTRACT_V" defaultOrderBy="t1.contract_number desc"> <bm:fields> <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID" prompt="CON301.CON_CONTRACT_V.CONTRACT_ID"/> <bm:field name="calc_session_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CALC_SESSION_ID" prompt="CON301.CON_CONTRACT_V.CALC_SESSION_ID"/> <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NUMBER" prompt="CON301.CON_CONTRACT_V.CONTRACT_NUMBER"/> <bm:field name="contract_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_NAME" prompt="CON301.CON_CONTRACT_V.CONTRACT_NAME"/> <bm:field name="business_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSINESS_TYPE" prompt="CON301.CON_CONTRACT_V.BUSINESS_TYPE"/> <bm:field name="business_type_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSINESS_TYPE_DESC" prompt="CON301.CON_CONTRACT_V.BUSINESS_TYPE_DESC"/> <bm:field name="document_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_TYPE" prompt="CON301.CON_CONTRACT_V.DOCUMENT_TYPE"/> <bm:field name="document_type_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_TYPE_DESC" prompt="CON301.CON_CONTRACT_V.DOCUMENT_TYPE_DESC"/> <bm:field name="document_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_CATEGORY" prompt="CON301.CON_CONTRACT_V.DOCUMENT_CATEGORY"/> <bm:field name="document_category_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_CATEGORY_DESC" prompt="CON301.CON_CONTRACT_V.DOCUMENT_CATEGORY_DESC"/> <bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROJECT_ID" prompt="CON301.CON_CONTRACT_V.PROJECT_ID"/> <bm:field name="project_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROJECT_NUMBER" prompt="CON301.CON_CONTRACT_V.PROJECT_NUMBER"/> <bm:field name="project_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROJECT_NAME" prompt="CON301.CON_CONTRACT_V.PROJECT_NAME"/> <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID" prompt="CON301.CON_CONTRACT_V.COMPANY_ID"/> <bm:field name="lease_organization" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_ORGANIZATION" prompt="CON301.CON_CONTRACT_V.LEASE_ORGANIZATION"/> <bm:field name="lease_organization_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_ORGANIZATION_DESC" prompt="CON301.CON_CONTRACT_V.LEASE_ORGANIZATION_DESC"/> <bm:field name="lease_channel" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_CHANNEL" prompt="CON301.CON_CONTRACT_V.LEASE_CHANNEL"/> <bm:field name="lease_channel_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_CHANNEL_DESC" prompt="CON301.CON_CONTRACT_V.LEASE_CHANNEL_DESC"/> <bm:field name="division" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION" prompt="CON301.CON_CONTRACT_V.DIVISION"/> <bm:field name="division_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION_DESC" prompt="CON301.CON_CONTRACT_V.DIVISION_DESC"/> <bm:field name="bp_id_tenant" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_TENANT" prompt="CON301.CON_CONTRACT_V.BP_ID_TENANT"/> <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME" prompt="CON301.CON_CONTRACT_V.BP_NAME"/> <bm:field name="bp_id_agent_level1" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_AGENT_LEVEL1" prompt="CON301.CON_CONTRACT_V.BP_ID_AGENT_LEVEL1"/> <bm:field name="bp_id_agent_level2" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_AGENT_LEVEL2" prompt="CON301.CON_CONTRACT_V.BP_ID_AGENT_LEVEL2"/> <bm:field name="bp_id_agent_level3" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID_AGENT_LEVEL3" prompt="CON301.CON_CONTRACT_V.BP_ID_AGENT_LEVEL3"/> <bm:field name="owner_user_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OWNER_USER_ID" prompt="CON301.CON_CONTRACT_V.OWNER_USER_ID"/> <bm:field name="employee_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EMPLOYEE_ID" prompt="CON301.CON_CONTRACT_V.EMPLOYEE_ID"/> <bm:field name="employee_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMPLOYEE_CODE" prompt="CON301.CON_CONTRACT_V.EMPLOYEE_CODE"/> <bm:field name="employee_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMPLOYEE_NAME" prompt="CON301.CON_CONTRACT_V.EMPLOYEE_NAME"/> <bm:field name="unit_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="UNIT_ID" prompt="CON301.CON_CONTRACT_V.UNIT_ID"/> <bm:field name="unit_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UNIT_CODE" prompt="CON301.CON_CONTRACT_V.UNIT_CODE"/> <bm:field name="unit_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UNIT_NAME" prompt="CON301.CON_CONTRACT_V.UNIT_NAME"/> <bm:field name="employee_id_of_manager" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EMPLOYEE_ID_OF_MANAGER" prompt="CON301.CON_CONTRACT_V.EMPLOYEE_ID_OF_MANAGER"/> <bm:field name="employee_code_of_manager" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMPLOYEE_CODE_OF_MANAGER" prompt="CON301.CON_CONTRACT_V.EMPLOYEE_CODE_OF_MANAGER"/> <bm:field name="employee_name_of_manager" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMPLOYEE_NAME_OF_MANAGER" prompt="CON301.CON_CONTRACT_V.EMPLOYEE_NAME_OF_MANAGER"/> <bm:field name="factoring_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FACTORING_TYPE" prompt="CON301.CON_CONTRACT_V.FACTORING_TYPE"/> <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="CON301.CON_CONTRACT_V.DESCRIPTION"/> <bm:field name="price_list" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRICE_LIST" prompt="CON301.CON_CONTRACT_V.PRICE_LIST"/> <bm:field name="calc_method" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CALC_METHOD" prompt="CON301.CON_CONTRACT_V.CALC_METHOD"/> <bm:field name="inception_of_lease" databaseType="DATE" datatype="java.util.Date" physicalName="INCEPTION_OF_LEASE" prompt="CON301.CON_CONTRACT_V.INCEPTION_OF_LEASE"/> <bm:field name="lease_start_date" databaseType="DATE" datatype="java.util.Date" physicalName="LEASE_START_DATE" prompt="CON301.CON_CONTRACT_V.LEASE_START_DATE"/> <bm:field name="first_pay_date" databaseType="DATE" datatype="java.util.Date" physicalName="FIRST_PAY_DATE" prompt="CON301.CON_CONTRACT_V.FIRST_PAY_DATE"/> <bm:field name="last_pay_date" databaseType="DATE" datatype="java.util.Date" physicalName="LAST_PAY_DATE" prompt="CON301.CON_CONTRACT_V.LAST_PAY_DATE"/> <bm:field name="lease_end_date" databaseType="DATE" datatype="java.util.Date" physicalName="LEASE_END_DATE" prompt="CON301.CON_CONTRACT_V.LEASE_END_DATE"/> <bm:field name="lease_times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_TIMES" prompt="CON301.CON_CONTRACT_V.LEASE_TIMES"/> <bm:field name="pay_times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PAY_TIMES" prompt="CON301.CON_CONTRACT_V.PAY_TIMES"/> <bm:field name="annual_pay_times" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ANNUAL_PAY_TIMES" prompt="CON301.CON_CONTRACT_V.ANNUAL_PAY_TIMES"/> <bm:field name="lease_term" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_TERM" prompt="CON301.CON_CONTRACT_V.LEASE_TERM"/> <bm:field name="pay_type" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PAY_TYPE" prompt="CON301.CON_CONTRACT_V.PAY_TYPE"/> <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="CON301.CON_CONTRACT_V.CURRENCY"/> <bm:field name="currency_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY_DESC" prompt="CON301.CON_CONTRACT_V.CURRENCY_DESC"/> <bm:field name="currency_precision" databaseType="NUMBER" datatype="java.lang.Double" physicalName="CURRENCY_PRECISION" prompt="CON301.CON_CONTRACT_V.CURRENCY_PRECISION"/> <bm:field name="machinery_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="MACHINERY_AMOUNT" prompt="CON301.CON_CONTRACT_V.MACHINERY_AMOUNT"/> <bm:field name="parts_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PARTS_AMOUNT" prompt="CON301.CON_CONTRACT_V.PARTS_AMOUNT"/> <bm:field name="lease_item_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_ITEM_AMOUNT" prompt="CON301.CON_CONTRACT_V.LEASE_ITEM_AMOUNT"/> <bm:field name="lease_item_cost" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_ITEM_COST" prompt="CON301.CON_CONTRACT_V.LEASE_ITEM_COST"/> <bm:field name="down_payment" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DOWN_PAYMENT" prompt="CON301.CON_CONTRACT_V.DOWN_PAYMENT"/> <bm:field name="down_payment_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DOWN_PAYMENT_RATIO" prompt="CON301.CON_CONTRACT_V.DOWN_PAYMENT_RATIO"/> <bm:field name="finance_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="FINANCE_AMOUNT" prompt="CON301.CON_CONTRACT_V.FINANCE_AMOUNT"/> <bm:field name="net_finance_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="NET_FINANCE_AMOUNT" prompt="CON301.CON_CONTRACT_V.NET_FINANCE_AMOUNT"/> <bm:field name="total_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TOTAL_INTEREST" prompt="CON301.CON_CONTRACT_V.TOTAL_INTEREST"/> <bm:field name="total_rental" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TOTAL_RENTAL" prompt="CON301.CON_CONTRACT_V.TOTAL_RENTAL"/> <bm:field name="total_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TOTAL_FEE" prompt="CON301.CON_CONTRACT_V.TOTAL_FEE"/> <bm:field name="contract_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="CONTRACT_AMOUNT" prompt="CON301.CON_CONTRACT_V.CONTRACT_AMOUNT"/> <bm:field name="tax_type_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="TAX_TYPE_ID" prompt="CON301.CON_CONTRACT_V.TAX_TYPE_ID"/> <bm:field name="vat_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="VAT_FLAG" prompt="CON301.CON_CONTRACT_V.VAT_FLAG"/> <bm:field name="vat_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_RATE" prompt="CON301.CON_CONTRACT_V.VAT_RATE"/> <bm:field name="vat_input" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_INPUT" prompt="CON301.CON_CONTRACT_V.VAT_INPUT"/> <bm:field name="vat_total_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_TOTAL_INTEREST" prompt="CON301.CON_CONTRACT_V.VAT_TOTAL_INTEREST"/> <bm:field name="vat_total_principal" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_TOTAL_PRINCIPAL" prompt="CON301.CON_CONTRACT_V.VAT_TOTAL_PRINCIPAL"/> <bm:field name="vat_total_rental" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_TOTAL_RENTAL" prompt="CON301.CON_CONTRACT_V.VAT_TOTAL_RENTAL"/> <bm:field name="vat_total_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_TOTAL_FEE" prompt="CON301.CON_CONTRACT_V.VAT_TOTAL_FEE"/> <bm:field name="lease_charge" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_CHARGE" prompt="CON301.CON_CONTRACT_V.LEASE_CHARGE"/> <bm:field name="lease_charge_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_CHARGE_RATIO" prompt="CON301.CON_CONTRACT_V.LEASE_CHARGE_RATIO"/> <bm:field name="lease_mgt_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_MGT_FEE" prompt="CON301.CON_CONTRACT_V.LEASE_MGT_FEE"/> <bm:field name="lease_mgt_fee_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="LEASE_MGT_FEE_RATIO" prompt="CON301.CON_CONTRACT_V.LEASE_MGT_FEE_RATIO"/> <bm:field name="lease_mgt_fee_rule" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_MGT_FEE_RULE" prompt="CON301.CON_CONTRACT_V.LEASE_MGT_FEE_RULE"/> <bm:field name="deposit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DEPOSIT" prompt="CON301.CON_CONTRACT_V.DEPOSIT"/> <bm:field name="deposit_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DEPOSIT_RATIO" prompt="CON301.CON_CONTRACT_V.DEPOSIT_RATIO"/> <bm:field name="deposit_deduction" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT_DEDUCTION" prompt="CON301.CON_CONTRACT_V.DEPOSIT_DEDUCTION"/> <bm:field name="residual_value" databaseType="NUMBER" datatype="java.lang.Double" physicalName="RESIDUAL_VALUE" prompt="CON301.CON_CONTRACT_V.RESIDUAL_VALUE"/> <bm:field name="residual_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="RESIDUAL_RATIO" prompt="CON301.CON_CONTRACT_V.RESIDUAL_RATIO"/> <bm:field name="balloon" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BALLOON" prompt="CON301.CON_CONTRACT_V.BALLOON"/> <bm:field name="balloon_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BALLOON_RATIO" prompt="CON301.CON_CONTRACT_V.BALLOON_RATIO"/> <bm:field name="interim_rent_period" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INTERIM_RENT_PERIOD" prompt="CON301.CON_CONTRACT_V.INTERIM_RENT_PERIOD"/> <bm:field name="interim_times" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTERIM_TIMES" prompt="CON301.CON_CONTRACT_V.INTERIM_TIMES"/> <bm:field name="interim_rental" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INTERIM_RENTAL" prompt="CON301.CON_CONTRACT_V.INTERIM_RENTAL"/> <bm:field name="insurance_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INSURANCE_FEE" prompt="CON301.CON_CONTRACT_V.INSURANCE_FEE"/> <bm:field name="insurance_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INSURANCE_RATE" prompt="CON301.CON_CONTRACT_V.INSURANCE_RATE"/> <bm:field name="commission_payable" databaseType="NUMBER" datatype="java.lang.Double" physicalName="COMMISSION_PAYABLE" prompt="CON301.CON_CONTRACT_V.COMMISSION_PAYABLE"/> <bm:field name="commission_receivable" databaseType="NUMBER" datatype="java.lang.Double" physicalName="COMMISSION_RECEIVABLE" prompt="CON301.CON_CONTRACT_V.COMMISSION_RECEIVABLE"/> <bm:field name="third_party_deposit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="THIRD_PARTY_DEPOSIT" prompt="CON301.CON_CONTRACT_V.THIRD_PARTY_DEPOSIT"/> <bm:field name="promise_to_pay" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PROMISE_TO_PAY" prompt="CON301.CON_CONTRACT_V.PROMISE_TO_PAY"/> <bm:field name="other_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OTHER_FEE" prompt="CON301.CON_CONTRACT_V.OTHER_FEE"/> <bm:field name="other_payment" databaseType="NUMBER" datatype="java.lang.Double" physicalName="OTHER_PAYMENT" prompt="CON301.CON_CONTRACT_V.OTHER_PAYMENT"/> <bm:field name="rounding_object" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ROUNDING_OBJECT" prompt="CON301.CON_CONTRACT_V.ROUNDING_OBJECT"/> <bm:field name="rounding_method" databaseType="NUMBER" datatype="java.lang.Double" physicalName="ROUNDING_METHOD" prompt="CON301.CON_CONTRACT_V.ROUNDING_METHOD"/> <bm:field name="int_rate_fixing_way" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INT_RATE_FIXING_WAY" prompt="CON301.CON_CONTRACT_V.INT_RATE_FIXING_WAY"/> <bm:field name="int_rate_fixing_range" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INT_RATE_FIXING_RANGE" prompt="CON301.CON_CONTRACT_V.INT_RATE_FIXING_RANGE"/> <bm:field name="int_rate_display" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INT_RATE_DISPLAY" prompt="CON301.CON_CONTRACT_V.INT_RATE_DISPLAY"/> <bm:field name="base_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BASE_RATE_TYPE" prompt="CON301.CON_CONTRACT_V.BASE_RATE_TYPE"/> <bm:field name="base_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BASE_RATE" prompt="CON301.CON_CONTRACT_V.BASE_RATE"/> <bm:field name="int_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INT_RATE" prompt="CON301.CON_CONTRACT_V.INT_RATE"/> <bm:field name="int_rate_implicit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INT_RATE_IMPLICIT" prompt="CON301.CON_CONTRACT_V.INT_RATE_IMPLICIT"/> <bm:field name="int_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INT_RATE_TYPE" prompt="CON301.CON_CONTRACT_V.INT_RATE_TYPE"/> <bm:field name="flt_rate_profile" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FLT_RATE_PROFILE" prompt="CON301.CON_CONTRACT_V.FLT_RATE_PROFILE"/> <bm:field name="flt_rate_adj_method" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FLT_RATE_ADJ_METHOD" prompt="CON301.CON_CONTRACT_V.FLT_RATE_ADJ_METHOD"/> <bm:field name="flt_simulate_step" databaseType="NUMBER" datatype="java.lang.Double" physicalName="FLT_SIMULATE_STEP" prompt="CON301.CON_CONTRACT_V.FLT_SIMULATE_STEP"/> <bm:field name="flt_simulate_range" databaseType="NUMBER" datatype="java.lang.Double" physicalName="FLT_SIMULATE_RANGE" prompt="CON301.CON_CONTRACT_V.FLT_SIMULATE_RANGE"/> <bm:field name="flt_unit_adj_amt" databaseType="NUMBER" datatype="java.lang.Double" physicalName="FLT_UNIT_ADJ_AMT" prompt="CON301.CON_CONTRACT_V.FLT_UNIT_ADJ_AMT"/> <bm:field name="flt_execute_times_rule" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FLT_EXECUTE_TIMES_RULE" prompt="CON301.CON_CONTRACT_V.FLT_EXECUTE_TIMES_RULE"/> <bm:field name="flt_int_rate_adj_date" databaseType="DATE" datatype="java.util.Date" physicalName="FLT_INT_RATE_ADJ_DATE" prompt="CON301.CON_CONTRACT_V.FLT_INT_RATE_ADJ_DATE"/> <bm:field name="int_rate_precision" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INT_RATE_PRECISION" prompt="CON301.CON_CONTRACT_V.INT_RATE_PRECISION"/> <bm:field name="irr" databaseType="NUMBER" datatype="java.lang.Double" physicalName="IRR" prompt="CON301.CON_CONTRACT_V.IRR"/> <bm:field name="irr_after_tax" databaseType="NUMBER" datatype="java.lang.Double" physicalName="IRR_AFTER_TAX" prompt="CON301.CON_CONTRACT_V.IRR_AFTER_TAX"/> <bm:field name="int_rate_implicit_after_tax" databaseType="NUMBER" datatype="java.lang.Double" physicalName="INT_RATE_IMPLICIT_AFTER_TAX" prompt="CON301.CON_CONTRACT_V.INT_RATE_IMPLICIT_AFTER_TAX"/> <bm:field name="irr_reserved1" databaseType="NUMBER" datatype="java.lang.Double" physicalName="IRR_RESERVED1" prompt="CON301.CON_CONTRACT_V.IRR_RESERVED1"/> <bm:field name="irr_reserved2" databaseType="NUMBER" datatype="java.lang.Double" physicalName="IRR_RESERVED2" prompt="CON301.CON_CONTRACT_V.IRR_RESERVED2"/> <bm:field name="irr_reserved3" databaseType="NUMBER" datatype="java.lang.Double" physicalName="IRR_RESERVED3" prompt="CON301.CON_CONTRACT_V.IRR_RESERVED3"/> <bm:field name="pmt" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PMT" prompt="CON301.CON_CONTRACT_V.PMT"/> <bm:field name="pmt_first" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PMT_FIRST" prompt="CON301.CON_CONTRACT_V.PMT_FIRST"/> <bm:field name="annual_mean_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="ANNUAL_MEAN_RATE" prompt="CON301.CON_CONTRACT_V.ANNUAL_MEAN_RATE"/> <bm:field name="total_salestax" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TOTAL_SALESTAX" prompt="CON301.CON_CONTRACT_V.TOTAL_SALESTAX"/> <bm:field name="biz_day_convention" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BIZ_DAY_CONVENTION" prompt="CON301.CON_CONTRACT_V.BIZ_DAY_CONVENTION"/> <bm:field name="calc_with_residual_value" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CALC_WITH_RESIDUAL_VALUE" prompt="CON301.CON_CONTRACT_V.CALC_WITH_RESIDUAL_VALUE"/> <bm:field name="exchange_rate_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_TYPE" prompt="CON301.CON_CONTRACT_V.EXCHANGE_RATE_TYPE"/> <bm:field name="exchange_rate_type_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_TYPE_DESC" prompt="CON301.CON_CONTRACT_V.EXCHANGE_RATE_TYPE_DESC"/> <bm:field name="exchange_rate_quotation" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXCHANGE_RATE_QUOTATION" prompt="CON301.CON_CONTRACT_V.EXCHANGE_RATE_QUOTATION"/> <bm:field name="exchange_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="EXCHANGE_RATE" prompt="CON301.CON_CONTRACT_V.EXCHANGE_RATE"/> <bm:field name="penalty_profile" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PENALTY_PROFILE" prompt="CON301.CON_CONTRACT_V.PENALTY_PROFILE"/> <bm:field name="grace_period" databaseType="NUMBER" datatype="java.lang.Double" physicalName="GRACE_PERIOD" prompt="CON301.CON_CONTRACT_V.GRACE_PERIOD"/> <bm:field name="penalty_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PENALTY_RATE" prompt="CON301.CON_CONTRACT_V.PENALTY_RATE"/> <bm:field name="penalty_calc_base" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PENALTY_CALC_BASE" prompt="CON301.CON_CONTRACT_V.PENALTY_CALC_BASE"/> <bm:field name="penalty_total_base_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PENALTY_TOTAL_BASE_RATIO" prompt="CON301.CON_CONTRACT_V.PENALTY_TOTAL_BASE_RATIO"/> <bm:field name="credit_write_off_order" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CREDIT_WRITE_OFF_ORDER" prompt="CON301.CON_CONTRACT_V.CREDIT_WRITE_OFF_ORDER"/> <bm:field name="fin_income_recognize_method" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIN_INCOME_RECOGNIZE_METHOD" prompt="CON301.CON_CONTRACT_V.FIN_INCOME_RECOGNIZE_METHOD"/> <bm:field name="early_termination_profile" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EARLY_TERMINATION_PROFILE" prompt="CON301.CON_CONTRACT_V.EARLY_TERMINATION_PROFILE"/> <bm:field name="payment_method_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PAYMENT_METHOD_ID" prompt="CON301.CON_CONTRACT_V.PAYMENT_METHOD_ID"/> <bm:field name="telex_transfer_bank_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="TELEX_TRANSFER_BANK_ID" prompt="CON301.CON_CONTRACT_V.TELEX_TRANSFER_BANK_ID"/> <bm:field name="tt_bank_branch_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TT_BANK_BRANCH_NAME" prompt="CON301.CON_CONTRACT_V.TT_BANK_BRANCH_NAME"/> <bm:field name="tt_bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TT_BANK_ACCOUNT_NUM" prompt="CON301.CON_CONTRACT_V.TT_BANK_ACCOUNT_NUM"/> <bm:field name="tt_bank_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TT_BANK_ACCOUNT_NAME" prompt="CON301.CON_CONTRACT_V.TT_BANK_ACCOUNT_NAME"/> <bm:field name="tt_remark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TT_REMARK" prompt="CON301.CON_CONTRACT_V.TT_REMARK"/> <bm:field name="direct_debit_bank_id" databaseType="NUMBER" datatype="java.lang.Double" physicalName="DIRECT_DEBIT_BANK_ID" prompt="CON301.CON_CONTRACT_V.DIRECT_DEBIT_BANK_ID"/> <bm:field name="dd_bank_branch_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_BRANCH_NAME" prompt="CON301.CON_CONTRACT_V.DD_BANK_BRANCH_NAME"/> <bm:field name="dd_bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_ACCOUNT_NUM" prompt="CON301.CON_CONTRACT_V.DD_BANK_ACCOUNT_NUM"/> <bm:field name="dd_bank_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_BANK_ACCOUNT_NAME" prompt="CON301.CON_CONTRACT_V.DD_BANK_ACCOUNT_NAME"/> <bm:field name="dd_agreement_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_AGREEMENT_NO" prompt="CON301.CON_CONTRACT_V.DD_AGREEMENT_NO"/> <bm:field name="dd_agreement_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_AGREEMENT_STATUS" prompt="CON301.CON_CONTRACT_V.DD_AGREEMENT_STATUS"/> <bm:field name="dd_remark" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DD_REMARK" prompt="CON301.CON_CONTRACT_V.DD_REMARK"/> <bm:field name="purchase_order_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PURCHASE_ORDER_NO" prompt="CON301.CON_CONTRACT_V.PURCHASE_ORDER_NO"/> <bm:field name="contract_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_STATUS" prompt="CON301.CON_CONTRACT_V.CONTRACT_STATUS"/> <bm:field name="contract_status_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTRACT_STATUS_DESC" prompt="CON301.CON_CONTRACT_V.CONTRACT_STATUS_DESC"/> <bm:field name="user_status_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USER_STATUS_1" prompt="CON301.CON_CONTRACT_V.USER_STATUS_1"/> <bm:field name="user_status_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USER_STATUS_2" prompt="CON301.CON_CONTRACT_V.USER_STATUS_2"/> <bm:field name="user_status_3" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USER_STATUS_3" prompt="CON301.CON_CONTRACT_V.USER_STATUS_3"/> <bm:field name="print_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRINT_STATUS" prompt="CON301.CON_CONTRACT_V.PRINT_STATUS"/> <bm:field name="print_status_desc" databaseType="VARCHAR2" datatype="java.lang.String" expression="(select decode(t1.print_status,'PRINTED','已打印','未打印') from dual)" physicalName="PRINT_STATUS" prompt="CON301.CON_CONTRACT_V.PRINT_STATUS"/> <bm:field name="print_times" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRINT_TIMES" prompt="CON301.CON_CONTRACT_V.PRINT_TIMES"/> <bm:field name="first_print_date" databaseType="DATE" datatype="java.util.Date" physicalName="FIRST_PRINT_DATE" prompt="CON301.CON_CONTRACT_V.FIRST_PRINT_DATE"/> <bm:field name="first_print_by" databaseType="NUMBER" datatype="java.lang.Double" physicalName="FIRST_PRINT_BY" prompt="CON301.CON_CONTRACT_V.FIRST_PRINT_BY"/> <bm:field name="delivery_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DELIVERY_STATUS" prompt="CON301.CON_CONTRACT_V.DELIVERY_STATUS"/> <bm:field name="delivery_date" databaseType="DATE" datatype="java.util.Date" physicalName="DELIVERY_DATE" prompt="CON301.CON_CONTRACT_V.DELIVERY_DATE"/> <bm:field name="billing_method" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BILLING_METHOD" prompt="CON301.CON_CONTRACT_V.BILLING_METHOD"/> <bm:field name="billing_method_desc" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BILLING_METHOD_DESC" prompt="CON301.CON_CONTRACT_V.BILLING_METHOD_DESC"/> <bm:field name="billing_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BILLING_STATUS" prompt="CON301.CON_CONTRACT_V.BILLING_STATUS"/> <bm:field name="signing_date" databaseType="DATE" datatype="java.util.Date" physicalName="SIGNING_DATE" prompt="CON301.CON_CONTRACT_V.SIGNING_DATE"/> <bm:field name="original_recall_date" databaseType="DATE" datatype="java.util.Date" physicalName="ORIGINAL_RECALL_DATE" prompt="CON301.CON_CONTRACT_V.ORIGINAL_RECALL_DATE"/> <bm:field name="lease_card_recall_date" databaseType="DATE" datatype="java.util.Date" physicalName="LEASE_CARD_RECALL_DATE" prompt="CON301.CON_CONTRACT_V.LEASE_CARD_RECALL_DATE"/> <bm:field name="early_termination_date" databaseType="DATE" datatype="java.util.Date" physicalName="EARLY_TERMINATION_DATE" prompt="CON301.CON_CONTRACT_V.EARLY_TERMINATION_DATE"/> <bm:field name="termination_date" databaseType="DATE" datatype="java.util.Date" physicalName="TERMINATION_DATE" prompt="CON301.CON_CONTRACT_V.TERMINATION_DATE"/> <bm:field name="assignment_agreement_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ASSIGNMENT_AGREEMENT_NO" prompt="CON301.CON_CONTRACT_V.ASSIGNMENT_AGREEMENT_NO"/> <bm:field name="assignment_date" databaseType="DATE" datatype="java.util.Date" physicalName="ASSIGNMENT_DATE" prompt="CON301.CON_CONTRACT_V.ASSIGNMENT_DATE"/> <bm:field name="btb_payment_date" databaseType="DATE" datatype="java.util.Date" physicalName="BTB_PAYMENT_DATE" prompt="CON301.CON_CONTRACT_V.BTB_PAYMENT_DATE"/> <bm:field name="btb_int_rate" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_INT_RATE" prompt="CON301.CON_CONTRACT_V.BTB_INT_RATE"/> <bm:field name="btb_int_rate_implicit" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_INT_RATE_IMPLICIT" prompt="CON301.CON_CONTRACT_V.BTB_INT_RATE_IMPLICIT"/> <bm:field name="btb_finance_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_FINANCE_AMOUNT" prompt="CON301.CON_CONTRACT_V.BTB_FINANCE_AMOUNT"/> <bm:field name="btb_net_finance_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_NET_FINANCE_AMOUNT" prompt="CON301.CON_CONTRACT_V.BTB_NET_FINANCE_AMOUNT"/> <bm:field name="btb_total_repayment" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_TOTAL_REPAYMENT" prompt="CON301.CON_CONTRACT_V.BTB_TOTAL_REPAYMENT"/> <bm:field name="btb_total_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_TOTAL_INTEREST" prompt="CON301.CON_CONTRACT_V.BTB_TOTAL_INTEREST"/> <bm:field name="btb_total_fee_pv" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_TOTAL_FEE_PV" prompt="CON301.CON_CONTRACT_V.BTB_TOTAL_FEE_PV"/> <bm:field name="btb_total_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_TOTAL_FEE" prompt="CON301.CON_CONTRACT_V.BTB_TOTAL_FEE"/> <bm:field name="btb_finance_ratio" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_FINANCE_RATIO" prompt="CON301.CON_CONTRACT_V.BTB_FINANCE_RATIO"/> <bm:field name="btb_interest_margin" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_INTEREST_MARGIN" prompt="CON301.CON_CONTRACT_V.BTB_INTEREST_MARGIN"/> <bm:field name="btb_vat_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_VAT_INTEREST" prompt="CON301.CON_CONTRACT_V.BTB_VAT_INTEREST"/> <bm:field name="btb_vat_fee" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_VAT_FEE" prompt="CON301.CON_CONTRACT_V.BTB_VAT_FEE"/> <bm:field name="btb_interest_after_tax" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_INTEREST_AFTER_TAX" prompt="CON301.CON_CONTRACT_V.BTB_INTEREST_AFTER_TAX"/> <bm:field name="btb_fee_after_tax" databaseType="NUMBER" datatype="java.lang.Double" physicalName="BTB_FEE_AFTER_TAX" prompt="CON301.CON_CONTRACT_V.BTB_FEE_AFTER_TAX"/> <bm:field name="cdd_list_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CDD_LIST_ID" prompt="CON301.CON_CONTRACT_V.CDD_LIST_ID"/> <bm:field name="vat_rate_of_interest" databaseType="NUMBER" datatype="java.lang.Double" physicalName="VAT_RATE_OF_INTEREST" prompt="CON301.CON_CONTRACT_V.VAT_RATE_OF_INTEREST"/> <bm:field name="hd_user_col_d01" databaseType="DATE" datatype="java.util.Date" physicalName="HD_USER_COL_D01" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_D01"/> <bm:field name="hd_user_col_d02" databaseType="DATE" datatype="java.util.Date" physicalName="HD_USER_COL_D02" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_D02"/> <bm:field name="hd_user_col_d03" databaseType="DATE" datatype="java.util.Date" physicalName="HD_USER_COL_D03" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_D03"/> <bm:field name="hd_user_col_d04" databaseType="DATE" datatype="java.util.Date" physicalName="HD_USER_COL_D04" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_D04"/> <bm:field name="hd_user_col_d05" databaseType="DATE" datatype="java.util.Date" physicalName="HD_USER_COL_D05" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_D05"/> <bm:field name="hd_user_col_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V01" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V01"/> <bm:field name="hd_user_col_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V02" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V02"/> <bm:field name="hd_user_col_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V03" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V03"/> <bm:field name="hd_user_col_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V04" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V04"/> <bm:field name="hd_user_col_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V05" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V05"/> <bm:field name="hd_user_col_v06" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V06" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V06"/> <bm:field name="hd_user_col_v07" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V07" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V07"/> <bm:field name="hd_user_col_v08" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V08" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V08"/> <bm:field name="hd_user_col_v09" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V09" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V09"/> <bm:field name="hd_user_col_v10" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HD_USER_COL_V10" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_V10"/> <bm:field name="hd_user_col_n01" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N01" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N01"/> <bm:field name="hd_user_col_n02" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N02" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N02"/> <bm:field name="hd_user_col_n03" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N03" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N03"/> <bm:field name="hd_user_col_n04" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N04" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N04"/> <bm:field name="hd_user_col_n05" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N05" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N05"/> <bm:field name="hd_user_col_n06" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N06" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N06"/> <bm:field name="hd_user_col_n07" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N07" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N07"/> <bm:field name="hd_user_col_n08" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N08" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N08"/> <bm:field name="hd_user_col_n09" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N09" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N09"/> <bm:field name="hd_user_col_n10" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N10" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N10"/> <bm:field name="hd_user_col_n11" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N11" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N11"/> <bm:field name="hd_user_col_n12" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N12" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N12"/> <bm:field name="hd_user_col_n13" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N13" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N13"/> <bm:field name="hd_user_col_n14" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N14" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N14"/> <bm:field name="hd_user_col_n15" databaseType="NUMBER" datatype="java.lang.Double" physicalName="HD_USER_COL_N15" prompt="CON301.CON_CONTRACT_V.HD_USER_COL_N15"/> <bm:field name="prj_search_term_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRJ_SEARCH_TERM_1" prompt="CON301.CON_CONTRACT_V.PRJ_SEARCH_TERM_1"/> <bm:field name="prj_search_term_2" databaseType="NUMBER" datatype="java.lang.Double" physicalName="PRJ_SEARCH_TERM_2" prompt="CON301.CON_CONTRACT_V.PRJ_SEARCH_TERM_2"/> <bm:field name="con_search_term_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CON_SEARCH_TERM_1" prompt="CON301.CON_CONTRACT_V.CON_SEARCH_TERM_1"/> <bm:field name="con_search_term_2" databaseType="NUMBER" datatype="java.lang.Double" physicalName="CON_SEARCH_TERM_2" prompt="CON301.CON_CONTRACT_V.CON_SEARCH_TERM_2"/> <bm:field name="con_content_confirm_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CON_CONTENT_CONFIRM_STATUS" prompt="CON301.CON_CONTRACT_V.CON_CONTENT_CONFIRM_STATUS"/> <bm:field name="owner_user_id_n" expression="(select a.description from sys_user a where a.user_id=t1.owner_user_id)"/> </bm:fields> <bm:features> <f:standard-who/> <s:bm-script><![CDATA[ var cx = Packages.leaf.javascript.Context.getCurrentContext(); Packages.leaf.plugin.script.engine.ScriptImportor.defineExternScript(cx, this, $ctx.getData(), "aut_authority_bm_validate.js"); ]]></s:bm-script> </bm:features> <bm:query-fields> <bm:query-field name="update_flag" queryExpression="(t1.contract_status in ('NEW') and nvl(${@update_flag},'N')='Y')"/> <bm:query-field name="contract_ref_content_flag" queryExpression="(t1.contract_status in ('NEW','INCEPT','SIGN','PAID','APPROVING') and nvl(${@contract_ref_content_flag},'N')='Y')"/> <bm:query-field field="bp_id_tenant" queryOperator="="/> <bm:query-field field="project_id" queryOperator="="/> <bm:query-field field="employee_id" queryOperator="="/> <bm:query-field field="employee_id_of_manager" queryOperator="="/> <bm:query-field field="unit_id" queryOperator="="/> <bm:query-field field="lease_organization" queryOperator="="/> <bm:query-field field="division" queryOperator="="/> <bm:query-field field="lease_channel" queryOperator="="/> <bm:query-field field="document_type" queryOperator="="/> <bm:query-field field="document_category" queryOperator="="/> <bm:query-field field="contract_status" queryOperator="="/> <bm:query-field field="contract_number" queryOperator="like"/> <bm:query-field field="business_type" queryOperator="="/> <bm:query-field name="inception_of_lease_from" queryExpression="inception_of_lease >= ${@document_date_from}"/> <bm:query-field name="inception_of_lease_to" queryExpression="inception_of_lease <= ${@document_date_to}"/> <bm:query-field field="contract_id" queryOperator="="/> <bm:query-field name="lease_start_date_from" queryExpression="lease_start_date >= to_date(${@lease_start_date_from},'yyyy-mm-dd')"/> <bm:query-field name="lease_start_date_to" queryExpression="lease_start_date <= to_date(${@lease_start_date_to},'yyyy-mm-dd')"/> <bm:query-field field="bp_name" queryOperator="like"/> <bm:query-field field="project_number" queryOperator="="/> <bm:query-field field="project_name" queryOperator="like"/> <bm:query-field field="contract_name" queryOperator="like"/> <bm:query-field field="prj_search_term_1" queryOperator="like"/> <bm:query-field field="prj_search_term_2" queryOperator="like"/> <bm:query-field field="con_search_term_1" queryOperator="like"/> <bm:query-field field="con_search_term_2" queryOperator="like"/> <bm:query-field field="owner_user_id" queryOperator="="/> <bm:query-field name="quotation_change_req_flag" queryExpression="(${@quotation_change_req_flag}='Y' and t1.contract_status in ('NEW','PAID'))"/> <bm:query-field name="content_notarize_flag" queryExpression="(${@content_notarize_flag}='Y' and t1.contract_status in ('NEW','PAID','SIGN','INCEPT') and t1.print_status='PRINTED')"/> <bm:query-field field="print_status" queryOperator="="/> </bm:query-fields> <bm:data-filters> <bm:data-filter name="query" expression="t1.con_content_confirm_status='Y' and nvl(t1.con_maintain_flag,'N')='Y' and t1.spv_company_id = ${/session/@company_id}"/> </bm:data-filters> </bm:model>