I_Ftr_Atpv_Cube

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_Ftr_Atpv_Cube.
-- 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.
-- SQL view name: IPOSVALCUBE
-- Parameters: P_KeyDate : vdm_v_key_date, P_TrsyPosPlndDataIsInclusive : ftr_atpv_planned_data

CREATE VIEW I_Ftr_Atpv_Cube AS
SELECT
  I_Ftr_Atpv_Logic.TreasuryValuationArea AS TreasuryValuationArea,
  I_Ftr_Atpv_Logic.TreasuryValuationClass AS TreasuryValuationClass,
  I_Ftr_Atpv_Logic.CompanyCode AS CompanyCode,
  I_Ftr_Atpv_Logic.SecurityAccount AS SecurityAccount,
  I_Ftr_Atpv_Logic.SecurityClass AS SecurityClass,
  I_Ftr_Atpv_Logic.LoanContract AS LoanContract,
  I_Ftr_Atpv_Logic.TreasuryPositionLongShortCode AS TreasuryPositionLongShortCode,
  I_Ftr_Atpv_Logic.FinancialTransaction AS FinancialTransaction,
  I_Ftr_Atpv_Logic.FinancialInstrumentProductType AS FinancialInstrumentProductType,
  I_Ftr_Atpv_Logic.TreasuryPositionAccount AS TreasuryPositionAccount,
  I_Ftr_Atpv_Logic.FinInstrProductGroup AS FinInstrProductGroup,
  I_Ftr_Atpv_Logic.TreasuryGLAccountAssignmentRef AS TreasuryGLAccountAssignmentRef,
  I_Ftr_Atpv_Logic.TreasuryPositionLot AS TreasuryPositionLot,
  I_Ftr_Atpv_Logic.CentralClearingAccount AS CentralClearingAccount,
  I_Ftr_Atpv_Logic.CentralClearingAccountCurrency AS CentralClearingAccountCurrency,
  I_Ftr_Atpv_Logic.TrsyPosManagementProcedure AS TrsyPosManagementProcedure,
  I_Ftr_Atpv_Logic.TreasuryPosition AS TreasuryPosition,
  _PositionIdentifier.Fund AS Fund,
  _PositionIdentifier.GrantID AS GrantID,
  _PositionIdentifier.WBSElementInternalID AS WBSElementInternalID,
  _PositionIdentifier.ProfitCenter AS ProfitCenter,
  _PositionIdentifier.CostCenter AS CostCenter,
  _PositionIdentifier.FunctionalArea AS FunctionalArea,
  _PositionIdentifier.TrsyPosCustomDiffntnTerm1 AS TrsyPosCustomDiffntnTerm1,
  _PositionIdentifier.TrsyPosCustomDiffntnTerm2 AS TrsyPosCustomDiffntnTerm2,
  _PositionIdentifier.TrsyPosCustomDiffntnTerm3 AS TrsyPosCustomDiffntnTerm3,
  _PositionIdentifier.TrsyPosCustomDiffntnTerm4 AS TrsyPosCustomDiffntnTerm4,
  _PositionIdentifier.TrsyPosCustomDiffntnTerm5 AS TrsyPosCustomDiffntnTerm5,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute1 AS TrsyPosFreeDefinedAttribute1,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute2 AS TrsyPosFreeDefinedAttribute2,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute3 AS TrsyPosFreeDefinedAttribute3,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute4 AS TrsyPosFreeDefinedAttribute4,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute5 AS TrsyPosFreeDefinedAttribute5,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute6 AS TrsyPosFreeDefinedAttribute6,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute7 AS TrsyPosFreeDefinedAttribute7,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute8 AS TrsyPosFreeDefinedAttribute8,
  _TrltPosattrib.TrsyPosFreeDefinedAttribute9 AS TrsyPosFreeDefinedAttribute9,
  _SecurityClass.Issuer AS Issuer,
  _FinancialTransaction.Counterparty AS Counterparty,
  _FinancialTransaction.BusinessArea AS BusinessArea,
  I_Ftr_Atpv_Logic.TreasuryPositionLedgerDate AS TreasuryPositionLedgerDate,
  I_Ftr_Atpv_Logic.TreasuryBusinessTransCategory AS TreasuryBusinessTransCategory,
  I_Ftr_Atpv_Logic.TreasuryUpdateType AS TreasuryUpdateType,
  _FinancialTransaction.FinancialInstrTransactionType AS FinancialInstrTransactionType,
  I_Ftr_Atpv_Logic.PositionCurrency AS PositionCurrency,
  I_Ftr_Atpv_Logic.ValuationCurrency AS ValuationCurrency,
  I_Ftr_Atpv_Logic.NominalCurrency AS NominalCurrency,
  I_Ftr_Atpv_Logic.BookValueAmountInValnCurrency AS BookValueAmountInValnCurrency,
  I_Ftr_Atpv_Logic.BookValueAmtInPositionCurrency AS BookValueAmtInPositionCurrency,
  I_Ftr_Atpv_Logic.NominalAmountInNominalCurrency AS NominalAmountInNominalCurrency,
  I_Ftr_Atpv_Logic.OriglNominalAmtInNominalCrcy AS OriglNominalAmtInNominalCrcy,
  I_Ftr_Atpv_Logic.PurchaseValueInValuationCrcy AS PurchaseValueInValuationCrcy,
  I_Ftr_Atpv_Logic.PurchaseValueInPositionCrcy AS PurchaseValueInPositionCrcy,
  I_Ftr_Atpv_Logic.OCIScrtyValnAmountInValnCrcy AS OCIScrtyValnAmountInValnCrcy,
  I_Ftr_Atpv_Logic.OCISecurityValnAmountInPosCrcy AS OCISecurityValnAmountInPosCrcy,
  I_Ftr_Atpv_Logic.IdxClnOCIScrtyValnAmtInPosCrcy AS IdxClnOCIScrtyValnAmtInPosCrcy,
  I_Ftr_Atpv_Logic.ForeignCrcyValnAmtInValnCrcy AS ForeignCrcyValnAmtInValnCrcy,
  I_Ftr_Atpv_Logic.CostExcldBookValAmtInValnCrcy AS CostExcldBookValAmtInValnCrcy,
  I_Ftr_Atpv_Logic.CostInPositionCurrency AS CostInPositionCurrency,
  I_Ftr_Atpv_Logic.SecurityCostValnAmtInValnCrcy AS SecurityCostValnAmtInValnCrcy,
  I_Ftr_Atpv_Logic.SecurityCostValnAmtInPosCrcy AS SecurityCostValnAmtInPosCrcy,
  I_Ftr_Atpv_Logic.FrgnExchCostValnAmtInValnCrcy AS FrgnExchCostValnAmtInValnCrcy,
  I_Ftr_Atpv_Logic.AmortizationAmtInValuationCrcy AS AmortizationAmtInValuationCrcy,
  I_Ftr_Atpv_Logic.AmortizationAmtInPositionCrcy AS AmortizationAmtInPositionCrcy,
  I_Ftr_Atpv_Logic.ClrdPremDiscDefrlAmtInValnCrcy AS ClrdPremDiscDefrlAmtInValnCrcy,
  I_Ftr_Atpv_Logic.ClrdPremDiscDefrlTxCompnAmount AS ClrdPremDiscDefrlTxCompnAmount,
  I_Ftr_Atpv_Logic.IndexValuationAmountInValnCrcy AS IndexValuationAmountInValnCrcy,
  I_Ftr_Atpv_Logic.IndexValuationAmountInPosCrcy AS IndexValuationAmountInPosCrcy,
  I_Ftr_Atpv_Logic.FXValnAmtzdAcqnAmtInValnCrcy AS FXValnAmtzdAcqnAmtInValnCrcy,
  I_Ftr_Atpv_Logic.VariationMarginAmtInValnCrcy AS VariationMarginAmtInValnCrcy,
  I_Ftr_Atpv_Logic.VariationMarginAmountInPosCrcy AS VariationMarginAmountInPosCrcy,
  I_Ftr_Atpv_Logic.OCIFrgnExchValnAmtInValnCrcy AS OCIFrgnExchValnAmtInValnCrcy,
  I_Ftr_Atpv_Logic.OCIIndexValnAmountInValnCrcy AS OCIIndexValnAmountInValnCrcy,
  I_Ftr_Atpv_Logic.OCIIndexValnAmountInPosCrcy AS OCIIndexValnAmountInPosCrcy,
  I_Ftr_Atpv_Logic.OCIScrtyCostValnAmtInValnCrcy AS OCIScrtyCostValnAmtInValnCrcy,
  I_Ftr_Atpv_Logic.OCIScrtyCostValnAmtInPosCrcy AS OCIScrtyCostValnAmtInPosCrcy,
  I_Ftr_Atpv_Logic.OCICostFXValnAmountInValnCrcy AS OCICostFXValnAmountInValnCrcy,
  I_Ftr_Atpv_Logic.AccruedInterestInValuationCrcy AS AccruedInterestInValuationCrcy,
  I_Ftr_Atpv_Logic.AccruedInterestInPositionCrcy AS AccruedInterestInPositionCrcy,
  I_Ftr_Atpv_Logic.CostExcldBookValueAmtInPosCrcy AS CostExcldBookValueAmtInPosCrcy,
  I_Ftr_Atpv_Logic.AcquisitionAmountInValnCrcy AS AcquisitionAmountInValnCrcy,
  I_Ftr_Atpv_Logic.AcquisitionAmtInPositionCrcy AS AcquisitionAmtInPositionCrcy,
  I_Ftr_Atpv_Logic.AmortizedAcqnAmountInValnCrcy AS AmortizedAcqnAmountInValnCrcy,
  I_Ftr_Atpv_Logic.AmortizedAcqnAmountInPosCrcy AS AmortizedAcqnAmountInPosCrcy,
  I_Ftr_Atpv_Logic.QuantityInPieces AS QuantityInPieces,
  I_Ftr_Atpv_Logic.SecurityValuationAmtInValnCrcy AS SecurityValuationAmtInValnCrcy,
  I_Ftr_Atpv_Logic.SecurityValuationAmtInPosCrcy AS SecurityValuationAmtInPosCrcy,
  I_Ftr_Atpv_Logic.ClearingAmountInPositionCrcy AS ClearingAmountInPositionCrcy,
  I_Ftr_Atpv_Logic.ClearingAmountInValuationCrcy AS ClearingAmountInValuationCrcy,
  I_Ftr_Atpv_Logic.CostInValuationCurrency AS CostInValuationCurrency,
  I_Ftr_Atpv_Logic.PurValDeferralItmAmtInPosCrcy AS PurValDeferralItmAmtInPosCrcy,
  I_Ftr_Atpv_Logic.PurValDeferralItmAmtInValnCrcy AS PurValDeferralItmAmtInValnCrcy,
  I_Ftr_Atpv_Logic.NegttnSpreadAmtznAmtInPosCrcy AS NegttnSpreadAmtznAmtInPosCrcy,
  I_Ftr_Atpv_Logic.NegttnSpreadAmtznAmtInValnCrcy AS NegttnSpreadAmtznAmtInValnCrcy,
  I_Ftr_Atpv_Logic.CumltvRepaymentAmountInPosCrcy AS CumltvRepaymentAmountInPosCrcy,
  I_Ftr_Atpv_Logic.CumltvRepaymentAmtInValnCrcy AS CumltvRepaymentAmtInValnCrcy,
  I_Ftr_Atpv_Logic.PurCrcySpotValnAmtInValnCrcy AS PurCrcySpotValnAmtInValnCrcy,
  I_Ftr_Atpv_Logic.SaleCrcySpotValnAmtInValnCrcy AS SaleCrcySpotValnAmtInValnCrcy,
  I_Ftr_Atpv_Logic.SwapAccrualAmountInPosCurrency AS SwapAccrualAmountInPosCurrency,
  I_Ftr_Atpv_Logic.SwapAccrualAmountInValnCrcy AS SwapAccrualAmountInValnCrcy,
  I_Ftr_Atpv_Logic.SwapValuationAmountInValnCrcy AS SwapValuationAmountInValnCrcy,
  I_Ftr_Atpv_Logic.ImpairmentAmountInPositionCrcy AS ImpairmentAmountInPositionCrcy,
  I_Ftr_Atpv_Logic.ImpairmentAmtInValuationCrcy AS ImpairmentAmtInValuationCrcy,
  I_Ftr_Atpv_Logic.HedgeAmortizationAmtInPosCrcy AS HedgeAmortizationAmtInPosCrcy,
  I_Ftr_Atpv_Logic.HedgeAmortizationAmtInValnCrcy AS HedgeAmortizationAmtInValnCrcy,
  I_Ftr_Atpv_Logic.FrgnExchValnDiffAmtInValnCrcy AS FrgnExchValnDiffAmtInValnCrcy,
  I_Ftr_Atpv_Logic.GainValueAdjmtAmountInPosCrcy AS GainValueAdjmtAmountInPosCrcy,
  I_Ftr_Atpv_Logic.GainValueAdjmtAmountInValnCrcy AS GainValueAdjmtAmountInValnCrcy,
  I_Ftr_Atpv_Logic.LossValueAdjmtAmountInPosCrcy AS LossValueAdjmtAmountInPosCrcy,
  I_Ftr_Atpv_Logic.LossValueAdjmtAmountInValnCrcy AS LossValueAdjmtAmountInValnCrcy,
  I_Ftr_Atpv_Logic.OriginalValueAdjmtAmtInPosCrcy AS OriginalValueAdjmtAmtInPosCrcy,
  I_Ftr_Atpv_Logic.OriginalValAdjmtAmtInValnCrcy AS OriginalValAdjmtAmtInValnCrcy,
  I_Ftr_Atpv_Logic.CapitalizationRsrvInPosCrcy AS CapitalizationRsrvInPosCrcy,
  I_Ftr_Atpv_Logic.CapitalizationRsrvInValnCrcy AS CapitalizationRsrvInValnCrcy,
  I_Ftr_Atpv_Logic.ForeignExchImprmtAmtInValnCrcy AS ForeignExchImprmtAmtInValnCrcy,
  I_Ftr_Atpv_Logic.CnsldtdScrtyGainAmtInPosCrcy AS CnsldtdScrtyGainAmtInPosCrcy,
  I_Ftr_Atpv_Logic.CnsldtdScrtyGainAmtInValnCrcy AS CnsldtdScrtyGainAmtInValnCrcy,
  I_Ftr_Atpv_Logic.CnsldtdScrtyLossAmtInPosCrcy AS CnsldtdScrtyLossAmtInPosCrcy,
  I_Ftr_Atpv_Logic.CnsldtdScrtyLossAmtInValnCrcy AS CnsldtdScrtyLossAmtInValnCrcy,
  I_Ftr_Atpv_Logic.CnsldtdForExGainAmtInValnCrcy AS CnsldtdForExGainAmtInValnCrcy,
  I_Ftr_Atpv_Logic.CnsldtdForExLossAmtInValnCrcy AS CnsldtdForExLossAmtInValnCrcy,
  I_Ftr_Atpv_Logic.InterestIncomeInPositionCrcy AS InterestIncomeInPositionCrcy,
  I_Ftr_Atpv_Logic.InterestIncomeInValuationCrcy AS InterestIncomeInValuationCrcy,
  I_Ftr_Atpv_Logic.SecurityWriteUpAmountInPosCrcy AS SecurityWriteUpAmountInPosCrcy,
  I_Ftr_Atpv_Logic.SecurityWriteDownAmtInPosCrcy AS SecurityWriteDownAmtInPosCrcy,
  I_Ftr_Atpv_Logic.SecurityWriteUpAmtInValnCrcy AS SecurityWriteUpAmtInValnCrcy,
  I_Ftr_Atpv_Logic.ScrtyWriteDownAmtInValnCrcy AS ScrtyWriteDownAmtInValnCrcy,
  I_Ftr_Atpv_Logic.FrgnExchWriteUpAmtInValnCrcy AS FrgnExchWriteUpAmtInValnCrcy,
  I_Ftr_Atpv_Logic.FrgnExchWriteDownAmtInValnCrcy AS FrgnExchWriteDownAmtInValnCrcy,
  I_Ftr_Atpv_Logic.ScrtyCostWriteUpAmtInPosCrcy AS ScrtyCostWriteUpAmtInPosCrcy,
  I_Ftr_Atpv_Logic.ScrtyCostWriteDownAmtInPosCrcy AS ScrtyCostWriteDownAmtInPosCrcy,
  I_Ftr_Atpv_Logic.ScrtyCostWriteUpAmtInValnCrcy AS ScrtyCostWriteUpAmtInValnCrcy,
  I_Ftr_Atpv_Logic.ScrtyCostWrtDownAmtInValnCrcy AS ScrtyCostWrtDownAmtInValnCrcy,
  I_Ftr_Atpv_Logic.FrgnExchCostWrtUpAmtInValnCrcy AS FrgnExchCostWrtUpAmtInValnCrcy,
  I_Ftr_Atpv_Logic.FXCostWriteDownAmtInValnCrcy AS FXCostWriteDownAmtInValnCrcy,
  I_Ftr_Atpv_Logic.IndexWriteUpAmountInPosCrcy AS IndexWriteUpAmountInPosCrcy,
  I_Ftr_Atpv_Logic.IndexWriteDownAmountInPosCrcy AS IndexWriteDownAmountInPosCrcy,
  I_Ftr_Atpv_Logic.IndexWriteUpAmountInValnCrcy AS IndexWriteUpAmountInValnCrcy,
  I_Ftr_Atpv_Logic.IndexWriteDownAmtInValnCrcy AS IndexWriteDownAmtInValnCrcy,
  I_Ftr_Atpv_Logic.IndexCleanClearingAmtInPosCrcy AS IndexCleanClearingAmtInPosCrcy,
  I_Ftr_Atpv_Logic.IndexCleanPurchaseValInPosCrcy AS IndexCleanPurchaseValInPosCrcy,
  I_Ftr_Atpv_Logic.IdxCleanScrtyValnAmtInPosCrcy AS IdxCleanScrtyValnAmtInPosCrcy,
  I_Ftr_Atpv_Logic.IndexCleanCostInPositionCrcy AS IndexCleanCostInPositionCrcy,
  I_Ftr_Atpv_Logic.IndexClnScrtyCostValuationAmt AS IndexClnScrtyCostValuationAmt,
  I_Ftr_Atpv_Logic.IndexCleanAmtznAmountInPosCrcy AS IndexCleanAmtznAmountInPosCrcy,
  I_Ftr_Atpv_Logic.IdxClnClrdPremDiscDeferralAmt AS IdxClnClrdPremDiscDeferralAmt,
  I_Ftr_Atpv_Logic.IdxClnPurValDefrlAmtInPosCrcy AS IdxClnPurValDefrlAmtInPosCrcy,
  I_Ftr_Atpv_Logic.IdxClnOCIScrtyCostValuationAmt AS IdxClnOCIScrtyCostValuationAmt,
  I_Ftr_Atpv_Logic.IndexCleanNegttnAmtznInPosCrcy AS IndexCleanNegttnAmtznInPosCrcy,
  I_Ftr_Atpv_Logic.IndexCleanRpaytAmtInPosCrcy AS IndexCleanRpaytAmtInPosCrcy,
  I_Ftr_Atpv_Logic.IndexCleanInterestIncInPosCrcy AS IndexCleanInterestIncInPosCrcy,
  I_Ftr_Atpv_Logic.IdxCleanHedgeAmtznAmtInPosCrcy AS IdxCleanHedgeAmtznAmtInPosCrcy,
  I_Ftr_Atpv_Logic.IndexCleanImprmtAmtInPosCrcy AS IndexCleanImprmtAmtInPosCrcy,
  I_Ftr_Atpv_Logic.IndexClnBookValueAmtInPosCrcy AS IndexClnBookValueAmtInPosCrcy,
  I_Ftr_Atpv_Logic.IdxClnCostExcldBookValueAmount AS IdxClnCostExcldBookValueAmount,
  I_Ftr_Atpv_Logic.IndexCleanAcqnAmountInPosCrcy AS IndexCleanAcqnAmountInPosCrcy,
  I_Ftr_Atpv_Logic.IdxCleanAmtzdAcqnAmtInPosCrcy AS IdxCleanAmtzdAcqnAmtInPosCrcy,
  I_Ftr_Atpv_Logic.TreasuryAccountingCode AS TreasuryAccountingCode,
  TrsySubPosition,
  _TreasurySubPosition._HedgedItem.HedgedItem AS HedgedItem,
  _TreasurySubPosition._HedgedItem.HedgedItemFiscalYear AS HedgedItemFiscalYear,
  _TreasurySubPosition._HedgingInstrument.HedgingInstr AS HedgingInstr,
  _TreasurySubPosition._HedgingInstrument.HedgingInstrumentFiscalYear AS HedgingInstrumentFiscalYear,
  _TreasurySubPosition.IsFreestanding AS IsFreestanding,
  DesignatedNominalCurrency,
  DesignatedQuantityInPieces,
  DesignatedAmountInNominalCrcy,
  DesignatedOrigAmtInNominalCrcy
