1 |
ACCOUNT_HOLDING_BANK |
|
BAPICMS_DTE_SEC_DEPO_BNK_ID |
CMS_SEC_DEPO_BNK_ID |
CHAR |
18 |
0 |
Depository bank identification |
|
2 |
ACCOUNT_NUMBER |
|
BAPICMS_DTE_SEC_ACC_NUMBER |
CMS_SEC_ACC_ID |
CHAR |
20 |
0 |
Securities account number |
|
3 |
POSITION_ID |
|
BAPICMS_DTE_SEC_ACC_POS_SEQ_NO |
CMS_SEC_POS_ID |
NUMC |
4 |
0 |
Sequence number identification of positions in an account |
|
4 |
POSITION_OLD_REFERENCE |
|
BAPICMS_DTE_SEC_ACC_POS_REF_NO |
CMS_SEC_EXT_REFID |
CHAR |
32 |
0 |
Reference number for an external system |
|
5 |
ISIN |
|
BAPICMS_DTE_SEC_ACC_POS_ISIN |
CMS_SEC_POS_ISIN |
CHAR |
20 |
0 |
Unique id number for every position in a securities account |
|
6 |
NUMBER_OF_SECURITIES |
|
BAPICMS_DTE_SEC_ACC_POS_NO_UNT |
CMS_SEC_UNITS |
DEC |
15 |
5 |
Number of position units |
|
7 |
NOMINAL_VALUE |
|
BAPICMS_DTE_SEC_ACC_POS_NVAL_A |
BAPICURR |
DEC |
23 |
4 |
Nominal value amount of a position |
|
8 |
CURRENCY_NOMINAL_VALUE |
|
BAPICMS_DTE_SEC_ACC_POS_NV_CUR |
WAERS |
CUKY |
5 |
0 |
Currency of nominal value of a position |
* |
9 |
CURRENCY_NOMINAL_VALUE_ISO |
|
BAPIISOCD |
ISOCD |
CHAR |
3 |
0 |
ISO Currency Code |
|
10 |
CURRENT_PRICE |
|
BAPICMS_DTE_SEC_ACC_POS_CP_AMT |
BAPICURR |
DEC |
23 |
4 |
Current price of a postion per unit |
|
11 |
CURRENCY_CURRENT_PRICE |
|
BAPICMS_DTE_SEC_ACC_POS_CP_CUR |
WAERS |
CUKY |
5 |
0 |
Currency of current price of a position |
* |
12 |
CURRENCY_CURRENT_PRICE_ISO |
|
BAPIISOCD |
ISOCD |
CHAR |
3 |
0 |
ISO Currency Code |
|
13 |
CURRENT_PRICE_PERCENTAGE |
|
BAPICMS_DTE_SEC_ACC_POS_CP_PCT |
CMS_SEC_PCT |
DEC |
10 |
6 |
Current price of a position per unit expressed in percentage |
|
14 |
COUNTRY_ZONE |
|
BAPICMS_DTE_SEC_ACC_POS_CY_ZON |
CMS_SEC_POS_ATTRIB |
CHAR |
10 |
0 |
Country zone - Rating information for regulatory reporting |
|
15 |
MARKET_VALUE |
|
BAPICMS_DTE_SEC_ACC_POS_MKT_VL |
BAPICURR |
DEC |
23 |
4 |
Market value of position |
|
16 |
CURRENCY_MARKET_VALUE |
|
BAPICMS_DTE_SEC_ACC_POS_MKT_CU |
WAERS |
CUKY |
5 |
0 |
Currency of market value of positions |
* |
17 |
CURRENCY_MARKET_VALUE_ISO |
|
BAPIISOCD |
ISOCD |
CHAR |
3 |
0 |
ISO Currency Code |
|
18 |
CONVERTED_MARKET_VALUE |
|
BAPICMS_DTE_SEC_ACC_POS_CMKTVL |
BAPICURR |
DEC |
23 |
4 |
Market value of position in account currency |
|
19 |
CURRENCY_CONV_MARKET_V |
|
BAPICMS_DTE_SEC_POS_CMKTVL_CUR |
WAERS |
CUKY |
5 |
0 |
Currency of currency converted market value of positions |
* |
20 |
CURRENCY_CONV_MARKET_V_ISO |
|
BAPIISOCD |
ISOCD |
CHAR |
3 |
0 |
ISO Currency Code |
|
21 |
ASSET_GUID |
|
BAPICMS_DTE_AST_GUID |
SYSUUID_C |
CHAR |
32 |
0 |
GUID for Table CMS_AST |
|
22 |
ASSET_TYPE |
|
BAPICMS_DTE_AST_TYP |
CMS_AST_TYP |
CHAR |
6 |
0 |
Asset Type |
* |
23 |
PARENT_GUID |
|
BAPICMS_DTE_AST_PAR_GUID |
SYSUUID_C |
CHAR |
32 |
0 |
Asset Guid as a parent GUID for a sub-asset |
|
24 |
RISK_CODE |
|
BAPICMS_DTE_RISK_CODE |
CMS_RISK_CODE |
CHAR |
6 |
0 |
Risk Code |
* |
25 |
SAFETY_INDICATOR |
|
BAPICMS_DTE_IND_SFTY_DISC |
CMS_IND_SFTY |
CHAR |
2 |
0 |
Indicates that the asset has a default sfty discount or not |
|
26 |
SAFETY_DISCOUNT |
|
BAPICMS_DTE_SAFETY_DSCNT |
CMS_SFTY_PCT |
DEC |
10 |
6 |
Safety discount |
|
27 |
SAFETY_AMOUNT |
|
BAPICMS_DTE_SAFETY_AMT |
BAPICURR |
DEC |
23 |
4 |
Safety discount as an amount |
|
28 |
SAFETY_AMOUNT_CURRENCY |
|
BAPICMS_DTE_SAFETY_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Safety discount amount |
* |
29 |
SAFETY_AMOUNT_CURRENCY_ISO |
|
BAPIISOCD |
ISOCD |
CHAR |
3 |
0 |
ISO Currency Code |
|
30 |
UNIT_VALUATION_FREQUENCY |
|
BAPICMS_DTE_IND_AST_VLN_FQ_UNT |
CMS_IND_AST_VALN_FREQ_UNIT |
CHAR |
2 |
0 |
Indicator: Units of time for revaluation of an asset |
|
31 |
PERIOD_VALUATION_FREQUENCY |
|
BAPICMS_DTE_AST_VLN_FQ_PRD |
CMS_AST_VALN_FREQ_PERIOD |
NUMC |
4 |
0 |
Period of revaluation for an asset |
|
32 |
START_DATE |
|
BAPICMS_DTE_START_DATE |
CMS_DATE |
DATS |
8 |
0 |
Valuation Start date |
|
33 |
END_DATE |
|
BAPICMS_DTE_END_DATE |
CMS_DATE |
DATS |
8 |
0 |
Valuation End date |
|
34 |
DEFAULT_LENDING_RATE_INDICATOR |
|
BAPICMS_DTE_IND_LND_RTE |
CMS_IND_LRTE |
CHAR |
2 |
0 |
Indicates that the asset has a default lending rate or not |
|
35 |
LENDING_RATE1 |
|
BAPICMS_DTE_LRTE_PCT1 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 1 |
|
36 |
LIQUIDATION_TYPE |
|
BAPICMS_DTE_LIQD_TYP |
CMS_TYP |
CHAR |
6 |
0 |
Liquidation Type |
|
37 |
LIQUIDATION_REASON |
|
BAPICMS_DTE_ATT_ID_TY_AST004 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Liquidation Reason |
|
38 |
LIQUIDATION_DATE |
|
BAPICMS_DTE_LIQD_DATE |
CMS_DATE |
DATS |
8 |
0 |
Collateral Liquidation Date |
|
39 |
LIQUIDATION_AMOUNT |
|
BAPICMS_DTE_LIQD_VALUE |
BAPICURR |
DEC |
23 |
4 |
Returns from the Liquidation of Collateral |
|
40 |
LIQUIDATION_CURRENCY |
|
BAPICMS_DTE_LIQD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Liquidation Value |
* |
41 |
LIQUIDATION_CURRENCY_ISO |
|
BAPIISOCD |
ISOCD |
CHAR |
3 |
0 |
ISO Currency Code |
|
42 |
CREATED_BY |
|
BAPICMS_DTE_USER |
CMS_USER |
CHAR |
12 |
0 |
Login ID of the User who created the Record |
|
43 |
CREATED_ON |
|
BAPICMS_DTE_SEC_CR_ON |
CMS_DATE |
DATS |
8 |
0 |
Created On |
|
44 |
CREATED_AT |
|
BAPICMS_DTE_SEC_CR_AT |
CMS_TIME |
TIMS |
6 |
0 |
Created At |
|
45 |
CHANGED_BY |
|
BAPICMS_DTE_LAST_CHNG_USER |
CMS_USER |
CHAR |
12 |
0 |
Last Changed By |
|
46 |
LAST_CHANGED_ON |
|
BAPICMS_DTE_SEC_CH_ON |
CMS_DATE |
DATS |
8 |
0 |
Last Changed on |
|
47 |
LAST_CHANGED_AT |
|
BAPICMS_DTE_SEC_CH_AT |
CMS_TIME |
TIMS |
6 |
0 |
Last Changed At |
|