I_TrsyPositionTransactionFlow

Treasury Position Transaction Flow | view: ITRSYPOSTRANSFLW | Extraction: Not supported | Component: Treasury and Risk Management
Tables used: DIFT_POS_IDENT, TRLT_FLOW, TRLT_POSITION, TRLT_TRANSACTION, TREAT_EXT_ACC, T001, TKA02, TWPOB_T, TRGC_COM_VALCL_T, VDARL, TWD01, VWPANLA, TRFT_POS_ACCOUNT, TRDC_DFLOWTYPE_T, TRGC_VAL_CLASS_T, TRLTS_PMCAT_T, TRGT_SECACCGRP, TRGC_VAL_AREA
Column Name Description
TreasuryTransactionFlow Number of TRL Flow
BusinessTransactionDocUUID FK Business Transaction (GUID)
Column Name Description
💲 Position Currency (PositionCurrency):
AmountInPositionCurrency Amount in Position Currency
IndexCleanAmountInPositionCrcy Index Clean Amount in Position Currency
💲 Valuation Currency (ValuationCurrency):
AmountInValuationCurrency Amount in Valuation Currency
CalculationBasis Calculation Base Amount
💲 Nominal Currency (NominalCurrency):
NominalAmountInNominalCurrency Nominal Amount
OriglNominalAmtInNominalCrcy Original Nominal Amount
Column Name Description
Column Name Description
CalculationDate Key Date of Last Interest Calculation
DueDate Due Date
CalculationPeriodStartDate Start of Calculation Period
CalculationPeriodEndDate End of Calculation Period
TreasuryPositionLedgerDate Treasury Ledger Date
CreationDate Creation Date of the Operative Business Transaction
CreationTime Creation Time of the Operative Business Transaction
FirstResponseByDate First Entered On
CorrespondenceCreationTime Time of Creation
Column Name Description
TrsyPosTransfSourceTargetCode Position Transfer Show values
TrsyPosQuantityChangeCategory Position Change Category (Quantity) Show values
CalcDateIsAsEndDateInclusive Incl./Excl. Indicator for Beginning and End of a Period Show values
FinInstrProductGroup Product Group Show values
TrsyDerivedBusTransacIsUpdated Status of Treasury Ledger Business Transaction Show values
TreasuryBusinessTransStatus Posting Status Treasury Ledger Business Transaction Show values
TrsyIntragroupTransacStatus Intragroup Transaction Status Show values
TreasuryPosAssetLiabilityCode Assets/Liabilities Position Show values
TreasuryPositionLongShortCode Code: Long or Short Position Show values
Column Name Description Domain name
TreasuryUpdateTypeName Name of the Update Type FTR_GEN_DESCRIPTION
TreasuryUpdateType Update Type TPM_DIS_FLOWTYPE
TreasuryPosChangeCategoryName Name of the Position Change Category FTR_GEN_DESCRIPTION
TreasuryPositionTransferGroup Position Transfer Group TPM_SYSTEM_KEY
TreasuryPositionTransferFactor Position Transfer Coefficient TPM_AMOUNT_FACTOR
TrsyPosQtyChangeCategoryName Position Change Category: Quantity (Text) TPM_DESCRIPTION
TrsyPosAmountChangeCategory Position Change Category (Amount) TPM_PM_CAT
QuantityInPieces Quantity in Pieces FTR_GEN_UNITS
EffectiveInterestRate For Calculation of Amortization Amts (SAC) for Used EffInR DEC3_7
EffctvIntrstRateRdmptnSched Redemption Schedule that Explains Effective Interest Rate
NextEffectiveInterestRate Valid Effective Interest Rate for the Next Amortization DEC3_7
FixedRedemptionSchedule Fixed Redemption Schedule
TreasuryBusinessTransaction Identifier of the Distributor Business Transaction SYSUUID
OriglTrsyBusinessTransaction Original Business Transaction SYSUUID
CreatedByUser Entered By SYCHAR12
Fund Fund BP_GEBER
GrantID Grant GM_GRANT_NBR
TreasuryValuationAreaName Name of the Valuation Area FTR_GEN_DESCRIPTION
TreasuryValuationClassName Name of the Valuation Class FTR_GEN_DESCRIPTION
SecurityClassName Name of the Security Class XKBEZ
SecurityClassDescription Description of the Security Class XLBEZ
DifferentiationPortfolioName Name of the Portfolio as Differentiation Characteristic TEXT30
TreasuryPositionLot Identifier of the Lot SYSUUID
LoanContractName Name of the Loan Contract XTEXT50
CentralClearingAccount Central Clearing Account FTR_GEN_CNTRL_CLEARING_ACCOUNT
CentralClearingAccountName Name of the Central Clearing Account TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
SecurityAccountName Name of the Security Account XLDEPO
SecurityAccountGroupName Name of Securities Account Group FTR_GEN_DESCRIPTION
TreasuryPositionAccountName Name of the Futures Account for Listed Options and Futures TEXT30
Issuer Issuer Identity Key BU_PARTNER
FinancialInstrValClassName Name of the Financial Instrument Valuation Class FTR_GEN_DESCRIPTION
FinancialExposureItem Exposure Item ID TOE_EXPOSURE_ITEM_ID
FinancialExposureSubItem Exposure Subitem ID TOE_EXPOSURE_SUBITEM_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Central Clearing Account Currency
  • Client
  • Central Clearing Account Currency
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TCURC.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.CENTRALCLEARINGACCOUNTCURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == T001.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.COMPANYCODE == T001.BUKRS
Portfolio as Differentiation Characteristic
  • Client
  • Portfolio as Differentiation Characteristic
  • Company Code
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TWPOB.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.DIFFERENTIATIONPORTFOLIO == TWPOB.RPORTB
  • I_TRSYPOSITIONTRANSACTIONFLOW.COMPANYCODE == TWPOB.BUKRS
