I_CollateralAgreementData

Collateral Agreement Details | view: ICAGDATA | ATTR | Extraction: Full or Incremental | Component: Collateral Management System
Tables used: CMS_CAG
Column Name Description
CollateralAgreementUUID GUID for Table CMS_CAG
Column Name Description
💲 Currency for Nominal Value of the Collateral Agreement (CollateralAgrmtNominalCrcy):
CollateralAgreementNominalAmt Nominal Value of the Collateral Agreement
💲 Currency of Assessment Value (ColltrlAgrmtAssessmentCrcy):
ColltrlAgrmtAssessmentAmt Assessment Amount
💲 Currency for Amount of Special Markdown (ColltrlAgrmtSpclMarkdownCrcy):
ColltrlAgrmtSpclMarkDwnAmt Amount of Special Markdown
💲 Currency for Amount of Guarantee in the event of Termination (ColltrlAgrmtTermnGuarCrcy):
ColltrlAgrmtTermnGuarAmt Amount of Guarantee in the event of Termination
💲 Currency of the Reduced Amount of the Guarantee (ColltrlAgrmtGuarReducnCrcy):
ColltrlAgrmtGuarReducnAmt Reduction in Amount of Guarantee
💲 Currency of the Original Protection Value (ColltrlAgrmtOriginalCurrency):
ColltrlAgrmtOriginalAmount Original Protection of the Agreements
💲 Currency of the Minimum Stock Amount (ColltrlAgrmtMinStockCurrency):
ColltrlAgrmtMinStockAmount Minimum stock Amount agreed in the Collateral Agreement
💲 Currency for Enforcement Amount of Land Charge (AgrmtLandChrgEnforcementCrcy):
AgrmtLandChrgEnforcementAmt Enforcement Amount
AgrmtLandChrgRefEnforcementAmt Reference amount for part (Equal,Secondar) enforcebility
💲 Currency for Increase in HBR amount (ColAgrHtBlRgIncreaseCrcy):
ColAgrHtBlRgIncreaseAmt Increase in Heritable Building Rights Amount
Column Name Description
Column Name Description
ColltrlAgrmtAssessmentDate Date on which the Assessment Value was Calculated
ColltrlAgreementConcludeDate Date on which Collateral Agreement was Concluded
ColltrlAgreementValidFromDate Date
ColltrlAgreementValidToDate Date
ColltrlAgrmtTermnNoticeDate Date on which Termination Notice was Sent
ColltrlAgrmtAdditionalRblDate Date on which Additional Receivable was Accepted
ColltrlAgrmtPledgeDisclosedDte Date of Disclosure to Third-party Debtor
AgrmtLandChrgCalcStrtDate Start Date for Land Charge Interest Calculation
ColAgrHtBlRgIntrstIncrStartDte Start date for Increase in Heritable Building Right Interest
ColAgrHtBlRgIntrstIncrLastDte Last date of Increase in Heritable Building Right Interest
Column Name Description
CollateralAgreementIsGlobal Flag to indicate a Global Collateral Agreement Show values
ColltrlAgrmtReleaseFrequency The unit for period of Release Frequency Show values
ColltrlAgrmtIsMinQltatvRqmts Flag:Minimum requirements fulfilled for CAG(for Basel II) Show values
ColltrlAgrmtTermnFrequency The Unit for Period of Termination Frequency Show values
ColltrlAgrmtTermnNoticeFrqcy The Unit for the Termination Notice Period Show values
ColltrlAgrmtHasCounterGuar Flag for Counter Guarantee Show values
ColltrlAgrmtHasAdditionalGuar Flag for Co-guarantee Show values
ColltrlAgrmtGuarIsFxdLiability Flag for Fixed Liability Show values
ColltrlAgrmtGuarIsDfltLblty Flag for Default Liability Show values
ColltrlAgrmtGuarLinkInCalc Flag for back-up guarantee to be used in calculations or not Show values
ColltrlAgrmtGuarAuthApproval Approval from authorities Show values
ColltrlAgrmtGuarIsEnforceable Agreement directly enforceable Show values
ColltrlAgrmtGuarReducnFrqcy Unit for Period of Frequency for Reduction in Guarantee Valu Show values
ColltrlAgrmtTransfIsLeasing Flag: Transfer is part of a leasing transaction Show values
ColltrlAgrmtAcctRblAssgmt Flag for Assignment of Accounts Receivables(AR) from Sale Show values
ColltrlAgrmtHasAdditionalRbl Flag for Additional receivable Show values
ColltrlAgrmtPledgeIsDisclosed Flag to indicator whether the Agreement is disclosed or not Show values
AgrmtLandChrgPaytFrqcy The unit for period of payment frequency Show values
AgrmtLandChrgEnforcementType Enforcement Type Show values
AgrmtLandChrgEnfrcmntTtlType Indicator for Enforcement Title Show values
ColAgrHtBlRgIntrstPayFrqUnit Unit for period of Payment Frequency of HBR interest Show values
ColAgrHtBlRgIsIntrstIncreasing Flag for increase in HBR interest Show values
ColAgrHtBlRgIntIncFrqUnit Unit for Frequency Period of Increase in HBR Interest Show values
AgrmtLandChrgIsCollective Flag: Collective Land Charge Show values
AgrmtLandChrgHasCert Flag: Land Charge certificate exists Show values
Column Name Description Domain name
CollateralAgreementID Collateral Agreement ID CMS_CAGID
CollateralAdminOrgUnit Administration Organizational Unit TEXT12
CollateralBankArea Bank Area in Collateral Management CMS_BANKAREA
ColltrlAgrmtSpclMarkDwnPct Percentage of Special Markdown CMS_PCT
CollateralAgreementDescription Description of Collateral Agreement CMS_DSC
ColltrlAgrmtReleasePeriod Period for Frequency of Release of Collateral Agreement CMS_CAG_FREQ_PERIOD
ColltrlAgrmtExtRefNumber External/Old Collateral Agreement ID CMS_OLD_CAGID
CollateralAgreementAssetPct Percentage of the Asset Value used in Collateral Agreement CMS_PCT
ColltrlAgrmtTermnRightType Termination Right Type CMS_CAG_TERM_RIGHT_TYP
ColltrlAgrmtTermnPeriod Period for Frequency of Termination of Collateral Agreement CMS_CAG_FREQ_PERIOD
ColltrlAgrmtGuaranteePct Guarantee Rate CMS_PCT
ColltrlAgrmtGuarDfltLbltyPct Default Liability in % CMS_PCT
ColltrlAgrmtGuarLendingRate Lending Rate of a Guarantee CMS_PCT
ColltrlAgrmtGuarReducnPeriod Period for Frequency of Reduction in Value of Guarantee CMS_CAG_FREQ_PERIOD
ColltrlAgrmtGuarReducnPct Percentage of Reduction in the Value of a Guarantee CMS_PCT
ColltrlAgrmtTransfAccsryLblty Specifies the applicability of accessories liability CMS_IND_CAG_ACC_LIABLE
AgrmtLandChrgInterestRate Land Charge Interest Rate CMS_PCT
AgrmtLandChrgIncidentalPaytPct Incidental Payments in Percentage CMS_PCT
AgrmtLandChrgPaytPeriod Period for Frequency of Payment of Land Charge Interest CMS_CAG_FREQ_PERIOD
AgrmtLandChrgIntrstCapitalYrs Number of Years the Land Charge Interest can be Capitalized CMS_CAG_LCHG_INT_YR
ColAgrHtBlRgIntrstPayFrqPerd Payment Frequency Period for HBR interest CMS_CAG_FREQ_PERIOD
ColAgrHtBlRgIntIncFrqPerd Frequency Period for Increase in HBR Interest CMS_CAG_FREQ_PERIOD
ColAgrHtBlRgIncreasePct Percentage Increase in Heritable Building Rights Amount CMS_PCT
AgrmtLandChrgCertNumber Charge Certificate Number CMS_LCHG_CERT_NUM
AgrmtLandChrgFileNumber File Number CMS_LCHG_FILE_NUM
ColltrlAgrmtUnit1 Organizational Unit 1: Collateral Agreement CMS_ORG_UNIT
ColltrlAgrmtUnit2 Organizational Unit 2: Collateral Agreement CMS_ORG_UNIT
ColltrlAgrmtUnit3 Organizational Unit 3: Collateral Agreement CMS_ORG_UNIT
ColltrlAgrmtUnit4 Organizational Unit 4: Collateral Agreement CMS_ORG_UNIT
ColltrlAgrmtUnit5 Organizational Unit 5: Collateral Agreement CMS_ORG_UNIT
ColltrlAgrmtLiquidationMode Mode of Liquidation decision for the pool agreement CMS_LIQD_MODE
ColltrlAgrmtPoolRelThreshold Limit above which the Collaterals can be Released from Pool CMS_PCT
Master Data Relations Join Conditions
GBC Lien on Agreement
  • GBC Lien on Agreement
  • Client
