TRLT_INIT_VAL_SE

Initialization Values for TRL Positions: Securities | #transactional | Component: Transfer to Financial Accounting

🔑 Keys (13)
💰 Amounts (96)
∑ Quantities
📅 Dates (1)
☰ Categorical (2)
Other (2)
🔗 Relations (7)

Column Name	Description
MANDT FK	Client
KEY_DATE	System Date
SRC_VAL_AREA	Source Valuation Area for Initializing Another Val. Area
COMPANY_CODE FK	Company Code
VALUATION_AREA FK	Treasury Valuation Area
VALUATION_CLASS FK	Valuation Class
SECURITY_ID FK	Security Class ID Number
LOT_ID	Identifier of the Lot
SECURITY_ACCOUNT FK	Securities Account
ACCOUNT_GROUP FK	Securities Account Group
PORTFOLIO	Portfolio
FUND	Fund
GRANT_NBR	Grant

Column Name	Description
💲 Nominal Currency (NOMINAL_CURR):
NOMINAL_AMT	Nominal Amount
NOMINAL_ORG_AMT	Original Nominal Amount in Position Currency
💲 Position Currency (POSITION_CURR):
PURCH_PC	Purchase Value in Position Currency
PURCH_IDX_CLEAN	Purchase Value, Index-Clean, in Position Currency
CHARGE_PC	Costs in Position Currency
CHARGE_IDX_CLEAN	Costs, Index-Clean, in Position Currency
VAL_TI_PC	Security Valuation in Position Currency
VAL_TI_IDX_CLEAN	Security Valuation, Index-Clean, in Position Currency
VAL_IDX_PC	Index Valuation in Position Currency
VAL_CH_TI_PC	Valuation of Cap. Costs, Security, in Position Currency
VAL_CH_TI_IDXCL	Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy
IMPAIRMENT_PC	Impairment in Position Currency
IMPMT_IDX_CLEAN	Impairment in Position Currency Index-Clean
AMORT_PC	Amortization in Position Currency
AMORT_IDX_CLEAN	Amortization, Index-Clean, in Position Currency
AMORT_NEG_SPR_PC	Amortization of Negotiation Spread in Position Currency
AM_NEG_SPR_IDXCL	Amortiz. of Negotiation Spread in Position Crcy Index-Clean
DISAGIO_PC	Discount/Premium in Position Currency
DISAGIO_IDXCL	Index-Clean Discount/Premium in Position Currency
VAL_TI_PC_NPL	Security Valuation in Position Currency
VAL_IT_IDXCL_NPL	Security Valuation, Index-Clean, in Position Currency
VAL_IDX_PC_NPL	Index Valuation in Position Currency
VAL_CH_TI_PC_NPL	Valuation of Cap. Costs, Security, in Position Currency
VAL_CHTIIDXCLNPL	Valuation of Cap. Costs, Security, Index-Clean, in Pos. Crcy
ACC_INT_PC	Accrued Interest in Position Currency
ACC_INT_IDXCL	Accrued Interest in Position Currency Index-Clean
NGSPR_PC	Negotiation Spread in Position Currency
NGSPR_IDXCL	Negotiation Spread Index Clean
REPAYMENT_PC	Cumulative Repayment in Position Currency
REPAYMENT_IDXCL	Cumulative Repayment in Position Currency Index-Clean
VAD_GAIN_PC	Value Adjustment of Gains in Position Currency
VAD_LOSS_PC	Value Adjustment of Losses in Position Currency
ORIG_VAD_PC	Original Value Adjustment in Position Currency
HAMORT_PC	Hedge Amortization in Position Currency
HAMORT_IDXCL_PC	Hedge Amortization in Position Crcy, Index-Clean
HADJ_PC	Hedge Adjustment in Position Currency
HADJ_IDXCL_PC	Hedge Adjustment in Position Currency, Index-Clean
EFF_PC	Effective Amount in Position Currency
EFF_IDXCL_PC	Effective Amount in Position Currency, Index Clean
INEFF_PC	Ineffective Amount in Position Currency
INEFF_IDXCL_PC	Ineffective Amount in Position Currency, Index Clean
EFFD_PC	Effective Amount (Dormant) in Position Currency
EFFD_IDXCL_PC	Effective Amount (Dormant) in Position Currency, Index-Clean
INEFFD_PC	Ineffective Amount (Dormant) in Position Currency
INEFFD_IDXCL_PC	Ineffective Amount (Dormant) in Position Currency, Index-Cln
LOSS_ALLOW_PC	Loss Allowance in Position Currency
LOSS_ALLOW_INDX_PC	Loss Allowance in Position Currency: Index-Clean
OFFS_LOSS_ALLOW_PC	Offset Loss Allowance in Position Currency
OFFS_LOSS_ALLOW_INDX_PC	Offset Loss Allowance in Position Currency: Index-Clean
CONTRACTUAL_CHANGE_PC	Contractual Change in Position Currency
CONTRACTUAL_CHANGE_INDX_PC	Contractual Change in Position Currency: Index-Clean
OCI_OFFS_LOSS_ALLOW_PC	OCI Offset Loss Allowance in Position Currency
OCI_OFFS_LOSS_ALLOW_IDX_PC	OCI Offset Loss Allowance in Position Currency: Index-Clean
AM_ADJ_LOSS_ALLOW_PC	Amortization Adjustm. of Loss Allowance in Position Currency
AM_ADJ_LOSS_ALLOW_INDX_PC	Amort. Adj. of Loss Allowance in Position Crcy (Index-Clean)
💲 Valuation Currency (VALUATION_CURR):
PURCH_VC	Purchase Value in Valuation Currency
CHARGE_VC	Costs in Valuation Currency
VAL_TI_VC	Security Valuation in Valuation Currency
VAL_FX_VC	Foreign Currency Valuation in Valuation Currency
VAL_IDX_VC	Index Valuation in Valuation Currency
VAL_CH_TI_VC	Valuation of Cap. Costs, Security, in Valuation Currency
VAL_CH_FX_VC	Valuation of Capitalized Costs, FX, in Valuation Currency
VAL_AAV_FX_VC	FX Valuation of Amort.Acquisition Value in Valuation Crcy
VAL_AV_FX_VC	FX Valuation of Acquisition Value in Valuation Crcy
IMPAIRMENT_VC	Impairment in Valuation Currency
IMPAIRMENT_FX_VC	FX Impairment in Valuation Currency
AMORT_VC	Amortization in Valuation Currency
AMORT_NEG_SPR_VC	Amortization of Negotiation Spread in Valuation Currency
DISAGIO_VC	Discount/Premium in Valuation Currency
VAL_TI_VC_NPL	Security Valuation in Valuation Currency
VAL_FX_VC_NPL	Foreign Currency Valuation in Valuation Currency
VAL_IDX_VC_NPL	Index Valuation in Valuation Currency
VAL_CH_TI_VC_NPL	Valuation of Cap. Costs, Security, in Valuation Currency
VAL_CH_FX_VC_NPL	Valuation of Capitalized Costs, FX, in Valuation Currency
ACC_INT_VC	Accrued Interest in Valuation Currency
NGSPR_VC	Negotiation Spread in Valuation Currency
REPAYMENT_VC	Cumulative Repayment in Valuation Currency
VAD_GAIN_VC	Value Adjustment of Gains in Valuation Currency
VAD_LOSS_VC	Value Adjustment of Losses in Valuation Currency
ORIG_VAD_VC	Original Value Adjustment in Valuation Currency
HAMORT_VC	Hedge Amortization in Valuation Currency
HADJ_VC	Hedge Adjustment in Valuation Currency
EFF_VC	Effective Amount in Valuation Currency
INEFF_VC	Ineffective Amount in Valuation Currency
EFFD_VC	Effective Amount (Dormant) in Valuation Currency
INEFFD_VC	Ineffective Amount (Dormant) in Valuation Currency
LOSS_ALLOW_VC	Loss Allowance in Valuation Currency
LOSS_ALLOW_FX_VC	Loss Allowance FX in Valuation Currency
OFFS_LOSS_ALLOW_VC	Offset Loss Allowance in Valuation Currency
OFFS_LOSS_ALLOW_FX_VC	Offset Loss Allowance FX in Valuation Currency
CONTRACTUAL_CHANGE_VC	Contractual Change in Valuation Currency
CONTRACTUAL_CHANGE_FX_VC	Contractual Change FX in Valuation Currency
OCI_OFFS_LOSS_ALLOW_VC	OCI Offset Loss Allowance in Valuation Currency
OCI_OFFS_LOSS_ALLOW_FX_VC	OCI Offset Loss Allowance FX in Valuation Currency
AM_ADJ_LOSS_ALLOW_VC	Amortization Adj. of Loss Allowance in Valuation Currency
AM_ADJ_LOSS_ALLOW_FX_VC	Amortization Adjust. of Loss Allowance FX in Valuation Crcy.

