fi_consignloan - 委贷放款
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_id | 单据主键 | CHAR | Y | 20 | 0 | | | | |
accdate | 记账日期 | CHAR | | 10 | 0 | | | | |
accnbr | 委托方帐号 | CHAR | | 35 | 0 | | | | |
accperson | 记账人 | CHAR | | 20 | 0 | | | | |
bankconno | 银行合同号 | VARCHAR | | 20 | 0 | | | | |
bbknbr | 委托方分行号 | CHAR | | 2 | 0 | | | | |
bjrepayed | 已还本金标志 | CHAR | | 1 | 0 | | | | |
bwracc | 借款方账号 | CHAR | | 35 | 0 | | | | |
bwrbbk | 借款方分行号 | CHAR | | 2 | 0 | | | | |
bwrclt | 借款方客户编号 | VARCHAR | | 15 | 0 | | | | |
cltnbr | 委托方客户编号 | VARCHAR | | 15 | 0 | | | | |
crlnum | 额度编号 | CHAR | | 10 | 0 | | | | |
currencytype | 币种 | CHAR | | 20 | 0 | | | | |
d_bj_planitem | 贷方本金计划项目 | CHAR | | 20 | 0 | | | | |
d_bj_szitem | 贷方本金收支项目 | CHAR | | 20 | 0 | | | | |
daccstatus | 贷方记账标志 | CHAR | | 1 | 0 | | | | |
dapprovedate | 审核日期 | CHAR | | 10 | 0 | | | | |
dcommitdate | 提交日期 | CHAR | | 10 | 0 | | | | |
dconfirmdate | 确认日期 | CHAR | | 10 | 0 | | | | |
dealdate | 受理日期 | CHAR | | 10 | 0 | | | | |
doperatedate | 制单日期 | CHAR | | 10 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
intrat | 利率 | DECIMAL | | 11 | 7 | | | | |
isbankloan | 是否走网银 | CHAR | | 1 | 0 | | | | |
isreverse | 是否冲帐单 | CHAR | | 1 | 0 | | | | |
j_bj_planitem | 借方本金计划项目 | CHAR | | 20 | 0 | | | | |
j_bj_szitem | 借方本金收支项目 | CHAR | | 20 | 0 | | | | |
jaccstatus | 借方记账标志 | CHAR | | 1 | 0 | | | | |
jdrelate | 借贷方关系 | VARCHAR | | 15 | 0 | | | | |
jiafangunit | 贷款单位 | CHAR | | 20 | 0 | | | | |
loandate | 提款日期 | CHAR | | 10 | 0 | | | | |
lonusg | 贷款用途 | VARCHAR | | 256 | 0 | | | | |
lxrepayed | 已还利息标志 | CHAR | | 1 | 0 | | | | |
moneyb | 金额(本) | DECIMAL | | 31 | 8 | | | | |
moneyf | 金额(辅) | DECIMAL | | 31 | 8 | | | | |
moneyy | 金额(原) | DECIMAL | | 31 | 8 | | | | |
payaccno | 贷款单位银行账户 | CHAR | | 20 | 0 | | | | |
pk_contract | 合同主键 | CHAR | | 20 | 0 | | | | |
pk_corp | 创建公司 | CHAR | | 4 | 0 | | | | |
quota | 额度 | DECIMAL | | 31 | 8 | | | | |
rateb | 本币汇率 | DECIMAL | | 15 | 8 | | | | |
ratef | 辅币汇率 | DECIMAL | | 15 | 8 | | | | |
realloandate | 实际放款日期 | CHAR | | 19 | 0 | | | | |
remark | 备注 | VARCHAR | | 256 | 0 | | | | |
repaydate | 还款日期 | CHAR | | 10 | 0 | | | | |
restquota | 剩余额度 | DECIMAL | | 31 | 8 | | | | |
saveaccno | 借款单位银行账号 | CHAR | | 20 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
usedquota | 已占额度 | DECIMAL | | 31 | 8 | | | | |
vapproveid | 审核人 | CHAR | | 20 | 0 | | | | |
vapprovenote | 审批意见 | VARCHAR | | 256 | 0 | | | | |
vbillno | 单据编号 | VARCHAR | | 30 | 0 | | | | |
vbillstatus | 单据状态 | SMALLINT | | 2 | 0 | | | | |
vbilltype | 单据类型 | VARCHAR | | 20 | 0 | | | | |
vcommitid | 提交人 | CHAR | | 20 | 0 | | | | |
vconfirmid | 确认人 | CHAR | | 20 | 0 | | | | |
vdef1 | 自定义项1 | VARCHAR | | 200 | 0 | | | | |
vdef10 | 自定义项10 | VARCHAR | | 200 | 0 | | | | |
vdef2 | 自定义项2 | VARCHAR | | 200 | 0 | | | | |
vdef3 | 自定义项3 | VARCHAR | | 200 | 0 | | | | |
vdef4 | 自定义项4 | VARCHAR | | 200 | 0 | | | | |
vdef5 | 自定义项5 | VARCHAR | | 200 | 0 | | | | |
vdef6 | 自定义项6 | VARCHAR | | 200 | 0 | | | | |
vdef7 | 自定义项7 | VARCHAR | | 200 | 0 | | | | |
vdef8 | 自定义项8 | VARCHAR | | 200 | 0 | | | | |
vdef9 | 自定义项9 | VARCHAR | | 200 | 0 | | | | |
voperatorid | 制单人 | CHAR | | 20 | 0 | | | | |
vreturnnote | 退回意见 | VARCHAR | | 256 | 0 | | | | |
yifangunit | 借款单位 | CHAR | | 20 | 0 | | | | |
yurref | 对方参考号 | VARCHAR | | 30 | 0 | | | | |
外键列表
索引列表