Indicator for Waiver of HBR Enforcement
  • Indicator for Waiver of HBR Enforcement
  • Client
Foreign key for Agreement type
  • Collateral Agreement Type
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLATERALAGREEMENTTYPE == TCMS_CAG_TYP.CAGMT_TYPE
  • I_COLLATERALAGREEMENTDATA.MANDT == TCMS_CAG_TYP.MANDT
Currency for Nominal Value of the Collateral Agreement
  • Client
  • Currency for Nominal Value of the Collateral Agreement
  • I_COLLATERALAGREEMENTDATA.MANDT == TCURC.MANDT
  • I_COLLATERALAGREEMENTDATA.COLLATERALAGRMTNOMINALCRCY == TCURC.WAERS
Currency of Assessment Value
  • Currency of Assessment Value
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTASSESSMENTCRCY == TCURC.WAERS
  • I_COLLATERALAGREEMENTDATA.MANDT == TCURC.MANDT
Reason for Assignment
  • ?
  • Reason for Assignment
  • Client
  • I_COLLATERALAGREEMENTDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTASSIGNMENTREASON == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_COLLATERALAGREEMENTDATA.MANDT == TCMS_ATT_ID_TY.MANDT
Correspondence role
  • Correspondence role
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTCORRESPNCROLE == TFK070M.CORR_ROLE
  • I_COLLATERALAGREEMENTDATA.MANDT == TFK070M.MANDT