Product Type
  • Client
  • Product Type
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TZPA.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.FINANCIALINSTRUMENTPRODUCTTYPE == TZPA.GSART
Financial Instrument Valuation Class
  • Client
  • Financial Instrument Valuation Class
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TRGC_COM_VALCL.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.FINANCIALINSTRVALUATIONCLASS == TRGC_COM_VALCL.COM_VAL_CLASS
Transaction Number
  • Client
  • Financial Transaction
  • Company Code
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == VTBFHA.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.FINANCIALTRANSACTION == VTBFHA.RFHA
  • I_TRSYPOSITIONTRANSACTIONFLOW.COMPANYCODE == VTBFHA.BUKRS
Loan Contract Number
  • Client
  • Loan Contract Number
  • ?
  • Company Code
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == VDARL.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.LOANCONTRACT == VDARL.RANL
  • I_TRSYPOSITIONTRANSACTIONFLOW.[column in domain "SARCHIV"] == VDARL.SARCHIV
  • I_TRSYPOSITIONTRANSACTIONFLOW.COMPANYCODE == VDARL.BUKRS
Security Account
  • Client
  • Security Account
  • Company Code
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TWD01.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.SECURITYACCOUNT == TWD01.RLDEPO
  • I_TRSYPOSITIONTRANSACTIONFLOW.COMPANYCODE == TWD01.BUKRS
Security Class
  • Client
  • Security Class
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == VWPANLA.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.SECURITYCLASS == VWPANLA.RANL
Business Transaction Category I_TRSYPOSITIONTRANSACTIONFLOW.TREASURYBUSINESSTRANSCATEGORY == TRDTS_BT_CAT.BUSTRANSCAT
Foreign Key Futures Account
  • Client
  • Futures Account for Listed Options and Futures
  • Company Code
Valuation Class
  • Client
  • Valuation Class
  • Treasury Valuation Area
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TRGC_VAL_CLASS.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.TREASURYVALUATIONCLASS == TRGC_VAL_CLASS.VALUATION_CLASS
  • I_TRSYPOSITIONTRANSACTIONFLOW.TREASURYVALUATIONAREA == TRGC_VAL_CLASS.VALUATION_AREA
Other Relations | to Master Data Relations ↑ Join Conditions
Securities Account Group
  • Securities Account Group
  • Client
  • Company Code
  • I_TRSYPOSITIONTRANSACTIONFLOW.SECURITYACCOUNTGROUP == TRGT_SECACCGRP.SEC_ACCT_GRP
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TRGT_SECACCGRP.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.COMPANYCODE == TRGT_SECACCGRP.COMPANY_CODE
Trader
  • Client
  • Company Code
  • Trader
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TZDEA.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.COMPANYCODE == TZDEA.BUKRS
  • I_TRSYPOSITIONTRANSACTIONFLOW.TRADER == TZDEA.RDEALER
Accounting Code
  • Accounting Code
  • Client
Treasury Valuation Area
  • Client
  • Treasury Valuation Area
  • I_TRSYPOSITIONTRANSACTIONFLOW.MANDT == TRGC_VAL_AREA.MANDT
  • I_TRSYPOSITIONTRANSACTIONFLOW.TREASURYVALUATIONAREA == TRGC_VAL_AREA.VALUATION_AREA