I_TrsyPosValuesCompatible

Position Values (OLD VERSION DO NOT USE) | view: IFTRPOSVALOLD | Extraction: Not supported | Component: Treasury and Risk Management
Column Name Description
Column Name Description
DesignatedAmountInNominalCrcy Designated Nominal Amount
DesignatedOrigAmtInNominalCrcy Designated Original Nominal Amount
NominalAmountInNominalCurrency Nominal Amount
OriglNominalAmtInNominalCrcy Original Nominal Amount
ClearingAmountInPositionCrcy Clearing Component in Position Currency
ClearingAmountInValuationCrcy Clearing Component in Valuation Currency
PurchaseValueInPositionCrcy Purchase Value in Position Currency
PurchaseValueInValuationCrcy Purchase Value in Valuation Currency
SecurityValuationAmtInPosCrcy Security Valuation in Position Currency
SecurityValuationAmtInValnCrcy Security Valuation in Valuation Currency
ForeignCrcyValnAmtInValnCrcy Foreign Currency Valuation in Valuation Currency
CostInPositionCurrency Costs in Position Currency
CostInValuationCurrency Costs in Valuation Currency
SecurityCostValnAmtInPosCrcy Valuation of Cap. Costs, Security, in Position Currency
SecurityCostValnAmtInValnCrcy Valuation of Cap. Costs, Security, in Valuation Currency
FrgnExchCostValnAmtInValnCrcy Valuation of Capitalized Costs, FX, in Valuation Currency
AmortizationAmtInPositionCrcy Amortization in Position Currency
AmortizationAmtInValuationCrcy Amortization in Valuation Currency
ClrdPremDiscDefrlTxCompnAmount Cleared PD Deferral/Tax Compensation in Position Currency
ClrdPremDiscDefrlAmtInValnCrcy Cleared PD Deferral/Tax Compensation in Valuation Currency
IndexValuationAmountInPosCrcy Index Valuation in Position Currency
IndexValuationAmountInValnCrcy Index Valuation in Valuation Currency
PurValDeferralItmAmtInPosCrcy Deferral Item for Purchase Value in Position Currency
PurValDeferralItmAmtInValnCrcy Deferral Item for Purchase Value in Valuation Currency
VariationMarginAmountInPosCrcy Variation Margin in Position Currency
VariationMarginAmtInValnCrcy Variation Margin in Valuation Currency
OCISecurityValnAmountInPosCrcy Security Valuation, Not Affecting P/L, in Position Currency
OCIScrtyValnAmountInValnCrcy Security Valuation, Not Affecting P/L, in Valuation Currency
OCIFrgnExchValnAmtInValnCrcy Foreign Currency Valuation, Not Affecting P/L, in Val. Crcy
OCIIndexValnAmountInPosCrcy Index Valuation, Not Affecting P/L, in Position Currency
OCIIndexValnAmountInValnCrcy Index Valuation, Not Affecting P/L, in Valuation Currency
OCIScrtyCostValnAmtInPosCrcy Valuation of Cap. Costs, Sec., Not Aff. P/L in Position Crcy
OCIScrtyCostValnAmtInValnCrcy Valuation of Cap. Costs, Sec., Not Aff. P/L in Val. Crcy
OCICostFXValnAmountInValnCrcy Valuation of Cap. Costs, FX, Not Aff. P/L in Valuation Crcy
AccruedInterestInPositionCrcy Accrued Interest (Position Component) in Position Currency
AccruedInterestInValuationCrcy Accrued Interest in Valuation Currency
NegttnSpreadAmtznAmtInPosCrcy Amortized Negotiation Spread in Position Currency
NegttnSpreadAmtznAmtInValnCrcy Amortized Negotiation Spread in Valuation Currency
CumltvRepaymentAmountInPosCrcy Cumulative Repayment in Position Currency
CumltvRepaymentAmtInValnCrcy Cumulative Repayment in Valuation Currency
PurCrcySpotValnAmtInValnCrcy Spot Valuation of Purchase Currency in Valuation Currency
SaleCrcySpotValnAmtInValnCrcy Spot Valuation of Sale Currency in Valuation Currency
SwapAccrualAmountInPosCurrency Swap/Margin Accrual/Deferral in Position Currency
SwapAccrualAmountInValnCrcy Swap or Margin Accrual/Deferral in Valuation Currency
SwapValuationAmountInValnCrcy Swap Valuation in Valuation Currency
ImpairmentAmountInPositionCrcy Impairment in Position Currency
ImpairmentAmtInValuationCrcy Impairment in Valuation Currency
HedgeAmortizationAmtInPosCrcy Hedge Amortization in Position Currency
HedgeAmortizationAmtInValnCrcy Hedge Amortization in Valuation Currency
FrgnExchValnDiffAmtInValnCrcy Foreign Exchange Valuation Differences
GainValueAdjmtAmountInPosCrcy Value Adjustment of Gains in Position Currency
GainValueAdjmtAmountInValnCrcy Value Adjustment of Gains in Valuation Currency
LossValueAdjmtAmountInPosCrcy Value Adjustment of Losses in Position Currency
LossValueAdjmtAmountInValnCrcy Value Adjustment of Losses in Valuation Currency
OriginalValueAdjmtAmtInPosCrcy Original Value Adjustment in Position Currency
OriginalValAdjmtAmtInValnCrcy Original Value Adjustment in Valuation Currency
CapitalizationRsrvInPosCrcy Capitalization Reserve in Position Currency
CapitalizationRsrvInValnCrcy Capitalization Reserve in Valuation Currency
FXValnAmtzdAcqnAmtInValnCrcy FX Valuation of Amort. Acquisition Value in Valuation Crcy
ForeignExchImprmtAmtInValnCrcy FX Impairment in Valuation Currency
CnsldtdScrtyGainAmtInPosCrcy Consolidated Security Gains in Position Currency
CnsldtdScrtyGainAmtInValnCrcy Consolidated Security Gains in Valuation Currency
CnsldtdScrtyLossAmtInPosCrcy Consolidated Security Losses in Position Currency
CnsldtdScrtyLossAmtInValnCrcy Consolidated Security Losses in Valuation Currency
CnsldtdForExGainAmtInValnCrcy Consolidated FX Gains in Valuation Currency
CnsldtdForExLossAmtInValnCrcy Consolidated FX Losses in Valuation Currency
InterestIncomeInPositionCrcy Interest Income in Position Currency
InterestIncomeInValuationCrcy Interest Income in Valuation Currency
EffctvAmtInPosCrcy Effective Amount in Position Currency
EffctvAmtInValnCrcy Effective Amount in Valuation Currency
IneffctvAmtInPosCrcy Ineffective Amount in Position Currency
IneffctvAmtInValnCrcy Ineffective Amount in Valuation Currency
LossAllowanceAmountInPosCrcy Loss Allowance in Position Currency
LossAllowanceAmountInValnCrcy Loss Allowance in Valuation Currency
FXLossAllowanceAmtInValnCrcy Loss Allowance FX in Valuation Currency
OffsetLossAllwncAmtInValnCrcy Offset Loss Allowance in Valuation Currency
OffstLossAllowanceAmtInPosCrcy Offset Loss Allowance in Position Currency
FXOffstLossAllwncAmtInValnCrcy Offset Loss Allowance FX in Valuation Currency
OCIOffstLossAllwncInValnCrcy OCI Offset Loss Allowance in Valuation Currency
OCIOffstLossAllwncAmtInPosCrcy OCI Offset Loss Allowance in Position Currency
FXOffstOCILossAllwncInValnCrcy OCI Offset Loss Allowance FX in Valuation Currency
AmtznAdjmtLossAllwncInPosCrcy Amortization Adjustm. of Loss Allowance in Position Currency
AmtznAdjmtLossAllwncInValnCrcy Amortization Adj. of Loss Allowance in Valuation Currency
FXAmtznAdjLossAllwncInValnCrcy Amortization Adjust. of Loss Allowance FX in Valuation Crcy.
ContractChangeAmtInPosCrcy Contractual Change in Position Currency
ContractChangeAmtInValnCrcy Contractual Change in Valuation Currency
FrgnExchContrChgAmtInValnCrcy Contractual Change FX in Valuation Currency
EffctvCostHdggRsrvInPosCrcy Effective/Cost of Hedging Reserve in Position Currency
EffctvCostHdggRsrvInValnCrcy Effective/Cost of Hedging Reserve in Valuation Currency
IneffctvHdggRsrvPnLInPosCrcy Ineffective/Hedging Rsrv Through Profit & Loss in Pos Crcy
IneffctvHdggRsrvPnLInValnCrcy Ineffective/Hedging Rsrv Through Profit & Loss in Vln Crcy
EffctvHdggRsrvPnLInPosCrcy Effective/Hedging Rsrv Through Profit & Loss in Pos. Crcy
EffctvHdggRsrvPnLInValnCrcy Effective/Hedging Rsrv Through Profit & Loss in Vln Crcy
IneffctvCostHdgRsrvPnLPosCrcy Ineffective/Cost of Hdg Rsrv Through Profit & Loss in PC
IneffctvCostHdgRsrvPnLValnCrcy Ineffective/Cost of Hdg Rsrv Through Profit & Loss in VC
EffctvCostHdgRsrvPnLInPosCrcy Effective/Cost of Hdg Rsrv Thr. Profit & Loss in Pos. Crcy
EffctvCostHdgRsrvPnLInValnCrcy Effective/Cost of Hdg Rsrv Thr. Profit & Loss in Vln Crcy
PnLDesignatedAmtInPosCrcy Profit/Loss Effective / Designated Comp. in Position Crcy
PnLDesignatedAmtInVC Profit/Loss Effective / Designated Comp. in Valuation Crcy
PnLNonDesignatedAmtInPosCrcy Profit/Loss Effective / Non-Designated Component in PC
PnLNonDesignatedAmtInVC Profit/Loss Effective / Non-Designated Component in VC
AmtznNonDesignatedAmtInPosCrcy Amortization / Non-Designated Component in Position Currency
AmtznNonDesignatedAmtInVC Amortization / Non-Designated Comp. in Valuation Currency
SecurityWriteUpAmountInPosCrcy Security Write-Up in Position Currency
SecurityWriteDownAmtInPosCrcy Security Write-Down in Position Currency
SecurityWriteUpAmtInValnCrcy Security Write-Up in Valuation Currency
ScrtyWriteDownAmtInValnCrcy Security Write-Down in Valuation Currency
FrgnExchWriteUpAmtInValnCrcy Forex Write-Up in Valuation Currency
FrgnExchWriteDownAmtInValnCrcy Forex Write-Down in Valuation Currency
ScrtyCostWriteUpAmtInPosCrcy Write-Up of Capitalized Costs, Security Val. in Pos.Crcy
ScrtyCostWriteDownAmtInPosCrcy Write-Down of Capitalized Costs, Security Valn in Pos. Crcy
ScrtyCostWriteUpAmtInValnCrcy Write-Up of Capitalized Costs, Security Val. in Val.Crcy
ScrtyCostWrtDownAmtInValnCrcy Write-Down of Capitalized Costs, Security Valn in Val.Crcy
FrgnExchCostWrtUpAmtInValnCrcy Write-Up of Capitalized Costs, FX Valuation in Val.Crcy
FXCostWriteDownAmtInValnCrcy Write-Down of Capitalized Costs, FX Valuation in Val.Crcy
IndexWriteUpAmountInPosCrcy Index Write-Up in Position Currency
IndexWriteDownAmountInPosCrcy Index Write-Down in Position Currency
IndexWriteUpAmountInValnCrcy Index Write-Up in Valuation Currency
IndexWriteDownAmtInValnCrcy Index Write-Down in Valuation Currency
IndexCleanClearingAmtInPosCrcy Clearing Component, Index Clean, in Position Crcy
IndexCleanPurchaseValInPosCrcy Purchase Value, Index-Clean, in Position Currency
IdxCleanScrtyValnAmtInPosCrcy Security Valuation, Index-Clean, in Position Currency
IndexCleanCostInPositionCrcy Costs, Index-Clean, in Position Currency
IndexClnScrtyCostValuationAmt Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy
IndexCleanAmtznAmountInPosCrcy Amortization, Index-Clean, in Position Currency
IdxClnClrdPremDiscDeferralAmt Cleared PD Deferral/Tax Compensation in PC: Index-Clean
IdxClnPurValDefrlAmtInPosCrcy Deferral Item for Purchase Value, Index-Clean, in Pos.Crcy
IdxClnOCIScrtyValnAmtInPosCrcy Security Valuation, Not Affecting P/L, Index-Clean, in PC
IdxClnOCIScrtyCostValuationAmt Val.of Cap.Costs, SE, Not Aff.P/L, Index-Clean, in Pos.Crcy
IndexCleanNegttnAmtznInPosCrcy Amort. Negotiation Spread, Index-Clean, in Position Currency
IndexCleanRpaytAmtInPosCrcy Cumulative Repayment, Index-Clean, in Position Currency
IndexCleanInterestIncInPosCrcy Interest Income, Index-Clean, in Position Currency
IdxCleanHedgeAmtznAmtInPosCrcy Hedge Amortization, Index-Clean, in Position Currency
IndexCleanImprmtAmtInPosCrcy Impairment, Index-Clean, in Position Currency
IdxCleanLossAllwncAmtInPosCrcy Loss Allowance in Position Currency: Index-Clean
IdxCleanOffsetLossAllowanceAmt Offset Loss Allowance in Position Currency: Index-Clean
IdxClnOCIOffstLossAllwncAmtIn OCI Offset Loss Allowance in Position Currency: Index-Clean
IdxClnAmtznAdjLossAllInPosCrcy Amort. Adj. of Loss Allowance in Position Crcy (Index-Clean)
IdxClnContrChangeAmtInPosCrcy Contractual Change in Position Currency: Index-Clean
BookValueAmtInPositionCurrency Book Value in Position Currency
CostExcldBookValueAmtInPosCrcy Book Value Excluding Costs in Position Currency
AcquisitionAmtInPositionCrcy Acquisition Value in Position Currency
AmortizedAcqnAmountInPosCrcy Amortized Acquisition Value in Position Currency
AmortizedCostInPositionCrcy OBSOLETE: Amortized Cost in Position Currency
BookValueAmountInValnCurrency Book Value in Valuation Currency
CostExcldBookValAmtInValnCrcy Book Value Excluding Costs in Valuation Currency
AcquisitionAmountInValnCrcy Acquisition Value in Valuation Currency
AmortizedAcqnAmountInValnCrcy Amortized Acquisition Value in Valuation Currency
AmortizedCostInValuationCrcy OBSOLETE: Amortized Cost in Valuation Currency
IndexClnBookValueAmtInPosCrcy Book Value, Index-Clean, in Position Currency
IdxClnCostExcldBookValueAmount Book Value Excluding Costs, Index-Clean, in Position Crcy
IndexCleanAcqnAmountInPosCrcy Acquisition Value, Index-Clean, in Position Currency
IdxCleanAmtzdAcqnAmtInPosCrcy Amortized Acquisition Value, Index-Clean, in Position Crcy
IdxClnAmortizedCostInPosCrcy Amortized Cost in Position Currency: Index-Clean
Column Name Description
Column Name Description
TreasuryPositionZeroDate Date of Zero Position
TreasuryPositionLedgerDate Treasury Ledger Date
PostingDate Different FI Reversal Date
Column Name Description
TreasuryPositionLongShortCode Code: Long or Short Position Show values
TreasuryPosAssetLiabilityCode Assets/Liabilities Position Show values
TrsyPosQuantityChangeCategory Position Change Category (Quantity) Show values
TreasuryBusinessTransStatus Posting Status Show values
TrsyDerivedBusTransacIsUpdated Status of Treasury Ledger Business Transaction Show values
Column Name Description Domain name
TreasuryPositionLot Identifier of the Lot SYSUUID
FinancialExposureItem Exposure Item ID TOE_EXPOSURE_ITEM_ID
FinancialExposureSubItem Exposure Subitem ID TOE_EXPOSURE_SUBITEM_ID
CentralClearingAccount Central Clearing Account FTR_GEN_CNTRL_CLEARING_ACCOUNT
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
TrsySubPosition Subposition SYSUUID
TrsyPosAmountChangeCategory Position Change Category (Amount) TPM_PM_CAT
TrsyPosValuationStepProcedure Procedure for a Step TPM_STEP_PROCEDURE
TreasuryUpdateType Update Type TPM_DIS_FLOWTYPE
Portfolio Portfolio RPORTB
CommitmentBusinessPartner Partner with Whom Commitment Exists BU_PARTNER
QuantityInPieces Quantity in Pieces FTR_GEN_UNITS
DesignatedQuantityInPieces Designated Quantity in Pieces FTR_GEN_UNITS
Master Data Relations | to Other Relations ↓ Join Conditions
Central Clearing Account Currency
  • Client
  • Central Clearing Account Currency
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TCURC.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.CENTRALCLEARINGACCOUNTCURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == T001.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.COMPANYCODE == T001.BUKRS
Portfolio as Differentiation Characteristic
  • Client
  • Company Code
  • Portfolio as Differentiation Characteristic
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TWPOB.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.COMPANYCODE == TWPOB.BUKRS
  • I_TRSYPOSVALUESCOMPATIBLE.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