Scope of Cover of Credit Insurance
  • Scope of Cover of Credit Insurance
  • ?
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTCREDITINSURCOVER == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_COLLATERALAGREEMENTDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_COLLATERALAGREEMENTDATA.MANDT == TCMS_ATT_ID_TY.MANDT
MInimum Qualitative Criterion
  • Client
  • MInimum Qualitative Criterion
  • I_COLLATERALAGREEMENTDATA.MANDT == TCMS_CAG_MQCRT.MANDT
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTMINQLTATVCRITERIA == TCMS_CAG_MQCRT.MIN_QL_CRITERION
Reason for the Minimum Qualitative Criterion
  • Reason for the Minimum Qualitative Criterion
  • ?
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTMINQLTATVCRITRARSN == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_COLLATERALAGREEMENTDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_COLLATERALAGREEMENTDATA.MANDT == TCMS_ATT_ID_TY.MANDT
Exceptions for Minimum Risk Weight
  • Exceptions for Minimum Risk Weight
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTMINQLTATVEXCPTN == TCMS_CAG_MQEXP.MIN_QL_EXCEP_TYP
  • I_COLLATERALAGREEMENTDATA.MANDT == TCMS_CAG_MQEXP.MANDT
Currency of the Minimum Stock Amount
  • Currency of the Minimum Stock Amount
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTMINSTOCKCURRENCY == TCURC.WAERS
  • I_COLLATERALAGREEMENTDATA.MANDT == TCURC.MANDT
Foreign key relationship
  • Termination Type
  • ?
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTTERMINATIONREASON == TCMS_ATT_ID_TY.INDICATOR_TYPE
  • I_COLLATERALAGREEMENTDATA.[column in domain "CMS_DTE_ATT_IND_CAT"] == TCMS_ATT_ID_TY.INDICATOR_ID
  • I_COLLATERALAGREEMENTDATA.MANDT == TCMS_ATT_ID_TY.MANDT
Indicator for Lessor Lien on Collateral Agreement
  • Indicator for Lessor Lien on Collateral Agreement
  • Client
  • I_COLLATERALAGREEMENTDATA.COLLTRLAGRMTTRANSFLESSORLIEN == TCMS_CAG_LSRLN.IND_LESSOR_LIEN
  • I_COLLATERALAGREEMENTDATA.MANDT == TCMS_CAG_LSRLN.MANDT