1 |
ACC_NUMBER_LIQ |
清算所得账号 |
VARCHAR2 |
35 |
0 |
Y |
|
|
|
|
Account number for liquidation proceeds - 清算所得账号 |
2 |
ACS_DESC |
成本说明 |
VARCHAR2 |
30 |
0 |
Y |
|
|
|
|
Description of the cost - 成本说明 |
3 |
ACS_ID |
附件或专用设备序列号 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Sequence Number of Accessory or Special Equipment - 附件或专用设备序列号 |
4 |
ACS_TYPE |
附件类型 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Accessory Type - 附件类型 |
5 |
ACS_VALUE |
附件的价值 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Value of the Accessory - 附件的价值 |
6 |
ACS_VALUE_CURR |
配件价值货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency for Value of the accessory - 配件价值货币 |
7 |
AST_GUID |
表CMS_ AST的GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
GUID for Table CMS_AST - 表CMS_ AST的GUID |
8 |
AST_TYP |
资产类型 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Asset Type - 资产类型 |
9 |
BANK_CNTRY_LIQ |
银行国家密钥 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Bank country key - 银行国家密钥 |
10 |
BANK_CTRLKEY_LIQ |
银行控制键 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Bank Control Key - 银行控制键 |
11 |
BANK_KEY_LIQ |
银行密钥 |
VARCHAR2 |
15 |
0 |
Y |
|
|
|
|
Bank Key - 银行密钥 |
12 |
DEL_INDICATOR |
链接指示器 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Link Indicator - 链接指示器 |
13 |
END_DATE |
房地产重估终止日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
End date for Revaluation of the Real Estate - 房地产重估终止日期 |
14 |
EXP_ACC_DATE |
预计应计日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Expected accrual date - 预计应计日期 |
15 |
EXP_PRCD_AMNT |
预计进行金额 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Expected Proceed Amount - 预计进行金额 |
16 |
EXP_PRCD_CURR |
货币:预计 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency: Expected Proceed - 货币:预计 |
17 |
IS_SUB_AST_CREA |
指示是否为建筑零件创建子资源 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Indicates whether a Sub-asset is created for Building Part - 指示是否为建筑零件创建子资源 |
18 |
LAST_VERF_DATE |
上次验证日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Last Verification Date - 上次验证日期 |
19 |
LENDING_RATE_IND |
指示资产是否具有默认贷款利率 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Indicates that the asset has a default lending rate or not - 指示资产是否具有默认贷款利率 |
20 |
LENDING_RATE1 |
贷款利率1 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Lending rate 1 - 贷款利率1 |
21 |
LENDING_RATE2 |
贷款利率2 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Lending rate 2 - 贷款利率2 |
22 |
LENDING_RATE3 |
贷款利率3 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Lending rate 3 - 贷款利率3 |
23 |
LENDING_RATE4 |
贷款利率4 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Lending rate 4 - 贷款利率4 |
24 |
LENDING_RATE5 |
贷款利率5 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Lending rate 5 - 贷款利率5 |
25 |
LIQD_AMT |
抵押品清算收益 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Returns from the Liquidation of Collateral - 抵押品清算收益 |
26 |
LIQD_CURR |
清算价值货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of Liquidation Value - 清算价值货币 |
27 |
LIQD_DATE |
抵押品清算日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Date on which the Collateral was Liquidated - 抵押品清算日期 |
28 |
LIQD_REASON |
清算原因 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Liquidation Reason - 清算原因 |
29 |
LIQD_TYP |
清算类型 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Liquidation Type - 清算类型 |
30 |
NO_OF_ACS |
附属装置数量 |
INTEGER |
10 |
0 |
Y |
|
|
|
|
No of Accessory Units - 附属装置数量 |
31 |
OBJ_GUID |
房地产对象的GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
GUID for Real Estate Object - 房地产对象的GUID |
32 |
OBJ_PRT_GUID |
对象部分的GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
GUID for Object part - 对象部分的GUID |
33 |
OBJECT_ID |
对象ID |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
Object ID - 对象ID |
34 |
OBJECT_TYPE |
房地产对象类型ID |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Real Estate Object Type ID - 房地产对象类型ID |
35 |
PARENT_GUID |
资源Guid作为子资源的父Guid |
RAW |
16 |
0 |
Y |
|
|
|
|
Asset Guid as a parent GUID for a sub-asset - 资源Guid作为子资源的父Guid |
36 |
PART_ID |
对象的零件ID |
VARCHAR2 |
10 |
0 |
Y |
|
|
|
|
Part ID for the Object - 对象的零件ID |
37 |
RISK_CODE |
风险代码 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Risk Code - 风险代码 |
38 |
SFTY_IND |
表示资产是否有默认的sfty折扣 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Indicates that the asset has a default sfty discount or not - 表示资产是否有默认的sfty折扣 |
39 |
SFTY_DSCNT |
安全折扣 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Safety discount - 安全折扣 |
40 |
SFTY_AMOUNT |
作为金额的安全折扣 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Safety discount as an amount - 作为金额的安全折扣 |
41 |
SFTY_AMT_CURR |
安全折扣金额的货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of the Safety discount amount - 安全折扣金额的货币 |
42 |
VALUATION_TYP |
对物体进行的检查类型 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Type of Check conducted on the object - 对物体进行的检查类型 |
43 |
UNIT_VALN_FREQ |
指标:估价期 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Indicator : Valuation Period - 指标:估价期 |
44 |
PERIOD_VALN_FREQ |
房地产重估期 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Period of revaluation for a real estate - 房地产重估期 |
45 |
PAST_VALUED_DATE |
房地产最后估价的最近日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Most Recent Date on which the Real Estate was last Valued - 房地产最后估价的最近日期 |
46 |
START_DATE |
重估开始日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Revaluation Start date - 重估开始日期 |
47 |
UNIT_VERF_FREQ |
指标:验证资产的时间单位 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Indicator: Units of time for verification of an asset - 指标:验证资产的时间单位 |
48 |
PERIOD_VERF_FREQ |
资产的报表期间 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Statement Period for an Asset - 资产的报表期间 |