<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: hand $Date: 2016-5-10 下午5:07:05 $Revision: 1.0 $Purpose: --> <bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="HLS_BP_MASTER"> <bm:fields> <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" prompt="HLS_BP_MASTER.BP_ID"/> <bm:field name="owner_user_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OWNER_USER_ID" prompt="HLS_BP_MASTER.OWNER_USER_ID"/> <bm:field name="bp_code" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="BP_CODE" prompt="编码"/> <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="BP_NAME" prompt="代理商"/> <bm:field name="extra_nam" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXTRA_NAM" prompt="HLS_BP_MASTER.EXTRA_NAM"/> <bm:field name="bp_class" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_CLASS" prompt="HLS_BP_MASTER.BP_CLASS"/> <bm:field name="bp_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_CATEGORY" prompt="HLS_BP_MASTER.BP_CATEGORY"/> <bm:field name="bp_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_TYPE" prompt="HLS_BP_MASTER.BP_TYPE"/> <bm:field name="bp_title" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_TITLE" prompt="HLS_BP_MASTER.BP_TITLE"/> <bm:field name="search_term_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEARCH_TERM_1" prompt="HLS_BP_MASTER.SEARCH_TERM_1"/> <bm:field name="search_term_2" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SEARCH_TERM_2" prompt="HLS_BP_MASTER.SEARCH_TERM_2"/> <bm:field name="external_bp_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EXTERNAL_BP_CODE" prompt="HLS_BP_MASTER.EXTERNAL_BP_CODE"/> <bm:field name="address_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ADDRESS_ID" prompt="HLS_BP_MASTER.ADDRESS_ID"/> <bm:field name="enabled_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENABLED_FLAG" prompt="HLS_BP_MASTER.ENABLED_FLAG"/> <bm:field name="first_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIRST_NAME" prompt="HLS_BP_MASTER.FIRST_NAME"/> <bm:field name="middle_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MIDDLE_NAME" prompt="HLS_BP_MASTER.MIDDLE_NAME"/> <bm:field name="last_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LAST_NAME" prompt="HLS_BP_MASTER.LAST_NAME"/> <bm:field name="gender" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GENDER" prompt="HLS_BP_MASTER.GENDER"/> <bm:field name="nationality" databaseType="NUMBER" datatype="java.lang.Long" physicalName="NATIONALITY" prompt="HLS_BP_MASTER.NATIONALITY"/> <bm:field name="date_of_birth" databaseType="DATE" datatype="java.util.Date" physicalName="DATE_OF_BIRTH" prompt="HLS_BP_MASTER.DATE_OF_BIRTH"/> <bm:field name="place_of_birth" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PLACE_OF_BIRTH" prompt="HLS_BP_MASTER.PLACE_OF_BIRTH"/> <bm:field name="name_at_birth" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NAME_AT_BIRTH" prompt="HLS_BP_MASTER.NAME_AT_BIRTH"/> <bm:field name="marital_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MARITAL_STATUS" prompt="HLS_BP_MASTER.MARITAL_STATUS"/> <bm:field name="number_of_children" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NUMBER_OF_CHILDREN" prompt="HLS_BP_MASTER.NUMBER_OF_CHILDREN"/> <bm:field name="academic_background" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACADEMIC_BACKGROUND" prompt="HLS_BP_MASTER.ACADEMIC_BACKGROUND"/> <bm:field name="age" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="AGE" prompt="HLS_BP_MASTER.AGE"/> <bm:field name="id_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_TYPE" prompt="HLS_BP_MASTER.ID_TYPE"/> <bm:field name="id_card_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_CARD_NO" prompt="HLS_BP_MASTER.ID_CARD_NO"/> <bm:field name="annual_income" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ANNUAL_INCOME" prompt="HLS_BP_MASTER.ANNUAL_INCOME"/> <bm:field name="currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CURRENCY" prompt="HLS_BP_MASTER.CURRENCY"/> <bm:field name="capital_of_family" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CAPITAL_OF_FAMILY" prompt="HLS_BP_MASTER.CAPITAL_OF_FAMILY"/> <bm:field name="liability_of_family" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LIABILITY_OF_FAMILY" prompt="HLS_BP_MASTER.LIABILITY_OF_FAMILY"/> <bm:field name="legal_form" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEGAL_FORM" prompt="HLS_BP_MASTER.LEGAL_FORM"/> <bm:field name="industry" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY" prompt="HLS_BP_MASTER.INDUSTRY"/> <bm:field name="business_license_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSINESS_LICENSE_NUM" prompt="HLS_BP_MASTER.BUSINESS_LICENSE_NUM"/> <bm:field name="corporate_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CORPORATE_CODE" prompt="HLS_BP_MASTER.CORPORATE_CODE"/> <bm:field name="organization_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ORGANIZATION_CODE" prompt="HLS_BP_MASTER.ORGANIZATION_CODE"/> <bm:field name="tax_registry_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TAX_REGISTRY_NUM" prompt="HLS_BP_MASTER.TAX_REGISTRY_NUM"/> <bm:field name="registered_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REGISTERED_PLACE" prompt="HLS_BP_MASTER.REGISTERED_PLACE"/> <bm:field name="founded_date" databaseType="DATE" datatype="java.util.Date" physicalName="FOUNDED_DATE" prompt="HLS_BP_MASTER.FOUNDED_DATE"/> <bm:field name="registered_capital" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REGISTERED_CAPITAL" prompt="HLS_BP_MASTER.REGISTERED_CAPITAL"/> <bm:field name="balance_sheet_currency" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BALANCE_SHEET_CURRENCY" prompt="HLS_BP_MASTER.BALANCE_SHEET_CURRENCY"/> <bm:field name="taxpayer_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="TAXPAYER_TYPE" prompt="HLS_BP_MASTER.TAXPAYER_TYPE"/> <bm:field name="invoice_title" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_TITLE" prompt="HLS_BP_MASTER.INVOICE_TITLE"/> <bm:field name="invoice_bp_address_phone_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_BP_ADDRESS_PHONE_NUM" prompt="HLS_BP_MASTER.INVOICE_BP_ADDRESS_PHONE_NUM"/> <bm:field name="invoice_bp_bank_account" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_BP_BANK_ACCOUNT" prompt="HLS_BP_MASTER.INVOICE_BP_BANK_ACCOUNT"/> <bm:field name="loan_card_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOAN_CARD_NUM" prompt="HLS_BP_MASTER.LOAN_CARD_NUM"/> <bm:field name="paid_up_capital" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PAID_UP_CAPITAL" prompt="HLS_BP_MASTER.PAID_UP_CAPITAL"/> <bm:field name="company_nature" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_NATURE" prompt="HLS_BP_MASTER.COMPANY_NATURE"/> <bm:field name="primary_business" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PRIMARY_BUSINESS" prompt="HLS_BP_MASTER.PRIMARY_BUSINESS"/> <bm:field name="main_products" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAIN_PRODUCTS" prompt="HLS_BP_MASTER.MAIN_PRODUCTS"/> <bm:field name="bp_name_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_NAME_SP" prompt="HLS_BP_MASTER.BP_NAME_SP"/> <bm:field name="gender_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="GENDER_SP" prompt="HLS_BP_MASTER.GENDER_SP"/> <bm:field name="country_sp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COUNTRY_SP" prompt="HLS_BP_MASTER.COUNTRY_SP"/> <bm:field name="province_sp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROVINCE_SP" prompt="HLS_BP_MASTER.PROVINCE_SP"/> <bm:field name="city_sp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CITY_SP" prompt="HLS_BP_MASTER.CITY_SP"/> <bm:field name="id_type_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_TYPE_SP" prompt="HLS_BP_MASTER.ID_TYPE_SP"/> <bm:field name="id_card_no_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_CARD_NO_SP" prompt="HLS_BP_MASTER.ID_CARD_NO_SP"/> <bm:field name="district_sp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="DISTRICT_SP" prompt="HLS_BP_MASTER.DISTRICT_SP"/> <bm:field name="address_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADDRESS_SP" prompt="HLS_BP_MASTER.ADDRESS_SP"/> <bm:field name="ref_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V01" prompt="HLS_BP_MASTER.REF_V01"/> <bm:field name="ref_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V02" prompt="HLS_BP_MASTER.REF_V02"/> <bm:field name="ref_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V03" prompt="HLS_BP_MASTER.REF_V03"/> <bm:field name="ref_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04" prompt="HLS_BP_MASTER.REF_V04"/> <bm:field name="ref_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V05" prompt="HLS_BP_MASTER.REF_V05"/> <bm:field name="ref_v06" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V06" prompt="HLS_BP_MASTER.REF_V06"/> <bm:field name="ref_v07" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V07" prompt="HLS_BP_MASTER.REF_V07"/> <bm:field name="ref_v08" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V08" prompt="HLS_BP_MASTER.REF_V08"/> <bm:field name="ref_v09" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V09" prompt="HLS_BP_MASTER.REF_V09"/> <bm:field name="ref_v10" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V10" prompt="HLS_BP_MASTER.REF_V10"/> <bm:field name="ref_v11" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V11" prompt="HLS_BP_MASTER.REF_V11"/> <bm:field name="ref_v12" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V12" prompt="HLS_BP_MASTER.REF_V12"/> <bm:field name="ref_v13" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V13" prompt="HLS_BP_MASTER.REF_V13"/> <bm:field name="ref_v14" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V14" prompt="HLS_BP_MASTER.REF_V14"/> <bm:field name="ref_v15" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V15" prompt="HLS_BP_MASTER.REF_V15"/> <bm:field name="ref_n01" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N01" prompt="HLS_BP_MASTER.REF_N01"/> <bm:field name="ref_n02" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N02" prompt="HLS_BP_MASTER.REF_N02"/> <bm:field name="ref_n03" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N03" prompt="HLS_BP_MASTER.REF_N03"/> <bm:field name="ref_n04" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N04" prompt="HLS_BP_MASTER.REF_N04"/> <bm:field name="ref_n05" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N05" prompt="HLS_BP_MASTER.REF_N05"/> <bm:field name="ref_n06" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N06" prompt="HLS_BP_MASTER.REF_N06"/> <bm:field name="ref_n07" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N07" prompt="HLS_BP_MASTER.REF_N07"/> <bm:field name="ref_n08" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N08" prompt="HLS_BP_MASTER.REF_N08"/> <bm:field name="ref_n09" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N09" prompt="HLS_BP_MASTER.REF_N09"/> <bm:field name="ref_n10" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N10" prompt="HLS_BP_MASTER.REF_N10"/> <bm:field name="ref_d01" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D01" prompt="HLS_BP_MASTER.REF_D01"/> <bm:field name="ref_d02" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D02" prompt="HLS_BP_MASTER.REF_D02"/> <bm:field name="ref_d03" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D03" prompt="HLS_BP_MASTER.REF_D03"/> <bm:field name="ref_d04" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D04" prompt="HLS_BP_MASTER.REF_D04"/> <bm:field name="ref_d05" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D05" prompt="HLS_BP_MASTER.REF_D05"/> <bm:field name="enterprise_scale" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ENTERPRISE_SCALE" prompt="HLS_BP_MASTER.ENTERPRISE_SCALE"/> <bm:field name="legal_person" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEGAL_PERSON" prompt="HLS_BP_MASTER.LEGAL_PERSON"/> <bm:field name="spouse_phone" databaseType="NUMBER" datatype="java.lang.Long" physicalName="SPOUSE_PHONE" prompt="HLS_BP_MASTER.SPOUSE_PHONE"/> <bm:field name="license_terms" databaseType="DATE" datatype="java.util.Date" physicalName="LICENSE_TERMS" prompt="HLS_BP_MASTER.LICENSE_TERMS"/> <bm:field name="porportion_of_guarantee" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PORPORTION_OF_GUARANTEE" prompt="HLS_BP_MASTER.PORPORTION_OF_GUARANTEE"/> <bm:field name="period_in_job" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PERIOD_IN_JOB" prompt="HLS_BP_MASTER.PERIOD_IN_JOB"/> <bm:field name="net_monthly_income" databaseType="NUMBER" datatype="java.lang.Long" physicalName="NET_MONTHLY_INCOME" prompt="HLS_BP_MASTER.NET_MONTHLY_INCOME"/> <bm:field name="leader_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEADER_FLAG" prompt="HLS_BP_MASTER.LEADER_FLAG"/> <bm:field name="mortgage_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MORTGAGE_FLAG" prompt="HLS_BP_MASTER.MORTGAGE_FLAG"/> <bm:field name="local_person_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LOCAL_PERSON_FLAG" prompt="HLS_BP_MASTER.LOCAL_PERSON_FLAG"/> <bm:field name="high_mental_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HIGH_MENTAL_FLAG" prompt="HLS_BP_MASTER.HIGH_MENTAL_FLAG"/> <bm:field name="has_house_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HAS_HOUSE_FLAG" prompt="HLS_BP_MASTER.HAS_HOUSE_FLAG"/> <bm:field name="has_car_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HAS_CAR_FLAG" prompt="HLS_BP_MASTER.HAS_CAR_FLAG"/> <bm:field name="community_leader_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMMUNITY_LEADER_FLAG" prompt="HLS_BP_MASTER.COMMUNITY_LEADER_FLAG"/> <bm:field name="bank_match_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_MATCH_FLAG" prompt="HLS_BP_MASTER.BANK_MATCH_FLAG"/> <bm:field name="house_property_value" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HOUSE_PROPERTY_VALUE" prompt="HLS_BP_MASTER.HOUSE_PROPERTY_VALUE"/> <bm:field name="house_loan_balance" databaseType="NUMBER" datatype="java.lang.Long" physicalName="HOUSE_LOAN_BALANCE" prompt="HLS_BP_MASTER.HOUSE_LOAN_BALANCE"/> <bm:field name="deposit_certificate" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPOSIT_CERTIFICATE" prompt="HLS_BP_MASTER.DEPOSIT_CERTIFICATE"/> <bm:field name="credit_card_limit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CREDIT_CARD_LIMIT" prompt="HLS_BP_MASTER.CREDIT_CARD_LIMIT"/> <bm:field name="address_on_id" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADDRESS_ON_ID" prompt="HLS_BP_MASTER.ADDRESS_ON_ID"/> <bm:field name="address_on_resident_booklit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADDRESS_ON_RESIDENT_BOOKLIT" prompt="HLS_BP_MASTER.ADDRESS_ON_RESIDENT_BOOKLIT"/> <bm:field name="living_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADDRESS" prompt="HLS_BP_MASTER.LIVING_ADDRESS"/> <bm:field name="working_place" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORKING_PLACE" prompt="HLS_BP_MASTER.WORKING_PLACE"/> <bm:field name="working_duration" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORKING_DURATION" prompt="HLS_BP_MASTER.WORKING_DURATION"/> <bm:field name="working_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORKING_ADDRESS" prompt="HLS_BP_MASTER.WORKING_ADDRESS"/> <bm:field name="operation_year" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OPERATION_YEAR" prompt="HLS_BP_MASTER.OPERATION_YEAR"/> <bm:field name="position" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POSITION" prompt="HLS_BP_MASTER.POSITION"/> <bm:field name="cell_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CELL_PHONE" prompt="HLS_BP_MASTER.CELL_PHONE"/> <bm:field name="phone_extra" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PHONE_EXTRA" prompt="HLS_BP_MASTER.PHONE_EXTRA"/> <bm:field name="phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PHONE" prompt="HLS_BP_MASTER.PHONE"/> <bm:field name="contact_person" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CONTACT_PERSON" prompt="HLS_BP_MASTER.CONTACT_PERSON"/> <bm:field name="fax_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FAX_NUMBER" prompt="HLS_BP_MASTER.FAX_NUMBER"/> <bm:field name="department" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DEPARTMENT" prompt="HLS_BP_MASTER.DEPARTMENT"/> <bm:field name="credit_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CREDIT_FLAG" prompt="HLS_BP_MASTER.CREDIT_FLAG"/> <bm:field name="credit_amount" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CREDIT_AMOUNT" prompt="HLS_BP_MASTER.CREDIT_AMOUNT"/> <bm:field name="credit_alt" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CREDIT_ALT" prompt="HLS_BP_MASTER.CREDIT_ALT"/> <bm:field name="credit_forbid" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CREDIT_FORBID" prompt="HLS_BP_MASTER.CREDIT_FORBID"/> <bm:field name="email" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="EMAIL" prompt="HLS_BP_MASTER.EMAIL"/> <bm:field name="nc_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NC_STATUS" prompt="HLS_BP_MASTER.NC_STATUS"/> <bm:field name="cell_phone_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CELL_PHONE_2" prompt="HLS_BP_MASTER.CELL_PHONE_2"/> <bm:field name="zip_on_resident_booklit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ZIP_ON_RESIDENT_BOOKLIT" prompt="HLS_BP_MASTER.ZIP_ON_RESIDENT_BOOKLIT"/> <bm:field name="zip_of_living_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ZIP_OF_LIVING_ADDRESS" prompt="HLS_BP_MASTER.ZIP_OF_LIVING_ADDRESS"/> <bm:field name="years_of_living_house" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="YEARS_OF_LIVING_HOUSE" prompt="HLS_BP_MASTER.YEARS_OF_LIVING_HOUSE"/> <bm:field name="other_annual_income" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OTHER_ANNUAL_INCOME" prompt="HLS_BP_MASTER.OTHER_ANNUAL_INCOME"/> <bm:field name="house_month_amount" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HOUSE_MONTH_AMOUNT" prompt="HLS_BP_MASTER.HOUSE_MONTH_AMOUNT"/> <bm:field name="ownship_of_house" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OWNSHIP_OF_HOUSE" prompt="HLS_BP_MASTER.OWNSHIP_OF_HOUSE"/> <bm:field name="house_loans_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="HOUSE_LOANS_FLAG" prompt="HLS_BP_MASTER.HOUSE_LOANS_FLAG"/> <bm:field name="source_of_income" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SOURCE_OF_INCOME" prompt="HLS_BP_MASTER.SOURCE_OF_INCOME"/> <bm:field name="ethnic_group" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ETHNIC_GROUP" prompt="HLS_BP_MASTER.ETHNIC_GROUP"/> <bm:field name="send_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SEND_ADDRESS" prompt="HLS_BP_MASTER.SEND_ADDRESS"/> <bm:field name="work_unit" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT" prompt="HLS_BP_MASTER.WORK_UNIT"/> <bm:field name="work_unit_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_ADDRESS" prompt="HLS_BP_MASTER.WORK_UNIT_ADDRESS"/> <bm:field name="work_unit_phone" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_PHONE" prompt="HLS_BP_MASTER.WORK_UNIT_PHONE"/> <bm:field name="work_unit_zip" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_ZIP" prompt="HLS_BP_MASTER.WORK_UNIT_ZIP"/> <bm:field name="entry_date" databaseType="DATE" datatype="java.util.Date" physicalName="ENTRY_DATE" prompt="HLS_BP_MASTER.ENTRY_DATE"/> <bm:field name="industry_work_experience" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_WORK_EXPERIENCE" prompt="HLS_BP_MASTER.INDUSTRY_WORK_EXPERIENCE"/> <bm:field name="main_driver_of_car" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="MAIN_DRIVER_OF_CAR" prompt="HLS_BP_MASTER.MAIN_DRIVER_OF_CAR"/> <bm:field name="driver_license_no" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DRIVER_LICENSE_NO" prompt="HLS_BP_MASTER.DRIVER_LICENSE_NO"/> <bm:field name="first_time_buyer_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FIRST_TIME_BUYER_FLAG" prompt="HLS_BP_MASTER.FIRST_TIME_BUYER_FLAG"/> <bm:field name="date_of_birth_sp" databaseType="DATE" datatype="java.util.Date" physicalName="DATE_OF_BIRTH_SP" prompt="HLS_BP_MASTER.DATE_OF_BIRTH_SP"/> <bm:field name="cell_phone_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CELL_PHONE_SP" prompt="HLS_BP_MASTER.CELL_PHONE_SP"/> <bm:field name="academic_background_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACADEMIC_BACKGROUND_SP" prompt="HLS_BP_MASTER.ACADEMIC_BACKGROUND_SP"/> <bm:field name="card_type_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CARD_TYPE_SP" prompt="HLS_BP_MASTER.CARD_TYPE_SP"/> <bm:field name="id_no_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ID_NO_SP" prompt="HLS_BP_MASTER.ID_NO_SP"/> <bm:field name="population_living_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POPULATION_LIVING_SP" prompt="HLS_BP_MASTER.POPULATION_LIVING_SP"/> <bm:field name="living_address_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADDRESS_SP" prompt="HLS_BP_MASTER.LIVING_ADDRESS_SP"/> <bm:field name="zip_of_living_address_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ZIP_OF_LIVING_ADDRESS_SP" prompt="HLS_BP_MASTER.ZIP_OF_LIVING_ADDRESS_SP"/> <bm:field name="resident_addres_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESIDENT_ADDRES_SP" prompt="HLS_BP_MASTER.RESIDENT_ADDRES_SP"/> <bm:field name="zip_of_resident_address_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ZIP_OF_RESIDENT_ADDRESS_SP" prompt="HLS_BP_MASTER.ZIP_OF_RESIDENT_ADDRESS_SP"/> <bm:field name="other_annual_income_sp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OTHER_ANNUAL_INCOME_SP" prompt="HLS_BP_MASTER.OTHER_ANNUAL_INCOME_SP"/> <bm:field name="annual_income_sp" databaseType="NUMBER" datatype="java.lang.Long" physicalName="ANNUAL_INCOME_SP" prompt="HLS_BP_MASTER.ANNUAL_INCOME_SP"/> <bm:field name="source_of_income_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SOURCE_OF_INCOME_SP" prompt="HLS_BP_MASTER.SOURCE_OF_INCOME_SP"/> <bm:field name="work_unit_name_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_NAME_SP" prompt="HLS_BP_MASTER.WORK_UNIT_NAME_SP"/> <bm:field name="work_unit_phone_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_PHONE_SP" prompt="HLS_BP_MASTER.WORK_UNIT_PHONE_SP"/> <bm:field name="work_unit_address_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_UNIT_ADDRESS_SP" prompt="HLS_BP_MASTER.WORK_UNIT_ADDRESS_SP"/> <bm:field name="position_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="POSITION_SP" prompt="HLS_BP_MASTER.POSITION_SP"/> <bm:field name="entry_date_sp" databaseType="DATE" datatype="java.util.Date" physicalName="ENTRY_DATE_SP" prompt="HLS_BP_MASTER.ENTRY_DATE_SP"/> <bm:field name="industry_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_SP" prompt="HLS_BP_MASTER.INDUSTRY_SP"/> <bm:field name="industry_work_experience_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_WORK_EXPERIENCE_SP" prompt="HLS_BP_MASTER.INDUSTRY_WORK_EXPERIENCE_SP"/> <bm:field name="bank_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BANK_ID" prompt="HLS_BP_MASTER.BANK_ID"/> <bm:field name="bank_account_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_ACCOUNT_NAME" prompt="HLS_BP_MASTER.BANK_ACCOUNT_NAME"/> <bm:field name="bank_account_num" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BANK_ACCOUNT_NUM" prompt="HLS_BP_MASTER.BANK_ACCOUNT_NUM"/> <bm:field name="uses_of_car" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USES_OF_CAR" prompt="HLS_BP_MASTER.USES_OF_CAR"/> <bm:field name="uses_of_car_1" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="USES_OF_CAR_1" prompt="HLS_BP_MASTER.USES_OF_CAR_1"/> <bm:field name="car_info" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CAR_INFO" prompt="HLS_BP_MASTER.CAR_INFO"/> <bm:field name="fax" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FAX" prompt="HLS_BP_MASTER.FAX"/> <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="HLS_BP_MASTER.DESCRIPTION"/> <bm:field name="others" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="OTHERS" prompt="HLS_BP_MASTER.OTHERS"/> <bm:field name="phone_2" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PHONE_2" prompt="HLS_BP_MASTER.PHONE_2"/> <bm:field name="approval_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="APPROVAL_STATUS" prompt="HLS_BP_MASTER.APPROVAL_STATUS"/> <bm:field name="yonda_organization_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="YONDA_ORGANIZATION_CODE" prompt="HLS_BP_MASTER.YONDA_ORGANIZATION_CODE"/> <bm:field name="fertility_status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FERTILITY_STATUS" prompt="HLS_BP_MASTER.FERTILITY_STATUS"/> <bm:field name="bp_property" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_PROPERTY" prompt="HLS_BP_MASTER.BP_PROPERTY"/> <bm:field name="invoice_send_address" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INVOICE_SEND_ADDRESS" prompt="HLS_BP_MASTER.INVOICE_SEND_ADDRESS"/> <bm:field name="kingdee_code" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="KINGDEE_CODE" prompt="HLS_BP_MASTER.KINGDEE_CODE"/> <bm:field name="living_situation" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_SITUATION" prompt="HLS_BP_MASTER.LIVING_SITUATION"/> <bm:field name="bp_info" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_INFO" prompt="HLS_BP_MASTER.BP_INFO"/> <bm:field name="province_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROVINCE_ID" prompt="HLS_BP_MASTER.PROVINCE_ID"/> <bm:field name="bp_into" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BP_INTO" prompt="HLS_BP_MASTER.BP_INTO"/> <bm:field name="company_personal" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="COMPANY_PERSONAL" prompt="HLS_BP_MASTER.COMPANY_PERSONAL"/> <bm:field name="actual_like" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ACTUAL_LIKE" prompt="HLS_BP_MASTER.ACTUAL_LIKE"/> <bm:field name="unbrand" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="UNBRAND" prompt="HLS_BP_MASTER.UNBRAND"/> <bm:field name="release_form" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RELEASE_FORM" prompt="HLS_BP_MASTER.RELEASE_FORM"/> <bm:field name="relationship_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RELATIONSHIP_SP" prompt="HLS_BP_MASTER.RELATIONSHIP_SP"/> <bm:field name="resident_addres" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESIDENT_ADDRES" prompt="HLS_BP_MASTER.RESIDENT_ADDRES"/> <bm:field name="living_address_db" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADDRESS_DB" prompt="HLS_BP_MASTER.LIVING_ADDRESS_DB"/> <bm:field name="source_of_income_db" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="SOURCE_OF_INCOME_DB" prompt="HLS_BP_MASTER.SOURCE_OF_INCOME_DB"/> <bm:field name="industry_work_exper" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="INDUSTRY_WORK_EXPER" prompt="HLS_BP_MASTER.INDUSTRY_WORK_EXPER"/> <bm:field name="e_mail" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="E_MAIL" prompt="HLS_BP_MASTER.E_MAIL"/> <bm:field name="wei_chat" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WEI_CHAT" prompt="HLS_BP_MASTER.WEI_CHAT"/> <bm:field name="qq" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="QQ" prompt="HLS_BP_MASTER.QQ"/> <bm:field name="liv_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIV_CITY" prompt="HLS_BP_MASTER.LIV_CITY"/> <bm:field name="liv_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIV_PROVINCE" prompt="HLS_BP_MASTER.LIV_PROVINCE"/> <bm:field name="add_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_CITY" prompt="HLS_BP_MASTER.ADD_CITY"/> <bm:field name="add_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ADD_PROVINCE" prompt="HLS_BP_MASTER.ADD_PROVINCE"/> <bm:field name="resident_add_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESIDENT_ADD_CITY" prompt="HLS_BP_MASTER.RESIDENT_ADD_CITY"/> <bm:field name="resident_add_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="RESIDENT_ADD_PROVINCE" prompt="HLS_BP_MASTER.RESIDENT_ADD_PROVINCE"/> <bm:field name="living_add_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADD_CITY" prompt="HLS_BP_MASTER.LIVING_ADD_CITY"/> <bm:field name="living_add_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LIVING_ADD_PROVINCE" prompt="HLS_BP_MASTER.LIVING_ADD_PROVINCE"/> <bm:field name="work_province_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_PROVINCE_SP" prompt="HLS_BP_MASTER.WORK_PROVINCE_SP"/> <bm:field name="work_city_sp" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_CITY_SP" prompt="HLS_BP_MASTER.WORK_CITY_SP"/> <bm:field name="work_province" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_PROVINCE" prompt="HLS_BP_MASTER.WORK_PROVINCE"/> <bm:field name="work_city" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="WORK_CITY" prompt="HLS_BP_MASTER.WORK_CITY"/> <bm:field name="car_from" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="CAR_FROM" prompt="HLS_BP_MASTER.CAR_FROM"/> <bm:field name="assessment_company" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="ASSESSMENT_COMPANY" prompt="HLS_BP_MASTER.ASSESSMENT_COMPANY"/> <bm:field name="through_flag" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="THROUGH_FLAG" prompt="HLS_BP_MASTER.THROUGH_FLAG"/> </bm:fields> <bm:features> <f:standard-who/> </bm:features> <bm:primary-key> <bm:pk-field name="bp_id"/> </bm:primary-key> <bm:data-filters> <bm:data-filter name="enabled_flag" expression="t1.enabled_flag='Y'"/> <bm:data-filter name="bp_category" expression="t1.bp_category='AGENT'"/> </bm:data-filters> <bm:query-fields> <bm:query-field name="bp_code" queryExpression="t1.bp_code=${@bp_code}"/> <bm:query-field name="bp_name" queryExpression="t1.bp_name=${@bp_name}"/> </bm:query-fields> </bm:model>