Column Name	Description

Column Name	Description
KEY_DATE	System Date

Column Name	Description
ACTIVE_PASSIVE	Indicator: Assets/Liabilities Position	Show values
FLG_TRANS	Status of Flow Related to Migration to CFM 1.0	Show values

Column Name	Description	Domain name
UNITS	Units	TPM_UNITS
BUSTRANSID	Identifier of the Distributor Business Transaction	SYSUUID

Master Data Relations \| to Other Relations ↓	Join Conditions
Company Code	`TRLT_INIT_VAL_SE.MANDT == T001.MANDT` `TRLT_INIT_VAL_SE.COMPANY_CODE == T001.BUKRS`
Client	`TRLT_INIT_VAL_SE.MANDT == T000.MANDT`
Securities Account Securities Account Company Code	`TRLT_INIT_VAL_SE.MANDT == TWD01.MANDT` `TRLT_INIT_VAL_SE.SECURITY_ACCOUNT == TWD01.RLDEPO` `TRLT_INIT_VAL_SE.COMPANY_CODE == TWD01.BUKRS`
Security Class ID Number	`TRLT_INIT_VAL_SE.MANDT == VWPANLA.MANDT` `TRLT_INIT_VAL_SE.SECURITY_ID == VWPANLA.RANL`
Valuation Class Treasury Valuation Area Valuation Class	`TRLT_INIT_VAL_SE.MANDT == TRGC_VAL_CLASS.MANDT` `TRLT_INIT_VAL_SE.VALUATION_AREA == TRGC_VAL_CLASS.VALUATION_AREA` `TRLT_INIT_VAL_SE.VALUATION_CLASS == TRGC_VAL_CLASS.VALUATION_CLASS`

Other Relations \| to Master Data Relations ↑	Join Conditions
Securities Account Group Company Code Securities Account Group Client	`TRLT_INIT_VAL_SE.COMPANY_CODE == TRGT_SECACCGRP.COMPANY_CODE` `TRLT_INIT_VAL_SE.ACCOUNT_GROUP == TRGT_SECACCGRP.SEC_ACCT_GRP` `TRLT_INIT_VAL_SE.MANDT == TRGT_SECACCGRP.MANDT`
Treasury Valuation Area	`TRLT_INIT_VAL_SE.MANDT == TRGC_VAL_AREA.MANDT` `TRLT_INIT_VAL_SE.VALUATION_AREA == TRGC_VAL_AREA.VALUATION_AREA`