FBM_DISCOUNTCALCULATE_B
贴现试算子表返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1DELAY_DAYSNUMBER380    
2DISCOUNT_DATECHAR19     
3DISCOUNT_DAYSNUMBER380   贴现天数
4DISCOUNT_INTERESTNUMBER288   贴现利息
5DISCOUNT_MONEYNUMBER288   贴现净值
6DRNUMBER100  0 
7ENABLE_DATECHAR19    起效日期
8FBMBILLNOVARCHAR250    票据编号(隐藏)
9GLC_DISCOUNT_INTERESTNUMBER288   集团贴现利息本币金额
10GLC_DISCOUNT_MONEYNUMBER288   集团贴现净值本币金额
11GLL_DISCOUNT_INTERESTNUMBER288   全局贴现利息本币金额
12GLL_DISCOUNT_MONEYNUMBER288   全局贴现净值本币金额
13INTEREST_DAYNUMBER288   贴现日利率
14INTEREST_DAYSNUMBER380    
15INTEREST_MONTHNUMBER288   贴现月利率
16INTEREST_YEARNUMBER288   贴现年利率
17OLC_DISCOUNT_INTERESTNUMBER288   组织贴现利息本币金额
18OLC_DISCOUNT_MONEYNUMBER288   组织贴现净值本币金额
19PK_DISCALCULATECHAR20    主表主键
20PK_GROUPVARCHAR220   '~'集团
21PK_ORGVARCHAR220   '~'组织
22PK_PK_DISCALCULATE_BCHAR20    主键
23PK_REGISTERVARCHAR220   '~'票据编号
24TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')