cmp_busibill_b - 结算单据表体
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | fb_oid | 辅表主键 | CHAR | Y | 20 | 0 | | | | |
accountid | 帐户ID | CHAR | | 20 | 0 | | | | |
assetpactno | 资产合同号 | VARCHAR | | 20 | 0 | | | | |
bankrollprojet | 资金计划 | CHAR | | 20 | 0 | | | | |
bbhl | 本币汇率 | DECIMAL | | 15 | 8 | | | | |
bbpjlx | 本币票据利息 | DECIMAL | | 20 | 8 | | | | |
bbtxfy | 本币贴现费用 | DECIMAL | | 20 | 8 | | | | |
bbye | 本币余额 | DECIMAL | | 20 | 8 | 0 | | | |
bfyhzh | 本方银行帐号 | CHAR | | 20 | 0 | | | | |
billdate | 单据日期 | CHAR | | 10 | 0 | | | | |
bjdwhsdj | 报价单位含税单价 | DECIMAL | | 20 | 8 | | | | |
bjdwsl | 报价单位数量 | DECIMAL | | 20 | 8 | | | | |
bjdwwsdj | 报价单位无税单价 | DECIMAL | | 20 | 8 | | | | |
bjjldw | 报价计量单位 | VARCHAR | | 40 | 0 | | | | |
bz_date | 并帐日期 | CHAR | | 10 | 0 | | | | |
bz_kjnd | 并帐会计年度 | CHAR | | 4 | 0 | | | | |
bz_kjqj | 并帐会计期间 | CHAR | | 2 | 0 | | | | |
bzbm | 币种pk | CHAR | | 20 | 0 | | | | |
cashitem | 现金流量项目 | CHAR | | 20 | 0 | | | | |
chbm_cl | 存货管理档案主键 | CHAR | | 20 | 0 | | | | |
checkflag | 对帐标志 | SMALLINT | | 2 | 0 | 0 | | | |
cinventoryid | 存货基本档案pk | CHAR | | 20 | 0 | | | | |
ckdh | 出库单号 | VARCHAR | | 50 | 0 | | | | |
ckdid | 出库单行id | CHAR | | 20 | 0 | | | | |
cksqsh | 源头单据行id | VARCHAR | | 20 | 0 | | | | |
clbh | 处理编号 | VARCHAR | | 20 | 0 | | | | |
commonflag | 通用标志 | VARCHAR | | 10 | 0 | | | | |
contractno | 采购合同号 | CHAR | | 20 | 0 | | | | |
ctzhtlx_pk | 筹投资合同类型 | CHAR | | 20 | 0 | | | | |
ddh | 订单号 | VARCHAR | | 50 | 0 | | | | |
ddhh | 上层来源单据行id | CHAR | | 20 | 0 | | | | |
ddhid | 订单行id | CHAR | | 20 | 0 | | | | |
ddlx | 上层来源单据id | VARCHAR | | 20 | 0 | | | | |
deptid | 部门pk | CHAR | | 20 | 0 | | | | |
dfbbje | 贷方本币金额 | DECIMAL | | 20 | 8 | 0 | | | |
dfbbsj | 贷方本币税金 | DECIMAL | | 20 | 8 | 0 | | | |
dfbbwsje | 贷方本币无税金额 | DECIMAL | | 20 | 8 | 0 | | | |
dffbje | 贷方辅币金额 | DECIMAL | | 20 | 8 | 0 | | | |
dffbsj | 贷方辅币税金 | DECIMAL | | 20 | 8 | 0 | | | |
dfjs | 贷方件数 | DECIMAL | | 20 | 8 | 0 | | | |
dfshl | 贷方数量 | DECIMAL | | 20 | 8 | 0 | | | |
dfybje | 贷方原币金额 | DECIMAL | | 20 | 8 | 0 | | | |
dfybsj | 贷方原币税金 | DECIMAL | | 20 | 8 | 0 | | | |
dfybwsje | 贷方原币无税金额 | DECIMAL | | 20 | 8 | 0 | | | |
dfyhzh | 对方银行帐号 | CHAR | | 20 | 0 | | | | |
dj | 单价 | DECIMAL | | 20 | 8 | | | | |
djbh | 单据编号冗余 | VARCHAR | | 30 | 0 | | | | |
djdl | 单据大类 | VARCHAR | | 2 | 0 | | | | |
djlxbm | 单据类型编码 | VARCHAR | | 20 | 0 | | | | |
djxtflag | 单据协同标志 | SMALLINT | | 2 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
dwbm | 公司pk | CHAR | | 4 | 0 | | | | |
encode | 密文 | VARCHAR | | 1000 | 0 | | | | |
equipmentcode | 设备编码 | VARCHAR | | 20 | 0 | | | | |
facardbh | 固定资产卡片号 | CHAR | | 20 | 0 | | | | |
fbhl | 辅币汇率 | DECIMAL | | 15 | 8 | | | | |
fbpjlx | 辅币票据利息 | DECIMAL | | 20 | 8 | | | | |
fbtxfy | 辅币贴现费用 | DECIMAL | | 20 | 8 | | | | |
fbye | 辅币余额 | DECIMAL | | 20 | 8 | 0 | | | |
fkyhdz | 付款银行地址 | VARCHAR | | 90 | 0 | | | | |
fkyhmc | 付款银行名称 | VARCHAR | | 512 | 0 | | | | |
fkyhzh | 付款银行帐号 | VARCHAR | | 200 | 0 | | | | |
flbh | 单据分录编号 | SMALLINT | | 2 | 0 | | | | |
fph | 发票号 | VARCHAR | | 30 | 0 | | | | |
fphid | 发票行id | CHAR | | 20 | 0 | | | | |
freeitemid | 自由项关联主键 | CHAR | | 20 | 0 | | | | |
fx | 方向 | SMALLINT | | 2 | 0 | 1 | | | |
groupnum | 批次号 | VARCHAR | | 30 | 0 | | | | |
hbbm | 客商基本档案主键 | CHAR | | 20 | 0 | | | | |
hsdj | 含税单价 | DECIMAL | | 20 | 8 | 0 | | | |
htbh | 合同编号 | VARCHAR | | 20 | 0 | | | | |
htmc | 合同名称(冗余) | VARCHAR | | 30 | 0 | | | | |
innerorderno | 调拨订单号 | VARCHAR | | 30 | 0 | | | | |
item_bill_pk | 事项审批单PK | CHAR | | 20 | 0 | | | | |
itemstyle | 项目类型 | CHAR | | 20 | 0 | | | | |
jfbbje | 借方本币金额 | DECIMAL | | 20 | 8 | 0 | | | |
jfbbsj | 借方本币税金 | DECIMAL | | 20 | 8 | 0 | | | |
jffbje | 借方辅币金额 | DECIMAL | | 20 | 8 | 0 | | | |
jffbsj | 借方辅币税金 | DECIMAL | | 20 | 8 | 0.0 | | | |
jfjs | 借方件数 | DECIMAL | | 20 | 8 | 0 | | | |
jfshl | 借方数量 | DECIMAL | | 20 | 8 | 0 | | | |
jfybje | 借方原币金额 | DECIMAL | | 20 | 8 | 0 | | | |
jfybsj | 借方原币税金 | DECIMAL | | 20 | 8 | 0 | | | |
jfybwsje | 借方原币无税金额 | DECIMAL | | 20 | 8 | 0 | | | |
jobid | 专项基本档案id | CHAR | | 20 | 0 | | | | |
jobphaseid | 专项阶段oid | CHAR | | 20 | 0 | | | | |
jsfsbm | 上层来源单据类型 | VARCHAR | | 20 | 0 | | | | |
kmbm | 科目pk | CHAR | | 20 | 0 | | | | |
kprq | 开票日期 | CHAR | | 10 | 0 | | | | |
kslb | 扣税类别 | SMALLINT | | 2 | 0 | | | | |
kxyt | 款项用途 | VARCHAR | | 20 | 0 | | | | |
notetype | 票据类型 | CHAR | | 20 | 0 | | | | |
ordercusmandoc | 订单客商 | CHAR | | 20 | 0 | | | | |
othersysflag | 外系统特殊标志 | VARCHAR | | 10 | 0 | | | | |
pausetransact | 挂起标志 | CHAR | | 1 | 0 | | | | |
paydate | 支付日期 | CHAR | | 10 | 0 | | | | |
payflag | 支付状态 | SMALLINT | | 2 | 0 | | | | |
payman | 支付人 | CHAR | | 20 | 0 | | | | |
pch | 筹投资标志 | VARCHAR | | 10 | 0 | | | | |
ph | 源头单据类型 | VARCHAR | | 20 | 0 | | | | |
pj_jsfs | 票据结算方式 | CHAR | | 20 | 0 | | | | |
pjdirection | 票据方向 | VARCHAR | | 10 | 0 | | | | |
pjh | 票据号 | VARCHAR | | 30 | 0 | | | | |
pk_jobobjpha | 项目阶段管理档案id | CHAR | | 20 | 0 | | | | |
pk_trader | 对方 | CHAR | | 20 | 0 | | | | |
produceorder | 生产订单号 | VARCHAR | | 30 | 0 | | | | |
productline | 产品线 | CHAR | | 20 | 0 | | | | |
qxrq | 起效日期 | CHAR | | 10 | 0 | | | | |
sanhu | 散户 | CHAR | | 20 | 0 | | | | |
seqnum | 批次号1 | VARCHAR | | 100 | 0 | | | | |
sfbz | 收付标志 | VARCHAR | | 2 | 0 | 3 | | | |
sfkxyh | 收付款协议号 | VARCHAR | | 20 | 0 | | | | |
shlye | 数量余额 | DECIMAL | | 20 | 8 | 0 | | | |
skyhdz | 收款银行地址 | VARCHAR | | 60 | 0 | | | | |
skyhmc | 收款银行名称 | VARCHAR | | 256 | 0 | | | | |
skyhzh | 收款银行帐号 | VARCHAR | | 200 | 0 | | | | |
sl | 税率 | DECIMAL | | 9 | 6 | | | | |
spzt | 审批状态 | SMALLINT | | 2 | 0 | | | | |
srbz | 收入标志 | CHAR | | 1 | 0 | | | | |
szxmid | 收支项目ID | CHAR | | 20 | 0 | | | | |
task | 任务 | CHAR | | 20 | 0 | | | | |
tax_num | 税号 | VARCHAR | | 30 | 0 | | | | |
tbbh | 托收单号 | CHAR | | 20 | 0 | | | | |
tradertype | 对方类型 | SMALLINT | | 2 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
txlx_bbje | 贴现利息本币金额 | DECIMAL | | 20 | 8 | | | | |
txlx_fbje | 贴现利息辅币金额 | DECIMAL | | 20 | 8 | | | | |
txlx_ybje | 贴现利息原币金额 | DECIMAL | | 20 | 8 | | | | |
usedept | 使用部门 | CHAR | | 20 | 0 | | | | |
verifyfinisheddate | 核销完成日期 | CHAR | | 10 | 0 | 3000-12-31 | | | |
vouchid | 主表ID | CHAR | | 20 | 0 | | | | |
wbfbbje | 借方本币无税金额 | DECIMAL | | 20 | 8 | 0 | | | |
wbffbje | 贷方辅币无税金额 | DECIMAL | | 20 | 8 | 0 | | | |
wbfybje | 借方辅币无税金额 | DECIMAL | | 20 | 8 | 0 | | | |
wldx | 往来对象标志 | SMALLINT | | 2 | 0 | | | | |
xgbh | 并账标志 | SMALLINT | | 2 | 0 | | | | |
xm | 项目 | CHAR | | 20 | 0 | | | | |
xmbm2 | 专项管理档案id | CHAR | | 20 | 0 | | | | |
xmys | 项目要素 | CHAR | | 20 | 0 | | | | |
xyzh | 源头单据id | VARCHAR | | 20 | 0 | | | | |
ybpjlx | 原币票据利息 | DECIMAL | | 20 | 8 | | | | |
ybtxfy | 原币贴现费用 | DECIMAL | | 20 | 8 | | | | |
ybye | 原币余额 | DECIMAL | | 20 | 8 | 0 | | | |
ycskrq | 预测收款日期 | CHAR | | 10 | 0 | | | | |
ywbm | 单据类型pk冗余 | VARCHAR | | 20 | 0 | | | | |
ywxz | 业务性质 | CHAR | | 20 | 0 | | | | |
ywybm | 业务员pk | CHAR | | 20 | 0 | | | | |
zrdeptid | 责任部门 | CHAR | | 20 | 0 | | | | |
zy | 摘要 | VARCHAR | | 256 | 0 | | | | |
zyx1 | 自定义项1 | VARCHAR | | 100 | 0 | | | | |
zyx10 | 自定义项10 | VARCHAR | | 100 | 0 | | | | |
zyx11 | 自定义项11 | VARCHAR | | 100 | 0 | | | | |
zyx12 | 自定义项12 | VARCHAR | | 100 | 0 | | | | |
zyx13 | 自定义项13 | VARCHAR | | 100 | 0 | | | | |
zyx14 | 自定义项14 | VARCHAR | | 100 | 0 | | | | |
zyx15 | 自定义项15 | VARCHAR | | 100 | 0 | | | | |
zyx16 | 自定义项16 | VARCHAR | | 100 | 0 | | | | |
zyx17 | 自定义项17 | VARCHAR | | 100 | 0 | | | | |
zyx18 | 自定义项18 | VARCHAR | | 100 | 0 | | | | |
zyx19 | 自定义项19 | VARCHAR | | 100 | 0 | | | | |
zyx2 | 自定义项2 | VARCHAR | | 100 | 0 | | | | |
zyx20 | 自定义项20 | VARCHAR | | 100 | 0 | | | | |
zyx21 | 自定义项21 | VARCHAR | | 100 | 0 | | | | |
zyx22 | 自定义项22 | VARCHAR | | 100 | 0 | | | | |
zyx23 | 自定义项23 | VARCHAR | | 100 | 0 | | | | |
zyx24 | 自定义项24 | VARCHAR | | 100 | 0 | | | | |
zyx25 | 自定义项25 | VARCHAR | | 100 | 0 | | | | |
zyx26 | 自定义项26 | VARCHAR | | 100 | 0 | | | | |
zyx27 | 自定义项27 | VARCHAR | | 100 | 0 | | | | |
zyx28 | 自定义项28 | VARCHAR | | 100 | 0 | | | | |
zyx29 | 自定义项29 | VARCHAR | | 100 | 0 | | | | |
zyx3 | 自定义项3 | VARCHAR | | 100 | 0 | | | | |
zyx30 | 自定义项30 | VARCHAR | | 100 | 0 | | | | |
zyx4 | 自定义项4 | VARCHAR | | 100 | 0 | | | | |
zyx5 | 自定义项5 | VARCHAR | | 100 | 0 | | | | |
zyx6 | 自定义项6 | VARCHAR | | 100 | 0 | | | | |
zyx7 | 自定义项7 | VARCHAR | | 100 | 0 | | | | |
zyx8 | 自定义项8 | VARCHAR | | 100 | 0 | | | | |
zyx9 | 自定义项9 | VARCHAR | | 100 | 0 | | | | |
外键列表
索引列表