sf_fundapply_sub - 下拨申请子表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_fundapply_b | 主键 | CHAR | Y | 20 | 0 | | | | |
agreedate | 批复下拨日期 | CHAR | | 10 | 0 | | | | |
agreemoney | 批复金额 | DECIMAL | | 23 | 8 | | | | |
applybankacc | 申请单位银行账号 | CHAR | | 20 | 0 | | | | |
applydate | 申请下拨日期 | CHAR | | 10 | 0 | | | | |
applyinneracc | 内部账户主键 | CHAR | | 20 | 0 | | | | |
applymoney | 申请金额 | DECIMAL | | 23 | 8 | | | | |
applymoneyb | 申请金额(本) | DECIMAL | | 23 | 8 | | | | |
applymoneyf | 申请金额(辅) | DECIMAL | | 23 | 8 | | | | |
brate | 本币汇率 | DECIMAL | | 23 | 8 | | | | |
confirmtype | 批复类型 | VARCHAR | | 20 | 0 | | | | |
contractno | 信贷合同号 | VARCHAR | | 256 | 0 | | | | |
custbank | 客商收款银行 | VARCHAR | | 20 | 0 | | | | |
custbankacc | 客商银行账号 | VARCHAR | | 30 | 0 | | | | |
custcode | 客商编码 | VARCHAR | | 20 | 0 | | | | |
custname | 客商名称 | VARCHAR | | 256 | 0 | | | | |
def1 | 自定义项1 | VARCHAR | | 256 | 0 | | | | |
def10 | 自定义项10 | VARCHAR | | 256 | 0 | | | | |
def2 | 自定义项2 | VARCHAR | | 256 | 0 | | | | |
def3 | 自定义项3 | VARCHAR | | 256 | 0 | | | | |
def4 | 自定义项4 | VARCHAR | | 256 | 0 | | | | |
def5 | 自定义项5 | VARCHAR | | 256 | 0 | | | | |
def6 | 自定义项6 | VARCHAR | | 256 | 0 | | | | |
def7 | 自定义项7 | VARCHAR | | 256 | 0 | | | | |
def8 | 自定义项8 | VARCHAR | | 256 | 0 | | | | |
def9 | 自定义项9 | VARCHAR | | 256 | 0 | | | | |
discarddate | 作废日期 | CHAR | | 10 | 0 | | | | |
discardperson | 作废人 | CHAR | | 20 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
fixedasset | 固定资产号 | VARCHAR | | 256 | 0 | | | | |
frate | 辅币汇率 | DECIMAL | | 23 | 8 | | | | |
linestatus | 行状态 | VARCHAR | | 50 | 0 | | | | |
memo | 摘要 | VARCHAR | | 256 | 0 | | | | |
nextbill | 下游单据 | VARCHAR | | 50 | 0 | | | | |
orderno | 订单号 | VARCHAR | | 256 | 0 | | | | |
pk_fund | 下拨主键 | CHAR | | 20 | 0 | | | | |
pk_fundapply | 关联主键 | CHAR | | 20 | 0 | | | | |
pk_sourcebill | 来源单据 | CHAR | | 20 | 0 | | | | |
pk_sourcebill_b | 来源单据行主键 | CHAR | | 20 | 0 | | | | |
pk_transplan | 调度计划主键 | CHAR | | 20 | 0 | | | | |
planitem | 计划项目 | CHAR | | 20 | 0 | | | | |
result | 批复意见 | VARCHAR | | 256 | 0 | | | | |
sfitem | 收支项目 | CHAR | | 20 | 0 | | | | |
sourcebillno | 来源单据号 | VARCHAR | | 50 | 0 | | | | |
sourcebilltype | 来源单据类型 | VARCHAR | | 30 | 0 | | | | |
sourcesystem | 来源系统 | VARCHAR | | 20 | 0 | | | | |
spec | 规格 | VARCHAR | | 50 | 0 | | | | |
stockcode | 存货编码 | VARCHAR | | 256 | 0 | | | | |
stockname | 存货名称 | VARCHAR | | 256 | 0 | | | | |
stocktype | 型号 | VARCHAR | | 256 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
外键列表
索引列表