hls_bp_master.lwm 34.1 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241
<?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=&apos;Y&apos;"/>
        <bm:data-filter name="bp_category" expression="t1.bp_category=&apos;AGENT&apos;"/>
    </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>