I_SecuritiesAcctPosMstrData

Securities Account Position Details | view: ISECACCPOSMD | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_SEC_ACC_POS
Column Name Description
SecuritiesAccountPositionUUID GUID for securities positions in an account
Column Name Description
💲 Currency of nominal value of a position (SecuritiesAcctPosNominalCrcy):
SecuritiesAcctPosNominalAmount Nominal Value of a Position
💲 Currency of Current Price of a Securities Position (SecuritiesAcctPosCurPriceCrcy):
SecuritiesAcctPosCurPriceAmt Current Price of a Securities Postion per Unit
💲 Currency of the Market Value of Securities Positions (SecuritiesAcctPosMarketValCrcy):
SecuritiesAcctPosMarketValAmt Market Value of a Securities Position
💲 Currency of Converted Market Value of Positions (SecuritiesAcctPosCnvrtdMktCrcy):
SecuritiesAcctPosCnvrtdMktAmt Market Value of a Securities Account Position
💲 Currency of the Safety discount amount (SecuritiesAcctPosSftyDiscCrcy):
SecuritiesAcctPosSftyDiscAmt Safety discount as an amount
💲 Currency of Liquidation value (SecuritiesAcctPosLqdtnCurrency):
SecuritiesAcctPosLqdtnAmount Proceeds obtained from liquidation of the collateral
Column Name Description
Column Name Description
SecuritiesAcctPosLqdtnDate Date of Liquidation of Collateral
SecuritiesAcctPosEnteredDate Created On
SecuritiesAcctPosEnteredTime Created At
SecuritiesAcctPosLastChgdDate Last Changed on
SecuritiesAcctPosLastChgdTime Last Changed At
Column Name Description
SecuritiesAcctPosSftyDiscSign Indicates that the asset has a default sfty discount or not Show values
SecuritiesAcctPosSftyDiscPct Safety discount Show values
SecuritiesAcctPosLendgRateSign Indicates that the asset has a default lending rate or not Show values
Column Name Description Domain name
SecuritiesAccountObjectUUID GUID for securities account SYSUUID
SecuritiesAcctPosSqncNmbr Sequence Number of a Position in a Securities Account CMS_SEC_POS_ID
SecuritiesAcctPosExtRefNmbr ID of a Positiion Referenced from an External System CMS_SEC_EXT_REFID
SecuritiesAccountPositionID Unique ID for a Position in a Securities Account CMS_SEC_POS_ISIN
SecuritiesAcctPosNumberOfUnits Number of Units in a Securities Position CMS_SEC_UNITS
SecuritiesAcctPosCurPricePct Current Price of a Unit of a Securities Position CMS_SEC_PCT
SecuritiesAcctPos1stLendgRate Lending rate 1 CMS_PCT
SecuritiesAcctPosLqdtnType Liquidation type CMS_TYP
SecuritiesAcctPosLqdtnReason Liquidation Reason CMS_ATT_ID_TYP
SecuritiesAcctPosEnteredBy Securities Add-On User CMS_USER
SecuritiesAcctPosLastChangedBy Last Changed By CMS_USER
Master Data Relations Join Conditions
Risk Code
  • Risk Code
  • Client
  • I_SECURITIESACCTPOSMSTRDATA.SECURITIESACCOUNTPOSRISKCODE == TCMS_RISKCODE.RISK_CODE
  • I_SECURITIESACCTPOSMSTRDATA.MANDT == TCMS_RISKCODE.MANDT
Currency of Current Price of a Securities Position
  • Currency of Current Price of a Securities Position
  • Client
  • I_SECURITIESACCTPOSMSTRDATA.SECURITIESACCTPOSCURPRICECRCY == TCURC.WAERS
  • I_SECURITIESACCTPOSMSTRDATA.MANDT == TCURC.MANDT
Currency of Liquidation value
  • Client
  • Currency of Liquidation value
  • I_SECURITIESACCTPOSMSTRDATA.MANDT == TCURC.MANDT
  • I_SECURITIESACCTPOSMSTRDATA.SECURITIESACCTPOSLQDTNCURRENCY == TCURC.WAERS
Currency of the Market Value of Securities Positions
  • Client
  • Currency of the Market Value of Securities Positions
  • I_SECURITIESACCTPOSMSTRDATA.MANDT == TCURC.MANDT
  • I_SECURITIESACCTPOSMSTRDATA.SECURITIESACCTPOSMARKETVALCRCY == TCURC.WAERS
Currency of nominal value of a position
  • Client
  • Currency of nominal value of a position
  • I_SECURITIESACCTPOSMSTRDATA.MANDT == TCURC.MANDT
  • I_SECURITIESACCTPOSMSTRDATA.SECURITIESACCTPOSNOMINALCRCY == TCURC.WAERS
Currency of the Safety discount amount
  • Client
  • Currency of the Safety discount amount
  • I_SECURITIESACCTPOSMSTRDATA.MANDT == TCURC.MANDT
  • I_SECURITIESACCTPOSMSTRDATA.SECURITIESACCTPOSSFTYDISCCRCY == TCURC.WAERS