1 |
.INCLUDE |
|
|
|
|
0 |
0 |
Rights primary key |
|
2 |
RIG_GUID |
|
CMS_DTE_RIG_GUID |
SYSUUID |
RAW |
16 |
0 |
Rights GUID |
|
3 |
.INCLUDE |
|
|
|
|
0 |
0 |
Semantic Key for insurance |
|
4 |
RIG_CATEGORY |
|
CMS_DTE_OMS_OBJ_CAT |
CMS_OBJ_CAT |
CHAR |
6 |
0 |
Object Category |
* |
5 |
RIG_TYP |
|
CMS_DTE_RIG_TYP |
CMS_RIG_TYP |
CHAR |
6 |
0 |
Right Type |
|
6 |
RIG_ID |
|
CMS_DTE_RIG_ID |
CMS_MOV_ID |
CHAR |
40 |
0 |
Rights ID |
|
7 |
RIG_CAT_NAME |
|
CMS_DTE_OMS_CAT_NAME |
CMS_OMS_CAT_NAME |
CHAR |
40 |
0 |
Object Category Name |
|
8 |
RIG_TYP_NAME |
|
CMS_DTE_RIG_TYP_NAME |
CMS_RIG_NAME |
CHAR |
40 |
0 |
Right Type Name |
|
9 |
.INCLUDE |
|
|
|
|
0 |
0 |
Insurance common data |
|
10 |
INS_DESC |
|
CMS_DTE_INS_DESC |
CMS_INS_DESC |
CHAR |
30 |
0 |
Insurance Description |
|
11 |
.INCLUDE |
|
|
|
|
0 |
0 |
Information on Insurance Settlement |
|
12 |
INSUR_TAX_DB |
|
CMS_DTE_INS_TAX_DB |
CMS_INS_FLG |
CHAR |
1 |
0 |
Insurance tax to the debit of the bank |
|
13 |
SETLMNT_TYPE |
|
CMS_DTE_INS_SETLMNT_TYPE |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Type of settlement |
TCMS_ATT_ID_TY |
14 |
INSUR_SUM |
|
CMS_DTE_INS_SUM |
CMS_AMOUNT |
CURR |
17 |
2 |
Insurance Sum |
|
15 |
INSUR_CURR |
|
CMS_DTE_INS_CURR |
WAERS |
CUKY |
5 |
0 |
Insurance Currency |
TCURC |
16 |
PRM_RT |
|
CMS_DTE_INS_PRM_RT |
CMS_INS_PRM_RT |
DEC |
10 |
7 |
Premium Rate |
|
17 |
INSUR_PREMIUM |
|
CMS_DTE_INS_PRM |
CMS_AMOUNT |
CURR |
17 |
2 |
Insurance Premium |
|
18 |
INSUR_PRM_CURR |
|
CMS_DTE_INS_CURR |
WAERS |
CUKY |
5 |
0 |
Insurance Currency |
TCURC |
19 |
INSUR_TAX_RT |
|
CMS_DTE_INS_TAX_RT |
CMS_INS_PRM_RT |
DEC |
10 |
7 |
Insurance tax rate (in %) |
|
20 |
INSUR_TAX_AMT |
|
CMS_DTE_INS_TAX_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Insurance tax amount |
|
21 |
INSUR_TAX_CURR |
|
CMS_DTE_INS_TAX_CURR |
WAERS |
CUKY |
5 |
0 |
Tax Currency |
TCURC |
22 |
.INCLUDE |
|
|
|
|
0 |
0 |
Insurance cover |
|
23 |
SCOPE_INS_COVER |
|
CMS_DTE_INS_COVER |
CMS_INS_COVER |
CHAR |
6 |
0 |
not used -> package has to be changed CMS_OMS_INS |
|
24 |
.INCLUDE |
|
|
|
|
0 |
0 |
Common OMS data |
|
25 |
EXT_ITM_NO |
|
CMS_DTE_OMS_EXT_ITM_NO |
CMS_OMS_ID |
CHAR |
40 |
0 |
Ext. Item no / Number for identification of the objects |
|
26 |
EXT_REFERENCE |
|
CMS_DTE_OMS_REF_ID |
CMS_OMS_REFID |
CHAR |
32 |
0 |
Reference number for the legacy system |
|
27 |
FOP |
|
CMS_DTE_INS_FOP |
CMS_INS_FREQ_OF_PAYMENT |
NUMC |
4 |
0 |
Frequency of Payment |
|
28 |
FREQ_UNIT |
|
CMS_DTE_INS_FREQ_UNIT |
CMS_INS_IND_FREQ_UNIT |
CHAR |
2 |
0 |
Indicator: Units of time for revaluation |
|
29 |
.INCLUDE |
|
|
|
|
0 |
0 |
Other general fields required for a standalone insurance |
|
30 |
INS_CODE |
|
CMS_DTE_INS_CODE |
CMS_INS_CODE |
CHAR |
6 |
0 |
Insurance Product Code |
|
31 |
ORIG_COUNTRY |
|
CMS_DTE_INS_ORIG_COUNTRY |
LAND1 |
CHAR |
3 |
0 |
Country where Insurance was purchased |
T005 |
32 |
ORIG_REGION |
|
CMS_DTE_INS_ORIG_REGION |
REGIO |
CHAR |
3 |
0 |
Region where Insurance was purchased |
T005S |
33 |
AUTO_CANCEL_DT |
|
CMS_DTE_INS_AUTO_CANCEL_DT |
CMS_DATE |
DATS |
8 |
0 |
Auto Cancellation Date for an Insurance Policy |
|
34 |
PRM_TYPE |
|
CMS_DTE_INS_PRM_TYPE |
CMS_INS_PREMIUM_TYPE |
CHAR |
2 |
0 |
Type of Premium |
|
35 |
PRM_VALID_FROM |
|
CMS_DTE_INS_PRM_VALID_FROM_DT |
CMS_DATE |
DATS |
8 |
0 |
Date from when specified Premium is valid |
|
36 |
PAYMNT_METHOD |
|
CMS_DTE_INS_PAYMENT_METHOD |
CMS_INS_PAYMENT_METHOD |
CHAR |
2 |
0 |
Payment method for premiums |
|
37 |
PAYMNT_INFO |
|
CMS_DTE_INS_PAY_INFO |
CMS_PAYMENT_HANDLE |
CHAR |
30 |
0 |
Payment Info for an insurance policy |
|
38 |
LAST_PAYMENT_DT |
|
CMS_DTE_INS_LAST_PAYMENT_DT |
CMS_DATE |
DATS |
8 |
0 |
Date when last premium payment was made |
|
39 |
NXT_PAYMENT_DT |
|
CMS_DTE_INS_NXT_PAYMENT_DT |
CMS_DATE |
DATS |
8 |
0 |
Next Payment Date when insurance premium is due |
|
40 |
STATEMENT_DT |
|
CMS_DTE_INS_STATEMENT_DT |
CMS_DATE |
DATS |
8 |
0 |
Date when statements for Policy was made |
|
41 |
REBATE_METHOD |
|
CMS_DTE_INS_REBATE_METHOD_ID |
CMS_INS_REBATE_METHOD_ID |
CHAR |
6 |
0 |
Identifier for the rebate method used to calculate refunds |
TCMS_INS_REB |
42 |
PORTFOLIO |
|
CMS_DTE_INS_PORTFOLIO |
CMS_INS_PORTFOLIO |
CHAR |
6 |
0 |
Insurance Portfolio |
TCMS_INS_PORT |
43 |
MAX_AGE_LIMIT |
|
CMS_DTE_INS_MAX_AGE_LIMIT |
CMS_AGE |
INT1 |
3 |
0 |
Maximum age limit for Policy Validity |
|
44 |
MAX_COVER_AMT |
|
CMS_DTE_INS_MAX_COVER_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Maximum Coverage Amount |
|
45 |
MIN_COVER_AMT |
|
CMS_DTE_INS_MIN_COVER_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Minimum Coverage Amount |
|
46 |
IND_INSURED_EVNT |
|
CMS_DTE_IND_INSURED_EVENT |
CMS_IND_OCCURENCE |
CHAR |
1 |
0 |
Boolean indicator that insured event occured (X = Occured) |
|
47 |
INSURED_EVENT_DT |
|
CMS_DTE_INSURED_EVENT_DT |
CMS_DATE |
DATS |
8 |
0 |
Date when Insured Event Occured |
|
48 |
IND_FORCE_PLACED |
|
CMS_DTE_INS_IND_FORCE_PLACE |
CMS_IND_INS_FORCE_PLACE |
CHAR |
2 |
0 |
Is Insurance Force Placed? (Default = No) |
|
49 |
IND_TAX_DEDUCT |
|
CMS_DTE_INS_IND_TAX_DEDUCT |
CMS_IND_INS_TAX_DEDUCTIBLE |
CHAR |
2 |
0 |
Indicator that Insurance Policy is Tax Deductible |
|
50 |
INACTIVE_REASON |
|
CMS_DTE_INS_INACTIVE_REASON |
CMS_INS_INACTIVE_REASON |
CHAR |
2 |
0 |
Reason for inactivating insurance policy |
TCMS_INS_SRSN |
51 |
POLICY_STATUS |
|
CMS_DTE_INS_POLICY_STATUS |
CMS_INS_POLICY_STATUS |
CHAR |
2 |
0 |
Insurance Policy Status |
|
52 |
.INCLUDE |
|
|
|
|
0 |
0 |
Insurance as object |
|
53 |
.INCLUDE |
|
|
|
|
0 |
0 |
Special features for description of insurances |
|
54 |
TARRIF |
|
CMS_DTE_INS_TARRIF |
CMS_INS_TARRIF |
CHAR |
30 |
0 |
Insurance tariff |
|
55 |
CONTRACT_STRT_DT |
|
CMS_DTE_INS_CNTRT_STRT_DT |
DATUM |
DATS |
8 |
0 |
Contract begin date |
|
56 |
CONTRACT_END_DT |
|
CMS_DTE_INS_CNTRT_END_DT |
DATUM |
DATS |
8 |
0 |
Contract end date |
|
57 |
CONTRACT_CON_DT |
|
CMS_DTE_INS_CNTRT_CON_DT |
DATUM |
DATS |
8 |
0 |
Date of conclusion of contract |
|
58 |
INSUR_STATUS |
|
CMS_DTE_INS_STATUS |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Status of insurance |
TCMS_ATT_ID_TY |
59 |
INSUR_STATUS_DT |
|
CMS_DTE_INS_STATUS_DT |
DATUM |
DATS |
8 |
0 |
Status date of insurance |
|
60 |
SUM_ONE_TM_CON |
|
CMS_DTE_INS_SUM_ONE_TM_CON |
CMS_AMOUNT |
CURR |
17 |
2 |
Sum of one time contribution |
|
61 |
ONE_TM_CON_CKY |
|
CMS_DTE_INS_ONE_TM_CON_CKY |
WAERS |
CUKY |
5 |
0 |
Currency |
TCURC |
62 |
DYNAMICS |
|
CMS_DTE_INS_DYNAMICS |
CMS_INS_FLG |
CHAR |
1 |
0 |
Dynamics |
|
63 |
PER_DYNAMICS |
|
CMS_DTE_INS_PER_DYNAMICS |
CMS_SEC_PCT |
DEC |
10 |
6 |
Percentage of the dynamics |
|
64 |
TERMIN_PRD |
|
CMS_DTE_INS_TERMIN_PRD |
CMS_INS_FREQ_OF_PAYMENT |
NUMC |
4 |
0 |
Termination period |
|
65 |
TERM_PRD_UNIT |
|
CMS_DTE_INS_TERM_PRD_UNIT |
CMS_INS_IND_FREQ_UNT |
CHAR |
2 |
0 |
Indicator: Units of termination period |
|
66 |
RECALL_PRD |
|
CMS_DTE_INS_RECALL_PRD |
CMS_INS_FREQ_OF_PAYMENT |
NUMC |
4 |
0 |
Recall period |
|
67 |
RECALL_PRD_UNIT |
|
CMS_DTE_INS_RECALL_PRD_UNIT |
CMS_INS_IND_FREQ_UNT |
CHAR |
2 |
0 |
Indicator: Units of Recall Period |
|
68 |
INS_SUM_SRVL |
|
CMS_DTE_INS_SUM_IN_SURVIVAL |
CMS_AMOUNT |
CURR |
17 |
2 |
Insurance sum incase of survival |
|
69 |
INS_SUM_SRVL_CKY |
|
CMS_DTE_INS_SUM_IN_SURVIVL_CKY |
WAERS |
CUKY |
5 |
0 |
Insurance survival Currency |
TCURC |
70 |
INS_SUM_DTH |
|
CMS_DTE_INS_SUM_IN_DEATH |
CMS_AMOUNT |
CURR |
17 |
2 |
Insurance sum in case of death |
|
71 |
INS_SUM_DTH_CKY |
|
CMS_DTE_INS_SUM_IN_DEATH_CKY |
WAERS |
CUKY |
5 |
0 |
Death benefit currency |
TCURC |
72 |
INS_BENF_EXP |
|
CMS_DTE_INS_PROB_BENF |
CMS_AMOUNT |
CURR |
17 |
2 |
Probable benefit on expiry |
|
73 |
INS_BENF_EXP_CKY |
|
CMS_DTE_INS_PROB_BENF_CKY |
WAERS |
CUKY |
5 |
0 |
Currency for probable benefit on expiry |
TCURC |
74 |
DT_PROB_BEN_EXP |
|
CMS_DTE_INS_DT_PRO_BEN_EXP |
DATUM |
DATS |
8 |
0 |
Date of probable benefit on expiry |
|
75 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure with Asset Details for Table CMS_AST |
|
76 |
.INCLUDE |
|
|
|
|
0 |
0 |
Basic Asset data |
|
77 |
DESCRIPTION |
|
CMS_DTE_AST_DESC |
CMS_DSC |
CHAR |
30 |
0 |
Description |
|
78 |
OBJECT_REF_ID |
|
CMS_DTE_OBJ_REFID |
CMS_OBJ_REFID |
CHAR |
40 |
0 |
Reference ID for the object |
|
79 |
OBJECT_TYP |
|
CMS_DTE_OBJ_TYP |
CMS_OBJ_TYP |
CHAR |
32 |
0 |
Not used |
|
80 |
COUNTRY_KEY |
|
CMS_DTE_AST_COUNTRY_KEY |
LAND1 |
CHAR |
3 |
0 |
Identification Key for Country |
* |
81 |
RISK_CODE |
|
CMS_DTE_RISK_CODE |
CMS_RISK_CODE |
CHAR |
6 |
0 |
Risk Code |
* |
82 |
SFTY_IND |
|
CMS_DTE_IND_SFTY_DISC |
CMS_IND_SFTY |
CHAR |
2 |
0 |
Indicates if the Asset has a Default Safety Discount |
|
83 |
SFTY_DSCNT |
|
CMS_DTE_SAFETY_DSCNT |
CMS_SFTY_PCT |
DEC |
10 |
6 |
Percentage of Safety Discount |
|
84 |
SFTY_AMOUNT |
|
CMS_DTE_SAFETY_AMT |
CMS_AMOUNT |
CURR |
17 |
2 |
Amount of Safety Discount |
|
85 |
SFTY_AMT_CURR |
|
CMS_DTE_SAFETY_AMT_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Safety Discount Amount |
TCURC |
86 |
OBJSYSID |
|
CMS_DTE_OBJ_SYSID |
CMS_SYS |
CHAR |
6 |
0 |
Object System Reference ID |
|
87 |
.INCLUDE |
|
|
|
|
0 |
0 |
Valuation data |
|
88 |
VALUATION_TYP |
|
CMS_DTE_IND_VALN_TYP |
CMS_VALN_TYP |
CHAR |
2 |
0 |
Type of Valuation Check performed on Collateral Object |
|
89 |
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 |
|
90 |
PERIOD_VALN_FREQ |
|
CMS_DTE_AST_VALN_FREQ_PERIOD |
CMS_AST_VALN_FREQ_PERIOD |
NUMC |
4 |
0 |
Revaluation Period for an Asset |
|
91 |
PAST_VALUED_DATE |
|
CMS_DTE_VALN_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Date on which the Asset was Valued |
|
92 |
START_DATE |
|
CMS_DTE_START_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the First Valuation is Performed on the Asset |
|
93 |
END_DATE |
|
CMS_DTE_END_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Last Valuation is Performed on the Asset |
|
94 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lending rate data |
|
95 |
LENDING_RATE_IND |
|
CMS_DTE_IND_LND_RTE |
CMS_IND_LRTE |
CHAR |
2 |
0 |
Indicator to specify if Asset has a Default Lending Rate |
|
96 |
.INCLUDE |
|
|
|
|
0 |
0 |
Lending rates structure |
|
97 |
LENDING_RATE1 |
|
CMS_DTE_LRTE_PCT1 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 1 |
|
98 |
LENDING_RATE2 |
|
CMS_DTE_LRTE_PCT2 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 2 |
|
99 |
LENDING_RATE3 |
|
CMS_DTE_LRTE_PCT3 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 3 |
|
100 |
LENDING_RATE4 |
|
CMS_DTE_LRTE_PCT4 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 4 |
|
101 |
LENDING_RATE5 |
|
CMS_DTE_LRTE_PCT5 |
CMS_PCT |
DEC |
10 |
6 |
Lending Rate 5 |
|
102 |
.INCLUDE |
|
|
|
|
0 |
0 |
Liquidation rights data |
|
103 |
LIQD_TYP |
|
CMS_DTE_LIQD_TYP |
CMS_TYP |
CHAR |
6 |
0 |
Liquidation Type |
|
104 |
LIQD_REASON |
|
CMS_DTE_ATT_ID_TY_AST004 |
CMS_ATT_ID_TYP |
CHAR |
6 |
0 |
Liquidation Reason |
TCMS_ATT_ID_TY |
105 |
LIQD_DATE |
|
CMS_DTE_LIQD_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date on which the Collateral was Liquidated |
|
106 |
LIQD_AMT |
|
CMS_DTE_LIQD_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Returns from the Liquidation of Collateral |
|
107 |
LIQD_CURR |
|
CMS_DTE_LIQD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Liquidation Value |
TCURC |
108 |
EXP_PRCD_AMNT |
|
CMS_DTE_LIQ_EXP_PRCD_AMOUNT |
CMS_AMOUNT |
CURR |
17 |
2 |
Expected Proceed Amount |
|
109 |
EXP_PRCD_CURR |
|
CMS_DTE_LIQ_EXP_PRCD_CURR |
WAERS |
CUKY |
5 |
0 |
Currency: Expected Proceed |
TCURC |
110 |
EXP_ACC_DATE |
|
CMS_DTE_LIQ_EXP_ACCRUAL_DATE |
CMS_DATE |
DATS |
8 |
0 |
Expected accrual date |
|
111 |
.INCLUDE |
|
|
|
|
0 |
0 |
Account for liquidation proceeds |
|
112 |
ACC_NUMBER_LIQ |
|
CMS_DTE_LIQ_ACC_NUMBER |
BANKN35 |
CHAR |
35 |
0 |
Account number for liquidation proceeds |
|
113 |
BANK_CNTRY_LIQ |
|
CMS_DTE_LIQ_BNK_CTRY_KY |
LAND1 |
CHAR |
3 |
0 |
Bank country key |
T005 |
114 |
BANK_KEY_LIQ |
|
CMS_DTE_LIQ_BNK_KEY |
BANKK |
CHAR |
15 |
0 |
Bank Key |
|
115 |
BANK_CTRLKEY_LIQ |
|
BKONT |
BKONT |
CHAR |
2 |
0 |
Bank Control Key |
|
116 |
.INCLUDE |
|
|
|
|
0 |
0 |
Verfication Data |
|
117 |
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 |
|
118 |
PERIOD_VERF_FREQ |
|
CMS_DTE_AST_VERF_FREQ_PERIOD |
CMS_AST_VERF_FREQ_PERIOD |
NUMC |
4 |
0 |
Statement Period for an Asset |
|
119 |
LAST_VERF_DATE |
|
CMS_DTE_AST_VERF_DATE |
CMS_DATE |
DATS |
8 |
0 |
Last Verification Date |
|
120 |
.INCLUDE |
|
|
|
|
0 |
0 |
AST PKy and Type and Parent GUID |
|
121 |
AST_GUID |
|
CMS_DTE_AST_GUID |
SYSUUID |
RAW |
16 |
0 |
GUID for Table CMS_AST |
|
122 |
AST_TYP |
|
CMS_DTE_AST_TYP |
CMS_AST_TYP |
CHAR |
6 |
0 |
Asset Type |
* |
123 |
PARENT_GUID |
|
CMS_DTE_SAS_PAR_GUID |
SYSUUID |
RAW |
16 |
0 |
Asset Guid as a parent GUID for a sub-asset |
|
124 |
.INCLUDE |
|
|
|
|
0 |
0 |
Structure for Asset values |
|
125 |
NOM_VALUE |
|
CMS_DTE_AST_NOMINAL_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Nominal Value of the Asset |
|
126 |
NOM_VALUE_CURR |
|
CMS_DTE_AST_NOMINAL_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Nominal value |
TCURC |
127 |
AST_VALUE |
|
CMS_DTE_AST_VALUE |
CMS_AMOUNT |
CURR |
17 |
2 |
Final Asset Value |
|
128 |
AST_VALUE_CURR |
|
CMS_DTE_AST_VALUE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of the Final Asset Value |
TCURC |
129 |
QUANTITY |
|
CMS_DTE_QTY |
CMS_QTY |
QUAN |
13 |
3 |
Quantity |
|
130 |
UNIT_OF_MEASURE |
|
CMS_DTE_UNIT |
MEINS |
UNIT |
3 |
0 |
Unit of Measure of Quantity |
T006 |
131 |
REC_AT |
|
CMS_DTE_REC_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Asset Value Recording Timestamp |
|
132 |
.INCLUDE |
|
|
|
|
0 |
0 |
Purchase price data |
|
133 |
PUR_PRICE |
|
CMS_DTE_AST_PURCHASE_PRICE |
CMS_AMOUNT |
CURR |
17 |
2 |
Purchase Price of the Asset |
|
134 |
PUR_PRICE_CURR |
|
CMS_DTE_AST_PUR_PRICE_CURR |
WAERS |
CUKY |
5 |
0 |
Currency of Purchase Price |
TCURC |
135 |
PUR_DATE |
|
CMS_DTE_AST_PUR_PRICE_DATE |
CMS_DATE |
DATS |
8 |
0 |
Date of Purchase |
|
136 |
.INCLUDE |
|
|
|
|
0 |
0 |
Administrative organization unit |
|
137 |
ADMIN_ORG_UNIT |
|
CMS_DTE_ADMINORG |
TEXT12 |
CHAR |
12 |
0 |
Administration Organizational Unit |
|
138 |
.INCLUDE |
|
|
|
|
0 |
0 |
Bank area |
|
139 |
BANKAREA |
|
CMS_DTE_BANKAREA |
CMS_BANKAREA |
CHAR |
4 |
0 |
Bank Area in Collateral Management |
* |
140 |
.INCLUDE |
|
|
|
|
0 |
0 |
Organization unit structure |
|
141 |
ORG_UNIT1 |
|
CMS_DTE_ORG_UNIT1 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 1 |
* |
142 |
ORG_UNIT2 |
|
CMS_DTE_ORG_UNIT2 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 2 |
* |
143 |
ORG_UNIT3 |
|
CMS_DTE_ORG_UNIT3 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 3 |
* |
144 |
ORG_UNIT4 |
|
CMS_DTE_ORG_UNIT4 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 4 |
* |
145 |
ORG_UNIT5 |
|
CMS_DTE_ORG_UNIT5 |
CMS_ORG_UNIT |
CHAR |
10 |
0 |
Organizational Unit 5 |
* |
146 |
.INCLUDE |
|
|
|
|
0 |
0 |
Stucture to record history of changes in all application tab |
|
147 |
CREATED_BY |
|
CMS_DTE_USER |
CMS_USER |
CHAR |
12 |
0 |
Login ID of the User who created the Record |
|
148 |
CREATED_AT |
|
CMS_DTE_CREATED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Creation Timestamp |
|
149 |
CHANGED_BY |
|
CMS_DTE_LAST_CHNG_USER |
CMS_USER |
CHAR |
12 |
0 |
Last Changed By |
|
150 |
CHANGED_AT |
|
CMS_DTE_CHANGED_AT |
TZNTSTMPS |
DEC |
15 |
0 |
Change Timestamp |
|
151 |
SOURCEOFENTRY |
|
CMS_DTE_SOURCE_OF_ENTRY |
CMS_SOURCE |
CHAR |
32 |
0 |
Source of Entry |
|