P_DerivativePosAdptrLayer

Derivative Positions Adapter Layer | view: PVFINDAL | TRAN | Extraction: Not supported | Component: Commodity Derivative Risk Management
Column Name Description
CompanyCode Company Code
CommodityPriceExposure Commodity Price Exposure ID
CommodityExposureCategory Exposure Category Show values
CommodityPriceSubExposure Hash key
CommodityPriceExposureVersion Version of a Commodity Price Exposure
Column Name Description
Column Name Description
CommodityPriceExposureQuantity Quantity
Column Name Description
ValidityStartDate Valid-From Date of Exposure
ValidityStartTime Valid-From Time of Commodity Derivative
ValidityEndDate Valid-To Date of Commodity Derivative
ValidityEndTime Valid-To Time of Commodity Derivative
ExposureDueDate Date on which the exposure is due and expires
ReportingDate Reporting Date
MaturityKeyDate Maturity Key Date
TermStartDate Term Start
TermEndDate Term End
DeliveryDate Delivery Date of a Commodity Derivative
EvaluationDate Evaluation Date
EndOfDaySnapshotDate Snapshot Date
Column Name Description
CommodityExposureCategory Exposure Category Show values
CashFlowDirection Transaction Flow Direction Show values
TreasuryPositionLongShortCode Indicates whether it is a long or a short position Show values
CmmdtyForwardIndexTiming Timing/Periodicity of Commodity Forward Indexes Show values
HasError Error Flag for Data Record of Commodity Risk Analytics Show values
CommodityPriceFixationStatus Fixation Status Show values
OptionPutCallCode Put/Call Indicator Show values
OptionExerciseType Exercise Type (American or European) Show values
ConsumptionType VLOGP Data Selection Type Show values
DisplayView View Variant Show values
RiskViewIsNotRelevant Ignore for Risk View Show values
Column Name Description Domain name
ValidityStartDateTime Valid-From Timestamp of Commodity Derivative TZNTSTMPS
ValidityEndDateTime Valid-To Timestamp of Commodity Derivative TZNTSTMPS
ValidityStartCharTimestamp null
ValidityEndCharTimestamp null
MaximumVersion Highest Version Number CMM_MTM_VERSION
RiskAnalyzerVersionUUID CMM_VFIND Version GUID SYSUUID
Commodity Commodity TBA_STOEFFCHEN
DerivativeContrSpecification Derivative Contract Specification ID TBA_DCSID
MarketIdentifierCode Market Identifier Code TBA_MIC
QuotationPriceType Type of Price Quotation VVSKURSART
TimeToMaturity Time to Maturity TBA_TENOR
DerivativeContractMaturityCode Contract Maturity Code TBA_CONTRACT_CODE
FinancialInstrProductCategory Product Category VVSANLF
FinancialAssetsMgmtProductType Product Type VVSART
FinInstrTransactionCategory Transaction Category T_SFGTYP
FinancialInstrumentProductType Financial Transaction Type T_SFHAART
FinancialInstrActivityCategory Transaction Activity Category T_SFGZUTY
FinancialObject Financial Object Number J_OBJNR
NumberOfCommodityContracts Number of Contracts ASTUECK
TreasuryPositionAccount Futures Account for Listed Options and Futures TPM_POS_ACCOUNT_FUT
DerivativeContract Contract for Listed Options and Futures WP_RANL
OptionStrikePrice Strike price for commodity listed options TB_CTY_STRIKE_PRICE
OptionStrikeCurrency Currency Unit of the Rate VVSRUNIT
EndOfDayBusinessEntityKey Key of an Business Entity requiring an End-of-day snapshot
ReportingMonth Reporting Month CHAR3
ReportingYear Reporting Year GJAHR
EndOfDaySnapshotDateTime Timestamp defining a End-of-day snapshot TZNTSTMPS
FinInstrExternalReference External Reference FTI_CHAR16LOW
TradedDrvtvContrSpecification Traded Derivative Contract Specification ID TBA_DCSID
ParDrvtvContractSpecification Parent Derivative Contract Specification ID TBA_DCSID