I_InsuranceObjectMasterData

Insurance Object Details | view: IINSOBJMDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_INS
Column Name Description
InsuranceObjectUUID Insurance GUID
Column Name Description
💲 Insurance Currency (InsuranceObjectSumCurrency):
InsuranceObjectSumAmount Insurance Sum
💲 Insurance Currency (InsuranceObjectPremiumCurrency):
InsuranceObjectPremiumAmount Insurance Premium
💲 Tax Currency (InsuranceObjectTaxCurrency):
InsuranceObjectTaxAmount Insurance tax amount
💲 Insurance Currency (InsuranceObjRequiredCoverCrcy):
InsuranceObjRequiredCoverAmt Required insurance cover
💲 Currency for Share of Cover Market (InsuranceObjMarketCoverShrCrcy):
InsuranceObjMarketCoverShrAmt Share of cover market
💲 Currency (InsuranceObjOneTmeContrbnCrcy):
InsuranceObjOneTimeContrbnAmt Sum of one time contribution
💲 Insurance survival Currency (InsuranceObjSurvivalBnftCrcy):
InsuranceObjectSurvivalBnftAmt Insurance sum incase of survival
💲 Death benefit currency (InsuranceObjDeathBnftCrcy):
InsuranceObjectDeathBnftAmt Insurance sum in case of death
💲 Currency for probable benefit on expiry (InsuranceObjExpiryBnftCrcy):
InsuranceObjectExpiryBnftAmt Probable benefit on expiry
Column Name Description
Column Name Description
InsuranceObjectStartDate Start date of insurance
InsuranceObjectExpiryDate Date of expiry of insurance
InsuranceObjContractBeginDate Contract begin date
InsuranceObjectContractEndDate Contract end date
InsuranceObjContrConclusionDte Date of conclusion of contract
InsuranceObjectStatusDate Status date of insurance
InsuranceObjExpiryBnftDate Date of probable benefit on expiry
Column Name Description
InsuranceObjectBankTaxDebit Insurance tax to the debit of the bank Show values
InsurObjHasDynamicAdaption Dynamics Show values
InsuranceObjectTermnPeriodUnit Indicator: Units of termination period Show values
InsuranceObjRecallPeriodUnit Indicator: Units of Recall Period Show values
Column Name Description Domain name
InsuranceObjectCategory Object Category CMS_OBJ_CAT
InsuranceObjectType Insurance Type CMS_MOV_TYP
CollateralInsuranceObjectID Insurance ID CMS_MOV_ID
InsuranceObjectDescription Insurance Description CMS_INS_DESC
InsuranceObjectPremiumRate Premium Rate CMS_INS_PRM_RT
InsuranceObjectTaxRate Insurance tax rate (in %) CMS_INS_PRM_RT
InsuranceObjectInsurerName Name of the insurer CMS_INS_INSURER
InsuranceObjectInsurerDesc Remarks on insurer CMS_INS_INSUR_INF
InsuranceObjectMarketCover Cover Market LAND1
InsuranceObjectContactFirmName Contact firm CMS_INS_CON_FRM
InsuranceObjContactPartnerName Contact partner CMS_INS_CON_PRT
InsuranceObjectTariffDesc Insurance tariff CMS_INS_TARRIF
InsuranceObjectDynamicsPct Percentage of the dynamics CMS_SEC_PCT
InsuranceObjectTermnPeriod Termination period CMS_INS_FREQ_OF_PAYMENT
InsuranceObjectRecallPeriod Recall period CMS_INS_FREQ_OF_PAYMENT
CollateralAdminOrgUnit Administration Organizational Unit TEXT12
CollateralBankArea Bank Area in Collateral Management CMS_BANKAREA
Master Data Relations Join Conditions
Death benefit currency
  • Death benefit currency
  • Client
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJDEATHBNFTCRCY == TCURC.WAERS
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCURC.MANDT
Insurance Currency
  • Client
  • Insurance Currency
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCURC.MANDT
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJECTPREMIUMCURRENCY == TCURC.WAERS
Type of settlement
  • ?
  • Type of settlement
  • Client
  • I_INSURANCEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJECTSETTLEMENTTYPE == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
Status of insurance
  • ?
  • Status of insurance
  • Client
  • I_INSURANCEOBJECTMASTERDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJECTSTATUS == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCMS_ATT_ID_TY.MANDT
Insurance Currency
  • Client
  • Insurance Currency
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCURC.MANDT
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJECTSUMCURRENCY == TCURC.WAERS
Tax Currency
  • Tax Currency
  • Client
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJECTTAXCURRENCY == TCURC.WAERS
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCURC.MANDT
Currency for probable benefit on expiry
  • Currency for probable benefit on expiry
  • Client
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJEXPIRYBNFTCRCY == TCURC.WAERS
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCURC.MANDT
Currency
  • Client
  • Currency
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCURC.MANDT
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJONETMECONTRBNCRCY == TCURC.WAERS
Insurance Currency
  • Client
  • Insurance Currency
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCURC.MANDT
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJREQUIREDCOVERCRCY == TCURC.WAERS
Insurance survival Currency
  • Insurance survival Currency
  • Client
  • I_INSURANCEOBJECTMASTERDATA.INSURANCEOBJSURVIVALBNFTCRCY == TCURC.WAERS
  • I_INSURANCEOBJECTMASTERDATA.MANDT == TCURC.MANDT