gl_detail - 凭证分录
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_detail | 分录主键 | CHAR | Y | 20 | 0 | | | | |
assid | 辅助核算标识 | CHAR | | 20 | 0 | | | | |
bankaccount | 银行帐户 | VARCHAR | | 40 | 0 | | | | |
busireconno | 业务系统协同号 | VARCHAR | | 60 | 0 | | | | |
checkdate | 票据日期 | CHAR | | 10 | 0 | | | | |
checkno | 票据编码 | VARCHAR | | 30 | 0 | | | | |
checkstyle | 结算方式 | VARCHAR | | 20 | 0 | | | | |
contrastflag | 队对账标志 | SMALLINT | | 2 | 0 | 0 | | | |
convertflag | 是否折算凭证标志 | CHAR | | 1 | 0 | | | | |
creditamount | 原币贷发生额 | DECIMAL | | 20 | 4 | | | | |
creditquantity | 贷方数量 | DECIMAL | | 20 | 8 | | | | |
debitamount | 原币借发生额 | DECIMAL | | 20 | 4 | | | | |
debitquantity | 借方数量 | DECIMAL | | 20 | 8 | | | | |
detailindex | 分录号 | INT | | 4 | 0 | | | | |
direction | 发生额方向 | CHAR | | 1 | 0 | | | | |
discardflagv | 作废标志 | CHAR | | 1 | 0 | N | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
errmessage | 错误信息 | VARCHAR | | 90 | 0 | | | | |
errmessage2 | 错误信息2 | VARCHAR | | 60 | 0 | | | | |
errmessageh | 标错的历史信息 | VARCHAR | | 90 | 0 | | | | |
excrate1 | 汇率1 | DECIMAL | | 15 | 8 | | | | |
excrate2 | 汇率2 | DECIMAL | | 15 | 8 | | | | |
explanation | 摘要内容 | VARCHAR | | 300 | 0 | | | | |
fraccreditamount | 辅币贷发生额 | DECIMAL | | 20 | 4 | | | | |
fracdebitamount | 辅币借发生额 | DECIMAL | | 20 | 4 | | | | |
free1 | 核销号 | VARCHAR | | 60 | 0 | | | | |
free10 | FREE10 | VARCHAR | | 60 | 0 | | | | |
free11 | FREE11 | VARCHAR | | 60 | 0 | | | | |
free2 | 核销日期 | VARCHAR | | 60 | 0 | | | | |
free3 | 票据类型 | VARCHAR | | 60 | 0 | | | | |
free4 | 内部交易业务号 | VARCHAR | | 60 | 0 | | | | |
free5 | 内部交易业务日期 | VARCHAR | | 60 | 0 | | | | |
free6 | 调整期间 | VARCHAR | | 60 | 0 | | | | |
free7 | FREE7 | VARCHAR | | 60 | 0 | | | | |
free8 | FREE8 | VARCHAR | | 60 | 0 | | | | |
free9 | FREE9 | VARCHAR | | 60 | 0 | | | | |
isdifflag | 是否差异凭证 | CHAR | | 1 | 0 | | | | |
localcreditamount | 本币贷发生额 | DECIMAL | | 20 | 4 | | | | |
localdebitamount | 本币借发生额 | DECIMAL | | 20 | 4 | | | | |
modifyflag | 修改标志 | CHAR | | 20 | 0 | | | | |
nov | 凭证编码 | INT | | 4 | 0 | | | | |
oppositesubj | 对方科目 | VARCHAR | | 200 | 0 | | | | |
periodv | 会计期间 | CHAR | | 2 | 0 | | | | |
pk_accsubj | 科目主键 | CHAR | | 20 | 0 | | | | |
pk_corp | 公司编码 | CHAR | | 4 | 0 | | | | |
pk_currtype | 币种主键 | CHAR | | 20 | 0 | | | | |
pk_glbook | 帐簿 | CHAR | | 20 | 0 | | | | |
pk_glorg | 主体 | CHAR | | 20 | 0 | | | | |
pk_glorgbook | 主体帐簿 | CHAR | | 20 | 0 | | | | |
pk_innercorp | 内部交易单位 | VARCHAR | | 20 | 0 | | | | |
pk_innersob | 交易单位帐簿主键 | VARCHAR | | 20 | 0 | | | | |
pk_managerv | 记账人 | VARCHAR | | 20 | 0 | | | | |
pk_offerdetail | 被冲销的分录主键 | CHAR | | 20 | 0 | | | | |
pk_othercorp | 内部客商对方公司pk | VARCHAR | | 4 | 0 | | | | |
pk_otherorgbook | 内部客商对方公司pk_glorgbook | CHAR | | 20 | 0 | | | | |
pk_sob | 帐簿主键 | CHAR | | 20 | 0 | | | | |
pk_sourcepk | 折算来源凭证pk | CHAR | | 20 | 0 | | | | |
pk_systemv | 制单系统 | CHAR | | 20 | 0 | | | | |
pk_voucher | 凭证主键 | CHAR | | 20 | 0 | | | | |
pk_vouchertypev | 凭证类别主键 | CHAR | | 20 | 0 | | | | |
prepareddatev | 制单日期 | CHAR | | 10 | 0 | | | | |
price | 单价 | DECIMAL | | 20 | 8 | | | | |
recieptclass | 单据处理类 | VARCHAR | | 60 | 0 | | | | |
signdatev | 签字日期 | CHAR | | 10 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
voucherkindv | 凭证类型 | SMALLINT | | 2 | 0 | | | | |
yearv | 会计年度 | CHAR | | 4 | 0 | | | | |
外键列表
索引列表