gl_commonvoucher - 常用凭证主表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_commonvoucher | pk_commonvoucher | CHAR | Y | 20 | 0 | | | | |
addclass | addclass | VARCHAR | | 60 | 0 | | | | |
attachment | attachment | SMALLINT | | 2 | 0 | | | | |
commoncode | commoncode | VARCHAR | | 20 | 0 | | | | |
commonsummary | commonsummary | CHAR | | 200 | 0 | | | | |
deleteclass | deleteclass | VARCHAR | | 60 | 0 | | | | |
detailmodflag | detailmodflag | CHAR | | 1 | 0 | | | | |
discardflag | discardflag | CHAR | | 1 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
errmessage | errmessage | VARCHAR | | 90 | 0 | | | | |
explanation | explanation | VARCHAR | | 300 | 0 | | | | |
isdifflag | 差异凭证标志 | CHAR | | 1 | 0 | | | | |
ispublic | ispublic | CHAR | | 1 | 0 | | | | |
modifyclass | modifyclass | VARCHAR | | 60 | 0 | | | | |
modifyflag | modifyflag | CHAR | | 20 | 0 | | | | |
no | no | INT | | 4 | 0 | | | | |
period | period | CHAR | | 2 | 0 | | | | |
pk_casher | pk_casher | CHAR | | 20 | 0 | | | | |
pk_checked | pk_checked | CHAR | | 20 | 0 | | | | |
pk_commnvclass | 常用凭证分类 | CHAR | | 20 | 0 | | | | |
pk_corp | pk_corp | CHAR | | 4 | 0 | | | | |
pk_glbook | 帐簿 | CHAR | | 20 | 0 | | | | |
pk_glorg | 主体 | CHAR | | 20 | 0 | | | | |
pk_glorgbook | 主体帐簿 | CHAR | | 20 | 0 | | | | |
pk_manager | pk_manager | CHAR | | 20 | 0 | | | | |
pk_prepared | pk_prepared | CHAR | | 20 | 0 | | | | |
pk_sob | 帐簿主键 | CHAR | | 20 | 0 | | | | |
pk_system | pk_system | CHAR | | 20 | 0 | | | | |
pk_user | pk_user | CHAR | | 20 | 0 | | | | |
pk_vouchertype | pk_vouchertype | CHAR | | 20 | 0 | | | | |
prepareddate | prepareddate | CHAR | | 10 | 0 | | | | |
signflag | signflag | CHAR | | 1 | 0 | | | | |
tallydate | tallydate | CHAR | | 10 | 0 | | | | |
totalcredit | totalcredit | DECIMAL | | 20 | 4 | | | | |
totaldebit | totaldebit | DECIMAL | | 20 | 4 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
voucherkind | voucherkind | SMALLINT | | 2 | 0 | | | | |
year | year | CHAR | | 4 | 0 | | | | |
外键列表
索引列表