1 |
MANDT |
顾客 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Client - 顾客 |
2 |
COMPANYCODE |
公司代码 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Company Code - 公司代码 |
3 |
DEAL_NUMBER |
头寸生成金融交易 |
CHAR |
13 |
0 |
Y |
|
|
|
|
Position-Generating Financial Transaction - 头寸生成金融交易 |
4 |
SE_DEAL_NUMBER |
证券/期货交易 |
CHAR |
13 |
0 |
Y |
|
|
|
|
Securities/Futures Transaction - 证券/期货交易 |
5 |
SIDE |
交易方向 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Direction of Transaction - 交易方向 |
6 |
REFERENCE_NO |
参考号(单元号) |
CHAR |
10 |
0 |
Y |
|
|
|
|
Reference Number (Unit No.) - 参考号(单元号) |
7 |
REFERENCE_TYPE |
参考类别(单位类别) |
CHAR |
3 |
0 |
Y |
|
|
|
|
Reference Category (Unit Category) - 参考类别(单位类别) |
8 |
OBJECTNUMBER |
对象编号 |
CHAR |
22 |
0 |
Y |
|
|
|
|
Object number - 对象编号 |
9 |
CREATE_DATE |
输入日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Entered On - 输入日期 |
10 |
CREATE_TIME |
进场时间 |
DATE |
6 |
0 |
Y |
|
|
|
|
Entry Time - 进场时间 |
11 |
UPDATE_DATE |
更改时间 |
DATE |
8 |
0 |
Y |
|
|
|
|
Changed On - 更改时间 |
12 |
UPDATE_TIME |
时间变了 |
DATE |
6 |
0 |
Y |
|
|
|
|
Time Changed - 时间变了 |
13 |
CONTRACT_TYPE |
合同类型 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Contract Type - 合同类型 |
14 |
PRODUCT_CAT |
产品类别 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Product Category - 产品类别 |
15 |
PRODUCT_TYPE |
产品类型 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Product Type - 产品类型 |
16 |
TRANSACTION_CAT |
交易类别 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Transaction Category - 交易类别 |
17 |
ACTIVITY_CAT |
交易活动类别 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Transaction Activity Category - 交易活动类别 |
18 |
TRANSACTION_TYPE |
金融交易类型 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Financial Transaction Type - 金融交易类型 |
19 |
ABWTYP |
加工类别 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Processing Category - 加工类别 |
20 |
START_TERM |
学期开始 |
DATE |
8 |
0 |
Y |
|
|
|
|
Start of Term - 学期开始 |
21 |
END_TERM |
期末 |
DATE |
8 |
0 |
Y |
|
|
|
|
End of Term - 期末 |
22 |
ROLLOVER_TERM |
展期日 |
DATE |
8 |
0 |
Y |
|
|
|
|
Rollover Date - 展期日 |
23 |
RLZTG_F |
剩余期限(天) |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Remaining Term in Days - 剩余期限(天) |
24 |
RLZMO_F |
剩余期限(月) |
VARCHAR2 |
4 |
0 |
Y |
|
|
|
|
Remaining Term in Months - 剩余期限(月) |
25 |
RLZJA_F |
剩余期限(年) |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Remaining Term in Years - 剩余期限(年) |
26 |
START_INCLUSIVE |
计算期间:开始包含与结束包含 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Calculation Period: Start Inclusive vs. End Inclusive - 计算期间:开始包含与结束包含 |
27 |
END_INCLUSIVE |
期末包容性指标 |
CHAR |
1 |
0 |
Y |
|
|
|
|
End of Term Inclusive Indicator - 期末包容性指标 |
28 |
NOTICE_DATE |
OTC通知日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
OTC Notice Date - OTC通知日期 |
29 |
EFFECTIVE_DATE |
生效日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Effective Date - 生效日期 |
30 |
CONTRACT_DATE |
合同订立日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Contract Conclusion Date - 合同订立日期 |
31 |
CONTRACT_TIME |
合同订立时间 |
DATE |
6 |
0 |
Y |
|
|
|
|
Time of Contract Conclusion - 合同订立时间 |
32 |
CONTRACT_TIMEZONE |
合同日期和时间的时区 |
CHAR |
6 |
0 |
Y |
|
|
|
|
Time Zone of Contract Date and Time - 合同日期和时间的时区 |
33 |
CONTRACT_DATE_ORIG |
活动合同签订日期;合同; |
DATE |
8 |
0 |
Y |
|
|
|
|
Contract Conclusion Date of Activity ;Contract; - 活动合同签订日期;合同; |
34 |
CONTRACT_TIME_ORIG |
活动合同签订时间;合同; |
DATE |
6 |
0 |
Y |
|
|
|
|
Time of contract conclusion of Activity ;Contract; - 活动合同签订时间;合同; |
35 |
CONTRACT_TIMEZONE_ORIG |
合同日期和活动时间的时区;合同; |
CHAR |
6 |
0 |
Y |
|
|
|
|
Time Zone of Contract Date and Time of Activity ;Contract; - 合同日期和活动时间的时区;合同; |
36 |
COUNTERPARTY |
交易对手 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Counterparty - 交易对手 |
37 |
TYPE |
业务伙伴类别 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Business Partner Category - 业务伙伴类别 |
38 |
ISTYPE |
产业体系 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Industry System - 产业体系 |
39 |
IND_SECTOR |
工业 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Industry - 工业 |
40 |
CNTRY_COMP |
业务伙伴注册办事处所在国 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Country of Registered Office of Business Partner - 业务伙伴注册办事处所在国 |
41 |
LEGAL_ENTY |
法定组织形式 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Legal Form of Organization - 法定组织形式 |
42 |
LEGAL_ORG |
组织法人 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Legal Entity of Organization - 组织法人 |
43 |
NATION |
国籍 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Nationality - 国籍 |
44 |
STATE |
公民身份 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Citizenship - 公民身份 |
45 |
GROUP_ID |
业务伙伴分组 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Business Partner Grouping - 业务伙伴分组 |
46 |
GROUP_D |
目标群体 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Target Group - 目标群体 |
47 |
STAFF_GRP |
员工组 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Employee Group - 员工组 |
48 |
COMP_RE |
组织关系 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Organization Relationship - 组织关系 |
49 |
GRADE |
估价 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Valuation - 估价 |
50 |
GRADE_METHOD |
估价程序 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Valuation Procedure - 估价程序 |
51 |
SOLVNCY |
信用状况 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Credit Standing - 信用状况 |
52 |
SOL_INF |
资信状况 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Status of Credit Standing Information - 资信状况 |
53 |
SOL_I_D |
资信日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Date of Credit Standing Information - 资信日期 |
54 |
RATING |
评级 |
CHAR |
3 |
0 |
Y |
|
|
|
|
Rating - 评级 |
55 |
SOL_INS |
提供信用信息的机构 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Institute providing credit standing information - 提供信用信息的机构 |
56 |
GUARANTOR |
金融交易担保人 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Guarantor of Financial Transaction - 金融交易担保人 |
57 |
EXTERNAL_REFNCE |
外部参照 |
CHAR |
16 |
0 |
Y |
|
|
|
|
External Reference - 外部参照 |
58 |
PORTFOLIO |
文件夹 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Portfolio - 文件夹 |
59 |
FINANCE_PROJECT |
财务项目 |
CHAR |
13 |
0 |
Y |
|
|
|
|
Finance Project - 财务项目 |
60 |
MASTER_AGREEMENT |
主协议 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Master Agreement - 主协议 |
61 |
ASSIGNMENT |
转让 |
CHAR |
18 |
0 |
Y |
|
|
|
|
Assignment - 转让 |
62 |
INTERNAL_REFNCE |
内部参考 |
CHAR |
16 |
0 |
Y |
|
|
|
|
Internal Reference - 内部参考 |
63 |
CHARACTERISTICS |
特点 |
CHAR |
25 |
0 |
Y |
|
|
|
|
Characteristics - 特点 |
64 |
FACILITY_DEALNO |
授信交易号 |
CHAR |
13 |
0 |
Y |
|
|
|
|
Transaction Number of Facility - 授信交易号 |
65 |
FACILITY_CCODE |
设施代码 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Company Code of Facility - 设施代码 |
66 |
DEAL_ACTIVE |
事务或活动的活动状态 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Active Status of Transaction or Activity - 事务或活动的活动状态 |
67 |
RELEASE_STATUS |
事务发布:发布状态 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Transaction Release: Release Status - 事务发布:发布状态 |
68 |
REVERSAL_REASON |
转回原因 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Reason for Reversal - 转回原因 |
69 |
CONFIRM_STATUS |
确认状态 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Confirmation Status - 确认状态 |
70 |
CONFIRM_DATE |
确认日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Confirmation Date - 确认日期 |
71 |
CNTRCONFIRM |
反确认 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Counterconfirmation - 反确认 |
72 |
CNTRCONFIRM_DATE |
反确认日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Counterconfirmation Date - 反确认日期 |
73 |
IGT_STATUS |
IGT:集团内部交易的状态 |
CHAR |
1 |
0 |
Y |
|
|
|
|
IGT: Status of an Intragroup transaction - IGT:集团内部交易的状态 |
74 |
CURRENCY |
交易货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of Transaction - 交易货币 |
75 |
CURRENCY_RCV |
交易对方货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of Incoming Side of Transaction - 交易对方货币 |
76 |
CURRENCY_PAY |
交易流出方货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Currency of Outgoing Side of Transaction - 交易流出方货币 |
77 |
NOM_AMOUNT |
名义金额 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Nominal Amount - 名义金额 |
78 |
NOM_AMOUNT_RCV |
名义金额:交易的传入方 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Nominal Amount: Incoming Side of Transaction - 名义金额:交易的传入方 |
79 |
NOM_AMOUNT_PAY |
名义金额:交易的出局方 |
NUMBER |
15 |
2 |
Y |
|
|
|
|
Nominal Amount: Outgoing Side of Transaction - 名义金额:交易的出局方 |
80 |
UNITS |
单位 |
FLOAT |
22 |
6 |
Y |
|
|
|
|
Units - 单位 |
81 |
LEAD_CURRENCY |
主导货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Leading Currency - 主导货币 |
82 |
FOLL_CURRENCY |
跟随货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Following Currency - 跟随货币 |
83 |
RATE |
外汇交易率 |
FLOAT |
13 |
9 |
Y |
|
|
|
|
Rate of Foreign Exchange Transaction - 外汇交易率 |
84 |
SPOTRATE |
即期汇率 |
FLOAT |
13 |
9 |
Y |
|
|
|
|
Spot Rate - 即期汇率 |
85 |
SWAPRATE |
互换率 |
FLOAT |
13 |
9 |
Y |
|
|
|
|
Swap Rate - 互换率 |
86 |
RATE_ADJ |
外汇交易利率-调整为1:1汇率。比率 |
FLOAT |
31 |
10 |
Y |
|
|
|
|
Rate of FX Transaction - Adjusted to 1:1 Transl. Ratio - 外汇交易利率-调整为1:1汇率。比率 |
87 |
SPOTRATE_ADJ |
即期汇率-调整为1:1的汇率。比率 |
FLOAT |
31 |
10 |
Y |
|
|
|
|
Spot Rate - Adjusted to 1:1 Transl. Ratio - 即期汇率-调整为1:1的汇率。比率 |
88 |
SWAPRATE_ADJ |
交换率-调整为1:1转换。比率 |
FLOAT |
31 |
10 |
Y |
|
|
|
|
Swap Rate - Adjusted to 1:1 Transl. Ratio - 交换率-调整为1:1转换。比率 |
89 |
FX_TRADED_SIDE |
外汇交易中交易金额的注释字段 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Note Field for Amount Traded in Forex Transactions - 外汇交易中交易金额的注释字段 |
90 |
TRADED_CURRENCY |
交易货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Traded Currency - 交易货币 |
91 |
SECPRICE_UNIT |
无货币参考的证券价格,带单位报价 |
FLOAT |
15 |
6 |
Y |
|
|
|
|
Security Price Without Currency Ref. with Unit Quotation - 无货币参考的证券价格,带单位报价 |
92 |
SECURITY_ACCOUNT |
证券账户 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Securities Account - 证券账户 |
93 |
SECURITY_ID |
安全等级ID号 |
CHAR |
13 |
0 |
Y |
|
|
|
|
Security Class ID Number - 安全等级ID号 |
94 |
POSITION_ACCOUNT |
上市期权和期货的期货账户 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Futures Account for Listed Options and Futures - 上市期权和期货的期货账户 |
95 |
EFF_INT |
实际利率 |
FLOAT |
10 |
7 |
Y |
|
|
|
|
Effective Interest Rate - 实际利率 |
96 |
EFF_INT_METHOD |
实际利率法(金融数学) |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Effective Interest Method (Financial Mathematics) - 实际利率法(金融数学) |
97 |
INT_CAT |
兴趣类别 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Interest Category - 兴趣类别 |
98 |
INT_CURRENT |
名义利率 |
FLOAT |
10 |
7 |
Y |
|
|
|
|
Nominal Interest Rate - 名义利率 |
99 |
INT_REF |
参考利率 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Reference Interest Rate - 参考利率 |
100 |
INT_FORMULA |
利息公式字符串 |
CHAR |
132 |
0 |
Y |
|
|
|
|
String for Interest Formula - 利息公式字符串 |
101 |
INT_STATUS |
定息状态 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Interest Fixing Status - 定息状态 |
102 |
INT_NEXT_FIX |
下次利率调整日 |
DATE |
8 |
0 |
Y |
|
|
|
|
Next Interest Rate Adjustment Date - 下次利率调整日 |
103 |
INT_NEXT_DUE |
下次利息到期日 |
DATE |
8 |
0 |
Y |
|
|
|
|
Next Interest Due Date - 下次利息到期日 |
104 |
INT_AMOUNT |
利息金额 |
NUMBER |
21 |
2 |
Y |
|
|
|
|
Interest Amount - 利息金额 |
105 |
INT_CURRENCY |
支付货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Payment Currency - 支付货币 |
106 |
INT_CAT_IN |
来料方兴趣类别 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Interest Category of Incoming Side - 来料方兴趣类别 |
107 |
INT_CURRENT_IN |
来方名义利率 |
FLOAT |
10 |
7 |
Y |
|
|
|
|
Nominal Interest Rate of Incoming Side - 来方名义利率 |
108 |
INT_REF_IN |
参考利率输入端 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Reference Interest Rate Incoming Side - 参考利率输入端 |
109 |
INT_FORMULA_IN |
输入端利息公式字符串 |
CHAR |
132 |
0 |
Y |
|
|
|
|
String for Interest Formula of Incoming Side - 输入端利息公式字符串 |
110 |
INT_STATUS_IN |
定息状态:入方 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Interest Fixing Status: Incoming Side - 定息状态:入方 |
111 |
INT_NEXT_FIX_IN |
来方下次利率调整日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Next Interest Rate Adjustment Date of Incoming Side - 来方下次利率调整日期 |
112 |
INT_NEXT_DUE_IN |
下次利息到期日 |
DATE |
8 |
0 |
Y |
|
|
|
|
Next Interest Due Date - 下次利息到期日 |
113 |
INT_AMOUNT_IN |
来方利息金额 |
NUMBER |
21 |
2 |
Y |
|
|
|
|
Interest Amount of Incoming Side - 来方利息金额 |
114 |
INT_CURRENCY_IN |
支付货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Payment Currency - 支付货币 |
115 |
INT_CAT_OUT |
出局方兴趣类别 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Interest Category of Outgoing Side - 出局方兴趣类别 |
116 |
INT_CURRENT_OUT |
出局方名义利率 |
FLOAT |
10 |
7 |
Y |
|
|
|
|
Nominal Interest Rate of Outgoing Side - 出局方名义利率 |
117 |
INT_REF_OUT |
出局方参考利率 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Reference Interest Rate of Outgoing Side - 出局方参考利率 |
118 |
INT_FORMULA_OUT |
输出端利息公式字符串 |
CHAR |
132 |
0 |
Y |
|
|
|
|
String for Interest Formula of Outgoing Side - 输出端利息公式字符串 |
119 |
INT_STATUS_OUT |
定息状态:出局侧 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Interest Fixing Status: Outgoing Side - 定息状态:出局侧 |
120 |
INT_NEXT_FIX_OUT |
出局方下次利率调整日 |
DATE |
8 |
0 |
Y |
|
|
|
|
Next Interest Rate Adjustment Date of Outgoing Side - 出局方下次利率调整日 |
121 |
INT_NEXT_DUE_OUT |
下次利息到期日 |
DATE |
8 |
0 |
Y |
|
|
|
|
Next Interest Due Date - 下次利息到期日 |
122 |
INT_AMOUNT_OUT |
出局方利息金额 |
NUMBER |
21 |
2 |
Y |
|
|
|
|
Interest Amount of Outgoing Side - 出局方利息金额 |
123 |
INT_CURRENCY_OUT |
支付货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Payment Currency - 支付货币 |
124 |
PUT_CALL |
Put/Call指示灯 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Put/Call Indicator - Put/Call指示灯 |
125 |
PUT_CALL_EXT |
外部Put/Call指示器 |
CHAR |
10 |
0 |
Y |
|
|
|
|
External Put/Call Indicator - 外部Put/Call指示器 |
126 |
EXPIRATION_DATE |
到期日(或行权期结束) |
DATE |
8 |
0 |
Y |
|
|
|
|
Expiration Date (or End of Exercise Period) - 到期日(或行权期结束) |
127 |
EXERCISE_DATE |
行使日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Exercise Date - 行使日期 |
128 |
STRIKE_CURRENCY |
期权/期货的行权货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Strike Currency of Option/Future - 期权/期货的行权货币 |
129 |
STRIKE_AMOUNT |
期权行权金额 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Option Strike Amount - 期权行权金额 |
130 |
STRIKE_PRICE |
执行价(上限为上限,下限为下限) |
FLOAT |
10 |
7 |
Y |
|
|
|
|
Strike Price (Upper Limit for Cap, Lower Limit for Floor) - 执行价(上限为上限,下限为下限) |
131 |
EXERCISE_TYPE |
运动类型(美国或欧洲) |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Exercise Type (American or European) - 运动类型(美国或欧洲) |
132 |
SETTLEMENT_TYPE |
沉降指示器 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Settlement Indicator - 沉降指示器 |
133 |
OPTION_CATEGORY |
原始期权类别(交割时) |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Original option category (on closing) - 原始期权类别(交割时) |
134 |
SECURITY_ACC_UL |
标的证券账户 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Securities Account Underlying - 标的证券账户 |
135 |
SECURITY_ID_UL |
基础安全ID |
CHAR |
13 |
0 |
Y |
|
|
|
|
Security ID Underlying - 基础安全ID |
136 |
UNITS_UL |
基础单位 |
FLOAT |
22 |
6 |
Y |
|
|
|
|
Units Underlying - 基础单位 |
137 |
STRIKE |
无货币参考的证券价格,带单位报价 |
FLOAT |
15 |
6 |
Y |
|
|
|
|
Security Price Without Currency Ref. with Unit Quotation - 无货币参考的证券价格,带单位报价 |
138 |
DIR_STRIKEAMOUNT |
走向量 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Direction of Strike Amount - 走向量 |
139 |
BARRIER_CATEGORY |
敲入/敲出等级类别 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Category of Knock-In/Knock-Out Level - 敲入/敲出等级类别 |
140 |
LEAD_CURR_UL |
基础交易的主导货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Leading Currency of Underlying Transaction - 基础交易的主导货币 |
141 |
FOLLOW_CURR_UL |
标的交易的后续货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Following Currency of Underlying Transaction - 标的交易的后续货币 |
142 |
BARRIER |
作为异域期权外汇汇率的障碍 |
FLOAT |
13 |
9 |
Y |
|
|
|
|
Barrier as Forex Rate for Exotic Options - 作为异域期权外汇汇率的障碍 |
143 |
BARRIER2 |
障碍2作为外汇汇率异国选择 |
FLOAT |
13 |
9 |
Y |
|
|
|
|
Barrier 2 as Forex Rate for Exotic Options - 障碍2作为外汇汇率异国选择 |
144 |
BARRIER_ADJ |
(外汇汇率)障碍-调整。翻译成1:1。比率 |
FLOAT |
31 |
10 |
Y |
|
|
|
|
(FX Rate) Barrier - Adj. to 1:1 Transl. Ratio - (外汇汇率)障碍-调整。翻译成1:1。比率 |
145 |
BARRIER2_ADJ |
(外汇汇率)限制2-调整。翻译成1:1。比率 |
FLOAT |
31 |
10 |
Y |
|
|
|
|
(FX Rate) Barrier2 - Adj. to 1:1 Transl. Ratio - (外汇汇率)限制2-调整。翻译成1:1。比率 |
146 |
PREMIUM_AMT_PYC |
支付货币期权溢价 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Option Premium in Payment Currency - 支付货币期权溢价 |
147 |
PREMIUM_AMT_LC |
本币期权溢价 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Option Premium in Local Currency - 本币期权溢价 |
148 |
PREMIUM_DATE |
保费支付日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Premium Payment Date - 保费支付日期 |
149 |
BPRC_SPOT1 |
当前即期汇率百分比 |
FLOAT |
15 |
6 |
Y |
|
|
|
|
Current Spot Rate in Percentage - 当前即期汇率百分比 |
150 |
BPRC_SPOT2 |
到期即期利率百分比 |
FLOAT |
15 |
6 |
Y |
|
|
|
|
Spot Rate at Maturity in Percentage - 到期即期利率百分比 |
151 |
COST_FWD |
远期汇率成本 |
FLOAT |
15 |
6 |
Y |
|
|
|
|
Forward Rate Cost - 远期汇率成本 |
152 |
INTEREST_FWD |
远期利率 |
FLOAT |
15 |
6 |
Y |
|
|
|
|
Forward Rate Interest - 远期利率 |
153 |
COMMODITY_ID |
商品ID(已过时) |
CHAR |
18 |
0 |
Y |
|
|
|
|
Commodity ID (obsolete) - 商品ID(已过时) |
154 |
QUANTITY_TRADED |
待交付商品数量 |
NUMBER |
25 |
5 |
Y |
|
|
|
|
Commodity Quantity to Be Delivered - 待交付商品数量 |
155 |
COMMODITY_UOM |
商品的计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Unit of Measure for the Commodity - 商品的计量单位 |
156 |
QUOTATION_NAME |
报价单名称 |
CHAR |
18 |
0 |
Y |
|
|
|
|
Quotation Name - 报价单名称 |
157 |
QUOTATION_SOURCE |
报价来源 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Quotation Source - 报价来源 |
158 |
QUOTATION_TYPE |
商品报价类型 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Commodity Quotation Type - 商品报价类型 |
159 |
SPREAD |
商品价差 |
FLOAT |
13 |
5 |
Y |
|
|
|
|
Commodity Spread - 商品价差 |
160 |
CONTRACT_PRICE |
商品合同价格 |
FLOAT |
13 |
5 |
Y |
|
|
|
|
Commodity Contract Price - 商品合同价格 |
161 |
CTY_SPOT_PRICE |
商品现货价格 |
FLOAT |
13 |
5 |
Y |
|
|
|
|
Commodity spot price - 商品现货价格 |
162 |
CONT_BACK |
商品续付 |
FLOAT |
13 |
5 |
Y |
|
|
|
|
Commodity Contango / Backwardation - 商品续付 |
163 |
PRICE_CURR_UNIT |
汇率的货币单位 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Currency Unit of the Rate - 汇率的货币单位 |
164 |
PRICE_UOM |
商品的计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Unit of Measure for the Commodity - 商品的计量单位 |
165 |
CMDTY_FIX_STATUS |
商品固定状态 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Commodity Fixing Status - 商品固定状态 |
166 |
COMMODITY_ID2 |
商品ID输入 |
CHAR |
18 |
0 |
Y |
|
|
|
|
Commodity ID Incoming - 商品ID输入 |
167 |
QUANTITY_IN |
进货数量 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Incoming Commodity Quantity - 进货数量 |
168 |
UOM_IN |
进货计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Unit of Measure for Incoming Commodity - 进货计量单位 |
169 |
CTY_PRICE_IN |
进货价格 |
FLOAT |
13 |
5 |
Y |
|
|
|
|
Incoming Comodity Price - 进货价格 |
170 |
QUOT_NAME_IN |
传入报价名称 |
CHAR |
18 |
0 |
Y |
|
|
|
|
Incoming Quotation Name - 传入报价名称 |
171 |
QUOT_SOURC_IN |
来料报价来源 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Incoming Quotation Source - 来料报价来源 |
172 |
QUOT_TYPE_IN |
传入报价类型 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Incoming Quotation Type - 传入报价类型 |
173 |
CTY_SPREAD_IN |
展开进线侧 |
FLOAT |
13 |
5 |
Y |
|
|
|
|
Spread Incoming Side - 展开进线侧 |
174 |
PRICE_CURR_UNIT_IN |
商品价格货币单位进货 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Commodity Price Currency Unit Incoming - 商品价格货币单位进货 |
175 |
PRICE_UOM_IN |
商品价格计量单位进货 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Commodity Price Uom Incoming - 商品价格计量单位进货 |
176 |
CMDTY_FIX_STATUS_IN |
定货状态:进料侧 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Commodity Fixing Status: Incoming Side - 定货状态:进料侧 |
177 |
COMMODITY_ID1 |
商品ID传出 |
CHAR |
18 |
0 |
Y |
|
|
|
|
Commodity ID Outgoing - 商品ID传出 |
178 |
QUANTITY_OUT |
出库商品数量 |
NUMBER |
13 |
3 |
Y |
|
|
|
|
Outgoing Commodity Quantity - 出库商品数量 |
179 |
UOM_OUT |
出厂商品计量单位 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Unit of Measure for Outgoing Commodity - 出厂商品计量单位 |
180 |
CTY_PRICE_OUT |
出厂商品价格 |
FLOAT |
13 |
5 |
Y |
|
|
|
|
Outgoing Commodity Price - 出厂商品价格 |
181 |
QUOT_NAME_OUT |
传出报价名称 |
CHAR |
18 |
0 |
Y |
|
|
|
|
Outgoing Quotation Name - 传出报价名称 |
182 |
QUOT_SOURC_OUT |
传出报价源 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Outgoing Quotation Source - 传出报价源 |
183 |
QUOT_TYPE_OUT |
传出报价类型 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Outgoing Quotation Type - 传出报价类型 |
184 |
CTY_SPREAD_OUT |
展开输出侧 |
FLOAT |
13 |
5 |
Y |
|
|
|
|
Spread Outgoing Side - 展开输出侧 |
185 |
PRICE_CURR_UNIT_OUT |
商品价格货币单位 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Commodity Price Currency Unit Outgoing - 商品价格货币单位 |
186 |
PRICE_UOM_OUT |
商品价格计量单位出库 |
VARCHAR2 |
3 |
0 |
Y |
|
|
|
|
Commodity Price Uom Outgoing - 商品价格计量单位出库 |
187 |
CMDTY_FIX_STATUS_OUT |
定货状态:出货侧 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Commodity Fixing Status: Outgoing Side - 定货状态:出货侧 |
188 |
UL_LOAN |
基础贷款合同 |
CHAR |
13 |
0 |
Y |
|
|
|
|
Underlying Loan Contract - 基础贷款合同 |
189 |
FORWARD_RATE |
付款/支付率 |
FLOAT |
10 |
7 |
Y |
|
|
|
|
Pay-in/disbursement rate - 付款/支付率 |
190 |
POSITION_CCY |
头寸币种(头寸金额币种) |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Position Currency (Currency of Position Amount) - 头寸币种(头寸金额币种) |
191 |
LOCAL_CCY |
当地货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Local Currency - 当地货币 |
192 |
NUMBER_TRADED |
单位报价证券/期货的交易单位数量 |
FLOAT |
15 |
5 |
Y |
|
|
|
|
Traded Number of Units for Unit-Quoted Securities/Futures - 单位报价证券/期货的交易单位数量 |
193 |
NOM_AMT_TRADED |
交易票面金额 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Traded Nominal Amount - 交易票面金额 |
194 |
NOMORGAMT_TRADED |
交易原始票面金额 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Traded Original Nominal Amount - 交易原始票面金额 |
195 |
PRICE_TRADED |
证券交易价格(混合代表) |
FLOAT |
15 |
6 |
Y |
|
|
|
|
Traded Price of Security (Mixed Representation) - 证券交易价格(混合代表) |
196 |
PRICE_CCYUNT |
汇率的货币单位 |
CHAR |
5 |
0 |
Y |
|
|
|
|
Currency Unit of the Rate - 汇率的货币单位 |
197 |
PRICE_CCYUNT_PRC |
报价货币单位/百分比(混合表示) |
CHAR |
5 |
0 |
Y |
|
|
|
|
Quotation Currency Unit / Percent (Mixed Representation) - 报价货币单位/百分比(混合表示) |
198 |
QUOTATION |
期权、期货、证券等的报价类型。 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Quotation type for option, future, security etc. - 期权、期货、证券等的报价类型。 |
199 |
MARKET_VAL_QC |
以报价货币表示的市场价值 |
NUMBER |
13 |
2 |
Y |
|
|
|
|
Market Value in Quotation Currency - 以报价货币表示的市场价值 |
200 |
QUOTATION_CCY |
报价货币 |
VARCHAR2 |
5 |
0 |
Y |
|
|
|
|
Quotation Currency - 报价货币 |
201 |
MARKET_VAL_CC |
支付货币市值 |
NUMBER |
21 |
2 |
Y |
|
|
|
|
Market Value in Payment Currency - 支付货币市值 |
202 |
FX_RATE_TO_CC |
支付货币汇率 |
FLOAT |
9 |
5 |
Y |
|
|
|
|
Payment Currency Rate - 支付货币汇率 |
203 |
MARKET_VAL_PC |
头寸货币市值 |
NUMBER |
21 |
2 |
Y |
|
|
|
|
Market Value in Position Currency - 头寸货币市值 |
204 |
FX_RATE_TO_PC |
头寸汇率 |
FLOAT |
9 |
5 |
Y |
|
|
|
|
Position Currency Rate - 头寸汇率 |
205 |
MARKET_VAL_LC |
当地货币市值 |
NUMBER |
21 |
2 |
Y |
|
|
|
|
Market Value in Local Currency - 当地货币市值 |
206 |
FX_RATE_TO_LC |
本币汇率 |
FLOAT |
9 |
5 |
Y |
|
|
|
|
Local Currency Rate - 本币汇率 |
207 |
LIMIT_DATE |
限制日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Limit Date - 限制日期 |
208 |
FIXING_DATE |
固定日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Fixing Date - 固定日期 |
209 |
FIXING_RATE |
外汇NDF交易固定利率 |
FLOAT |
13 |
9 |
Y |
|
|
|
|
Fixing Rate of FX NDF Transaction - 外汇NDF交易固定利率 |
210 |
FIXING_RATE_ADJ |
外汇交易固定率-调整为1:1交易。比率 |
FLOAT |
31 |
10 |
Y |
|
|
|
|
Fixing Rate of FX Trans.- Adjusted to 1:1 Transl. Ratio - 外汇交易固定率-调整为1:1交易。比率 |
211 |
CLEARING_OPTION |
中央结算期权 |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Central Clearing Option (TREA) - 中央结算期权 |
212 |
CLEARING_STATUS |
清算状态(TREA) |
VARCHAR2 |
1 |
0 |
Y |
|
|
|
|
Clearing Status (TREA) - 清算状态(TREA) |
213 |
CLEARING_DATE |
计划清算日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Planned Clearing Date - 计划清算日期 |
214 |
EXT_ACCOUNT |
外部账户 |
CHAR |
10 |
0 |
Y |
|
|
|
|
External Account - 外部账户 |
215 |
CSP |
交易对手 |
CHAR |
10 |
0 |
Y |
|
|
|
|
Counterparty - 交易对手 |
216 |
CLEAR_DATE_ACT |
实际结算日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Actual Clearing Date - 实际结算日期 |
217 |
RISK_MITIGATING |
风险缓解指标 |
CHAR |
1 |
0 |
Y |
|
|
|
|
Risk Mitigation Indicator - 风险缓解指标 |
218 |
FORWARD_DATE |
提前日期 |
DATE |
8 |
0 |
Y |
|
|
|
|
Forward Date - 提前日期 |
219 |
CALENDAR_ID |
工厂日历 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Factory calendar - 工厂日历 |
220 |
CALENDAR_ID2 |
工厂日历 |
CHAR |
2 |
0 |
Y |
|
|
|
|
Factory calendar - 工厂日历 |
221 |
MIC |
市场识别码 |
CHAR |
4 |
0 |
Y |
|
|
|
|
Market Identifier Code - 市场识别码 |
222 |
CFI_CODE |
CFI代码 |
CHAR |
6 |
0 |
Y |
|
|
|
|
CFI Code - CFI代码 |
223 |
ISIN |
安全ID号(ISIN) |
CHAR |
12 |
0 |
Y |
|
|
|
|
Security ID Number (ISIN) - 安全ID号(ISIN) |
224 |
PARENT_CFI_CODE |
父CFI代码 |
CHAR |
6 |
0 |
Y |
|
|
|
|
Parent CFI Code - 父CFI代码 |
225 |
PARENT_ISIN |
父ISIN |
CHAR |
12 |
0 |
Y |
|
|
|
|
Parent ISIN - 父ISIN |
226 |
LEGAL_BASIS |
法律依据 |
VARCHAR2 |
2 |
0 |
Y |
|
|
|
|
Legal Basis - 法律依据 |
227 |
TRADE_ID |
对外贸易ID |
CHAR |
52 |
0 |
Y |
|
|
|
|
External Trade ID - 对外贸易ID |
228 |
PRE_TRADE_ID |
临时交易ID |
CHAR |
52 |
0 |
Y |
|
|
|
|
Interim Trade ID - 临时交易ID |
229 |
EXECUTION_TIMESTAMP |
执行时间戳(UTC) |
CHAR |
20 |
0 |
Y |
|
|
|
|
Execution Timestamp (UTC) - 执行时间戳(UTC) |
230 |
UNDERLYING |
潜在的 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
UNDERLYING - 潜在的 |
231 |
PAY_INFO |
支付信息 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
PAY_INFO - 支付信息 |
232 |
INTEREST_ADJ |
利息调整 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
INTEREST_ADJ - 利息调整 |
233 |
COMM_ADJ |
通信调整 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
COMM_ADJ - 通信调整 |
234 |
SEC_ADJ |
秒调整 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
SEC_ADJ - 秒调整 |
235 |
CONDITIONS |
条件 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
CONDITIONS - 条件 |
236 |
FLOWS |
流量 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
FLOWS - 流量 |
237 |
ROLLOVER_PLAN |
展期计划 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
ROLLOVER_PLAN - 展期计划 |
238 |
DIV_PLAN |
分区平面图 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
DIV_PLAN - 分区平面图 |
239 |
PARTNER_ASGMNT |
合伙人 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
PARTNER_ASGMNT - 合伙人 |
240 |
TRADE_REP |
贸易代表 |
VARCHAR2 |
250 |
0 |
Y |
|
|
|
|
TRADE_REP - 贸易代表 |