LCM_CONTRACT_EXEC
合同执行情况返回目录
序号列名数据类型长度小数位数主键自增允许空默认值列说明
1BUSIDATECHAR19    日期
2DRNUMBER100  0 
3GLCINTERESTNUMBER288   集团利息本币
4GLCPAYAMOUNTNUMBER288   集团已放本金本币
5GLCPAYCHARGENUMBER288   集团已付手续费本币
6GLCPAYINTERESTNUMBER288   集团已付利息本币
7GLCRATENUMBER158   集团本币汇率
8GLCREPAYAMOUNTNUMBER288   集团已还本金本币
9GLLCINTERESTNUMBER288   全局利息本币
10GLLCPAYAMOUNTNUMBER288   全局已放本金本币
11GLLCPAYCHARGENUMBER288   全局已付手续费本币
12GLLCPAYINTERESTNUMBER288   全局已付利息本币
13GLLCRATENUMBER158   全局本币汇率
14GLLCREPAYAMOUNTNUMBER288   全局已还本金本币
15INITIALFLAGCHAR1    期初标识
16INTERESTNUMBER288   利息
17INTERESTFLAGCHAR1    计息标识
18LEFTCHARGENUMBER288   未付手续费
19LEFTINTERESTNUMBER288   未付利息
20LEFTPAYAMOUNTNUMBER288   未放本金
21LEFTREPAYAMOUNTNUMBER288   未还本金
22OLCINTERESTNUMBER288   利息本币
23OLCPAYAMOUNTNUMBER288   已放本金本币
24OLCPAYCHARGENUMBER288   已付手续费本币
25OLCPAYINTERESTNUMBER288   已付利息本币
26OLCRATENUMBER158   本币汇率
27OLCREPAYAMOUNTNUMBER288   已还本金本币
28OPERATORVARCHAR220   '~'操作人
29PAYAMOUNTNUMBER288   放款金额
30PAYCHARGENUMBER288   已付手续费
31PAYINTERESTNUMBER288   已付利息
32PK_BILLTYPECODEVARCHAR220    单据类型
33PK_CONTRACTCHAR20     押汇合同_主键
34PK_CONTRACT_EXECCHAR20    主键
35PK_GROUPVARCHAR220   '~'集团
36PK_ORGVARCHAR220   '~'财务组织
37PK_ORG_VVARCHAR220   '~'财务组织版本
38PK_SRCBILLCHAR20    来源单据主键
39REPAYAMOUNTNUMBER288   已还本金
40SERIALNONUMBER380   序号
41SUMMARYVARCHAR250    摘要
42TSCHAR19   to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') 
43VBILLNOVARCHAR240    单据编号
44VDEF1VARCHAR2101    自定义项1
45VDEF10VARCHAR2101    自定义项10
46VDEF2VARCHAR2101    自定义项2
47VDEF3VARCHAR2101    自定义项3
48VDEF4VARCHAR2101    自定义项4
49VDEF5VARCHAR2101    自定义项5
50VDEF6VARCHAR2101    自定义项6
51VDEF7VARCHAR2101    自定义项7
52VDEF8VARCHAR2101    自定义项8
53VDEF9VARCHAR2101    自定义项9