I_TreasuryPositionHistory

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_TreasuryPositionHistory.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- Parameters: P_KeyDate : vdm_v_key_date, P_TreasuryPositionPeriod : ftr_pos_hist_period, P_DisplayCurrency : vdm_v_display_currency, P_ExchangeRateType : kurst

CREATE VIEW I_TreasuryPositionHistory AS
SELECT
  I_Ftr_Position_Values.TreasuryValuationArea AS TreasuryValuationArea,
  I_Ftr_Position_Values.TreasuryValuationClass AS TreasuryValuationClass,
  I_Ftr_Position_Values.CompanyCode AS CompanyCode,
  I_Ftr_Position_Values.SecurityAccount AS SecurityAccount,
  I_Ftr_Position_Values.SecurityClass AS SecurityClass,
  I_Ftr_Position_Values.TreasuryPositionAccount AS TreasuryPositionAccount,
  I_Ftr_Position_Values.TreasuryPositionLot AS TreasuryPositionLot,
  I_Ftr_Position_Values.FinancialTransaction AS FinancialTransaction,
  I_Ftr_Position_Values.FinancialExposureItem AS FinancialExposureItem,
  I_Ftr_Position_Values.FinancialExposureSubItem AS FinancialExposureSubItem,
  I_Ftr_Position_Values.FinancialInstrValuationClass AS FinancialInstrValuationClass,
  I_Ftr_Position_Values.DifferentiationPortfolio AS DifferentiationPortfolio,
  I_Ftr_Position_Values.SecurityAccountGroup AS SecurityAccountGroup,
  I_Ftr_Position_Values.LoanContract AS LoanContract,
  I_Ftr_Position_Values.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  I_Ftr_Position_Values.CentralClearingAccount AS CentralClearingAccount,
  I_Ftr_Position_Values.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  I_Ftr_Position_Values.CentralClearingAccountCurrency AS CentralClearingAccountCurrency,
  I_Ftr_Position_Values.Trader AS Trader,
  I_Ftr_Position_Values.Fund AS Fund,
  I_Ftr_Position_Values.GrantID AS GrantID,
  I_Ftr_Position_Values.TreasuryAccountingCode AS TreasuryAccountingCode,
  I_Ftr_Position_Values.TreasuryPositionZeroDate AS TreasuryPositionZeroDate,
  I_Ftr_Position_Values.TreasuryPosAssetLiabilityCode AS TreasuryPosAssetLiabilityCode,
  I_Ftr_Position_Values.TrsyPosManagementProcedure AS TrsyPosManagementProcedure,
  P_TreasuryHistPeriod.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
  P_TreasuryHistPeriod.TreasuryPositionLedgerDateText AS TreasuryPositionLedgerDateText,
  I_Ftr_Position_Values.PostingDate AS PostingDate,
  I_Ftr_Position_Values.TreasuryPosition AS TreasuryPosition,
  I_Ftr_Position_Values.TrsySubPosition AS TrsySubPosition,
  I_Ftr_Position_Values.TrsyPosQuantityChangeCategory AS TrsyPosQuantityChangeCategory,
  I_Ftr_Position_Values.TrsyPosAmountChangeCategory AS TrsyPosAmountChangeCategory,
  I_Ftr_Position_Values.TreasuryBusinessTransStatus AS TreasuryBusinessTransStatus,
  I_Ftr_Position_Values.TrsyPosValuationStepProcedure AS TrsyPosValuationStepProcedure,
  I_Ftr_Position_Values.CommitmentBusinessPartner AS CommitmentBusinessPartner,
  I_Ftr_Position_Values.TrsyDerivedBusinessTransStatus AS TrsyDerivedBusinessTransStatus,
  I_Ftr_Position_Values.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  I_Ftr_Position_Values.TreasuryUpdateType AS TreasuryUpdateType,
  I_Ftr_Position_Values.PositionCurrency AS PositionCurrency,
  I_Ftr_Position_Values.ValuationCurrency AS ValuationCurrency,
  I_Ftr_Position_Values.WBSElementExternalID AS WBSElementExternalID,
  I_Ftr_Position_Values.FunctionalArea AS FunctionalArea,
  I_Ftr_Position_Values.CostCenter AS CostCenter,
  I_Ftr_Position_Values.ProfitCenter AS ProfitCenter,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  _TrsyPosCustomDiffntnTerm1._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm1Name AS TrsyPosCustomDiffntnTerm1Name,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  _TrsyPosCustomDiffntnTerm2._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm2Name AS TrsyPosCustomDiffntnTerm2Name,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  _TrsyPosCustomDiffntnTerm3._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm3Name AS TrsyPosCustomDiffntnTerm3Name,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  _TrsyPosCustomDiffntnTerm4._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm4Name AS TrsyPosCustomDiffntnTerm4Name,
  I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  _TrsyPosCustomDiffntnTerm5._Text[1:Language = $session.system_language].TrsyPosCustomDiffntnTerm5Name AS TrsyPosCustomDiffntnTerm5Name,
  cast($parameters.P_DisplayCurrency as vdm_v_display_currency preserving type) AS DisplayCurrency,
  $parameters.P_ExchangeRateType AS ExchangeRateType,
  $parameters.P_TreasuryPositionPeriod AS TreasuryPositionPeriod,
  I_Ftr_Position_Values.NominalCurrency AS NominalCurrency,
  case when I_Ftr_Position_Values._TreasurySubPosition.DesignatedNominalCurrency is null then I_Ftr_Position_Values.NominalCurrency else I_Ftr_Position_Values._TreasurySubPosition.DesignatedNominalCurrency end AS DesignatedNominalCurrency,
  I_Ftr_Position_Values.QuantityInPieces AS QuantityInPieces,
  I_Ftr_Position_Values.NominalAmountInNominalCurrency AS NominalAmountInNominalCurrency,
  I_Ftr_Position_Values.OriglNominalAmtInNominalCrcy AS OriglNominalAmtInNominalCrcy,
  I_Ftr_Position_Values.PurchaseValueInPositionCrcy AS PurchaseValueInPositionCrcy,
  I_Ftr_Position_Values.PurchaseValueInValuationCrcy AS PurchaseValueInValuationCrcy,
  I_Ftr_Position_Values.SecurityValuationAmtInPosCrcy AS SecurityValuationAmtInPosCrcy,
  I_Ftr_Position_Values.SecurityValuationAmtInValnCrcy AS SecurityValuationAmtInValnCrcy,
  I_Ftr_Position_Values.ForeignCrcyValnAmtInValnCrcy AS ForeignCrcyValnAmtInValnCrcy,
  I_Ftr_Position_Values.CostInPositionCurrency AS CostInPositionCurrency,
  I_Ftr_Position_Values.CostInValuationCurrency AS CostInValuationCurrency,
  I_Ftr_Position_Values.SecurityCostValnAmtInPosCrcy AS SecurityCostValnAmtInPosCrcy,
  I_Ftr_Position_Values.SecurityCostValnAmtInValnCrcy AS SecurityCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchCostValnAmtInValnCrcy AS FrgnExchCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.AmortizationAmtInPositionCrcy AS AmortizationAmtInPositionCrcy,
  I_Ftr_Position_Values.AmortizationAmtInValuationCrcy AS AmortizationAmtInValuationCrcy,
  I_Ftr_Position_Values.ClrdPremDiscDefrlTxCompnAmount AS ClrdPremDiscDefrlTxCompnAmount,
  I_Ftr_Position_Values.ClrdPremDiscDefrlAmtInValnCrcy AS ClrdPremDiscDefrlAmtInValnCrcy,
  I_Ftr_Position_Values.PurValDeferralItmAmtInPosCrcy AS PurValDeferralItmAmtInPosCrcy,
  I_Ftr_Position_Values.PurValDeferralItmAmtInValnCrcy AS PurValDeferralItmAmtInValnCrcy,
  I_Ftr_Position_Values.FXValnAmtzdAcqnAmtInValnCrcy AS FXValnAmtzdAcqnAmtInValnCrcy,
  I_Ftr_Position_Values.VariationMarginAmountInPosCrcy AS VariationMarginAmountInPosCrcy,
  I_Ftr_Position_Values.VariationMarginAmtInValnCrcy AS VariationMarginAmtInValnCrcy,
  I_Ftr_Position_Values.OCISecurityValnAmountInPosCrcy AS OCISecurityValnAmountInPosCrcy,
  I_Ftr_Position_Values.OCIScrtyValnAmountInValnCrcy AS OCIScrtyValnAmountInValnCrcy,
  I_Ftr_Position_Values.OCIFrgnExchValnAmtInValnCrcy AS OCIFrgnExchValnAmtInValnCrcy,
  I_Ftr_Position_Values.OCIScrtyCostValnAmtInPosCrcy AS OCIScrtyCostValnAmtInPosCrcy,
  I_Ftr_Position_Values.OCIScrtyCostValnAmtInValnCrcy AS OCIScrtyCostValnAmtInValnCrcy,
  I_Ftr_Position_Values.OCICostFXValnAmountInValnCrcy AS OCICostFXValnAmountInValnCrcy,
  I_Ftr_Position_Values.InterestIncomeInPositionCrcy AS InterestIncomeInPositionCrcy,
  I_Ftr_Position_Values.InterestIncomeInValuationCrcy AS InterestIncomeInValuationCrcy,
  I_Ftr_Position_Values.AccruedInterestInPositionCrcy AS AccruedInterestInPositionCrcy,
  I_Ftr_Position_Values.AccruedInterestInValuationCrcy AS AccruedInterestInValuationCrcy,
  I_Ftr_Position_Values.NegttnSpreadAmtznAmtInPosCrcy AS NegttnSpreadAmtznAmtInPosCrcy,
  I_Ftr_Position_Values.NegttnSpreadAmtznAmtInValnCrcy AS NegttnSpreadAmtznAmtInValnCrcy,
  I_Ftr_Position_Values.CumltvRepaymentAmountInPosCrcy AS CumltvRepaymentAmountInPosCrcy,
  I_Ftr_Position_Values.CumltvRepaymentAmtInValnCrcy AS CumltvRepaymentAmtInValnCrcy,
  I_Ftr_Position_Values.PurCrcySpotValnAmtInValnCrcy AS PurCrcySpotValnAmtInValnCrcy,
  I_Ftr_Position_Values.SaleCrcySpotValnAmtInValnCrcy AS SaleCrcySpotValnAmtInValnCrcy,
  I_Ftr_Position_Values.SwapAccrualAmountInPosCurrency AS SwapAccrualAmountInPosCurrency,
  I_Ftr_Position_Values.SwapAccrualAmountInValnCrcy AS SwapAccrualAmountInValnCrcy,
  I_Ftr_Position_Values.SwapValuationAmountInValnCrcy AS SwapValuationAmountInValnCrcy,
  I_Ftr_Position_Values.ImpairmentAmountInPositionCrcy AS ImpairmentAmountInPositionCrcy,
  I_Ftr_Position_Values.ImpairmentAmtInValuationCrcy AS ImpairmentAmtInValuationCrcy,
  I_Ftr_Position_Values.ForeignExchImprmtAmtInValnCrcy AS ForeignExchImprmtAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchValnDiffAmtInValnCrcy AS FrgnExchValnDiffAmtInValnCrcy,
  I_Ftr_Position_Values.CapitalizationRsrvInPosCrcy AS CapitalizationRsrvInPosCrcy,
  I_Ftr_Position_Values.CapitalizationRsrvInValnCrcy AS CapitalizationRsrvInValnCrcy,
  I_Ftr_Position_Values.SecurityWriteUpAmountInPosCrcy AS SecurityWriteUpAmountInPosCrcy,
  I_Ftr_Position_Values.SecurityWriteUpAmtInValnCrcy AS SecurityWriteUpAmtInValnCrcy,
  I_Ftr_Position_Values.SecurityWriteDownAmtInPosCrcy AS SecurityWriteDownAmtInPosCrcy,
  I_Ftr_Position_Values.ScrtyWriteDownAmtInValnCrcy AS ScrtyWriteDownAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchWriteUpAmtInValnCrcy AS FrgnExchWriteUpAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchWriteDownAmtInValnCrcy AS FrgnExchWriteDownAmtInValnCrcy,
  I_Ftr_Position_Values.ScrtyCostWriteUpAmtInPosCrcy AS ScrtyCostWriteUpAmtInPosCrcy,
  I_Ftr_Position_Values.ScrtyCostWriteUpAmtInValnCrcy AS ScrtyCostWriteUpAmtInValnCrcy,
  I_Ftr_Position_Values.ScrtyCostWriteDownAmtInPosCrcy AS ScrtyCostWriteDownAmtInPosCrcy,
  I_Ftr_Position_Values.ScrtyCostWrtDownAmtInValnCrcy AS ScrtyCostWrtDownAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchCostWrtUpAmtInValnCrcy AS FrgnExchCostWrtUpAmtInValnCrcy,
  I_Ftr_Position_Values.FXCostWriteDownAmtInValnCrcy AS FXCostWriteDownAmtInValnCrcy,
  I_Ftr_Position_Values.DesignatedQuantityInPieces AS DesignatedQuantityInPieces,
  I_Ftr_Position_Values.DesignatedAmountInNominalCrcy AS DesignatedAmountInNominalCrcy,
  I_Ftr_Position_Values.DesignatedOrigAmtInNominalCrcy AS DesignatedOrigAmtInNominalCrcy,
  I_Ftr_Position_Values.HedgeAmortizationAmtInPosCrcy AS HedgeAmortizationAmtInPosCrcy,
  I_Ftr_Position_Values.HedgeAmortizationAmtInValnCrcy AS HedgeAmortizationAmtInValnCrcy,
  I_Ftr_Position_Values.GainValueAdjmtAmountInPosCrcy AS GainValueAdjmtAmountInPosCrcy,
  I_Ftr_Position_Values.GainValueAdjmtAmountInValnCrcy AS GainValueAdjmtAmountInValnCrcy,
  I_Ftr_Position_Values.LossValueAdjmtAmountInPosCrcy AS LossValueAdjmtAmountInPosCrcy,
  I_Ftr_Position_Values.LossValueAdjmtAmountInValnCrcy AS LossValueAdjmtAmountInValnCrcy,
  I_Ftr_Position_Values.OriginalValueAdjmtAmtInPosCrcy AS OriginalValueAdjmtAmtInPosCrcy,
  I_Ftr_Position_Values.OriginalValAdjmtAmtInValnCrcy AS OriginalValAdjmtAmtInValnCrcy,
  I_Ftr_Position_Values.TrsyClsfctnAmtInPosCrcy AS TrsyClsfctnAmtInPosCrcy,
  I_Ftr_Position_Values.TrsyClsfctnAmtInValnCrcy AS TrsyClsfctnAmtInValnCrcy,
  I_Ftr_Position_Values.EffctvAmtInPosCrcy AS EffctvAmtInPosCrcy,
  I_Ftr_Position_Values.EffctvAmtInValnCrcy AS EffctvAmtInValnCrcy,
  I_Ftr_Position_Values.IneffctvAmtInPosCrcy AS IneffctvAmtInPosCrcy,
  I_Ftr_Position_Values.IneffctvAmtInValnCrcy AS IneffctvAmtInValnCrcy,
  I_Ftr_Position_Values.EffctvCostHdggRsrvInPosCrcy AS EffctvCostHdggRsrvInPosCrcy,
  I_Ftr_Position_Values.EffctvCostHdggRsrvInValnCrcy AS EffctvCostHdggRsrvInValnCrcy,
  I_Ftr_Position_Values.IneffctvHdggRsrvPnLInPosCrcy AS IneffctvHdggRsrvPnLInPosCrcy,
  I_Ftr_Position_Values.IneffctvHdggRsrvPnLInValnCrcy AS IneffctvHdggRsrvPnLInValnCrcy,
  I_Ftr_Position_Values.EffctvHdggRsrvPnLInPosCrcy AS EffctvHdggRsrvPnLInPosCrcy,
  I_Ftr_Position_Values.EffctvHdggRsrvPnLInValnCrcy AS EffctvHdggRsrvPnLInValnCrcy,
  I_Ftr_Position_Values.IneffctvCostHdgRsrvPnLPosCrcy AS IneffctvCostHdgRsrvPnLPosCrcy,
  I_Ftr_Position_Values.IneffctvCostHdgRsrvPnLValnCrcy AS IneffctvCostHdgRsrvPnLValnCrcy,
  I_Ftr_Position_Values.EffctvCostHdgRsrvPnLInPosCrcy AS EffctvCostHdgRsrvPnLInPosCrcy,
  I_Ftr_Position_Values.EffctvCostHdgRsrvPnLInValnCrcy AS EffctvCostHdgRsrvPnLInValnCrcy,
  I_Ftr_Position_Values.PnLDesignatedAmtInPosCrcy AS PnLDesignatedAmtInPosCrcy,
  I_Ftr_Position_Values.PnLDesignatedAmtInVC AS PnLDesignatedAmtInVC,
  I_Ftr_Position_Values.PnLNonDesignatedAmtInPosCrcy AS PnLNonDesignatedAmtInPosCrcy,
  I_Ftr_Position_Values.PnLNonDesignatedAmtInVC AS PnLNonDesignatedAmtInVC,
  I_Ftr_Position_Values.AmtznNonDesignatedAmtInPosCrcy AS AmtznNonDesignatedAmtInPosCrcy,
  I_Ftr_Position_Values.AmtznNonDesignatedAmtInVC AS AmtznNonDesignatedAmtInVC,
  I_Ftr_Position_Values.CnsldtdScrtyGainAmtInPosCrcy AS CnsldtdScrtyGainAmtInPosCrcy,
  I_Ftr_Position_Values.CnsldtdScrtyGainAmtInValnCrcy AS CnsldtdScrtyGainAmtInValnCrcy,
  I_Ftr_Position_Values.CnsldtdScrtyLossAmtInPosCrcy AS CnsldtdScrtyLossAmtInPosCrcy,
  I_Ftr_Position_Values.CnsldtdScrtyLossAmtInValnCrcy AS CnsldtdScrtyLossAmtInValnCrcy,
  I_Ftr_Position_Values.CnsldtdForExGainAmtInValnCrcy AS CnsldtdForExGainAmtInValnCrcy,
  I_Ftr_Position_Values.CnsldtdForExLossAmtInValnCrcy AS CnsldtdForExLossAmtInValnCrcy,
  I_Ftr_Position_Values.LossAllowanceAmountInValnCrcy AS LossAllowanceAmountInValnCrcy,
  I_Ftr_Position_Values.FXLossAllowanceAmtInValnCrcy AS FXLossAllowanceAmtInValnCrcy,
  I_Ftr_Position_Values.OffstLossAllowanceAmtInPosCrcy AS OffstLossAllowanceAmtInPosCrcy,
  I_Ftr_Position_Values.OffsetLossAllwncAmtInValnCrcy AS OffsetLossAllwncAmtInValnCrcy,
  I_Ftr_Position_Values.OCIOffstLossAllwncAmtInPosCrcy AS OCIOffstLossAllwncAmtInPosCrcy,
  I_Ftr_Position_Values.OCIOffstLossAllwncInValnCrcy AS OCIOffstLossAllwncInValnCrcy,
  I_Ftr_Position_Values.FXOffstLossAllwncAmtInValnCrcy AS FXOffstLossAllwncAmtInValnCrcy,
  I_Ftr_Position_Values.FXOffstOCILossAllwncInValnCrcy AS FXOffstOCILossAllwncInValnCrcy,
  I_Ftr_Position_Values.AmtznAdjmtLossAllwncInPosCrcy AS AmtznAdjmtLossAllwncInPosCrcy,
  I_Ftr_Position_Values.AmtznAdjmtLossAllwncInValnCrcy AS AmtznAdjmtLossAllwncInValnCrcy,
  I_Ftr_Position_Values.ContractChangeAmtInPosCrcy AS ContractChangeAmtInPosCrcy,
  I_Ftr_Position_Values.ContractChangeAmtInValnCrcy AS ContractChangeAmtInValnCrcy,
  I_Ftr_Position_Values.FrgnExchContrChgAmtInValnCrcy AS FrgnExchContrChgAmtInValnCrcy,
  I_Ftr_Position_Values.FXAmtznAdjLossAllwncInValnCrcy AS FXAmtznAdjLossAllwncInValnCrcy,
  I_Ftr_Position_Values.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency,
  I_Ftr_Position_Values.BookValueAmountInValnCurrency AS BookValueAmountInValnCurrency,
  I_Ftr_Position_Values.AcquisitionAmtInPositionCrcy AS AcquisitionAmtInPositionCrcy,
  I_Ftr_Position_Values.AcquisitionAmountInValnCrcy AS AcquisitionAmountInValnCrcy,
  I_Ftr_Position_Values.AmortizedAcqnAmountInPosCrcy AS AmortizedAcqnAmountInPosCrcy,
  I_Ftr_Position_Values.AmortizedAcqnAmountInValnCrcy AS AmortizedAcqnAmountInValnCrcy,
  I_Ftr_Position_Values.AmortizedCostInPositionCrcy AS AmortizedCostInPositionCrcy,
  I_Ftr_Position_Values.AmortizedCostInValuationCrcy AS AmortizedCostInValuationCrcy,
  I_Ftr_Position_Values._CentralClearingAccount AS _CentralClearingAccount,
  I_Ftr_Position_Values._CompanyCode AS _CompanyCode,
  I_Ftr_Position_Values._DifferentiationPortfolioText AS _DifferentiationPortfolioText,
  I_Ftr_Position_Values._FinancialInstrProdTypeText AS _FinancialInstrProdTypeText,
  I_Ftr_Position_Values._FinancialInstrProdType AS _FinancialInstrProdType,
  I_Ftr_Position_Values._FinancialInstrValClassText AS _FinancialInstrValClassText,
  I_Ftr_Position_Values._LoanContract AS _LoanContract,
  I_Ftr_Position_Values._SecurityAccount AS _SecurityAccount,
  I_Ftr_Position_Values._SecurityAccountGroup AS _SecurityAccountGroup,
  I_Ftr_Position_Values._SecurityClass AS _SecurityClass,
  I_Ftr_Position_Values._TreasuryPositionAccount AS _TreasuryPositionAccount,
  I_Ftr_Position_Values._TreasuryValuationArea AS _TreasuryValuationArea,
  I_Ftr_Position_Values._TreasuryValuationClassText AS _TreasuryValuationClassText,
  I_Ftr_Position_Values._TrsyLdgrGLAcctAssgmtRef AS _TrsyLdgrGLAcctAssgmtRef,
  I_Ftr_Position_Values._TreasurySubPosition AS _TreasurySubPosition
