对应关系表.xlsx

列名列描述字段类型目标字段英文名目标字段数据类型CRTDT创建日期VARCHAR2(8)IM_DTDATEMODDT修改日期VARCHAR2(8)IM_DTDATECREDITLEVEL信用等级VARCHAR2(5)PT_CREDIT_LEVEL_CODEVARCHAR2(5)CTFTYP证件类型VARCHAR2(3)PT_IDENTY_TYP_CODEVARCHAR2(3)CTFNO证件号码VARCHAR2(32)IDENTY_COCEVARCHAR2(32)RISKQUT风险额度NUMBER(18)LIMIT_AMTNUMBER(18)CUSTOMERNAME客户全称VARCHAR2(120)PT_NAMEVARCHAR2(150)SHORTNAME客户简称VARCHAR2(30)PT_NAMEVARCHAR2(150)ENGNAME英文名称VARCHAR2(150)PT_NAMEVARCHAR2(150)CUSTYP客户类型VARCHAR2(2)PT_TYP_CODEVARCHAR2(2)REGADDR注册地址VARCHAR2(405)PT_ADDRESSVARCHAR2(405)WORKADDR办公地址VARCHAR2(180)PT_ADDRESSVARCHAR2(405)ZIPCODE邮政编码VARCHAR2(8)PT_ADDRESSVARCHAR2(405)TELNO联系电话VARCHAR2(22)PT_ADDRESSVARCHAR2(405)FAXNO传真号码VARCHAR2(22)PT_ADDRESSVARCHAR2(405)CUSTOMERCODE客户号VARCHAR2(16)PT_NOVARCHAR2(16)ISONMARKET是否上市VARCHAR2(1)FAX_FLAGVARCHAR2(1)_TYPE_CODE内部机构类型代码CHAR(1)_TYP_CODEvarchar2(2)PARENT_BR_NO上级机构内部机构号CHAR(5)char(5)BEL_FIR_BR_NO所属一级分行内部机构号CHAR(5)char(5)_NO内部机构号CHAR(5)_NOVARCHAR2(8)_NAME内部机构名称VARCHAR2(200)_NAMEVARCHAR2(200)AGREEMENT_NO协议编号CHAR(3)AGR_NOvarchar2(20)T_STATU_CODE贷款账户状态代码CHAR(5)varchar(10)FIRST_DEPOS_DATE首次还款日期DATEIM_DTDATEINT_STRT_DATE起息日DATEIM_DTDATEALLOW_TERM_END_DATE宽限期结束日期DATEIM_DTDATEMATURITY_DATE到期日DATEIM_DTDATENEXT_REPR_DATE下次重定价日DATEIM_DTDATERISK_LEVEL_C0DE贷款五级分类代码CHAR(4)LEVEL_RESULT_CODEchar(4)EXECU_RATE执行利率NUMBER(11,6)RATENUMBER(11,6)OVER_FINE_INT_RATE逾期罚息利率NUMBER(11,6)RATENUMBER(11,6)LOAN_BAL贷款余额NUMBER(17,3)AMTNUMERIC(17,3)LOAN_TOTA