I_DCBDealEnterpriseSearch

Deal Enterprise Search Help | view: IDCBDEALES | Extraction: Not supported | Component: Commodity Management – Deal Capture
Tables used: /DMBE/TM_DEALHDR, /DMBE/TM_ACCOUNT, /DMBE/TM_ACCO_TX, /DMBE/TM_BRKVOL, /DMBE/TM_BRKVOLT, /DMBE/TM_BRKFEE, T006A, /DMBE/TM_BRKFEET, BUT000, BUT100, /DMBE/TM_CREDCL, /DMBE/TM_CREDCLT, TCURX, TCURT, /DMBE/TM_HDRCLSS, /DMBE/TM_HDRCLST, /DMBE/TM_DEALTYP, /DMBE/TM_DEALT_T, /DMBE/TM_EVGCANC, /DMBE/TM_EVGRENW, /DMBE/TM_EVGCN_T, /DMBE/TM_EVGRN_T, OIA01, /DMBE/TM_IEREC, /DMBE/TM_FASCODE, /DMBE/TM_FASCODT, /DMBE/TM_PROVIS, /DMBE/TM_PROVIST, /DMBE/TM_LAWS, /DMBE/TM_LAWS_T, /DMBE/TM_GOVPT_T, /DMBE/TM_GOVPRTY, /DMBE/TM_IEREC, /DMBE/TM_IEREC_T, /DMBE/TM_IEREC, ADRC, OIFSPBL, OIJLOC, TVZBT, T052U, TCURX, /DMBE/TM_PRDTP, /DMBE/TM_PRDTP_T, /DMBE/TM_SCHEDLR, /DMBE/TM_SCHED_T, /DMBE/TM_STATUS, T052, T000, T006, ADRP, USR21, BUT000, BUT100, T001, TKA02, T006A, /DMBE/TM_BPROLE, /DMBE/TM_BPROLE, /DMBE/TM_COMPCOD, /DMBE/TM_CURC, /DMBE/TM_FTFLAG, /DMBE/TM_CURCPRC, /DMBE/TM_PRDFEAT, /DMBE/TM_TRTNAME
Column Name Description
CmmdtyDealUUID UUID in X form (binary)
Column Name Description
Column Name Description
Column Name Description
DealTradeDate Trade Date
DealEffectiveFromDate Effective From
Column Name Description
DealTransactionType Transaction Type Show values
Column Name Description Domain name
CmmdtyDealNumber Deal Number /DMBE/DM_SMART_ID
DealInternalContact Deal Trader USNAM
DealCounterparty Counterparty BU_PARTNER
DealTypeDescription Deal Type /DMBE/DM_DEAL_TYPE_DESC
DealTransactionTypeDescription null
DealProductTypeDescription Product Type /DMBE/DM_PRODUCT_TYPE_DESCR
DealResponsibleTraderDesc Full Name of Person TEXT80
DealInternalCompanyDesc Company Name /DMBE/DM_COMPANY_NAME
DealCounterpartyDescription null
Master Data Relations Join Conditions
Product Type
  • Product Type
  • Client
Deal Type
  • Deal Type
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
Internal Company
  • Internal Company
  • Client