A_IntrstRateInstrIntrstCndn

@AccessControl.authorizationCheck: #MANDATORY
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #CONSUMPTION
@ObjectModel:{
    usageType : {
        sizeCategory: #L,
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL
    }
}
@EndUserText.label: 'Interest Condition'
@OData.entityType.name: 'IntrstRateInstrIntrstCndn_Type'
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
define view entity A_IntrstRateInstrIntrstCndn
  as select from I_FinTransInterestCondition

  association [0..*] to A_IntrstRateInstrCndnScale  as _Scale           on  $projection.CompanyCode                    = _Scale.CompanyCode
                                                                        and $projection.FinancialTransaction           = _Scale.FinancialTransaction
                                                                        and $projection.FinancialInstrumentActivity    = _Scale.FinancialInstrumentActivity
                                                                        and $projection.FinancialTransactionDirection  = _Scale.FinancialTransactionDirection
                                                                        and $projection.FinInstrConditionLogicGroup    = _Scale.FinInstrConditionLogicGroup
                                                                        and $projection.ConditionItemValidityStartDate = _Scale.ConditionItemValidityStartDate
  association [0..*] to A_IntrstRateInstrCndnSglDte as _SingleDate      on  $projection.CompanyCode                    = _SingleDate.CompanyCode
                                                                        and $projection.FinancialTransaction           = _SingleDate.FinancialTransaction
                                                                        and $projection.FinancialInstrumentActivity    = _SingleDate.FinancialInstrumentActivity
                                                                        and $projection.FinancialTransactionDirection  = _SingleDate.FinancialTransactionDirection
                                                                        and $projection.FinConditionItem               = _SingleDate.FinConditionItem
                                                                        and $projection.ConditionItemValidityStartDate = _SingleDate.ConditionItemValidityStartDate
  association [0..*] to A_IntrstRateInstrFmlaVarbl  as _FormulaVariable on  $projection.CompanyCode                       =  _FormulaVariable.CompanyCode
                                                                        and $projection.FinancialTransaction              =  _FormulaVariable.FinancialTransaction
                                                                        and $projection.FinancialInstrumentActivity       =  _FormulaVariable.FinancialInstrumentActivity
                                                                        and $projection.FinancialTransactionDirection     =  _FormulaVariable.FinancialTransactionDirection
                                                                        and $projection.FinConditionItem                  =  _FormulaVariable.FinConditionItem
                                                                        and $projection.ConditionItemValidityStartDate    =  _FormulaVariable.ConditionItemValidityStartDate
                                                                        and _FormulaVariable.FinConditionFormulaReference <> '0003'
{

  key CompanyCode,
  key FinancialTransaction,
  key FinancialInstrumentActivity,
  key FinancialTransactionDirection,
  key FinConditionItem,
  key ConditionItemValidityStartDate,
      FinConditionConditionCategory,
      FinConditionConditionType,
      FinInstrConditionLogicGroup,
      InterestCalculationMethod,
      IntrstCalcMethFactoryCalendar,
      InterestCalculationType,
      ExponentialIntrstSettlmtFrqcy,
      FinConditionInterestCategory,
      @Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
      FinancialConditionItemAmount,
      FinancialConditionItemCurrency,
      ConditionPercentageRate,
      FinancialConditionPaymentRate,
      InterestReference,
      InterestMarkupMarkdownValue,
      InterestFirstPeriodRate,
      FinConditionFormulaReference,
      FinConditionFactoryCalendar1,
      FinConditionFactoryCalendar2,
      FinConditionFactoryCalendar3,
      FinConditionFactoryCalendar4,
      FinConditionFactoryCalendar5,
      FinCndnFirstPeriodCalcMethod,
      FinCndnLastPeriodCalcMethod,
      FinCndnCalcDteUpdateRule,
      FinCndnCalcDteFrequency,
      FinCndnCalcDteFrqcyUnit,
      CalculationDate,
      CalcDateIsAsEndDateInclusive,
      CalcDteIsRegularWithVarblDte,
      CalcDateIsAsEndDateMonthEnd,
      FinCndnCalcDteWrkgDayShft,
      FinCndnCalcDteShftDrctn,
      FinCndnCalcDteShftNrOfDays,
      InterestCalculationDateRef,
      FinCndnDueDteUpdateRule,
      FinCndnDueDteFrequency,
      FinCndnDueDteFrqcyUnit,
      DueDate,
      DueDteIsRegularWithVarblDte,
      DueDateIsAsEndDateInclusive,
      DueDateIsAsEndDateMonthEnd,
      FinCndnDueDteWrkgDayShft,
      FinCndnDueDteShftDrctn,
      FinCndnDueDteShftNrOfDays,
      InterestDueDateReference,
      FinCndnDueDteShiftToTermEnd,
      FinCndnPaytDateWrkgDayShft,
      AverageIntrstRateWeightingCat,
      AverageIntrstRateRndngCategory,
      AverageIntrstRateRndngDecimals,
      AverageInterestRateSpreadValue,
      AvgIntrstRateHasUsedUpperLimit,
      AverageInterestUpperLimitRate,
      AvgIntrstRateHasUsedLowerLimit,
      AverageInterestLowerLimitRate,
      AverageIntrstRateResetCalcEvt,
      FinCndnRateFactorRndngCategory,
      FinCndnRateFactorRndngDecimals,
      FinCndnFactorRoundingCategory,
      FinCndnFactorRoundingDecimals,
      FinCndnBaseFactorRndngCategory,
      FinCndnBaseFactorRndngDecimals,
      FinCndnAmountRoundingCategory,
      FinCndnAmountRoundingUnit,
      @Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
      RndngBaseUntAmtInCndnItmCrcy,
      @Semantics.amount.currencyCode: 'FinancialConditionItemCurrency'
      FinCndnCalcBaseAmt,
      FinCndnCalcBaseReference,
      FinCndnProcessingSequenceValue,
      FinCndnAmountTimeUnit,
      FinCndnItmHasUsedLowerLimitAmt,
      @Semantics.amount.currencyCode: 'FinCndnLimitAmountCurrency'
      FinCndnItemLowerLimitAmount,
      FinCndnItmHasUsedUpperLimitAmt,
      @Semantics.amount.currencyCode: 'FinCndnLimitAmountCurrency'
      FinCndnItemUpperLimitAmount,
      FinCndnLimitAmountCurrency,
      FinCndnCrsRefcdAccmlnCndnGrp,

      _Scale,
      _SingleDate,
      _FormulaVariable,
      @Consumption.hidden: true
      _FinTrans
}
where
  FinancialInstrProductCategory = '550'