1 |
WA_CMS_AST |
|
CMS_STR_AST_DETAILS_GET_MAP |
|
STRU |
0 |
0 |
|
|
2 |
AST_GUID |
|
CMS_DTE_AST_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_AST |
|
3 |
DESCRIPTION |
|
CMS_DTE_AST_DESC |
CMS_DSC |
CHAR |
30 |
0 |
Description |
|
4 |
OBJECT_REF_ID |
|
CMS_DTE_OBJ_REFID |
CMS_OBJ_REFID |
CHAR |
40 |
0 |
Reference ID for the object |
|
5 |
OBJSYSID |
|
CMS_DTE_OBJ_SYSID |
CMS_SYS |
CHAR |
6 |
0 |
Object System Reference ID |
|
6 |
COUNTRY_KEY |
|
CMS_DTE_AST_COUNTRY_KEY |
LAND1 |
CHAR |
3 |
0 |
Identification Key for Country |
|
7 |
RISK_CODE |
|
CMS_DTE_RISK_CODE |
CMS_RISK_CODE |
CHAR |
6 |
0 |
Risk Code |
|
8 |
NOM_VALUE |
|
CMS_DTE_AST_NOMINAL_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Nominal Value of the Asset |
|
9 |
NOM_VALUE_CURR |
|
CMS_DTE_AST_NOMINAL_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Nominal value |
|
10 |
AST_VALUE |
|
CMS_DTE_AST_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Final Asset Value |
|
11 |
AST_VALUE_CURR |
|
CMS_DTE_AST_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Final Asset Value |
|
12 |
QUANTITY |
|
CMS_DTE_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity |
|
13 |
UNIT_OF_MEASURE |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
|
14 |
REC_AT |
|
CMS_DTE_REC_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Asset Value Recording Timestamp |
|
15 |
ADMIN_ORG_UNIT |
|
CMS_DTE_ADMINORG |
TEXT12 |
CHAR |
12 |
0 |
Administration Organizational Unit |
|
16 |
BANKAREA |
|
CMS_DTE_BANKAREA |
CMS_BANKAREA |
CHAR |
4 |
0 |
Bank Area in Collateral Management |
|
17 |
SFTY_IND |
|
CMS_DTE_IND_SFTY_DISC |
CMS_IND_SFTY |
CHAR |
2 |
0 |
Indicates if the Asset has a Default Safety Discount |
|
18 |
SFTY_DSCNT |
|
CMS_DTE_SAFETY_DSCNT |
CMS_SFTY_PCT |
DEC |
10 |
6 |
Percentage of Safety Discount |
|
19 |
SFTY_AMOUNT |
|
CMS_DTE_SAFETY_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Amount of Safety Discount |
|
20 |
SFTY_AMT_CURR |
|
CMS_DTE_SAFETY_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Safety Discount Amount |
|
21 |
VALUATION_TYP |
|
CMS_DTE_IND_VALN_TYP |
CMS_VALN_TYP |
CHAR |
2 |
0 |
Type of Valuation Check performed on Collateral Object |
|
22 |
UNIT_VALN_FREQ |
|
CMS_DTE_IND_AST_VALN_FREQ_UNIT |
CMS_IND_AST_VALN_FREQ_UNIT |
CHAR |
2 |
0 |
Indicator: Units of time for revaluation of an asset |
|
23 |
PERIOD_VALN_FREQ |
|
CMS_DTE_AST_VALN_FREQ_PERIOD |
CMS_AST_VALN_FREQ_PERIOD |
NUMC |
4 |
0 |
Revaluation Period for an Asset |
|
24 |
PAST_VALUED_DATE |
|
CMS_DTE_VALN_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Date on which the Asset was Valued |
|
25 |
START_DATE |
|
CMS_DTE_START_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the First Valuation is Performed on the Asset |
|
26 |
END_DATE |
|
CMS_DTE_END_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Last Valuation is Performed on the Asset |
|
27 |
LENDING_RATE_IND |
|
CMS_DTE_IND_LND_RTE |
CMS_IND_LRTE |
CHAR |
2 |
0 |
Indicator to specify if Asset has a Default Lending Rate |
|
28 |
LENDING_RATE1 |
|
CMS_DTE_LRTE_PCT1 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 1 |
|
29 |
LENDING_RATE2 |
|
CMS_DTE_LRTE_PCT2 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 2 |
|
30 |
LENDING_RATE3 |
|
CMS_DTE_LRTE_PCT3 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 3 |
|
31 |
LENDING_RATE4 |
|
CMS_DTE_LRTE_PCT4 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 4 |
|
32 |
LENDING_RATE5 |
|
CMS_DTE_LRTE_PCT5 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 5 |
|
33 |
LIQD_TYP |
|
CMS_DTE_LIQD_TYP |
CMS_TYP |
CHAR |
6 |
0 |
Liquidation Type |
|
34 |
LIQD_REASON |
|
CMS_DTE_ATT_ID_TY_AST004 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Liquidation Reason |
|
35 |
LIQD_DATE |
|
CMS_DTE_LIQD_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Collateral was Liquidated |
|
36 |
LIQD_AMT |
|
CMS_DTE_LIQD_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Returns from the Liquidation of Collateral |
|
37 |
LIQD_CURR |
|
CMS_DTE_LIQD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Liquidation Value |
|
38 |
UNIT_VERF_FREQ |
|
CMS_DTE_IND_AST_VERF_FREQ_UNIT |
CMS_IND_AST_VERF_FREQ_UNIT |
CHAR |
2 |
0 |
Indicator: Units of time for verification of an asset |
|
39 |
PERIOD_VERF_FREQ |
|
CMS_DTE_AST_VERF_FREQ_PERIOD |
CMS_AST_VERF_FREQ_PERIOD |
NUMC |
4 |
0 |
Statement Period for an Asset |
|
40 |
ORG_UNIT1 |
|
CMS_DTE_ORG_UNIT1 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 1 |
|
41 |
ORG_UNIT2 |
|
CMS_DTE_ORG_UNIT2 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 2 |
|
42 |
ORG_UNIT3 |
|
CMS_DTE_ORG_UNIT3 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 3 |
|
43 |
ORG_UNIT4 |
|
CMS_DTE_ORG_UNIT4 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 4 |
|
44 |
ORG_UNIT5 |
|
CMS_DTE_ORG_UNIT5 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 5 |
|
45 |
AST_DISP_DATA |
|
CMS_DTE_AST_IF_OBJ_ID_SCR |
CMS_SCR_TEXT |
CHAR |
90 |
0 |
Asset IF : Screen Data for Object ID |
|
46 |
CREATED_BY |
|
CMS_DTE_USER |
CMS_USER |
CHAR |
12 |
0 |
Login ID of the User who created the Record |
|
47 |
CREATED_AT |
|
CMS_DTE_CREATED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Creation Timestamp |
|
48 |
CHANGED_BY |
|
CMS_DTE_LAST_CHNG_USER |
CMS_USER |
CHAR |
12 |
0 |
Last Changed By |
|
49 |
CHANGED_AT |
|
CMS_DTE_CHANGED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Change Timestamp |
|
50 |
SOURCEOFENTRY |
|
CMS_DTE_SOURCE_OF_ENTRY |
CMS_SOURCE |
CHAR |
32 |
0 |
Source of Entry |
|