CMS_INS

Insurance Application Table | #masterdata | Component: Rights
Column Name Description
MANDT Client
INS_GUID Insurance GUID
Column Name Description
💲 Insurance Currency (INSUR_CURR):
INSUR_SUM Insurance Sum
MAX_COVER_AMT Maximum Coverage Amount
MIN_COVER_AMT Minimum Coverage Amount
💲 Insurance Currency (INSUR_PRM_CURR):
INSUR_PREMIUM Insurance Premium
💲 Tax Currency (INSUR_TAX_CURR):
INSUR_TAX_AMT Insurance tax amount
💲 Insurance Currency (REQD_INSUR_CURR):
REQD_INSUR_CVR Required insurance cover
💲 Currency for Share of Cover Market (SH_CVR_MKT_CUR):
SHARE_CVR_MKT Share of cover market
💲 Currency (ONE_TM_CON_CKY):
SUM_ONE_TM_CON Sum of one time contribution
💲 Insurance survival Currency (INS_SUM_SRVL_CKY):
INS_SUM_SRVL Insurance sum incase of survival
💲 Death benefit currency (INS_SUM_DTH_CKY):
INS_SUM_DTH Insurance sum in case of death
💲 Currency for probable benefit on expiry (INS_BENF_EXP_CKY):
INS_BENF_EXP Probable benefit on expiry
Column Name Description
Column Name Description
AUTO_CANCEL_DT Auto Cancellation Date for an Insurance Policy
PRM_VALID_FROM Date from when specified Premium is valid
LAST_PAYMENT_DT Date when last premium payment was made
NXT_PAYMENT_DT Next Payment Date when insurance premium is due
STATEMENT_DT Date when statements for Policy was made
INSURED_EVENT_DT Date when Insured Event Occured
INS_STRT_DAT Start date of insurance
INSUR_EXPY_DAT Date of expiry of insurance
CONTRACT_STRT_DT Contract begin date
CONTRACT_END_DT Contract end date
CONTRACT_CON_DT Date of conclusion of contract
INSUR_STATUS_DT Status date of insurance
DT_PROB_BEN_EXP Date of probable benefit on expiry
Column Name Description
INSUR_TAX_DB Insurance tax to the debit of the bank Show values
FREQ_UNIT Indicator: Units of time for revaluation Show values
IND_INSURED_EVNT Boolean indicator that insured event occured (X = Occured) Show values
IND_FORCE_PLACED Is Insurance Force Placed? (Default = No) Show values
IND_TAX_DEDUCT Indicator that Insurance Policy is Tax Deductible Show values
POLICY_STATUS Insurance Policy Status Show values
DYNAMICS Dynamics Show values
TERM_PRD_UNIT Indicator: Units of termination period Show values
RECALL_PRD_UNIT Indicator: Units of Recall Period Show values
Column Name Description Domain name
INS_CATEGORY Object Category CMS_OBJ_CAT
INS_TYP Insurance Type CMS_MOV_TYP
INS_ID Insurance ID CMS_MOV_ID
INS_DESC Insurance Description CMS_INS_DESC
PRM_RT Premium Rate CMS_INS_PRM_RT
INSUR_TAX_RT Insurance tax rate (in %) CMS_INS_PRM_RT
SCOPE_INS_COVER not used -> package has to be changed CMS_OMS_INS CMS_INS_COVER
EXT_ITM_NO Ext. Item no / Number for identification of the objects CMS_OMS_ID
EXT_REFERENCE Reference number for the legacy system CMS_OMS_REFID
INS_COMP Insurance Company CMS_INS_COMP
FOP Frequency of Payment CMS_INS_FREQ_OF_PAYMENT
INS_CODE Insurance Product Code CMS_INS_CODE
PAYMNT_METHOD Payment method for premiums CMS_INS_PAYMENT_METHOD
PAYMNT_INFO Payment Info for an insurance policy CMS_PAYMENT_HANDLE
MAX_AGE_LIMIT Maximum age limit for Policy Validity CMS_AGE
INSURER_NAM Name of the insurer CMS_INS_INSURER
INSURER_INF Remarks on insurer CMS_INS_INSUR_INF
COVER_MKT Cover Market LAND1
CONTACT_FIRM Contact firm CMS_INS_CON_FRM
CONTACT_PARTNER Contact partner CMS_INS_CON_PRT
TARRIF Insurance tariff CMS_INS_TARRIF
CALC_BASIS Calculation basis for Insurance handling CMS_INS_CALC_BASIC
INT_CALC_METH Interest calculation method for Insurance CMS_INS_INT_CAL_MTD
PER_DYNAMICS Percentage of the dynamics CMS_SEC_PCT
TERMIN_PRD Termination period CMS_INS_FREQ_OF_PAYMENT
RECALL_PRD Recall period CMS_INS_FREQ_OF_PAYMENT
ADMIN_ORG_UNIT Administration Organizational Unit TEXT12
BANKAREA Bank Area in Collateral Management CMS_BANKAREA
CREATED_BY Login ID of the User who created the Record CMS_USER
CREATED_AT Creation Timestamp TZNTSTMPS
CHANGED_BY Last Changed By CMS_USER
CHANGED_AT Change Timestamp TZNTSTMPS
SOURCEOFENTRY Source of Entry CMS_SOURCE
BUPR_ID Business Process ID SYSUUID
BUPR_TYPE_CODE Business Process Type Code CMS_BUPR_TYP_CODE
Master Data Relations Join Conditions
Reason for inactivating insurance policy
  • Reason for inactivating insurance policy
  • Client
Insurance Currency
  • CMS_INS.MANDT == TCURC.MANDT
  • CMS_INS.INSUR_CURR == TCURC.WAERS
Insurance Currency
  • CMS_INS.MANDT == TCURC.MANDT
  • CMS_INS.INSUR_PRM_CURR == TCURC.WAERS
Status of insurance
  • ?
  • Client
  • Status of insurance
Tax Currency
  • CMS_INS.MANDT == TCURC.MANDT
  • CMS_INS.INSUR_TAX_CURR == TCURC.WAERS
Currency for probable benefit on expiry
  • CMS_INS.MANDT == TCURC.MANDT
  • CMS_INS.INS_BENF_EXP_CKY == TCURC.WAERS
Death benefit currency
  • CMS_INS.MANDT == TCURC.MANDT
  • CMS_INS.INS_SUM_DTH_CKY == TCURC.WAERS
Insurance survival Currency
  • CMS_INS.MANDT == TCURC.MANDT
  • CMS_INS.INS_SUM_SRVL_CKY == TCURC.WAERS
Currency
  • CMS_INS.MANDT == TCURC.MANDT
  • CMS_INS.ONE_TM_CON_CKY == TCURC.WAERS
Country/Region of Insurance Purchase
  • Country/Region of Insurance Purchase
  • Client
  • CMS_INS.ORIG_COUNTRY == T005.LAND1
  • CMS_INS.MANDT == T005.MANDT
Region where Insurance was purchased
  • Country/Region of Insurance Purchase
  • Region where Insurance was purchased
  • CMS_INS.MANDT == T005S.MANDT
  • CMS_INS.ORIG_COUNTRY == T005S.LAND1
  • CMS_INS.ORIG_REGION == T005S.BLAND
Insurance Portfolio
  • Insurance Portfolio
  • Client
Type of Premium
Identifier for the rebate method used to calculate refunds
Insurance Currency
  • CMS_INS.MANDT == TCURC.MANDT
  • CMS_INS.REQD_INSUR_CURR == TCURC.WAERS
Type of settlement
  • ?
  • Client
  • Type of settlement