BATM_DEPOSIT
定期通知存款返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1BILLDATECHAR19    操作日期
2DEF1VARCHAR2101    自定义项1
3DEF10VARCHAR2101    自定义项10
4DEF11VARCHAR2101    自定义项11
5DEF12VARCHAR2101    自定义项12
6DEF13VARCHAR2101    自定义项13
7DEF14VARCHAR2101    自定义项14
8DEF15VARCHAR2101    自定义项15
9DEF16VARCHAR2101    自定义项16
10DEF17VARCHAR2101    自定义项17
11DEF18VARCHAR2101    自定义项18
12DEF19VARCHAR2101    自定义项19
13DEF2VARCHAR2101    自定义项2
14DEF20VARCHAR2101    自定义项20
15DEF3VARCHAR2101    自定义项3
16DEF4VARCHAR2101    自定义项4
17DEF5VARCHAR2101    自定义项5
18DEF6VARCHAR2101    自定义项6
19DEF7VARCHAR2101    自定义项7
20DEF8VARCHAR2101    自定义项8
21DEF9VARCHAR2101    自定义项9
22DEPOSITAMOUNTNUMBER288   存入原币金额
23DEPOSITCODEVARCHAR250    存单号
24DEPOSITDATECHAR19    存款日期
25DEPOSITMODEVARCHAR250    存款类型
26DEPOSITTYPEVARCHAR250    存单类型
27DEPOSITYRATEVARCHAR250    年利率
28DEPOSTBALMNTNUMBER288   存款余额
29DRNUMBER100  0 
30ENDDATECHAR19    到期日期
31GLCDEPOSITAMOUNTNUMBER288   存入集团本币金额
32GLCDEPOSTBALMNTNUMBER288   存款集团本币余额
33GLCINTERESTNUMBER288   利息集团本币金额
34GLCWITHDRAWAMOUNTNUMBER288   支取集团本币金额
35GLLCDEPOSITAMOUNTNUMBER288   存入全局本币金额
36GLLCDEPOSTBALMNTNUMBER288   存款余全局本币额
37GLLCINTERESTNUMBER288   利息全局本币金额
38GLLCWITHDRAWAMOUNTNUMBER288   支取全局本币金额
39INTERESTNUMBER288   利息原币金额
40INTERVALUNITVARCHAR250    期限
41OLCDEPOSITAMOUNTNUMBER288   存入组织本币金额
42OLCDEPOSTBALMNTNUMBER288   存款组织本币余额
43OLCINTERESTNUMBER288   利息组织本币金额
44OLCWITHDRAWAMOUNTNUMBER288   支取组织本币金额
45PK_BANKVARCHAR250    存款银行
46PK_CURRTYPEVARCHAR220   '~'币种
47PK_DEPOSITCHAR20    主键
48PK_DEPOSITACCVARCHAR250    账号
49PK_DEPOSITORGVARCHAR220   '~'存款单位
50PK_DEPOSTRATEVARCHAR250    利率
51PK_GROUPVARCHAR250    所属集团
52PK_ORGVARCHAR250    资金组织
53PK_ORG_VVARCHAR250    资金组织版本
54PK_SOURCEBILLVARCHAR250    来源单据
55REDEPOSITTYPEVARCHAR250    转存类型
56TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
57WITHDRAWAMOUNTNUMBER288   支取原币金额