I_SecuritiesAcctObjMstrData

Securities Account Object Details | view: ISECACCOBJMDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: TCMS_SEC_ASTCMS_SEC_ACC
Column Name Description
SecuritiesAccountObjectUUID GUID for securities account
Column Name Description
💲 Currency of Securities Account Value (SecuritiesAccountObjValCrcy):
SecuritiesAccountObjValAmt Value of the Securities Account
💲 Currency of the Safety discount amount (SecuritiesAcctObjSftyDiscCrcy):
SecuritiesAcctObjSftyDiscAmt Safety discount as an amount
💲 Currency of Liquidation value (SecuritiesAcctObjLqdtnCrcy):
SecuritiesAcctObjLqdtnAmt Proceeds obtained from liquidation of the collateral
Column Name Description
Column Name Description
SecuritiesAccountObjValnDte Date of last valuation
SecuritiesAcctObjRevalStrtDte Valuation Start date
SecuritiesAcctObjRevalEndDte Valuation End date
SecuritiesAcctObjLqdtnDate Date of Liquidation of Collateral
SecuritiesAcctObjEnteredDte Created On
SecuritiesAcctObjEnteredTme Created At
SecuritiesAcctObjLastChgdDte Last Changed on
SecuritiesAcctObjLastChgdTme Last Changed At
Column Name Description
SecuritiesAcctObjSftyDiscSign Indicates that the asset has a default sfty discount or not Show values
SecuritiesAcctObjSftyDiscPct Safety discount Show values
SecuritiesAcctObjValnFrqcy Indicator : Valuation Frequency of Securities Account Show values
SecuritiesAcctObjLendgRateSign Indicates that the asset has a default lending rate or not Show values
Column Name Description Domain name
SecuritiesAcctObjDepositoryBk Depository Bank Identification CMS_SEC_DEPO_BNK_ID
SecuritiesAccountObjectNumber Securities Account Identification Number CMS_SEC_ACC_ID
SecuritiesAccountObjDesc Description of the Securities Account CMS_SEC_DESC
SecuritiesAcctObjExtRefNmbr ID of a Securities Account Referenced from External System CMS_SEC_EXT_REFID
CollateralAdminOrgUnit Administration Organizational Unit TEXT12
CollateralBankArea Bank Area in Collateral Management CMS_BANKAREA
SecuritiesAccountObjRiskCode Risk Code CMS_RISK_CODE
SecuritiesAcctObjValnPerd Period of revaluation for securities CMS_AST_VALN_FREQ_PERIOD
SecuritiesAcctObj1stLendgRate Lending rate 1 CMS_PCT
SecuritiesAcctObjLqdtnType Liquidation type CMS_TYP
SecuritiesAcctObjLqdtnRsn Liquidation Reason CMS_ATT_ID_TYP
SecuritiesAccountObjOrgUnit1 Organizational Unit 1: Assets CMS_ORG_UNIT
SecuritiesAccountObjOrgUnit2 Organizational Unit 2: Assets CMS_ORG_UNIT
SecuritiesAccountObjOrgUnit3 Organizational Unit 3: Assets CMS_ORG_UNIT
SecuritiesAccountObjOrgUnit4 Organizational Unit 4: Assets CMS_ORG_UNIT
SecuritiesAccountObjOrgUnit5 Organizational Unit 5: Assets CMS_ORG_UNIT
SecuritiesAcctObjEnteredBy Securities Add-On User CMS_USER
SecuritiesAcctObjLastChgdBy Last Changed By CMS_USER
Master Data Relations Join Conditions
Process Control Key
  • Process Control Key
  • Client
  • I_SECURITIESACCTOBJMSTRDATA.COLLATERALPROCESSCONTROLKEY == TCMS_PCN_CKY.PROC_OBJ
  • I_SECURITIESACCTOBJMSTRDATA.MANDT == TCMS_PCN_CKY.MANDT
currency field check
  • Client
  • Currency of Securities Account Value
  • I_SECURITIESACCTOBJMSTRDATA.MANDT == TCURC.MANDT
  • I_SECURITIESACCTOBJMSTRDATA.SECURITIESACCOUNTOBJVALCRCY == TCURC.WAERS
Currency of Liquidation value
  • Client
  • Currency of Liquidation value
  • I_SECURITIESACCTOBJMSTRDATA.MANDT == TCURC.MANDT
  • I_SECURITIESACCTOBJMSTRDATA.SECURITIESACCTOBJLQDTNCRCY == TCURC.WAERS
Currency of the Safety discount amount
  • Client
  • Currency of the Safety discount amount
  • I_SECURITIESACCTOBJMSTRDATA.MANDT == TCURC.MANDT
  • I_SECURITIESACCTOBJMSTRDATA.SECURITIESACCTOBJSFTYDISCCRCY == TCURC.WAERS