FROM I_Ftr_Atpv_Logic
LEFT OUTER JOIN I_TreasuryValuationArea AS _TreasuryValuationArea ON TreasuryValuationArea = _TreasuryValuationArea.TreasuryValuationArea  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CentralClearingAccount AS _CentralClearingAccount ON CompanyCode = _CentralClearingAccount.CompanyCode AND CentralClearingAccount = _CentralClearingAccount.CentralClearingAccount  -- association [0..1]
LEFT OUTER JOIN I_SecurityAccount AS _SecurityAccount ON SecurityAccount = _SecurityAccount.SecurityAccount AND CompanyCode = _SecurityAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialinstrProductType AS _ProductType ON FinancialInstrumentProductType = _ProductType.FinancialInstrumentProductType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _PositionCurrency ON PositionCurrency = _PositionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _ValuationCurrency ON ValuationCurrency = _ValuationCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SecurityClass AS _SecurityClass ON SecurityClass = _SecurityClass.SecurityClass  -- association [0..1]
LEFT OUTER JOIN I_TreasuryValuationClass AS _TreasuryValuationClass ON TreasuryValuationClass = _TreasuryValuationClass.TreasuryValuationClass AND TreasuryValuationArea = _TreasuryValuationClass.TreasuryValuationArea  -- association [0..1]
LEFT OUTER JOIN I_LoanContract AS _LoanContract ON LoanContract = _LoanContract.LoanContract AND CompanyCode = _LoanContract.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialTransaction AS _FinancialTransaction ON FinancialTransaction = _FinancialTransaction.FinancialTransaction AND CompanyCode = _FinancialTransaction.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_FinancialInstrTransType AS _TransactionType ON FinancialInstrumentProductType = _TransactionType.FinancialInstrumentProductType AND financialinstrtransactiontype = _TransactionType.FinancialInstrTransactionType  -- association [0..1]
LEFT OUTER JOIN I_DifferentiationPortfolio AS _Portfolio ON CompanyCode = _Portfolio.CompanyCode AND Portfolio = _Portfolio.DifferentiationPortfolio  -- association [0..1]
LEFT OUTER JOIN I_TrltPosattrib AS _TrltPosattrib ON TreasuryPosition = _TrltPosattrib.TreasuryPosition  -- association [0..1]
LEFT OUTER JOIN I_TreasuryGLAccountAssignRef AS _Treasuryglaccountassignref ON TreasuryGLAccountAssignmentRef = _Treasuryglaccountassignref.TreasuryGLAccountAssignmentRef  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON businessarea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_TreasuryPositionAccount AS _TreasuryPositionAccount ON TreasuryPositionAccount = _TreasuryPositionAccount.TreasuryPositionAccount AND CompanyCode = _TreasuryPositionAccount.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_TrsyPosManagementProcedure AS _Trsyposmanagementprocedure ON TrsyPosManagementProcedure = _Trsyposmanagementprocedure.TrsyPosManagementProcedure  -- association [0..1]
LEFT OUTER JOIN I_PositionIdentifier AS _PositionIdentifier ON TreasuryPosition = _PositionIdentifier.TreasuryPosition AND _PositionIdentifier.TreasuryPositionContext = 'TRL'  -- association [0..1]
;