GPMC_GUACONTRACT 担保合同返回目录
序号 | 列名 | 数据类型 | 长度 | 小数位数 | 主键 | 自增 | 允许空 | 默认值 | 列说明 |
1 | APPROVENOTE | VARCHAR2 | 200 | | | | √ | | 审批批语 |
2 | APPROVER | VARCHAR2 | 20 | | | | √ | '~' | 审批人 |
3 | AVAAMOUNT | NUMBER | 28 | 8 | | | √ | | 可用担保总金额 |
4 | BANKID | VARCHAR2 | 200 | | | | √ | | 金融机构 |
5 | BILLMAKEDATE | CHAR | 19 | | | | √ | | 制单日期 |
6 | BILLMAKER | VARCHAR2 | 20 | | | | √ | '~' | 制单人 |
7 | BILLMAKETIME | CHAR | 19 | | | | √ | | 制单时间 |
8 | BUSISTATUS | NUMBER | 38 | 0 | | | √ | | 单据状态 |
9 | CONTRACTNO | VARCHAR2 | 200 | | | | √ | | 担保合约号 |
10 | CONTRACTTYPE | NUMBER | 38 | 0 | | | √ | | 合同类型 |
11 | CREATIONTIME | CHAR | 19 | | | | √ | | 创建时间 |
12 | CREATOR | VARCHAR2 | 20 | | | | √ | '~' | 创建人 |
13 | CREDITOR | VARCHAR2 | 200 | | | | √ | | 债权人 |
14 | CREDITORTYPE | NUMBER | 38 | 0 | | | √ | | 债权人类型 |
15 | DAPPROVEDATE | CHAR | 19 | | | | √ | | 审批日期 |
16 | DEBTAMOUNT | NUMBER | 28 | 8 | | | √ | | 债务本币金额 |
17 | DEBTCURRENCYID | VARCHAR2 | 20 | | | | √ | '~' | 债务币种 |
18 | DEBTGLOAMOUNT | NUMBER | 28 | 8 | | | √ | | 债务全局本币金额 |
19 | DEBTGROAMOUNT | NUMBER | 28 | 8 | | | √ | | 债务集团本币金额 |
20 | DEBTNOTE | VARCHAR2 | 200 | | | | √ | | 担保债务描述 |
21 | DEBTOR | VARCHAR2 | 200 | | | | √ | | 债务人 |
22 | DEBTORTYPE | NUMBER | 38 | 0 | | | √ | | 债务人类型 |
23 | DEBTTYPE | VARCHAR2 | 20 | | | | √ | '~' | 债务种类 |
24 | DR | NUMBER | 10 | 0 | | | √ | 0 | |
25 | ENDDATE | CHAR | 19 | | | | √ | | 债务终止日期 |
26 | FINCREDITOR | VARCHAR2 | 20 | | | | √ | '~' | 债权人金融机构 |
27 | FINGUARANTOR | VARCHAR2 | 20 | | | | √ | '~' | 担保人金融机构 |
28 | GLCRATE | NUMBER | 28 | 8 | | | √ | | 集团本币汇率 |
29 | GLLCRATE | NUMBER | 28 | 8 | | | √ | | 全局本币汇率 |
30 | GLOAMOUNT | NUMBER | 28 | 8 | | | √ | | 担保全局本币总金额 |
31 | GLOAVAAMOUNT | NUMBER | 28 | 8 | | | √ | | 可用担保总额全局本币 |
32 | GLODEBTRATE | NUMBER | 28 | 8 | | | √ | | 债务全局本币汇率 |
33 | GLOMORAMOUNT | NUMBER | 28 | 8 | | | √ | | 抵押全局本币总金额 |
34 | GLOPLEAMOUNT | NUMBER | 28 | 8 | | | √ | | 质押全局本币总金额 |
35 | GLOUSEDAMOUNT | NUMBER | 28 | 8 | | | √ | | 已用全局本币担保总金额 |
36 | GROAMOUNT | NUMBER | 28 | 8 | | | √ | | 担保集团本币总金额 |
37 | GROAVAAMOUNT | NUMBER | 28 | 8 | | | √ | | 可用担保总额集团本币 |
38 | GRODEBTRATE | NUMBER | 28 | 8 | | | √ | | 债务集团本币汇率 |
39 | GROMORAMOUNT | NUMBER | 28 | 8 | | | √ | | 抵押集团本币总金额 |
40 | GROPLEAMOUNT | NUMBER | 28 | 8 | | | √ | | 质押集团本币总金额 |
41 | GROUPGUAARTEE | CHAR | 1 | | | | √ | | 集团担保 |
42 | GROUSEDAMOUNT | NUMBER | 28 | 8 | | | √ | | 已用集团本币担保总金额 |
43 | GUAAMOUNT | NUMBER | 28 | 8 | | | √ | | 担保总金额 |
44 | GUACURRTYPEID | VARCHAR2 | 200 | | | | √ | | 担保币种 |
45 | GUAENDDATE | CHAR | 19 | | | | √ | | 担保结束日期 |
46 | GUALCAMOUNT | NUMBER | 28 | 8 | | | √ | | 担保本币总金额 |
47 | GUAOLCRATE | NUMBER | 28 | 8 | | | √ | | 担保本币汇率 |
48 | GUARANGE | VARCHAR2 | 200 | | | | √ | | 担保范围 |
49 | GUARANTOR | VARCHAR2 | 200 | | | | √ | | 担保人 |
50 | GUARANTORTYPE | NUMBER | 38 | 0 | | | √ | | 担保人类型 |
51 | GUASTARTDATE | CHAR | 19 | | | | √ | | 担保开始日期 |
52 | GUATYPE | NUMBER | 38 | 0 | | | √ | | 担保方式 |
53 | INCREDITOR | VARCHAR2 | 20 | | | | √ | '~' | 债权人内部单位 |
54 | INDEBTOR | VARCHAR2 | 20 | | | | √ | '~' | 债务人内部单位 |
55 | INGUARANTOR | VARCHAR2 | 20 | | | | √ | '~' | 担保人内部单位 |
56 | ISCONTRARY | CHAR | 1 | | | | √ | | 是否需要反担保 |
57 | ISEARLY | CHAR | 1 | | | | √ | | 期初标志 |
58 | ISVERSIONEFFECT | CHAR | 1 | | | | √ | | 版本是否有效 |
59 | MAXAMOUNT | CHAR | 1 | | | | √ | | 最高额保证合同 |
60 | MODIFIEDTIME | CHAR | 19 | | | | √ | | 最后修改时间 |
61 | MODIFIER | VARCHAR2 | 20 | | | | √ | '~' | 最后修改人 |
62 | MORAMOUNT | NUMBER | 28 | 8 | | | √ | | 抵押总金额 |
63 | MORLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 抵押本币总金额 |
64 | OLCDEBTRATE | NUMBER | 28 | 8 | | | √ | | 债务本币汇率 |
65 | OLCRATE | NUMBER | 28 | 8 | | | √ | | 组织本币汇率 |
66 | ORGAVAAMOUNT | NUMBER | 28 | 8 | | | √ | | 可用担保总额组织本币 |
67 | ORGUSEDAMOUNT | NUMBER | 28 | 8 | | | √ | | 已用组织本币担保总金额 |
68 | OWERCREDITOR | VARCHAR2 | 20 | | | | √ | '~' | 债权人本单位 |
69 | OWERDEBTOR | VARCHAR2 | 20 | | | | √ | '~' | 债务人本单位 |
70 | OWERGUARANTOR | VARCHAR2 | 20 | | | | √ | '~' | 担保人本单位 |
71 | PARTCREDITOR | VARCHAR2 | 20 | | | | √ | '~' | 债权人外部单位 |
72 | PARTDEBTOR | VARCHAR2 | 20 | | | | √ | '~' | 债务人外部单位 |
73 | PARTGUARANTOR | VARCHAR2 | 20 | | | | √ | '~' | 担保人外部单位 |
74 | PK_BILLTYPECODE | VARCHAR2 | 200 | | | | √ | | 单据类型 |
75 | PK_BILLTYPEID | VARCHAR2 | 200 | | | | √ | | 单据类型主键 |
76 | PK_CURRTYPE | VARCHAR2 | 20 | | | | √ | '~' | 币种 |
77 | PK_GROUP | VARCHAR2 | 20 | | | | √ | '~' | 所属集团 |
78 | PK_GUACONTRACT | CHAR | 20 | | √ | | | | 主键 |
79 | PK_ORG | VARCHAR2 | 20 | | | | √ | '~' | 组织 |
80 | PK_ORG_V | VARCHAR2 | 20 | | | | √ | '~' | 组织版本 |
81 | PK_SRCBILL | VARCHAR2 | 200 | | | | √ | | 来源单据主键 |
82 | PK_SRCBILLTYPEID | VARCHAR2 | 200 | | | | √ | | 来源单据类型主键 |
83 | PK_VERSION | VARCHAR2 | 20 | | | | √ | | 版本pk |
84 | PLEAMOUNT | NUMBER | 28 | 8 | | | √ | | 质押总金额 |
85 | PLELCAMOUNT | NUMBER | 28 | 8 | | | √ | | 质押本币总金额 |
86 | PRIDEBTAMOUNT | NUMBER | 28 | 8 | | | √ | | 债务金额 |
87 | REMARK | VARCHAR2 | 200 | | | | √ | | 详细说明 |
88 | SOURCESYSTYPECODE | VARCHAR2 | 200 | | | | √ | | 来源系统 |
89 | SRCBILLNO | VARCHAR2 | 200 | | | | √ | | 来源单据号 |
90 | STARTDATE | CHAR | 19 | | | | √ | | 债务起始日期 |
91 | SUMMARY | VARCHAR2 | 200 | | | | √ | | 摘要 |
92 | TS | CHAR | 19 | | | | √ | to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') | |
93 | USEDAMOUNT | NUMBER | 28 | 8 | | | √ | | 已用担保总金额 |
94 | VBILLNO | VARCHAR2 | 200 | | | | √ | | 单据编号 |
95 | VBILLSTATUS | VARCHAR2 | 200 | | | | √ | | 审批状态 |
96 | VDEF1 | VARCHAR2 | 101 | | | | √ | | 自定义项1 |
97 | VDEF10 | VARCHAR2 | 101 | | | | √ | | 自定义项10 |
98 | VDEF11 | VARCHAR2 | 101 | | | | √ | | 自定义项11 |
99 | VDEF12 | VARCHAR2 | 101 | | | | √ | | 自定义项12 |
100 | VDEF13 | VARCHAR2 | 101 | | | | √ | | 自定义项13 |
101 | VDEF14 | VARCHAR2 | 101 | | | | √ | | 自定义项14 |
102 | VDEF15 | VARCHAR2 | 101 | | | | √ | | 自定义项15 |
103 | VDEF16 | VARCHAR2 | 101 | | | | √ | | 自定义项16 |
104 | VDEF17 | VARCHAR2 | 101 | | | | √ | | 自定义项17 |
105 | VDEF18 | VARCHAR2 | 101 | | | | √ | | 自定义项18 |
106 | VDEF19 | VARCHAR2 | 101 | | | | √ | | 自定义项19 |
107 | VDEF2 | VARCHAR2 | 101 | | | | √ | | 自定义项2 |
108 | VDEF20 | VARCHAR2 | 101 | | | | √ | | 自定义项20 |
109 | VDEF3 | VARCHAR2 | 101 | | | | √ | | 自定义项3 |
110 | VDEF4 | VARCHAR2 | 101 | | | | √ | | 自定义项4 |
111 | VDEF5 | VARCHAR2 | 101 | | | | √ | | 自定义项5 |
112 | VDEF6 | VARCHAR2 | 101 | | | | √ | | 自定义项6 |
113 | VDEF7 | VARCHAR2 | 101 | | | | √ | | 自定义项7 |
114 | VDEF8 | VARCHAR2 | 101 | | | | √ | | 自定义项8 |
115 | VDEF9 | VARCHAR2 | 101 | | | | √ | | 自定义项9 |
116 | VERSIONDATE | CHAR | 19 | | | | √ | | 版本日期 |
117 | VERSIONER | VARCHAR2 | 20 | | | | √ | '~' | 版本创建人 |
118 | VERSIONMARK | VARCHAR2 | 100 | | | | √ | | 版本原因 |
119 | VERSIONNO | NUMBER | 38 | 0 | | | √ | | 版本号 |
120 | VERSIONORIGIN | VARCHAR2 | 200 | | | | √ | | 版本来源 |
121 | WARGLOAMOUNT | NUMBER | 28 | 8 | | | √ | | 保证全局本币总额 |
122 | WARGROAMOUNT | NUMBER | 28 | 8 | | | √ | | 保证集团本币总额 |
123 | WARLCAMOUNT | NUMBER | 28 | 8 | | | √ | | 保证本币总金额 |
124 | WARLIABILITY | NUMBER | 38 | 0 | | | √ | | 保证责任 |
125 | WAROCAMOUNT | NUMBER | 28 | 8 | | | √ | | 保证总金额 |
|