I_ObjectAssetData

Object Asset Details | view: IOBJASSETDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_AST
Column Name Description
ObjectAssetUUID GUID for Table CMS_AST
Column Name Description
💲 Currency of the Safety Discount Amount (ObjectAssetSafetyDiscountCrcy):
ObjectAssetSafetyDiscountAmt Amount of Safety Discount
💲 Currency of Liquidation Value (ObjectAssetLiquidationCurrency):
ObjectAssetLiquidationAmount Returns from the Liquidation of Collateral
💲 Currency of Nominal value (ObjectAssetNominalCurrency):
ObjectAssetNominalAmount Nominal Value of the Asset
💲 Currency of the Final Asset Value (ObjectAssetFinalCurrency):
ObjectAssetFinalAmount Final Asset Value
💲 Currency of the Original Protection Value (ObjectAssetOriginalCurrency):
ObjectAssetOriginalAmount Original Protection of the Asset
Column Name Description
📏 Unit of Measure of Quantity (ObjectAssetUnitOfMeasure):
ObjectAssetQuantity Quantity
Column Name Description
ObjectAssetLastRevaluationDate Last Date on which the Asset was Valued
ObjectAssetRevaluationStartDte Date on which the First Valuation is Performed on the Asset
ObjectAssetRevaluationEndDate Date on which the Last Valuation is Performed on the Asset
ObjectAssetLiquidationDate Date on which the Collateral was Liquidated
ObjectAssetVerificationDate Last Verification Date
Column Name Description
ObjectAssetSafetyDiscountSign Indicates if the Asset has a Default Safety Discount Show values
ObjectAssetSafetyDiscountPct Percentage of Safety Discount Show values
ObjectAssetValuationType Type of Valuation Check performed on Collateral Object Show values
ObjectAssetValuationFrequency Indicator: Units of time for revaluation of an asset Show values
ObjectAssetLendingRateSign Indicator to specify if Asset has a Default Lending Rate Show values
ObjectAssetVerificationFrqcy Indicator: Units of time for verification of an asset Show values
Column Name Description Domain name
ObjectAssetID Asset ID CMS_AST_ID
ObjectAssetParentUUID Asset Guid as a parent GUID for a sub-asset SYSUUID
ObjectAssetReferenceNumber Reference ID for the object CMS_OBJ_REFID
ObjectAssetReferenceSystem Object System Reference ID CMS_SYS
ObjectAssetValuationPeriod Revaluation Period for an Asset CMS_AST_VALN_FREQ_PERIOD
ObjectAsset1stLendingRate Lending Rate 1 CMS_PCT
ObjectAsset2ndLendingRate Lending Rate 2 CMS_PCT
ObjectAsset3rdLendingRate Lending Rate 3 CMS_PCT
ObjectAsset4thLendingRate Lending Rate 4 CMS_PCT
ObjectAsset5thLendingRate Lending Rate 5 CMS_PCT
ObjectAssetLqdtnAccountNumber Account number for liquidation proceeds BANKN35
ObjectAssetLiquidationBankKey Bank Key BANKK
ObjectAssetBankControlKey Bank Control Key BKONT
ObjectAssetVerificationPeriod Statement Period for an Asset CMS_AST_VERF_FREQ_PERIOD
Master Data Relations Join Conditions
Currency of the Final Asset Value
  • Client
  • Currency of the Final Asset Value
  • I_OBJECTASSETDATA.MANDT == TCURC.MANDT
  • I_OBJECTASSETDATA.OBJECTASSETFINALCURRENCY == TCURC.WAERS
Currency of Liquidation Value
  • Currency of Liquidation Value
  • Client
  • I_OBJECTASSETDATA.OBJECTASSETLIQUIDATIONCURRENCY == TCURC.WAERS
  • I_OBJECTASSETDATA.MANDT == TCURC.MANDT
Liquidation Reason
  • Liquidation Reason
  • Client
  • ?
  • I_OBJECTASSETDATA.OBJECTASSETLIQUIDATIONREASON == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_OBJECTASSETDATA.MANDT == TCMS_ATT_ID_TY.MANDT
  • I_OBJECTASSETDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
Foreign key relationship
  • Liquidation Type
  • Client
Key of Bank Country/Region
  • Key of Bank Country/Region
  • Client
  • I_OBJECTASSETDATA.OBJECTASSETLQDTNBANKCOUNTRY == T005.LAND1
  • I_OBJECTASSETDATA.MANDT == T005.MANDT
Currency of Nominal value
  • Client
  • Currency of Nominal value
  • I_OBJECTASSETDATA.MANDT == TCURC.MANDT
  • I_OBJECTASSETDATA.OBJECTASSETNOMINALCURRENCY == TCURC.WAERS
Currency of the Original Protection Value
  • Client
  • Currency of the Original Protection Value
  • I_OBJECTASSETDATA.MANDT == TCURC.MANDT
  • I_OBJECTASSETDATA.OBJECTASSETORIGINALCURRENCY == TCURC.WAERS
Currency of the Safety Discount Amount
  • Client
  • Currency of the Safety Discount Amount
  • I_OBJECTASSETDATA.MANDT == TCURC.MANDT
  • I_OBJECTASSETDATA.OBJECTASSETSAFETYDISCOUNTCRCY == TCURC.WAERS
Foreign key for Asset type
  • Asset Type
  • Client
Foreign key for unit of measure
  • Client
  • Unit of Measure of Quantity
  • I_OBJECTASSETDATA.MANDT == T006.MANDT
  • I_OBJECTASSETDATA.OBJECTASSETUNITOFMEASURE == T006.MSEHI