P_RecnclnCashFlowBasic

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MIXED
define view entity P_RecnclnCashFlowBasic
  as select from I_CashPositionFlow as one_exposure
{ --I_CashPositionFlow P_CashFlowCombn
  key one_exposure.ValidFrom,
  key one_exposure.OriginSystem,
  key one_exposure.OriginApplication,
  key one_exposure.OriginDocument,
  key one_exposure.OriginTransaction,
  key one_exposure.OriginTransactionQualifier,
  key one_exposure.CashFlow,

      one_exposure.ExpirationDate,

      one_exposure.TransactionDate,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      one_exposure.AmountInTransactionCurrency,
      one_exposure.TransactionCurrency,
      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      one_exposure.AmountInCompanyCodeCurrency,
      one_exposure.CompanyCodeCurrency,
      one_exposure.DocumentItemText,
      one_exposure.BankAccountInternalID,
      one_exposure.CompanyCode,
      one_exposure.PlanningLevel,
      one_exposure.LiquidityItem,
      one_exposure.CertaintyLevel,
      one_exposure.AccountingDocument,
      one_exposure.AccountingDocumentItem,
      one_exposure.AccountingDocumentType,
      one_exposure.FinancialAccountType,
      one_exposure.Customer,
      one_exposure.Supplier,
      cast( BankStatementItem as farp_esnum )                                                as BankStatementItem,
      BankStatementShortID,
      cast(case when one_exposure.CertaintyLevel = 'INTRAM' or one_exposure.CertaintyLevel = 'MEMO' or  one_exposure.CertaintyLevel = 'RFC'
      then  lpad(substring(one_exposure.OriginDocument,1,10),10,'0') end as fclm_mr_doc_id ) as MemoRecord
}
where
  (
           one_exposure.CertaintyLevel               =  'INTRAM'
    or     one_exposure.CertaintyLevel               =  'REC_N'
    or     one_exposure.CertaintyLevel               =  'PAY_N'
    or     one_exposure.CertaintyLevel               =  'SI_CIT'
    or     one_exposure.CertaintyLevel               =  'CMIDOC'
    or     one_exposure.CertaintyLevel               =  'MEMO'
    or     one_exposure.CertaintyLevel               =  'RFC'
    or(
           one_exposure.CertaintyLevel               =  'ACTUAL'
      and  one_exposure.OriginApplication            =  'BS'
    )
  )
  and(
           one_exposure.MemoRecordExpirationDateTime is initial
    or     one_exposure.MemoRecordExpirationDateTime >= tstmp_current_utctimestamp( )
  )
  and      one_exposure.IsValid                      =  'X'
  and(
           one_exposure.NetDueDate                   =  '00000000'
    or(
           one_exposure.CertaintyLevel               <> 'INTRAM'
      and  one_exposure.CertaintyLevel               <> 'MEMO'
    )
    or(
      (
           one_exposure.CertaintyLevel               =  'INTRAM'
        or one_exposure.CertaintyLevel               =  'MEMO'
      )
      and  one_exposure.NetDueDate                   >= $session.user_date
    )
  )