/dmbe/c_EFP_Pricing_Search

Column Name Description
dealUuid UUID in X form (binary)
dealItemUuid UUID in X form (binary)
pricingUuid UUID in X form (binary)
Column Name Description
💲 Quotation Currency (pricingCurrency):
pricingAmount Amount
💲 Currency (basisPricingCurrency):
basisPricingAmount Amount
Column Name Description
📏 Detail Unit of Measure (UOM):
quantity Detail Quantity
Column Name Description
effectiveFrom Effective From
effectiveTo Effective To
postedDate Posted Date of a Deal
efpDeemedDate Deemed Date
Column Name Description
Industry Industry Type Show values
AreOptionalitiesInLine Truth Value: True/False Show values
IsComplexPricing Truth Value: True/False Show values
efpPricingCategory Pricing Category for Exchange Futures for Physicals Show values
efpUpdateStatus EFP Update Status Show values
posted Deal is Posted Show values
actionType Pricing Action Type Show values
Column Name Description Domain name
smartId Deal Number /DMBE/DM_SMART_ID
counterParty Counterparty BU_PARTNER
counterpartyName null
counterpartycontact Counterparty Contact Business Partner BU_PARTNER
internalContact Deal Trader USNAM
internalContactDescr Deal Trader TEXT80
responsibleTrader Responsible Trader USNAM
responsibleTraderDescr Responsible Limit Of Authority
transactionType Transaction Type
transactionTypeDescr null
detailTransactionType Detail Transaction Type
detailTransactionTypeDescr Short Text for Fixed Values DDTEXT
productTypeDescr Product Type /DMBE/DM_PRODUCT_TYPE_DESCR
origin Origin OIJ_LOCID
originDescr Location name (used by system owner) OIJ_LOCNAM
destination Destination Trader Scheduler Workbench OIJ_LOCID
destinationDescr Location name (used by system owner) OIJ_LOCNAM
product Product MATNR
productDescr Product TEXT40
efpPricingCategoryName Short Text for Fixed Values DDTEXT
efpContractMonth Contract Month TEXT40
efpFixIndex Exchange Futures for Physicals Mercantile Instrument Type CPE_RULE
efpFixIndexDescr Exchange Futures for Physicals Mercantile Instrument Type /DMBE/DM_DESCRIPTION
pricingUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
pricingCurrencyDescr Long Text TEXT40
strategy Strategy /DMBE/DM_DEAL_STRATEGY_30C
strategyDescr Strategy /DMBE/DM_DEAL_STRATEGY_30C
UOMDescr Detail Unit of Measure TEXT10
dealBlocked null
basisPricingUomDescr Unit of Measurement Text (Maximum 10 Characters) TEXT10
detailNumber Detail Number /DMBE/DM_OPTIONALITY_KEY
Master Data Relations Join Conditions
Product Type
  • Client
  • Product Type
Other Relations Join Conditions
Internal Company
  • Internal Company
  • Client