GL_CONTRASTDATA
对帐数据返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1ACCOUNTPROPVARCHAR236    账簿属性
2AMOUNTEQUALVARCHAR21    金额两清
3ASSIDVARCHAR236    辅助核算
4ASSIDARRAYVARCHAR236    辅助核算项
5BUSIRECONNOVARCHAR260    业务协同号
6CHECKDATECHAR19    结算日期
7CHECKNOVARCHAR230    结算号
8CHECKSTYLECHAR20    结算方式
9CONVERTFLAGCHAR1    折算标记
10CREDITAMOUNTNUMBER288  0原币贷发生额
11CREDITQUANTITYNUMBER288  0贷方数量
12DEBITAMOUNTNUMBER288  0原币借发生额
13DEBITQUANTITYNUMBER288  0借方数量
14DETAILNONUMBER380   分录号
15DISCARDFLAGCHAR1    作废标记
16DRNUMBER100  0 
17ERRMESSAGEVARCHAR260    错误消息
18EXPLANATIONVARCHAR2150    分录摘要
19GLOBALCREDITAMOUNTNUMBER288  0全局本币贷发生额
20GLOBALDEBITAMOUNTNUMBER288  0全局本币借发生额
21GROUPCREDITAMOUNTNUMBER288  0集团本币贷发生额
22GROUPDEBITAMOUNTNUMBER288  0集团本币借发生额
23INNERBUSDATECHAR19    内部交易业务日期
24INNERBUSNOVARCHAR260    内部交易业务号
25ISCONTRASTEDCHAR1    是否对帐
26ISINITCHAR1    是否期初
27ISRECONCILEVARCHAR21    是否协同
28LOCALCREDITAMOUNTNUMBER288  0组织本币贷发生额
29LOCALDEBITAMOUNTNUMBER288  0组织本币借发生额
30PERIODVVARCHAR22    会计期间
31PK_ACCASOAVARCHAR236    会计科目
32PK_ACCOUNTINGBOOKVARCHAR236   '~'核算账簿
33PK_CHECKEDVARCHAR236    审核人
34PK_CONTRASTDATAVARCHAR236    对账分录数据标识
35PK_CONTRASTRULEVARCHAR236    内部交易规则标识
36PK_CORPCONTRASTVARCHAR236    对账主表标识
37PK_CURRTYPECHAR20    币种
38PK_CUSTOMERCHAR20    客商档案标识
39PK_DETAILVARCHAR236     分录标识
40PK_GROUPVARCHAR236    所属集团
41PK_INNERORGVARCHAR236    内部交易单位
42PK_INNERSOBVARCHAR236    交易单位帐簿主键
43PK_MANAGERVVARCHAR236    记账人
44PK_ORGCHAR20     
45PK_OTHERCORPVARCHAR236    内部客商对方公司pk
46PK_OTHERORGBOOKVARCHAR236    内部客商对方公司pk_glorgbook
47PK_PREPAREDVARCHAR236    制单人
48PK_RECONCILERULEVARCHAR236    协同业务标识
49PK_SETOFBOOKVARCHAR236    账簿类型
50PK_SOURCEPKVARCHAR236    源凭证标识
51PK_SYSTEMVARCHAR236    来源系统
52PK_VOUCHERVARCHAR236    凭证标识
53PK_VOUCHERTYPEVVARCHAR236    凭证类别主键
54PREPAREDDATEVCHAR19    制单日期
55PRICENUMBER288   单价
56QUANTITYEQUALVARCHAR21    数量两清
57TOTALCREDITNUMBER288   凭证贷方合计
58TOTALDEBITNUMBER288   凭证借方合计
59TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
60VOUCHERKINDNUMBER380   凭证类别
61VOUCHERNONUMBER380   凭证号
62VOUCHEXPLANATIONVARCHAR2150    凭证摘要
63YEARINITCHAR1    是否年初
64YEARVVARCHAR24    会计年度