|
TCUSTOMERINFO(TCUSTOMERINFO(客户编号下客户信息)) | | | | | | | | | | |
| C_CUSTNO | | | |
| |
| |
| | | | | | |
| | |
| | | | | | |
| |
| |
| C_SHORTNAME | | | | |
| |
| |
| C_HELPCODE | | | | |
| |
| |
| C_IDENTITYTYPE | | | | |
| | |
| | | | | | |
| |
| |
| C_ZIPCODE | | | | |
| |
| |
| C_ADDRESS | | | | |
| |
| |
| C_PHONE | | | | |
| |
| |
| C_FAXNO | | | | |
| |
| |
| C_MOBILENO | | | | |
| |
| |
| C_EMAIL | | | | |
| |
| |
| C_SEX | | | | |
| |
| |
| C_BIRTHDAY | | | | |
| |
| |
| C_VOCATION | | | | |
| |
| |
| C_EDUCATION | | | | |
| |
| |
| C_INCOME | | | | |
| |
| |
| C_CONTACT | | | | |
| |
| |
| C_CONTYPE | | | | |
| |
| |
| C_CONTNO | | | | |
| |
| |
| C_BILLSENDFLAG | | | | |
| | 1:不寄送;2:按月;3:按季;4:半年;5:一年;8:强制不寄送 |
| | | | | | |
| |
| |
| C_INTERNET | | | | |
| |
| |
| C_SECRETCODE | | | | |
| |
| |
| C_NATIONALITY | | | | |
| |
| |
| C_CITYNO | | | | |
| |
| |
| C_LAWNAME | | | | |
| |
| |
| C_SHACCO | | | | |
| |
| |
| C_SZACCO | | | | |
| |
| |
| C_BROKER | | | | |
| |
| |
| F_AGIO | | | | |
| |
| |
| C_MEMO | | | | |
| |
| |
| C_RESERVE | | | | |
| |
| |
| C_CORPNAME | | | | |
| |
| |
| C_CORPTEL | | | | |
| |
| |
| C_SPECIALCODE | | | | |
| |
| |
| C_ACTCODE | | | | |
| |
| |
| C_BILLSENDPASS | | | | |
| |
| |
| C_BILL | | | | |
| |
| |
| C_CHECKED | | | | |
| | |
| | | | | | |
| |
| |
| C_VIPLEVEL | | | | |
| |
| |
| C_TANO | | | | |
| |
| |
| C_BILLSEND | | | | |
| | 0 or NULL:字段内容无效;1:对帐单强制不寄送(基金公司发起,由于客户意愿造成);8:对帐单强制不寄送(退信后自动设置) |
| | | | | | |
| |
| |
| C_BANK_ACCONO | | | | |
| |
| |
| C_BANK | | | | |
| |
| |
| L_TRGLIMIT | | | | |
| | 数字越小,触发器内部逻辑被执行的部分越多。0 全部执行,1 全部取消 |
| | | | | | |
| | |
| | | | | | |
| |
| |
| D_LASTMODIFY | | |
| |
| |
| |
| C_MANUALFLAG | | | | |
| | 0 未人工干预
1 人工干预更新,以后按默认规则更新
2 人工干预更新,以后按当前规则更新 |
| | | | | | |
| | 1、座席退信后,TACCOINFO.L_BILLTIME+1;2、短信去判断TACCOINFO.L_SBILLTIME是否 <TACCOINFO.L_BILLTIME;3、如果条件成立,发送短信和邮件提醒,发送结束后,需要将客户的TACCOINFO.L_SBILLTIME =" TACCOINFO.L_BILLTIME(短信),如果条件成立,发送短信和邮件提醒,发送结束后,需要将客户的TACCOINFO.L_MBILLTIME = TACCOINFO.L_BILLTIME(邮件) |
| | | | | | |
| |
| |
| C_MAILADDRESS | | | | |
| |
| |
| C_MAILZIP | | | | |
| |
| |
| C_HOMEPHONE | | | | |
| |
| |
| C_CORPPHONE | | | | |
| |
| |
| C_SEND | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| |
| |
| C_EMOBILEPHONE | | | | |
| |
| |
| C_EMAILADDRESS | | | | |
| |
| |
| C_UNPHONE | | | | |
| |
| |
| C_MODIFYDATE | | |
| 是 |
| | |
| | | | | | |
| |
| |
| C_BRANCH | | | | |
| |
| |
| C_CUSTOMERTYPE | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| |
| |
| C_CREATOR | | | | |
| |
| |
| C_CHANNELNO | | | | |
| |
| |
| C_AREACODE | | | | |
| |
| |
| C_CUSTOMERSTATUS | | | | |
| | |
| | | | | | |
| |
| |
| F_FAMILYYEARSALARY | | | | |
| |
| |
| C_INVESTFAVOUR | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| |
| |
| C_BP | | | | |
| |
| |
| C_CURRENTSTATUS | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| | |
| | | | | | |
| |
| |
| C_FAMILYMEMBERCOUNT | | | | |
| |
| |
| C_MARKETREGION | | | | |
| |
| |
| C_WEBSITE | | | | |
| |
| |
| C_NICKNAME | | | | |
| |
| |
| C_UNSMS | | |
| 是 |
| |
| |
| C_UNEMAIL | | |
| 是 |
| |
| |
| L_SBILLTIME | | | | |
| |
| |
| L_MBILLTIME | | | | |
| |
| |
| C_THROWAWAY | | | | |
| | --增加宣传品寄送字段 null或1:不寄送,0:寄送 |
| | | | | | |
| | 1:重点服务客户;2不良记录客户; 取字典表1180'; |
| | | | | | |
| |
| |
| C_RECOMMENDERTYPE | | | | |
| |
| |
| D_IDNOVALIDDATE | | |
| 是 |
| |
| |
链接: http://pan.baidu.com/s/1bo6134r 密码:
|
|