FVM_EBANKBALANCE
银行账户余额信息返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1ACCNAMEVARCHAR2200    户名
2ACCNUMVARCHAR240    帐号
3ACCTYPENUMBER380   账户类型
4ARAPPROPVARCHAR250    收付属性
5BALANCENUMBER288   余额
6BALANCEDATECHAR19    余额日期
7BANKAREAVARCHAR280    开户地区
8CITYVARCHAR280    城市
9DEF1VARCHAR2200    自定义项1
10DEF2VARCHAR2200    自定义项2
11DEF3VARCHAR2200    自定义项3
12DEF4VARCHAR2200    自定义项4
13DEF5VARCHAR2200    自定义项5
14DEF6VARCHAR2200    自定义项6
15DEF7VARCHAR2200    自定义项7
16DEF8VARCHAR2200    自定义项8
17DEF9VARCHAR2200    自定义项9
18DRNUMBER100  0 
19GLCBALANCENUMBER288   余额集团本币
20GLCINMONEYNUMBER288   收入集团本币
21GLCOUTMONEYNUMBER288   支出集团本币
22GLCUSABLEBALANCENUMBER288   可用余额集团本币
23GLLCBALANCENUMBER288   余额全局本币
24GLLCINMONEYNUMBER288   收入全局本币
25GLLCOUTMONEYNUMBER288   支出全局本币
26GLLCUSABLEBALANCENUMBER288   可用余额全局本币
27INMONEYNUMBER288   收入
28ISINNERACCCHAR1    是否内部账户
29ISMARGINCHAR1    保证金户
30OLCBALANCENUMBER288   余额本币
31OLCINMONEYNUMBER288   收入本币
32OLCOUTMONEYNUMBER288   支出本币
33OLCUSABLEBALANCENUMBER288   可用余额本币
34OUTMNYNUMBER288   支出
35PK_BANKACCBASVARCHAR220   '~'银行账户主键
36PK_BANKACCSUBVARCHAR220   '~'银行账户子户主键
37PK_BANKDOCVARCHAR220   '~'开户银行
38PK_BANKTYPEVARCHAR220   '~'银行类别
39PK_CURRTYPEVARCHAR220   '~'币种
40PK_EBANK_BALANCEVARCHAR250    余额主键(银企直连)
41PK_FVM_BALANCECHAR20    余额主键
42PK_FVM_DZDVARCHAR250    对账单主键
43PK_GROUPVARCHAR220   '~'集团
44PK_NETBANKINFTPVARCHAR220   '~'网银信息
45PK_ORGVARCHAR220   '~'组织(核算)
46PROVINCEVARCHAR280    省份
47TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
48USABLEBALANCENUMBER288   可用余额
49YESTERDAYBALANCENUMBER288   昨日余额