Product Type
  • Client
  • Product Type
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TZPA.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Financial Instrument Valuation Class
  • Client
  • Financial Instrument Valuation Class
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TRGC_COM_VALCL.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.FINANCIALINSTRVALUATIONCLASS == TRGC_COM_VALCL.COM_VAL_CLASS
Transaction Number
  • Financial Transaction
  • Client
  • Company Code
  • I_TRSYPOSVALUESCOMPATIBLE.FINANCIALTRANSACTION == VTBFHA.RFHA
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == VTBFHA.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.COMPANYCODE == VTBFHA.BUKRS
Loan Contract Number
  • ?
  • Loan Contract Number
  • Client
  • Company Code
  • I_TRSYPOSVALUESCOMPATIBLE.[column in domain "SARCHIV"] == VDARL.SARCHIV
  • I_TRSYPOSVALUESCOMPATIBLE.LOANCONTRACT == VDARL.RANL
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == VDARL.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.COMPANYCODE == VDARL.BUKRS
Security Account
  • Client
  • Company Code
  • Security Account
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TWD01.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.COMPANYCODE == TWD01.BUKRS
  • I_TRSYPOSVALUESCOMPATIBLE.SECURITYACCOUNT == TWD01.RLDEPO
Security Class
  • Client
  • Security Class
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == VWPANLA.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.SECURITYCLASS == VWPANLA.RANL
Business Transaction Category I_TRSYPOSVALUESCOMPATIBLE.TREASURYBUSINESSTRANSCATEGORY == TRDTS_BT_CAT.BUSTRANSCAT
Account Assignment Reference of Position Management
  • Account Assignment Reference of Position Management
  • Client
  • I_TRSYPOSVALUESCOMPATIBLE.TREASURYGLACCOUNTASSIGNMENTREF == TRACC_AA_REF.AA_REF
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TRACC_AA_REF.MANDT
Foreign Key Futures Account
  • Client
  • Futures Account for Listed Options and Futures
  • Company Code
