1 |
ACC_NUMBER_LIQ |
清算所得账号 |
VARCHAR2 |
35 |
0 |
Y |
|
|
|
|
Account number for liquidation proceeds - 清算所得账号 |
2 |
ACCOUNT_NUMBER |
证券账户识别号 |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
Securities Account Identification Number - 证券账户识别号 |
3 |
AST_GUID |
表CMS_ AST的GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
GUID for Table CMS_AST - 表CMS_ AST的GUID |
4 |
AST_TYP |
资产类型 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Asset Type - 资产类型 |
5 |
BANK_CNTRY_LIQ |
银行国家密钥 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Bank country key - 银行国家密钥 |
6 |
BANK_CTRLKEY_LIQ |
银行控制键 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Bank Control Key - 银行控制键 |
7 |
BANK_KEY_LIQ |
银行密钥 |
VARCHAR2 |
15 |
0 |
Y |
|
|
|
|
Bank Key - 银行密钥 |
8 |
CON_MKT_VAL |
证券账户头寸市值 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Market Value of a Securities Account Position - 证券账户头寸市值 |
9 |
CON_MKT_VAL_CURR |
持仓市值折算货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of Converted Market Value of Positions - 持仓市值折算货币 |
10 |
CURR_PRICE_AT |
位置值记录时间戳 |
VARCHAR2 |
15 |
0 |
Y |
|
|
|
|
Position value recording Timestamp - 位置值记录时间戳 |
11 |
CURR_PRICE_CURR |
证券头寸当前价格的货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of Current Price of a Securities Position - 证券头寸当前价格的货币 |
12 |
CURR_PRICE_PCT |
证券头寸单位的当前价格 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Current Price of a Unit of a Securities Position - 证券头寸单位的当前价格 |
13 |
CURRENT_PRICE |
每单位证券头寸的当前价格 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Current Price of a Securities Postion per Unit - 每单位证券头寸的当前价格 |
14 |
DEL_INDICATOR |
链接指示器 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Link Indicator - 链接指示器 |
15 |
DEPO_BANK_ID |
存管银行标识 |
VARCHAR2 |
18 |
0 |
Y |
|
|
|
|
Depository Bank Identification - 存管银行标识 |
16 |
END_DATE |
估价结束日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Valuation End date - 估价结束日期 |
17 |
ISIN |
证券账户中职位的唯一ID |
VARCHAR2 |
20 |
0 |
Y |
|
|
|
|
Unique ID for a Position in a Securities Account - 证券账户中职位的唯一ID |
18 |
LENDING_RATE_IND |
指示资产是否具有默认贷款利率 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Indicates that the asset has a default lending rate or not - 指示资产是否具有默认贷款利率 |
19 |
LENDING_RATE1 |
贷款利率1 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Lending rate 1 - 贷款利率1 |
20 |
LIQD_AMT |
抵押品清算所得收益 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Proceeds obtained from liquidation of the collateral - 抵押品清算所得收益 |
21 |
LIQD_CURR |
清算价值货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of Liquidation value - 清算价值货币 |
22 |
LIQD_DATE |
抵押物清算日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Date of Liquidation of Collateral - 抵押物清算日期 |
23 |
LIQD_REASON |
清算原因 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Liquidation Reason - 清算原因 |
24 |
LIQD_TYP |
清算类型 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Liquidation type - 清算类型 |
25 |
MARKET_VAL_CURR |
证券头寸市值的货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of the Market Value of Securities Positions - 证券头寸市值的货币 |
26 |
MARKET_VALUE |
证券头寸的市值 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Market Value of a Securities Position - 证券头寸的市值 |
27 |
NO_OF_UNITS |
证券持仓单位数 |
FLOAT |
15 |
5 |
Y |
|
|
|
|
Number of Units in a Securities Position - 证券持仓单位数 |
28 |
NOMINAL_VAL_CURR |
头寸面值的货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of nominal value of a position - 头寸面值的货币 |
29 |
NOMINAL_VALUE |
位置的标称值 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Nominal Value of a Position - 位置的标称值 |
30 |
PARENT_GUID |
资源Guid作为子资源的父Guid |
RAW |
16 |
0 |
Y |
|
|
|
|
Asset Guid as a parent GUID for a sub-asset - 资源Guid作为子资源的父Guid |
31 |
PERIOD_VALN_FREQ |
证券重估期 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Period of revaluation for securities - 证券重估期 |
32 |
POS_NO |
证券账户头寸的序号 |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Sequence Number of a Position in a Securities Account - 证券账户头寸的序号 |
33 |
POS_OLD_REF_NO |
从外部系统引用的位置的ID |
VARCHAR2 |
32 |
0 |
Y |
|
|
|
|
ID of a Positiion Referenced from an External System - 从外部系统引用的位置的ID |
34 |
RISK_CODE |
风险代码 |
VARCHAR2 |
6 |
0 |
Y |
|
|
|
|
Risk Code - 风险代码 |
35 |
SEC_ACC_GUID |
证券账户GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
GUID for securities account - 证券账户GUID |
36 |
SEC_ACC_POS_GUID |
帐户中证券头寸的GUID |
RAW |
16 |
0 |
Y |
|
|
|
|
GUID for securities positions in an account - 帐户中证券头寸的GUID |
37 |
SFTY_IND |
表示资产是否有默认的sfty折扣 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Indicates that the asset has a default sfty discount or not - 表示资产是否有默认的sfty折扣 |
38 |
SFTY_DSCNT |
安全折扣 |
FLOAT |
10 |
6 |
Y |
|
|
|
|
Safety discount - 安全折扣 |
39 |
SFTY_AMOUNT |
作为金额的安全折扣 |
NUMBER |
17 |
2 |
Y |
|
|
|
|
Safety discount as an amount - 作为金额的安全折扣 |
40 |
SFTY_AMT_CURR |
安全折扣金额的货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of the Safety discount amount - 安全折扣金额的货币 |
41 |
UNIT_VALN_FREQ |
指标:证券账户估值频率 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Indicator : Valuation Frequency of Securities Account - 指标:证券账户估值频率 |
42 |
START_DATE |
估价开始日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Valuation Start date - 估价开始日期 |