FROM P_TreasuryHistPeriod
INNER JOIN I_Ftr_Position_Values ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeRateTypeVH ON ExchangeRateType = _ExchangeRateTypeVH.ExchangeRateType  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_TreasuryPositionPeriodVH AS _TreasuryPositionPeriodVH ON TreasuryPositionPeriod = _TreasuryPositionPeriodVH.TreasuryPositionPeriod  -- association [1..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm1 AS _TrsyPosCustomDiffntnTerm1 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm1 = _TrsyPosCustomDiffntnTerm1.TrsyPosCustomDiffntnTerm1  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm2 AS _TrsyPosCustomDiffntnTerm2 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm2 = _TrsyPosCustomDiffntnTerm2.TrsyPosCustomDiffntnTerm2  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm3 AS _TrsyPosCustomDiffntnTerm3 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm3 = _TrsyPosCustomDiffntnTerm3.TrsyPosCustomDiffntnTerm3  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm4 AS _TrsyPosCustomDiffntnTerm4 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm4 = _TrsyPosCustomDiffntnTerm4.TrsyPosCustomDiffntnTerm4  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosCustomDiffntnTerm5 AS _TrsyPosCustomDiffntnTerm5 ON I_Ftr_Position_Values.TrsyPosCustomDiffntnTerm5 = _TrsyPosCustomDiffntnTerm5.TrsyPosCustomDiffntnTerm5  -- association [0..1]
;