gl_voucher - 凭证表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_voucher | 凭证主键 | CHAR | Y | 20 | 0 | | | | |
addclass | 增加接口类 | VARCHAR | | 60 | 0 | | | | |
attachment | 附单据数 | SMALLINT | | 2 | 0 | | | | |
checkeddate | 审核日期 | CHAR | | 10 | 0 | | | | |
contrastflag | 对账标志 | SMALLINT | | 2 | 0 | 0 | | | |
convertflag | 是否折算凭证标志 | CHAR | | 1 | 0 | | | | |
deleteclass | 删除接口类 | VARCHAR | | 60 | 0 | | | | |
detailmodflag | 分录增删标志 | CHAR | | 1 | 0 | | | | |
discardflag | 作废标志 | CHAR | | 1 | 0 | N | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
errmessage | 错误信息 | VARCHAR | | 60 | 0 | | | | |
errmessageh | 错误凭证历史信息 | VARCHAR | | 90 | 0 | | | | |
explanation | 摘要 | VARCHAR | | 300 | 0 | | | | |
free1 | 调整期间 | VARCHAR | | 60 | 0 | | | | |
free10 | 预留字段10 | VARCHAR | | 60 | 0 | | | | |
free2 | 预留字段2 | VARCHAR | | 60 | 0 | | | | |
free3 | 预留字段3 | VARCHAR | | 60 | 0 | | | | |
free4 | 预留字段4 | VARCHAR | | 60 | 0 | | | | |
free5 | 预留字段5 | VARCHAR | | 60 | 0 | | | | |
free6 | 预留字段6 | VARCHAR | | 60 | 0 | | | | |
free7 | 预留字段7 | VARCHAR | | 60 | 0 | | | | |
free8 | 预留字段8 | VARCHAR | | 60 | 0 | | | | |
free9 | 预留字段9 | VARCHAR | | 60 | 0 | | | | |
isdifflag | ISDIFFLAG | CHAR | | 1 | 0 | N | | | |
modifyclass | 修改接口类 | VARCHAR | | 60 | 0 | | | | |
modifyflag | 修改标志 | CHAR | | 20 | 0 | | | | |
no | 凭证编码 | INT | | 4 | 0 | | | | |
offervoucher | 冲销凭证PK | VARCHAR | | 20 | 0 | | | | |
period | 会计期间 | CHAR | | 2 | 0 | | | | |
pk_casher | 出纳 | VARCHAR | | 20 | 0 | | | | |
pk_checked | 审核人 | VARCHAR | | 20 | 0 | | | | |
pk_corp | 公司编码 | CHAR | | 4 | 0 | | | | |
pk_glbook | 帐簿 | CHAR | | 20 | 0 | | | | |
pk_glorg | 主体 | CHAR | | 20 | 0 | | | | |
pk_glorgbook | 主体帐簿 | CHAR | | 20 | 0 | | | | |
pk_manager | 记账人 | VARCHAR | | 20 | 0 | | | | |
pk_prepared | 制单人 | VARCHAR | | 20 | 0 | | | | |
pk_sob | 帐簿主键 | CHAR | | 20 | 0 | | | | |
pk_sourcepk | 折算来源凭证pk | CHAR | | 20 | 0 | | | | |
pk_system | 制单系统 | CHAR | | 20 | 0 | | | | |
pk_vouchertype | 凭证类别主键 | CHAR | | 20 | 0 | | | | |
prepareddate | 制单日期 | CHAR | | 10 | 0 | | | | |
signdate | 签字日期 | CHAR | | 10 | 0 | | | | |
signflag | 签字标志 | CHAR | | 1 | 0 | | | | |
tallydate | 记账日期 | CHAR | | 10 | 0 | | | | |
totalcredit | 贷方合计 | DECIMAL | | 20 | 4 | | | | |
totaldebit | 借方合计 | DECIMAL | | 20 | 4 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
voucherkind | 凭证类型 | SMALLINT | | 2 | 0 | | | | |
year | 会计年度 | CHAR | | 4 | 0 | | | | |
外键列表
索引列表