CDS Views for Commodity Derivative Order and Trade Execution (FIN-FSCM-CMM-DOT)

CDS View NameDescriptionSQL View Name
C_CMMDTYORDERFILLPACKETLOGConsumption View for Order Error LogCCMDTYFLPKTLOG
C_CMMDTYORDERFILLSTAGINGConsumption View for staging tableCCMMFILLSTG
C_CMMDTYORDERREQLEGTPCmmdty Order Req. Leg Consumption ViewCCMMDTYORDLEGTP
C_CMMDTYORDERREQUESTSTATUSConsumption View for Order Req StatusCCMMDTYORDSTATUS
C_CMMDTYORDFILLASSGDDOCTPAssigned Documents Consumption ViewCCMMDTYFILLDOCTP
C_CMMDTYORDFILLENRICHMENTCommodity Order Fill Enrichment ViewCCMMDTYORDFILLEN
C_CMMDTYORDFILLPACKETASSGDFILLFill Packet Assigned Fills Consump. ViewCCMMDTYPKTDOCTP
C_CMMDTYORDFILLPACKETSTSConsumption View for Fill Packet StatusCCMMDTYFLPKTSTS
C_CMMDTYORDFILLRELATEDFILLAssigned Fills Consumption ViewCCMMDTYFILLREL
C_CMMDTYORDREQASSGDOCTPCmmdty Order Requests per DocumentCCMMDTYORDBYDOC
C_CMMDTYORDREQASSGDORDBRACKETCmmdty Assgd Order Brackets Cons. ViewCCMMDTYASDORDBKT
C_CMMDTYORDREQASSIGNEDFILLAssigned Fills Consumption ViewCCMMDTYORDFLL
C_CMMDTYORDREQBRACKETITMTPCmmdty Order Bracket Consumption ViewCCMMDTYORDBKTITP
C_CMMDTYORDREQBRACKETTPOrder Bracket InformationCCMMDTYORDBKTTP
C_CMMDTYORDREQBYASSGDDOCTPSort Cmmdty Ord Req by DocumentCCMORDREQBYDOCTP
C_CMMDTYORDREQDOCUMENTTPCmmdty Order Request Assgined DocumentCCMMDTYORDDOCTP
C_COMMODITYORDERFILLTPFill InformationCCMMDTYORDFILLTP
C_COMMODITYORDERREQUESTCmmdty Drvtv Order Request DetailsCCMMDTYORDREQ
C_COMMODITYORDERREQUESTLEGCmmdty Drvtv Order Request Leg DetailsCCMMDTYORDREQLEG
C_COMMODITYORDERREQUESTTPCommodity Derivative Order RequestCCMMDTYORDREQTP
C_COMMODITYORDFILLPACKETLOGTPConsumption View for a Cmmdty Deriv Ord Fill Packet LogCCMDTYFLPKTLOGTP
C_COMMODITYORDFILLPACKETTPFill Packet InformationCCMMDTYORDFPKTTP
C_COMMODITYSUBACCOUNTTPCommodity SubaccountCCMMDTYSUBACCTTP
E_CMMDTYORDERFILLPACKETExt. View for Cmmdty Deriv Ord Fill PktECMMDTYORDFPKT
E_COMMODITYORDERFILLExtension View for Commodity Order FillECMMDTYORDERFILL
E_COMMODITYORDERREQUESTCommodity Order Request Extension ViewECMMDTYORDERREQ
E_COMMODITYORDERREQUESTBRACKETExtention View for Order BracketECMMDTYORDERBKT
E_COMMODITYSUBACCOUNTExtension View for Commodity Sub AccountECMMDTYSUBACCT
I_CMMDTYASSGDORDERREQBYBRACKETBasic View to Count Bracket Assgd OrdsICMMBKTASGORDCNT
I_CMMDTYBROKERCOMMSETTINGSBasic View for Broker Comm. SettingsICMMDTYBROFIX
I_CMMDTYCNTRPTYBRKRREFACCTBasic View for Ctrprty Broker Ref AcctsICMMDTYBRORACC
I_CMMDTYCOCODEPRFTCTRVHView for Company Code and Profit CenterICMMDTYCOCODEPFC
I_CMMDTYDRVTVBROKERFIXMESSAGEBasic View for Cmmdty Broker Fix MessageICMMDTYFIXFLD
I_CMMDTYDRVTVCONTRKEYDATESDerivative Contract Maturity Key DatesICMMDTYDRVCNTDTE
I_CMMDTYDRVTVCONTRMICPHYSView for DCS, MIC and CommodityICMMDTYDCSMICCM
I_CMMDTYDRVTVCONTRSPECVALDFROMBasic View for DCS Valid From DateICMMDTYVALFRM
I_CMMDTYDRVTVEXECINSTRNCmmdty Pricing Execution InstructionsICMMDTYPRCEXINST
I_CMMDTYDRVTVFIXACTIONTEXTCmmdty Ord Req Fix ActionICMMDTYFIXATXT
I_CMMDTYDRVTVFIXMSGSTATEXTCmmdty Ord Req Fix Message StatusICMMDTYFIXMSTXT
I_CMMDTYDRVTVFIXTYPETEXTCmmdty Ord Req Fix TypeICMMDTYFIXTXT
I_CMMDTYDRVTVFLOWTYPETEXTCmmdty Ord Req Flow TypeICMMDTYFLOWTXT
I_CMMDTYDRVTVGENERICDOMAINVHObsolete -- do not use --ICMMDTYGENVH
I_CMMDTYDRVTVMKTPRCSRCETXTCmmdty Drvtv Last Knwn Mkt Prc Src TextICMMDTYPRCSRCTXT
I_CMMDTYDRVTVMULTILEGTYPETEXTCmmdty Ord Multi Leg TextICMMDMULTLTXT
I_CMMDTYDRVTVORDERUSERDETAILSBasic View for User DetailsICMMDTYUSRDET
I_CMMDTYDRVTVORDREQUESTBRACKETCommodity Drvtv Order Request BracketICMMDTYORDREQBKT
I_CMMDTYDRVTVORDTRDEXECRECENTRecent Changes for UI ApplicationICMMDTYRECENTCH
I_CMMDTYERRORMSGSBYFILLPACKETFill Packet Warning Error CountICMDTYPKTERRCNT
I_CMMDTYEXPRTNINSTRNCmmdty Order Expiration InstructionsICMMDTYEXPINST
I_CMMDTYEXPRTNINSTRNTEXTCmmdty Order Expiration InstructionsICMMDTYEXPTXT
I_CMMDTYFILLPACKETPRCDVTNBasic View for Fill Pkt price deviationsICMFLPKTPRCDVTN
I_CMMDTYFUTRACCTPRTFLOVHView for Futures Account and PortfolioICMMDTYFAPPRTFLO
I_CMMDTYFWDSTATUSTEXTCommodity Forward Status TextICMMDTYFWDSTSTXT
I_CMMDTYINTCOUNTERPARTYSUBACCTSubaccounts assgn. to int. CounterpartyICMMDTYCNTRSUB
I_CMMDTYLOTSOFFILLBYFILLPACKETBasic View for Fill Packet LotsICMMDTYPKTFLLOTS
I_CMMDTYNONTRADEDORDERREQTYPENon-Tradable Order Request TypeICMMDTYNTORD
I_CMMDTYNROFDSTCTUOMBYBRACKETBasic View to Count Distinct UOMsICMMDTYBKTUOM
I_CMMDTYORDASSGDFILLBYORDREQBasic View to Count Ord Req Assgd FillsICMDTYORDASFLCNT
I_CMMDTYORDASSGDLEGBYORDERREQBasic View to Count Ord Req Assgd LegsICMMORDASGLEGCNT
I_CMMDTYORDBRACKETTYPEVHValue Help View for Order Bracket TypeICMMDTYBKTTYPVH
I_CMMDTYORDDRAFTADMINVDATAOrder Request Draft Administrative DataICMMDTYORDDRAFT
I_CMMDTYORDERASSGDDOCBYORDFILLBasic View to Count Ord Fill Assgd DocsICMMFILASGDOCCNT
I_CMMDTYORDERASSGDDOCBYPACKETBasic View to Count Packet Assgd DocsICMMPKTASGDOCCNT
I_CMMDTYORDERASSGDFILLBYPACKETBasic View to Count Packet Assgd FillsICMMPKTASGFLCNT
I_CMMDTYORDERBRACKETITEMBasic View for Order Bracket ItemICMMDTYORDBKTIT
I_CMMDTYORDERFILLPACKETRCVDONBasic View for Fill Packet Recieved OnICMMDTYPKTRCVDON
I_CMMDTYORDERFILLPACKETSUBACCTBasic View for Fill Packet SubaccountIFILLPKTSUBACC
I_CMMDTYORDERFILLSTAGINGBasic View for Staging of fillsICMMFDOFSTGF
I_CMMDTYORDERFUTUREIDVHCommodity Order Future IDICMMDTYFUTUREID
I_CMMDTYORDERREQLEGCommodity Derivative Order Request LegICMMDTYORDLEG
I_CMMDTYORDERREQLEGTPCmmdty Order Req. Leg Transactional ViewICMMDTYORDLEGTP
I_CMMDTYORDERREQPACKETLOGBasic View for Order Error LogICMDTYORDLOG
I_CMMDTYORDERREQQUEUEERRLOGbgRFC Queue Error Log for Order RequestICMDTYORDQERR
I_CMMDTYORDERREQQUEUEERRLOGRAWbgRFC Queue Error Log Raw DataICMDTYORDQERRRW
I_CMMDTYORDERREQUESTREFERENCEBasic View for Order Request ReferenceICMMDTYORDREF
I_CMMDTYORDERREQUESTTYPECmmdty Order Request TypeICMMDTYORDTYP
I_CMMDTYORDERRMSGSBYORDREQBasic View to Count Ord Req Error MsgsICMDTYORDERRCNT
I_CMMDTYORDERTRADEATSETTLEMENTBasic View for Trade At SettlementICMMDTYTAS
I_CMMDTYORDFILLASSIGNEDDOCCmmdty Order Fills Assigned DocICMMDTYASSDOC
I_CMMDTYORDFILLFILLEDQUANTITYBasic View for Fill Packet Qty InfoICMMDTYFLQTY
I_CMMDTYORDFILLFORWARDCommodity Order Fill Forward Basic ViewICMMDTYORDFLFWRD
I_CMMDTYORDFILLFORWARDTPCommodity Order Fill Forward Transactional ViewICMMDTYORDFWDTP
I_CMMDTYORDFILLPACKETCOMMODITYBasic View for Cmmdty Deriv Ord Fill PktIFILLPKTCMMDTY
I_CMMDTYORDFILLPKTSTSTEXTCommodity Order Fill Packet Status TextICMMDTYPKTSTTXT
I_CMMDTYORDFILLPOSTYPETEXTCommodity Order Fill Position Type TextICMMDTYPOSTYPTXT
I_CMMDTYORDFILLPRCDQTYBYORDREQTotal Priced Quantity for Ord Req ViewICMMDTYPRCDQTY
I_CMMDTYORDFILLQTYBYFILLPACKETBasic value for Fill Pkt Filled QtyICMMDTYPKTFLQTY
I_CMMDTYORDFILLQTYBYORDBRACKETBasic View to Calc Bracket Filled QtyICMMDTYBKTFLQTY
I_CMMDTYORDFILLSTATUSTEXTCommodity Order Fill Status TextICMMDTYOFSTTXT
I_CMMDTYORDPRCDQTYBYORDBRACKETBasic View to Calc Bracket Priced QtyICMMDTYBKTPRQTY
I_CMMDTYORDRELTDFILLBYORDFILLBasic View to Count Fill Related FillsICMMPKTRELFLCNT
I_CMMDTYORDREQAGGRGREASONAggregate Reasons for DocICMMDTYDOCRSNAGR
I_CMMDTYORDREQASSGDDOCBYORDREQBasic View to Count Ord Req Assgd DocsICMMORDASGDOCCNT
I_CMMDTYORDREQASSIGNEDFILLAssigned Fills Basic ViewICMMDTYORDREQFIL
I_CMMDTYORDREQBRACKETCmmdty Order Req Bracket Interface ViewICMMDTYORDBKT
I_CMMDTYORDREQBRACKETITMCmmdty Order Bracket Item Interface ViewICMMDTYORDBKTI
I_CMMDTYORDREQBRACKETITMTPCmmdty Ord. Bkt. Item Transactional ViewICMMDTYORDBKTITP
I_CMMDTYORDREQBRACKETTPCmmdty Order Bracket Transactional ViewICMMDTYORDBKTTP
I_CMMDTYORDREQCNTRPTYTEXTCounterparty Information TextICMMDTYCNTPTYTXT
I_CMMDTYORDREQCOUNTERPARTYVHView for Counter Party DetailsICMMDTYCNTRPTY
I_CMMDTYORDREQDOCANDORDREQCustomized Basic View Docs and Ord ReqICMMDTYORDDOCORD
I_CMMDTYORDREQDOCCONTRTYPETEXTCmmdty Ord Req Doc Contract Type TextICMMDTYCTRTYPTXT
I_CMMDTYORDREQDOCNMBROFREASONSAmount of several OR ReasonsICMORDREQRSNCNT
I_CMMDTYORDREQDOCOPNQTYOrd Req Open QuantityICMMDTYORDDOCQTY
I_CMMDTYORDREQDOCPRCGSTSTEXTCmmdty Ord Req Doc Pricing Status TextICMMDTYPCGSTSTXT
I_CMMDTYORDREQDOCSBYORDREQBasic View to Count Assigned DocumentsICMDTYORDDOCCNT
I_CMMDTYORDREQDOCTYPETEXTCmmdty. Drvtv. Document Type Text viewICMMDTYDOCTYPTXT
I_CMMDTYORDREQDOCUMENTCmmdty Order Request Assgined DocumentICMMDTYORDDOC
I_CMMDTYORDREQDOCUMENTTPCmmdty Order Request Assgined DocumentICMMDTYORDDOCTP
I_CMMDTYORDREQEXCHTYPETEXTCmmdty Order Request Exchange Type TextICMMDTYORDEXCTXT
I_CMMDTYORDREQFILLEDVHValue Help View for Order Request StatusICMMDTYREQSTAVH
I_CMMDTYORDREQFILLQTYBYORDREQTotal filled Quantity for Ord Req ViewICMMDTYFILLQTY
I_CMMDTYORDREQMSGAVAILYVHBasic View for Err Msg AvailabilityICMDTYMSGAVL
I_CMMDTYORDREQMSGSBYORDREQBasic View to Count Ord Req MessagesICMDTYORDMSGCNT
I_CMMDTYORDREQMSGTYPETEXTBasic View for Message TypeICMDTYMSGDT
I_CMMDTYORDREQPRICETYPECommodity Order Request Price TypeICMMDTYORDPRTY
I_CMMDTYORDREQQTYTHRESHOLDOrder Request Quantity ThresholdICMMDTYORDQTYTH
I_CMMDTYORDREQREASONTEXTOrder Request Reason TextICMMDTYORDRSTXT
I_CMMDTYORDREQROUNDINGRULECommodity Order Request Rounding RulesICMMDTYORDREQRR
I_CMMDTYORDREQSORTREASONSSorts Number of Reasons for one DocICMMDTYORDREQRSN
I_CMMDTYORDREQSOURCETEXTCommodity Order Request Source TextICMMDTYORDSRCTXT
I_CMMDTYORDREQSTATUSTEXTCommodity Order Request Status TextICMMDTYORDSTSTXT
I_CMMDTYORDREQTIMECALCOrd Req Time CalculationICMMDTYTMCLC
I_CMMDTYORDREQTRADERVHValue Help View for Order Request TraderICMMDTYORDTRADER
I_CMMDTYORDREQUESTKINDTEXTCommodity Order Request Kind TextICMMDTYORDKNDTXT
I_CMMDTYORDREQUESTREASONCmmdty Order Request ReasonICMMDTYORDRSNTXT
I_CMMDTYORDREQUESTTYPETEXTCommodity Order Request Type TextICMMDTYORDTYPTXT
I_CMMDTYORDSELFMATCHPREVENTIONBasic View for Self Match PreventionICMMDTYSMP
I_CMMDTYORDTOBEPRCDQTYBYORDREQCmmdty Ord Request To Be Priced QuantityICMMDTYTOPRCQTY
I_CMMDTYORDWRNGMSGSBYORDREQBasic View to Count Ord Req Warning MsgsICMDTYORDWRNGCNT
I_CMMDTYPRCGEXECINSTRNTEXTPricing Execution InstructionsICMMDTYPRCGTXT
I_CMMDTYRELATEDBRACKETBYORDREQBasic View to Count Ord Rltd BracketsICMMORDRLBKTCNT
I_CMMDTYRELTDORDREQBYORDREQDOCBasic View to Count Doc Related OrdsICMMDOCRLORDCNT
I_CMMDTYSUBACCTBROKERVHView for Commodity Subaccount BrokerICMMDTYSABROKER
I_CMMDTYSUBACCTCHARCMAPPGCommodity Sub Account Free Characteristics MappingICMMSACHARCMPG
I_CMMDTYSUBACCTCLRGACCTVHBroker Clearing AccountsICMMDTYCLRGACCT
I_CMMDTYSUBACCTFOOTPRINTCommodity Subaccount On FootprintICMMDTYSAONFP
I_CMMDTYSUBACCTMAPPEDEXTERNALJoin Subacct with mapping table depending on derivation modeICMMSAMPGEXT
I_CMMDTYSUBACCTMAPPINGVHValue Help for Active/Inactive SubAccICMMDTYSUBMAPVH
I_CMMDTYSUBACCTREFACCTVHCounterparty Broker Reference AccountsICMMDTYREFACCT
I_CMMDTYSUBACCTSTATUSTEXTCommodity Subaccount Status TextICMMDTYSASTSTXT
I_CMMDTYSUBACCTSTATUSVHValue help view for Subaccount StatusISUBACCTSTATUSVH
I_CMMDTYWRNGMSGSBYFILLPACKETFill Packet Warning Message CountICMDTYPKTWRNGCNT
I_COMMODITYORDERFILLCommodity Order FillICMMDTYORDERFILL
I_COMMODITYORDERFILLPACKETBasic View for Cmmdty Deriv Ord Fill PktICMMDTYORDFLPKT
I_COMMODITYORDERFILLTPCommodity Order Fill Transactional ViewICMMDTYORDFILLTP
I_COMMODITYORDERFILLTYPECommodity Order Fill TypeICMMDTYORDFILLTY
I_COMMODITYORDERLEGCommodity Derivative Order Leg DetailsICOMMODITYORDLEG
I_COMMODITYORDERREQUESTCommodity Order Request Interface ViewICMMDTYORDREQ
I_COMMODITYORDERREQUESTFILLBasic View for Commodity Order FillICMMDTYORDFILL
I_COMMODITYORDERREQUESTTPCommodity Order Req. Transactional ViewICMMDTYORDREQTP
I_COMMODITYORDERREQUESTVHValue Help View for Order RequestICMMDTYORDVH
I_COMMODITYORDFILLKINDTEXTView for Commodity Order Fill Kind TextICMMDTYFIKINDTXT
I_COMMODITYORDFILLPACKETLOGBasic View for a Commodity Derivative Order Fill Packet LogICMDTYFLPKTLOG
I_COMMODITYORDFILLPACKETLOGTPTransactional View for a Cmmdty Deriv Ord Fill Packet LogICMDTYFLPKTLOGTP
I_COMMODITYORDFILLPACKETTPTran. View for Cmmdty Deriv Ord Fill PktICMMDTYFLPKTTP
I_COMMODITYORDFILLTYPETEXTView for Commodity Derivative Order Fill Type TextICMMDTYFILLTYPET
I_COMMODITYSUBACCOUNTCommodity SubaccountICMMDTYSUBACCT
I_COMMODITYSUBACCOUNTTEXTCommodity Subaccount TextICMMDTYSATXT
I_COMMODITYSUBACCOUNTTPCommodity Subaccount Transactional ViewICMMDTYSUBACCTTP
I_COMMODITYSUBACCOUNTVHCommodity Subaccount Value Help ViewICMMDTYDRVTVSA
P_CMMDTYDRVTVORDTRDEXECTMESTMPRecent Changes time for UI AppPCMMDTYRCNTMSTMP
P_CMMDTYORDFILLPACKETFIRSTFILLPrivate view for First Fill of Fill PacketPCMMDTYPKTFRSTFL
P_CMMDTYORDFILLPRCDQTYBYORDREQTotal Priced Quantity for Ord Req ViewPCMMDTYPRCDQTY
P_CMMDTYORDREQBRACKETUOMPrivate View for Order Bracket UOMPCMMDTYBKTUOM
P_CMMDTYSUBACCDCSCMMDTYVALFROMPrivate View for DCS Cmmdty Valid FromPCMMDTYVALFRM