gl_lastpagedata - 按年排页打印最后一页数据表
字段列表
编码 | 显示名称 | 数据类型 | 主键 | 长度 | 精度 | 默认值 | 初始值 | 提示 | 注释 | pk_lastpagedata | 最后一页数据表主键 | CHAR | Y | 20 | 0 | | | | |
assid | 辅助核算id | CHAR | | 20 | 0 | | | | |
averageprice | 平均单价 | DECIMAL | | 20 | 8 | | | | |
balancedirect | 余额方向 | SMALLINT | | 2 | 0 | | | | |
balcreditamount | 贷方原币余额 | DECIMAL | | 20 | 4 | | | | |
balcreditfracamount | 贷方辅币余额 | DECIMAL | | 20 | 4 | | | | |
balcreditlocalamount | 贷方本币余额 | DECIMAL | | 20 | 4 | | | | |
balcreditquant | 贷方余额数量 | DECIMAL | | 20 | 8 | | | | |
baldebitamount | 借方原币余额 | DECIMAL | | 20 | 4 | | | | |
baldebitfracamount | 借方辅币余额 | DECIMAL | | 20 | 4 | | | | |
baldebitlocalamount | 借方本币余额 | DECIMAL | | 20 | 4 | | | | |
baldebitquant | 借方余额数量 | DECIMAL | | 20 | 8 | | | | |
bothoriflag | 是否双向显示 | CHAR | | 1 | 0 | | | | |
corpcode | 公司编码 | VARCHAR | | 12 | 0 | | | | |
corpname | 公司名称 | VARCHAR | | 100 | 0 | | | | |
creditamount | 贷方原币金额 | DECIMAL | | 20 | 4 | | | | |
creditfracamount | 贷方辅币金额 | DECIMAL | | 20 | 4 | | | | |
creditlocalamount | 贷方本币金额 | DECIMAL | | 20 | 4 | | | | |
creditquant | 贷方数量 | DECIMAL | | 20 | 8 | | | | |
currtypename | 币种名称 | VARCHAR | | 20 | 0 | | | | |
day | 日期 | CHAR | | 10 | 0 | | | | |
daybak | 显示日期 | CHAR | | 10 | 0 | | | | |
debitamount | 借方原币金额 | DECIMAL | | 20 | 4 | | | | |
debitfracamount | 借方辅币金额 | DECIMAL | | 20 | 4 | | | | |
debitlocalamount | 借方本币金额 | DECIMAL | | 20 | 4 | | | | |
debitquant | 借方数量 | DECIMAL | | 20 | 8 | | | | |
digitnum | 小数位数 | INT | | 4 | 0 | | | | |
dr | 删除标志 | SMALLINT | | 2 | 0 | | | | |
excrate1 | 折辅汇率 | DECIMAL | | 15 | 8 | | | | |
excrate2 | 折本汇率 | DECIMAL | | 15 | 8 | | | | |
explanation | 摘要 | VARCHAR | | 200 | 0 | | | | |
free1 | 预留字段1 | VARCHAR | | 60 | 0 | | | | |
free2 | 预留字段2 | VARCHAR | | 60 | 0 | | | | |
free3 | 预留字段3 | VARCHAR | | 60 | 0 | | | | |
free4 | 预留字段4 | VARCHAR | | 60 | 0 | | | | |
free5 | 预留字段5 | VARCHAR | | 60 | 0 | | | | |
glbookcode | 帐簿编码 | VARCHAR | | 60 | 0 | | | | |
glbookname | 帐簿名称 | VARCHAR | | 100 | 0 | | | | |
glorgcode | 主体编码 | VARCHAR | | 60 | 0 | | | | |
glorgname | 主体名称 | VARCHAR | | 100 | 0 | | | | |
month | 期间 | CHAR | | 2 | 0 | | | | |
oppositesubj | 对方科目 | VARCHAR | | 200 | 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_querycondition | 查询条件主键 | CHAR | | 20 | 0 | | | | |
pk_voucher | 凭证主键 | CHAR | | 20 | 0 | | | | |
pk_vouchertype | 凭证类别主键 | CHAR | | 20 | 0 | | | | |
price | 单价 | DECIMAL | | 20 | 8 | | | | |
rowproperty | 行属性 | CHAR | | 2 | 0 | | | | |
settleinfo | 结算信息 | VARCHAR | | 100 | 0 | | | | |
subfieldproperty | 小计合计属性 | CHAR | | 2 | 0 | | | | |
subjcode | 科目编码 | VARCHAR | | 30 | 0 | | | | |
subjdirect | 科目方向 | SMALLINT | | 2 | 0 | | | | |
subjname | 科目名称 | VARCHAR | | 40 | 0 | | | | |
ts | 时间戳 | CHAR | | 19 | 0 | | | | |
voucherno | 凭证号 | VARCHAR | | 20 | 0 | | | | |
vouchertypename | 凭证类别名称 | VARCHAR | | 20 | 0 | | | | |
year | 年度 | CHAR | | 4 | 0 | | | | |
外键列表
索引列表