C_CmmdtyOrderFillStaging

Consumption View for staging table | view: CCMMFILLSTG | Extraction: Not supported | Component: Commodity Derivative Order and Trade Execution
Tables used: CMMFDAI_D_STGFIX, CMMFDOR_C_PREXEC, CMMFDOR_C_PREXET, CMMFDOR_D_PRCGET, CMMFDOR_D_PRCGEX, CMMFDOF_C_FILLTT, CMMFDOF_C_FILLTY
Column Name Description
CmmdtyFillStagUUID UUID serving as key (parent key, root key)
Column Name Description
Column Name Description
Column Name Description
CmmdtyFixMsgStagedDate Fix message received on Date
CmmdtyFixMsgStagedTime Fix message received on Time
CmmdtyFixStagedLastProcDate Fix message Last processing Date
CmmdtyFixStagedLastProcTime Fix message Last processing Time
Column Name Description
CmmdtyOrderRequestFlowType Commodity Derivative Order Request Flow Type Show values
CmmdtyOrderReqLegOwnerRole Commodity Derivative Order Leg Owner Show values
CmmdtyOrdFillMultiLegType Multileg Type Show values
CmmdtyFixType Fix Type Show values
CmmdtyFixAction Inbound FIX Action Show values
CmmdtyOrdReqPrcgExecInstrnCat Pricing and Execution Instruction Category Show values
CmmdtyOrderIsFillWithOrder Commodity Derivative Fill Uploaded With Order Show values
CmmdtyFixMsgStagingStatus Fix Message staging status Show values
Column Name Description Domain name
CommodityOrderRequest Commodity Order Request ID CMMFDOF_CMMDTYORDERREQUESTID
CmmdtyDerivativeFlowTypeText Short Text for Fixed Values DDTEXT
MarketIdentifierCode Market Identifier Code TBA_MIC
CmmdtyOrderFillRequestType Commodity Derivative Fill Packet Type CMMFDOF_FILLTYPE
CmmdtyOrderFillRequestTypeDesc Fill Packet Type Description CMMFDOF_FILLTYPEDESCRIPTION
CmmdtyOrderFillCounterParty Commodity Order Fill Counter Party BU_PARTNER
CmmdtyOrdReqCntrPtyBroker Counterparty Broker CMMFSA_COUNTERPARTY_BROKER
ReferenceBrokerAccount Counterparty Reference Account CMMFSA_REFERENCEBROKERACCOUNT
CommoditySubAccount Commodity Subaccount ID CMMFSA_SUBACCOUNTID
CmmdtyOrdReqCntrPtySubAcct Commodity Order Request Counterparty Subaccount CMMFSA_SUBACCOUNTID
CmmdtyOrderFillQuantityInLots Commodity Order Fill Quantity In Lots INT4
CmmdtyMaturityMonthYear Maturity Key Date (YYYYMMDD) Or Year/Month(YYYYMM) CMMFDOF_AIF_MATURITY_MON_YR
CommodityProductSymbol Product Symbol CMMFDOF_PRODUCT_SYMBOL
CmmdtyOrderFillDateTime Transaction Time TZNTSTMPS
CmmdtyOrdRequestQuantityInLot Order Quantity In Lots CMMFDOF_CMMDTYFLPKTFLEDQTYLOTS
CmmdtyOrdReqRmngQtyInLots Remaining Quantity In Lots CMMFDOF_CMMDTYFLPKTRMGQTYLOTS
CmmdtyFillPacketMsgOrdID Commodity Order Fill External Source Reference CMMFDOF_CMMDTYORDFILLEXTORDREF
CmmdtyFillPacketTrdExecutionID Commodity Order Fill Trade Execution ID CMMFDOF_CMMDTYORDFILLTRDEXECID
CmmdtyOrderFillPrice Fill Price of Commodity Derivative Order CMMFDOF_CMMDTYORDERFILLPRICECH
CommodityOrderRequestTicks Commodity Order Request Ticks CMMFDOR_ORDREQTICKS
CmmdtyOrdFillMultiLegTypeText Short Text for Fixed Values DDTEXT
CommodityOrderRequestTrader Trader RDEALER
CommodityOrderRequestUUID UUID serving as key (parent key, root key) SYSUUID
CmmdtyOrderReqRejectionReason Commodity Derivative Order Request Rejection Reason CMMFDOR_ORDERREQREJREASON
CommodityOrderRequestComment Commodity Derivative Order Request Comment CMMFDOR_ORDERREQUESTCOMMENT
CmmdtyFixTypeText Short Text for Fixed Values DDTEXT
CmmdtyFixActionText Short Text for Fixed Values DDTEXT
CmmdtyOrdReqPrcExecInsText Cmmdty Drvtv Order Pricing Execution Instruction Description DDTEXT
CommodityOrderFillPacketUUID UUID serving as key (parent key, root key) SYSUUID
CmmdtyOrderRequestType Commodity Derivative Order Request Type CMMFDOR_ORDERTYPE
CmmdtyFixMsgProcessingGroup Fix message processing group CMMFDAI_FIXMSG_PROCESSING_GRP
CmmdtyFixMsgStagingStatusText Short Text for Fixed Values DDTEXT