| MANDT |
✔ |
Client |
MANDT |
CLNT |
3 |
* |
| INS_GUID |
✔ |
Insurance GUID |
CMS_DTE_INS_GUID |
RAW |
16 |
|
| INS_CATEGORY |
|
Object Category |
CMS_DTE_OMS_OBJ_CAT |
CHAR |
6 |
* |
| INS_TYP |
|
Insurance Type |
CMS_DTE_INS_TYPE |
CHAR |
6 |
* |
| INS_ID |
|
Insurance ID |
CMS_DTE_INS_ID |
CHAR |
40 |
|
| INS_DESC |
|
Insurance Description |
CMS_DTE_INS_DESC |
CHAR |
30 |
|
| INSUR_TAX_DB |
|
Insurance tax to the debit of the bank |
CMS_DTE_INS_TAX_DB |
CHAR |
1 |
|
| SETLMNT_TYPE |
|
Type of settlement |
CMS_DTE_INS_SETLMNT_TYPE |
CHAR |
6 |
TCMS_ATT_ID_TY |
| INSUR_SUM |
|
Insurance Sum |
CMS_DTE_INS_SUM |
CURR |
17 |
|
| INSUR_CURR |
|
Insurance Currency |
CMS_DTE_INS_CURR |
CUKY |
5 |
TCURC |
| PRM_RT |
|
Premium Rate |
CMS_DTE_INS_PRM_RT |
DEC |
10 |
|
| INSUR_PREMIUM |
|
Insurance Premium |
CMS_DTE_INS_PRM |
CURR |
17 |
|
| INSUR_PRM_CURR |
|
Insurance Currency |
CMS_DTE_INS_CURR |
CUKY |
5 |
TCURC |
| INSUR_TAX_RT |
|
Insurance tax rate (in %) |
CMS_DTE_INS_TAX_RT |
DEC |
10 |
|
| INSUR_TAX_AMT |
|
Insurance tax amount |
CMS_DTE_INS_TAX_AMT |
CURR |
17 |
|
| INSUR_TAX_CURR |
|
Tax Currency |
CMS_DTE_INS_TAX_CURR |
CUKY |
5 |
TCURC |
| SCOPE_INS_COVER |
|
not used -> package has to be changed CMS_OMS_INS |
CMS_DTE_INS_COVER |
CHAR |
6 |
|
| EXT_ITM_NO |
|
Ext. Item no / Number for identification of the objects |
CMS_DTE_OMS_EXT_ITM_NO |
CHAR |
40 |
|
| EXT_REFERENCE |
|
Reference number for the legacy system |
CMS_DTE_OMS_REF_ID |
CHAR |
32 |
|
| FOP |
|
Frequency of Payment |
CMS_DTE_INS_FOP |
NUMC |
4 |
|
| FREQ_UNIT |
|
Indicator: Units of time for revaluation |
CMS_DTE_INS_FREQ_UNIT |
CHAR |
2 |
|
| INS_CODE |
|
Insurance Product Code |
CMS_DTE_INS_CODE |
CHAR |
6 |
|
| ORIG_COUNTRY |
|
Country where Insurance was purchased |
CMS_DTE_INS_ORIG_COUNTRY |
CHAR |
3 |
T005 |
| ORIG_REGION |
|
Region where Insurance was purchased |
CMS_DTE_INS_ORIG_REGION |
CHAR |
3 |
T005S |
| AUTO_CANCEL_DT |
|
Auto Cancellation Date for an Insurance Policy |
CMS_DTE_INS_AUTO_CANCEL_DT |
DATS |
8 |
|
| PRM_TYPE |
|
Type of Premium |
CMS_DTE_INS_PRM_TYPE |
CHAR |
2 |
|
| PRM_VALID_FROM |
|
Date from when specified Premium is valid |
CMS_DTE_INS_PRM_VALID_FROM_DT |
DATS |
8 |
|
| PAYMNT_METHOD |
|
Payment method for premiums |
CMS_DTE_INS_PAYMENT_METHOD |
CHAR |
2 |
|
| PAYMNT_INFO |
|
Payment Info for an insurance policy |
CMS_DTE_INS_PAY_INFO |
CHAR |
30 |
|
| LAST_PAYMENT_DT |
|
Date when last premium payment was made |
CMS_DTE_INS_LAST_PAYMENT_DT |
DATS |
8 |
|
| NXT_PAYMENT_DT |
|
Next Payment Date when insurance premium is due |
CMS_DTE_INS_NXT_PAYMENT_DT |
DATS |
8 |
|
| STATEMENT_DT |
|
Date when statements for Policy was made |
CMS_DTE_INS_STATEMENT_DT |
DATS |
8 |
|
| REBATE_METHOD |
|
Identifier for the rebate method used to calculate refunds |
CMS_DTE_INS_REBATE_METHOD_ID |
CHAR |
6 |
TCMS_INS_REB |
| PORTFOLIO |
|
Insurance Portfolio |
CMS_DTE_INS_PORTFOLIO |
CHAR |
6 |
TCMS_INS_PORT |
| MAX_AGE_LIMIT |
|
Maximum age limit for Policy Validity |
CMS_DTE_INS_MAX_AGE_LIMIT |
INT1 |
3 |
|
| MAX_COVER_AMT |
|
Maximum Coverage Amount |
CMS_DTE_INS_MAX_COVER_AMT |
CURR |
17 |
|
| MIN_COVER_AMT |
|
Minimum Coverage Amount |
CMS_DTE_INS_MIN_COVER_AMT |
CURR |
17 |
|
| IND_INSURED_EVNT |
|
Boolean indicator that insured event occured (X = Occured) |
CMS_DTE_IND_INSURED_EVENT |
CHAR |
1 |
|
| INSURED_EVENT_DT |
|
Date when Insured Event Occured |
CMS_DTE_INSURED_EVENT_DT |
DATS |
8 |
|
| IND_FORCE_PLACED |
|
Is Insurance Force Placed? (Default = No) |
CMS_DTE_INS_IND_FORCE_PLACE |
CHAR |
2 |
|
| IND_TAX_DEDUCT |
|
Indicator that Insurance Policy is Tax Deductible |
CMS_DTE_INS_IND_TAX_DEDUCT |
CHAR |
2 |
|
| INACTIVE_REASON |
|
Reason for inactivating insurance policy |
CMS_DTE_INS_INACTIVE_REASON |
CHAR |
2 |
TCMS_INS_SRSN |
| POLICY_STATUS |
|
Insurance Policy Status |
CMS_DTE_INS_POLICY_STATUS |
CHAR |
2 |
|
| INS_STRT_DAT |
|
Start date of insurance |
CMS_DTE_INS_STRT_DAT |
DATS |
8 |
|
| INSUR_EXPY_DAT |
|
Date of expiry of insurance |
CMS_DTE_INS_EXPY_DAT |
DATS |
8 |
|
| REQD_INSUR_CVR |
|
Required insurance cover |
CMS_DTE_INS_REQD_CVR |
CURR |
17 |
|
| REQD_INSUR_CURR |
|
Insurance Currency |
CMS_DTE_INS_CURR |
CUKY |
5 |
TCURC |
| INSURER_NAM |
|
Name of the insurer |
CMS_DTE_INS_INSUR_NAM |
CHAR |
30 |
|
| INSURER_INF |
|
Remarks on insurer |
CMS_DTE_INS_INSUR_INF |
CHAR |
30 |
|
| COVER_MKT |
|
Cover Market |
CMS_DTE_INS_COVER_MKT |
CHAR |
3 |
* |
| SHARE_CVR_MKT |
|
Share of cover market |
CMS_DTE_INS_SH_CVR_MKT |
CURR |
17 |
|
| SH_CVR_MKT_CUR |
|
Currency for Share of Cover Market |
CMS_DTE_INS_SH_CVR_MKT_CUR |
CUKY |
5 |
* |
| CONTACT_FIRM |
|
Contact firm |
CMS_DTE_INS_CON_FRM |
CHAR |
30 |
|
| CONTACT_PARTNER |
|
Contact partner |
CMS_DTE_INS_CON_PRT |
CHAR |
30 |
|
| TARRIF |
|
Insurance tariff |
CMS_DTE_INS_TARRIF |
CHAR |
30 |
|
| CONTRACT_STRT_DT |
|
Contract begin date |
CMS_DTE_INS_CNTRT_STRT_DT |
DATS |
8 |
|
| CONTRACT_END_DT |
|
Contract end date |
CMS_DTE_INS_CNTRT_END_DT |
DATS |
8 |
|
| CONTRACT_CON_DT |
|
Date of conclusion of contract |
CMS_DTE_INS_CNTRT_CON_DT |
DATS |
8 |
|
| INSUR_STATUS |
|
Status of insurance |
CMS_DTE_INS_STATUS |
CHAR |
6 |
TCMS_ATT_ID_TY |
| INSUR_STATUS_DT |
|
Status date of insurance |
CMS_DTE_INS_STATUS_DT |
DATS |
8 |
|
| SUM_ONE_TM_CON |
|
Sum of one time contribution |
CMS_DTE_INS_SUM_ONE_TM_CON |
CURR |
17 |
|
| ONE_TM_CON_CKY |
|
Currency |
CMS_DTE_INS_ONE_TM_CON_CKY |
CUKY |
5 |
TCURC |
| DYNAMICS |
|
Dynamics |
CMS_DTE_INS_DYNAMICS |
CHAR |
1 |
|
| PER_DYNAMICS |
|
Percentage of the dynamics |
CMS_DTE_INS_PER_DYNAMICS |
DEC |
10 |
|
| TERMIN_PRD |
|
Termination period |
CMS_DTE_INS_TERMIN_PRD |
NUMC |
4 |
|
| TERM_PRD_UNIT |
|
Indicator: Units of termination period |
CMS_DTE_INS_TERM_PRD_UNIT |
CHAR |
2 |
|
| RECALL_PRD |
|
Recall period |
CMS_DTE_INS_RECALL_PRD |
NUMC |
4 |
|
| RECALL_PRD_UNIT |
|
Indicator: Units of Recall Period |
CMS_DTE_INS_RECALL_PRD_UNIT |
CHAR |
2 |
|
| INS_SUM_SRVL |
|
Insurance sum incase of survival |
CMS_DTE_INS_SUM_IN_SURVIVAL |
CURR |
17 |
|
| INS_SUM_SRVL_CKY |
|
Insurance survival Currency |
CMS_DTE_INS_SUM_IN_SURVIVL_CKY |
CUKY |
5 |
TCURC |
| INS_SUM_DTH |
|
Insurance sum in case of death |
CMS_DTE_INS_SUM_IN_DEATH |
CURR |
17 |
|
| INS_SUM_DTH_CKY |
|
Death benefit currency |
CMS_DTE_INS_SUM_IN_DEATH_CKY |
CUKY |
5 |
TCURC |
| INS_BENF_EXP |
|
Probable benefit on expiry |
CMS_DTE_INS_PROB_BENF |
CURR |
17 |
|
| INS_BENF_EXP_CKY |
|
Currency for probable benefit on expiry |
CMS_DTE_INS_PROB_BENF_CKY |
CUKY |
5 |
TCURC |
| DT_PROB_BEN_EXP |
|
Date of probable benefit on expiry |
CMS_DTE_INS_DT_PRO_BEN_EXP |
DATS |
8 |
|
| ADMIN_ORG_UNIT |
|
Administration Organizational Unit |
CMS_DTE_ADMINORG |
CHAR |
12 |
|
| BANKAREA |
|
Bank Area in Collateral Management |
CMS_DTE_BANKAREA |
CHAR |
4 |
* |
| CREATED_BY |
|
Login ID of the User who created the Record |
CMS_DTE_USER |
CHAR |
12 |
|
| CREATED_AT |
|
Creation Timestamp |
CMS_DTE_CREATED_AT |
DEC |
15 |
|
| CHANGED_BY |
|
Last Changed By |
CMS_DTE_LAST_CHNG_USER |
CHAR |
12 |
|
| CHANGED_AT |
|
Change Timestamp |
CMS_DTE_CHANGED_AT |
DEC |
15 |
|
| SOURCEOFENTRY |
|
Source of Entry |
CMS_DTE_SOURCE_OF_ENTRY |
CHAR |
32 |
|