fi_contract - 合同基本信息
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_id | 主键 | CHAR | Y | 20 | 0 | | | | |
acc_credit | 借贷款账户 | VARCHAR | | 20 | 0 | | | | |
address | 注册地址 | VARCHAR | | 256 | 0 | | | | |
applycode | 申请单号 | VARCHAR | | 28 | 0 | | | | |
assureaccount | 第三方账号 | VARCHAR | | 60 | 0 | | | | |
assurebank | 第三方开户银行 | VARCHAR | | 120 | 0 | | | | |
assuredeputy | 第三方代表 | VARCHAR | | 80 | 0 | | | | |
assureperson | 第三方法人 | VARCHAR | | 80 | 0 | | | | |
assureunit | 第三方(客商) | CHAR | | 20 | 0 | | | | |
autoaccflag | 自动划款标识 | CHAR | | 1 | 0 | | | | |
autocredit | 自动划款帐户 | CHAR | | 20 | 0 | | | | |
autoenddate | 自动结束日期 | CHAR | | 10 | 0 | | | | |
back | 备注 | VARCHAR | | 4000 | 0 | | | | |
bankcontno | 对应银行合同编号 | VARCHAR | | 30 | 0 | | | | |
begindate | 起息日期 | CHAR | | 10 | 0 | | | | |
borrowoutaccno | 拆入方还款账号 | VARCHAR | | 60 | 0 | | | | |
businessrate | 营业税率 | DECIMAL | | 16 | 4 | | | | |
caldatecode | 结息日编码 | VARCHAR | | 56 | 0 | | | | |
capital | 注册资本 | DECIMAL | | 31 | 12 | | | | |
cardno | 贷款卡号 | VARCHAR | | 256 | 0 | | | | |
contprop | 合同性质 | VARCHAR | | 30 | 0 | newadd | | | |
coopflag | 协同标志 | CHAR | | 1 | 0 | | | | |
countinterest | 是否核算利息 | CHAR | | 1 | 0 | | | | |
creditperiod | 借贷期间 | VARCHAR | | 20 | 0 | | | | |
currencycode | 币种编码 | CHAR | | 20 | 0 | | | | |
datasource | 数据来源 | VARCHAR | | 40 | 0 | | | | |
dateid | 资金日历编码 | VARCHAR | | 56 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
duifangpersonno | 法人代码 | VARCHAR | | 256 | 0 | | | | |
enddate | 终止日期 | CHAR | | 10 | 0 | | | | |
envelopflag | 封存标志 | CHAR | | 1 | 0 | | | | |
errterminatedate | 异常终止日期 | CHAR | | 10 | 0 | | | | |
extd_begdate | 展期开始日期 | VARCHAR | | 20 | 0 | | | | |
extd_expdate | 展期到期日期 | VARCHAR | | 20 | 0 | | | | |
extd_ratecode | 展期利率 | VARCHAR | | 20 | 0 | | | | |
fdrate | 浮动比率 | DECIMAL | | 15 | 8 | | | | |
fi_def1 | 自定义项1 | VARCHAR | | 200 | 0 | | | | |
fi_def2 | 自定义项2 | VARCHAR | | 200 | 0 | | | | |
fi_def21 | 自定义项21 | VARCHAR | | 200 | 0 | | | | |
fi_def22 | 自定义项22 | VARCHAR | | 200 | 0 | | | | |
fi_def23 | 自定义项23 | VARCHAR | | 200 | 0 | | | | |
fi_def24 | 自定义项24 | VARCHAR | | 200 | 0 | | | | |
fi_def25 | 自定义项25 | VARCHAR | | 200 | 0 | | | | |
fi_def26 | 自定义项26 | VARCHAR | | 200 | 0 | | | | |
fi_def27 | 自定义项27 | VARCHAR | | 200 | 0 | | | | |
fi_def28 | 自定义项28 | VARCHAR | | 200 | 0 | | | | |
fi_def29 | 自定义项29 | VARCHAR | | 200 | 0 | | | | |
fi_def3 | 自定义项3 | VARCHAR | | 200 | 0 | | | | |
fi_def30 | 自定义项30 | VARCHAR | | 200 | 0 | | | | |
fi_def31 | 自定义项31 | VARCHAR | | 200 | 0 | | | | |
fi_def32 | 自定义项32 | VARCHAR | | 200 | 0 | | | | |
fi_def33 | 自定义项33 | VARCHAR | | 200 | 0 | | | | |
fi_def34 | 自定义项34 | VARCHAR | | 200 | 0 | | | | |
fi_def35 | 自定义项35 | VARCHAR | | 200 | 0 | | | | |
fi_def4 | 自定义项4 | VARCHAR | | 200 | 0 | | | | |
fi_def5 | 自定义项5 | VARCHAR | | 200 | 0 | | | | |
fimode | 筹投资方式 | VARCHAR | | 28 | 0 | | | | |
fixrateflag | 固定汇率标志 | CHAR | | 1 | 0 | | | | |
hasrecive | 已收款标志 | CHAR | | 1 | 0 | | | | |
hasreturn | 已还款标志 | CHAR | | 1 | 0 | | | | |
initialflag | 期初标识 | CHAR | | 1 | 0 | | | | |
inputdate | 录入日期 | CHAR | | 10 | 0 | | | | |
inputman | 录入人 | CHAR | | 20 | 0 | | | | |
isbankcredit | 是否网银委贷 | CHAR | | 1 | 0 | | | | |
jiafangbank | 贷方开户银行 | VARCHAR | | 120 | 0 | | | | |
jiafangcredit | 甲方帐户 | CHAR | | 20 | 0 | | | | |
jiafangdept | 贷方部门 | CHAR | | 20 | 0 | | | | |
jiafangdeputy | 贷方代表 | VARCHAR | | 80 | 0 | | | | |
jiafangperson | 贷方法人 | VARCHAR | | 80 | 0 | | | | |
jiafangunit | 贷方(客商) | CHAR | | 20 | 0 | | | | |
lastbalancedate | 上次结息日期 | CHAR | | 10 | 0 | | | | |
lendinaccno | 拆出方收款账号 | VARCHAR | | 60 | 0 | | | | |
licenceno | 法人执照注册号 | VARCHAR | | 256 | 0 | | | | |
loanreason | 借款原因 | VARCHAR | | 256 | 0 | | | | |
moneyb | 本币金额 | DECIMAL | | 31 | 12 | | | | |
moneyf | 辅币金额 | DECIMAL | | 31 | 12 | | | | |
moneyy | 原币金额 | DECIMAL | | 31 | 12 | | | | |
payaccno | 贷方账号 | VARCHAR | | 60 | 0 | | | | |
periodcount | 存款期间 | INT | | 4 | 0 | | | | |
periodunit | 期间单位 | CHAR | | 1 | 0 | | | | |
pk_parent | 关联父PK | CHAR | | 20 | 0 | | | | |
proceduremoney | 手续费额 | DECIMAL | | 31 | 12 | | | | |
proceduremoneyb | 手续费本币 | DECIMAL | | 31 | 12 | | | | |
proceduremoneyf | 手续费辅币 | DECIMAL | | 31 | 12 | | | | |
procedurerate | 手续费率 | DECIMAL | | 31 | 12 | | | | |
rateb | 本币汇率 | DECIMAL | | 15 | 8 | | | | |
ratecode | 利率编码 | CHAR | | 20 | 0 | | | | |
ratef | 辅币汇率 | DECIMAL | | 15 | 8 | | | | |
regardedas_entrust | 是否视同委贷 | CHAR | | 1 | 0 | N | | | |
returnacc | 还款账户 | CHAR | | 20 | 0 | | | | |
returnmode | 还款方式 | VARCHAR | | 100 | 0 | | | | |
saveaccno | 借方账号 | VARCHAR | | 60 | 0 | | | | |
signdate | 合同签定日期 | CHAR | | 10 | 0 | | | | |
status | 合同状态 | CHAR | | 1 | 0 | | | | |
telephone | 财务联系人电话 | VARCHAR | | 256 | 0 | | | | |
terminateman | 终止操作员 | VARCHAR | | 40 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
verifydate | 审核日期 | CHAR | | 10 | 0 | | | | |
verifyflag | 审核标志 | CHAR | | 1 | 0 | | | | |
verifying | 审核中 | CHAR | | 1 | 0 | | | | |
verifyman | 审核人 | VARCHAR | | 40 | 0 | | | | |
versionno | 版本号 | SMALLINT | | 2 | 0 | | | | |
yifangbank | 借方开户银行 | VARCHAR | | 120 | 0 | | | | |
yifangdept | 借方部门 | CHAR | | 20 | 0 | | | | |
yifangdeputy | 借方代表 | VARCHAR | | 80 | 0 | | | | |
yifangperson | 借方法人 | VARCHAR | | 80 | 0 | | | | |
yifangunit | 借方(客商) | CHAR | | 20 | 0 | | | | |
yqlx | 是否逾期利息 | CHAR | | 1 | 0 | | | | |
外键列表
索引列表