<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zksy.data.mapper.XcrNaturalPersonContributionsMapper">

    <resultMap id="BaseResultMap" type="com.zksy.data.domain.po.XcrNaturalPersonContributions">
            <id property="invid" column="INVID" jdbcType="VARCHAR"/>
            <result property="etpsId" column="ETPS_ID" jdbcType="VARCHAR"/>
            <result property="pripid" column="PRIPID" jdbcType="VARCHAR"/>
            <result property="inv" column="INV" jdbcType="VARCHAR"/>
            <result property="certype" column="CERTYPE" jdbcType="VARCHAR"/>
            <result property="certypeCn" column="CERTYPE_CN" jdbcType="VARCHAR"/>
            <result property="cerno" column="CERNO" jdbcType="VARCHAR"/>
            <result property="lisubconam" column="LISUBCONAM" jdbcType="DECIMAL"/>
            <result property="subconamusd" column="SUBCONAMUSD" jdbcType="DECIMAL"/>
            <result property="subconform" column="SUBCONFORM" jdbcType="VARCHAR"/>
            <result property="subconprop" column="SUBCONPROP" jdbcType="DECIMAL"/>
            <result property="condate" column="CONDATE" jdbcType="DATE"/>
            <result property="liacconam" column="LiAcConAm" jdbcType="DECIMAL"/>
            <result property="acconamusd" column="ACCONAMUSD" jdbcType="DECIMAL"/>
            <result property="dom" column="DOM" jdbcType="VARCHAR"/>
            <result property="currency" column="CURRENCY" jdbcType="VARCHAR"/>
            <result property="currencyCn" column="CURRENCY_CN" jdbcType="VARCHAR"/>
            <result property="country" column="COUNTRY" jdbcType="VARCHAR"/>
            <result property="countryCn" column="COUNTRY_CN" jdbcType="VARCHAR"/>
            <result property="exeaffsign" column="EXEAFFSIGN" jdbcType="VARCHAR"/>
            <result property="respform" column="RESPFORM" jdbcType="VARCHAR"/>
            <result property="respformCn" column="RESPFORM_CN" jdbcType="VARCHAR"/>
            <result property="sconform" column="SCONFORM" jdbcType="VARCHAR"/>
            <result property="sex" column="SEX" jdbcType="VARCHAR"/>
            <result property="nation" column="NATION" jdbcType="VARCHAR"/>
            <result property="natdate" column="NATDATE" jdbcType="DATE"/>
            <result property="litdeg" column="LITDEG" jdbcType="VARCHAR"/>
            <result property="polstand" column="POLSTAND" jdbcType="VARCHAR"/>
            <result property="occst" column="OCCST" jdbcType="VARCHAR"/>
            <result property="postalcode" column="POSTALCODE" jdbcType="VARCHAR"/>
            <result property="tel" column="TEL" jdbcType="VARCHAR"/>
            <result property="sExtDatatime" column="S_EXT_DATATIME" jdbcType="TIMESTAMP"/>
            <result property="sExtTimestamp" column="S_EXT_TIMESTAMP" jdbcType="TIMESTAMP"/>
    </resultMap>

    <sql id="Base_Column_List">
        INVID,ETPS_ID,PRIPID,
        INV,CERTYPE,CERTYPE_CN,
        CERNO,LISUBCONAM,SUBCONAMUSD,
        SUBCONFORM,SUBCONPROP,CONDATE,
        LiAcConAm,ACCONAMUSD,DOM,
        CURRENCY,CURRENCY_CN,COUNTRY,
        COUNTRY_CN,EXEAFFSIGN,RESPFORM,
        RESPFORM_CN,SCONFORM,SEX,
        NATION,NATDATE,LITDEG,
        POLSTAND,OCCST,POSTALCODE,
        TEL,S_EXT_DATATIME,S_EXT_TIMESTAMP
    </sql>
</mapper>