Valuation Class
  • Client
  • Treasury Valuation Area
  • Valuation Class
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TRGC_VAL_CLASS.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.TREASURYVALUATIONAREA == TRGC_VAL_CLASS.VALUATION_AREA
  • I_TRSYPOSVALUESCOMPATIBLE.TREASURYVALUATIONCLASS == TRGC_VAL_CLASS.VALUATION_CLASS
Position Management Procedure
  • Client
  • Position Management Procedure
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TRGC_PM_PROC.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.TRSYPOSMANAGEMENTPROCEDURE == TRGC_PM_PROC.POS_MAN_PROC
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Securities Account Group
  • Client
  • Company Code
Trader
  • Client
  • Company Code
  • Trader
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TZDEA.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.COMPANYCODE == TZDEA.BUKRS
  • I_TRSYPOSVALUESCOMPATIBLE.TRADER == TZDEA.RDEALER
Accounting Code
  • Client
  • Accounting Code
Treasury Valuation Area
  • Client
  • Treasury Valuation Area
  • I_TRSYPOSVALUESCOMPATIBLE.MANDT == TRGC_VAL_AREA.MANDT
  • I_TRSYPOSVALUESCOMPATIBLE.TREASURYVALUATIONAREA == TRGC_VAL_AREA.VALUATION_AREA