GL_LASTPAGEDATA
最后一页数据返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1ASSIDCHAR20    辅助核算ID
2AVERAGEPRICENUMBER208   平均单价
3BALANCEDIRECTNUMBER380   余额方向
4BALCREDITAMOUNTNUMBER204   贷方原币余额
5BALCREDITFRACAMOUNTNUMBER204   贷方辅币余额
6BALCREDITLOCALAMOUNTNUMBER204   贷方本币余额
7BALCREDITQUANTNUMBER208   贷方余额数量
8BALDEBITAMOUNTNUMBER204   借方原币余额
9BALDEBITFRACAMOUNTNUMBER204   借方辅币余额
10BALDEBITLOCALAMOUNTNUMBER204   借方本币余额
11BALDEBITQUANTNUMBER208   借方余额数量
12BOTHORIFLAGCHAR1    是否双向显示
13CORPCODEVARCHAR212     
14CORPNAMEVARCHAR2100     
15CREDITAMOUNTNUMBER204   贷方原币金额
16CREDITFRACAMOUNTNUMBER204   贷方辅币金额
17CREDITLOCALAMOUNTNUMBER204   贷方本币金额
18CREDITQUANTNUMBER208   贷方数量
19CURRTYPENAMEVARCHAR220    币种名称
20DATESCHAR10     
21DAYBAKCHAR10    显示日期
22DEBITAMOUNTNUMBER204   借方原币金额
23DEBITFRACAMOUNTNUMBER204   借方辅币金额
24DEBITLOCALAMOUNTNUMBER204   借方本币金额
25DEBITQUANTNUMBER208   借方数量
26DIGITNUMNUMBER380   小数位数
27DRNUMBER100  0 
28EXCRATE1NUMBER158   折辅汇率
29EXCRATE2NUMBER158   折本汇率
30EXPLANATIONVARCHAR2200    摘要
31FREE1VARCHAR260    预留字段1
32FREE2VARCHAR260    预留字段2
33FREE3VARCHAR260    预留字段3
34FREE4VARCHAR260    预留字段4
35FREE5VARCHAR260    预留字段5
36GLBOOKCODEVARCHAR260    帐簿编码
37GLBOOKNAMEVARCHAR2100    帐簿名称
38GLORGCODEVARCHAR260     
39GLORGNAMEVARCHAR2100     
40OPPOSITESUBJVARCHAR2200    对方科目
41PERIODCHAR2    期间
42PK_ACCSUBJCHAR20    科目主键
43PK_CORPCHAR4     
44PK_CURRTYPECHAR20    币种主键
45PK_GLBOOKCHAR20     
46PK_GLORGCHAR20     
47PK_GLORGBOOKCHAR20     
48PK_LASTPAGEDATACHAR20    最后一页数据表主键
49PK_QUERYCONDITIONCHAR20    查询条件标识
50PK_VOUCHERCHAR20    凭证主键
51PK_VOUCHERTYPECHAR20    凭证类别主键
52PRICENUMBER208   单价
53ROWPROPERTYCHAR2    行属性
54SETTLEINFOVARCHAR2100    结算信息
55SUBFIELDPROPERTYCHAR2    小计合计属性
56SUBJCODEVARCHAR230    科目编码
57SUBJDIRECTNUMBER380   科目方向
58SUBJNAMEVARCHAR240    科目名称
59TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
60VOUCHERNOVARCHAR220    凭证号
61VOUCHERTYPENAMEVARCHAR220    凭证类别名称
62YEARCHAR4    年度