arap_djclb - 单据处理表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | clb_oid | 处理表id | CHAR | Y | 20 | 0 | | | | |
bbhl | 本币汇率 | DECIMAL | | 20 | 8 | | | | |
clbh | 处理编号 | VARCHAR | | 28 | 0 | | | | |
clbz | 处理标志 | SMALLINT | | 2 | 0 | | | | |
clid | 处理序号 | INT | | 4 | 0 | | | | |
clnd | 处理年度 | CHAR | | 4 | 0 | | | | |
clqj | 处理期间 | CHAR | | 2 | 0 | | | | |
clr | 处理人 | CHAR | | 20 | 0 | | | | |
clrq | 处理日期 | CHAR | | 10 | 0 | | | | |
dfclbbje | 贷方处理本币金额 | DECIMAL | | 20 | 8 | 0 | | | |
dfclbbje2 | 贷方处理本币金额2 | DECIMAL | | 20 | 8 | 0 | | | |
dfclfbje | 贷方处理辅币金额 | DECIMAL | | 20 | 8 | 0 | | | |
dfclfbje2 | 贷方处理辅币金额2 | DECIMAL | | 20 | 8 | 0 | | | |
dfclshl | 贷方处理数量 | DECIMAL | | 20 | 8 | | | | |
dfclshl2 | 贷方处理数量2 | DECIMAL | | 20 | 8 | 0 | | | |
dfclybje | 贷方处理原币金额 | DECIMAL | | 20 | 8 | 0 | | | |
dfclybje2 | 贷方处理原币金额2 | DECIMAL | | 20 | 8 | 0 | | | |
djbh | 单据编号 | VARCHAR | | 30 | 0 | | | | |
djdl | 单据大类 | VARCHAR | | 2 | 0 | | | | |
djrq | 单据日期 | CHAR | | 10 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
dwbm | 单位编码 | CHAR | | 4 | 0 | | | | |
dydjbh | 对应单据编号 | VARCHAR | | 30 | 0 | | | | |
dydjdl | 对应单据大类 | VARCHAR | | 2 | 0 | | | | |
dydjfbid | 对应单据付表id | CHAR | | 20 | 0 | | | | |
dydjfkxyid | 对应单据付款协议id | CHAR | | 20 | 0 | | | | |
dydjzbid | 对应单据主表id | CHAR | | 20 | 0 | | | | |
dydwbm | 对应单位编码 | CHAR | | 4 | 0 | | | | |
dyflbh | 对应单据分录类型 | SMALLINT | | 2 | 0 | | | | |
dysfbz | 对应收付标志 | VARCHAR | | 2 | 0 | | | | |
dyywbm | 对应业务类型编码 | CHAR | | 20 | 0 | | | | |
effectdate | 起效日期 | CHAR | | 10 | 0 | | | | |
fb_oid | 单据辅表id | CHAR | | 20 | 0 | | | | |
fbhl | 辅币汇率 | DECIMAL | | 20 | 8 | | | | |
fkxyb_oid | 单据付款协议表id | CHAR | | 20 | 0 | | | | |
flbh | 单据分录编号 | SMALLINT | | 2 | 0 | | | | |
hxbbhl | 核销辅币汇率 | DECIMAL | | 15 | 8 | | | | |
hxbh | 核销分录号 | SMALLINT | | 2 | 0 | 0 | | | |
hxfbhl | 核销本币汇率 | DECIMAL | | 15 | 8 | | | | |
isauto | 自动处理 | CHAR | | 1 | 0 | N | | | |
isreserve | 预占用 | SMALLINT | | 2 | 0 | 0 | | | |
jfclbbje | 借方处理本币金额 | DECIMAL | | 20 | 8 | 0 | | | |
jfclbbje2 | 借方处理本币金额2 | DECIMAL | | 20 | 8 | 0 | | | |
jfclfbje | 借方处理辅币金额 | DECIMAL | | 20 | 8 | 0 | | | |
jfclfbje2 | 借方处理辅币金额2 | DECIMAL | | 20 | 8 | 0 | | | |
jfclshl | 借方处理数量 | DECIMAL | | 20 | 8 | | | | |
jfclshl2 | 借方处理数量2 | DECIMAL | | 20 | 8 | 0 | | | |
jfclybje | 借方处理原币金额 | DECIMAL | | 20 | 8 | 0 | | | |
jfclybje2 | 借方处理原币金额2 | DECIMAL | | 20 | 8 | 0 | | | |
ordercusmandoc | 订单客商 | CHAR | | 20 | 0 | | | | |
samebzbm | 同币种 | CHAR | | 1 | 0 | N | | | |
samecinventoryid | 同存货 | CHAR | | 1 | 0 | N | | | |
samedeptid | 同部门 | CHAR | | 1 | 0 | N | | | |
samehbbm | 同客商 | CHAR | | 1 | 0 | N | | | |
samejobid | 同专项 | CHAR | | 1 | 0 | N | | | |
samekmbm | 同表体科目 | CHAR | | 1 | 0 | N | | | |
samekmbm_h | 同表头科目 | CHAR | | 1 | 0 | N | | | |
sameszxmid | 同收支项目 | CHAR | | 1 | 0 | N | | | |
samewldx | 同往来对象 | CHAR | | 1 | 0 | N | | | |
sameywybm | 同业务员 | CHAR | | 1 | 0 | N | | | |
shrq | 审核日期 | CHAR | | 10 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
vouchid | 主表id | CHAR | | 20 | 0 | | | | |
xydqr | 信用到期日 | CHAR | | 10 | 0 | | | | |
ywbm | 单据类型 | CHAR | | 20 | 0 | | | | |
zy | 摘要 | VARCHAR | | 20 | 0 | | | | |
外键列表
索引列表