fts_payment - 6.委托付款书
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_payment | 委托付款书主键 | CHAR | Y | 20 | 0 | | | | |
audit_cfca | 审核人CFCA证书主键 | CHAR | | 20 | 0 | | | | |
auditdate | 审核日期 | CHAR | | 10 | 0 | | | | |
audituser | 审核人 | CHAR | | 20 | 0 | | | | |
bill_cfca | 填写人CFCA证书主键 | CHAR | | 20 | 0 | | | | |
billdate | 填写日期 | CHAR | | 10 | 0 | | | | |
billtime | 填写时间 | CHAR | | 19 | 0 | | | | |
billuser | 填写人 | CHAR | | 20 | 0 | | | | |
cancel_cfca | 撤消人CFCA证书主键 | CHAR | | 20 | 0 | | | | |
canceldate | 撤消日期 | CHAR | | 10 | 0 | | | | |
cancelreason | 作废原因 | VARCHAR | | 512 | 0 | | | | |
canceluser | 撤消人 | CHAR | | 20 | 0 | | | | |
checkdate | 核查日期 | CHAR | | 10 | 0 | | | | |
checkuser | 核查人 | CHAR | | 20 | 0 | | | | |
code | 编码 | VARCHAR | | 30 | 0 | | | | |
creditflag | 信贷标志 | VARCHAR | | 20 | 0 | | | | |
decidedate | 经办日期 | CHAR | | 10 | 0 | | | | |
decideuser | 经办人 | CHAR | | 20 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
exchangeinfoitem | 前后台交互项 | VARCHAR | | 30 | 0 | | | | |
funddownbillno | 资金下拨单单据号 | VARCHAR | | 30 | 0 | | | | |
funddowndate | 提交下拨日期 | CHAR | | 10 | 0 | | | | |
funddownstatus | 下拨处理状态 | SMALLINT | | 2 | 0 | 0 | | | |
funddownuser | 提交下拨人 | CHAR | | 20 | 0 | | | | |
glbusinessdate | 总账入账日期 | CHAR | | 10 | 0 | | | | |
isautoappropriate | 银行是否自动回拨 | CHAR | | 1 | 0 | | | | |
iscashpay | 是否现金业务 | CHAR | | 1 | 0 | N | | | |
isfundappropriate | 是否资金回拨 | CHAR | | 1 | 0 | | | | |
isfunddown | 是否需提交下拨 | CHAR | | 1 | 0 | N | | | |
isnetsend | 是否网银发送付款 | CHAR | | 1 | 0 | N | | | |
isremotebill | 是否结算单位填写 | CHAR | | 1 | 0 | | | | |
issendok | 网银发送是否成功 | CHAR | | 1 | 0 | N | | | |
makeupstatus | 补录付款信息 | SMALLINT | | 2 | 0 | 0 | | | |
makevdate | 制证日期 | CHAR | | 10 | 0 | | | | |
makevuser | 制证人 | CHAR | | 20 | 0 | | | | |
memo | 审核提示信息 | VARCHAR | | 200 | 0 | | | | |
netpayqrytime | 网银支付查询时间 | VARCHAR | | 19 | 0 | | | | |
netpaystatus | 网银支付状态 | SMALLINT | | 2 | 0 | | | | |
noticedate | 通知取款日期 | CHAR | | 10 | 0 | | | | |
password | 密码 | VARCHAR | | 10 | 0 | | | | |
paydate | 支付日期 | CHAR | | 10 | 0 | | | | |
paymessage | 支付信息 | VARCHAR | | 800 | 0 | | | | |
paystatus | 委托付款书状态 | SMALLINT | | 2 | 0 | 0 | | | |
payuser | 支付人 | CHAR | | 20 | 0 | | | | |
pk_account | 付款帐户主键 | CHAR | | 20 | 0 | | | | |
pk_billtype | 单据类型 | VARCHAR | | 10 | 0 | | | | |
pk_budget | 收支计划 | CHAR | | 20 | 0 | | | | |
pk_client | 结算单位主键 | CHAR | | 20 | 0 | | | | |
pk_contract | 合同主键 | CHAR | | 20 | 0 | | | | |
pk_corp | 付款结算中心所属公司主键 | CHAR | | 4 | 0 | | | | |
pk_costsubj | 收支项目 | CHAR | | 20 | 0 | | | | |
pk_curcenter | 当前结算中心 | CHAR | | 20 | 0 | | | | |
pk_fixsave | 定期存单主键 | CHAR | | 20 | 0 | | | | |
pk_funddown | 资金下拨单主键 | CHAR | | 20 | 0 | | | | |
pk_getcenter | 收款结算中心 | CHAR | | 20 | 0 | | | | |
pk_interestcode | 利息单主键 | CHAR | | 20 | 0 | | | | |
pk_paymanagement | 委托付款书管理主键 | CHAR | | 20 | 0 | | | | |
pk_recpay | 上游单据主键 | VARCHAR | | 30 | 0 | | | | |
pk_reversed | 被冲销单据主键 | CHAR | | 20 | 0 | | | | |
pk_settlecenter | 付款结算中心 | CHAR | | 20 | 0 | | | | |
pk_transactcenter | 办理结算中心 | CHAR | | 20 | 0 | | | | |
purpose | 用途 | VARCHAR | | 200 | 0 | | | | |
recmodul | 来源模块 | SMALLINT | | 2 | 0 | 0 | | | |
reverseflag | 冲销标志 | SMALLINT | | 2 | 0 | 0 | | | |
senddate | 发送日期 | CHAR | | 10 | 0 | | | | |
senduser | 发送人 | CHAR | | 20 | 0 | | | | |
sourcecode | 来源单据号 | VARCHAR | | 30 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
vapprovenote | 审核批语 | VARCHAR | | 128 | 0 | | | | |
vbillstatus | 单据状态 | SMALLINT | | 2 | 0 | | | | |
vuserdef1 | 用户自定义项1 | VARCHAR | | 100 | 0 | | | | |
vuserdef10 | 用户自定义项10 | VARCHAR | | 100 | 0 | | | | |
vuserdef2 | 用户自定义项2 | VARCHAR | | 100 | 0 | | | | |
vuserdef3 | 用户自定义项3 | VARCHAR | | 100 | 0 | | | | |
vuserdef4 | 用户自定义项4 | VARCHAR | | 100 | 0 | | | | |
vuserdef5 | 用户自定义项5 | VARCHAR | | 100 | 0 | | | | |
vuserdef6 | 用户自定义项6 | VARCHAR | | 100 | 0 | | | | |
vuserdef7 | 用户自定义项7 | VARCHAR | | 100 | 0 | | | | |
vuserdef8 | 用户自定义项8 | VARCHAR | | 100 | 0 | | | | |
vuserdef9 | 用户自定义项9 | VARCHAR | | 100 | 0 | | | | |
外键列表
索引列表