eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BIM.BIM_EDW_RVCT_MTH_F#

Source

View Text - Preformatted


select REVCOST_PK_KEY REVCOST_PK_KEY, REVCOST_PK REVCOST_PK, CMPGN_FK_KEY CMPGN_FK_KEY, CMPGN_STATUS_FK_KEY CMPGN_STATUS_FK_KEY, EVENT_FK_KEY EVENT_FK_KEY, MEDCHNL_FK_KEY MEDCHNL_FK_KEY, MKTSGMT_FK_KEY MKTSGMT_FK_KEY, TGTSGMT_FK_KEY TGTSGMT_FK_KEY, SRCLST_FK_KEY SRCLST_FK_KEY, HEADER_OFFER_FK_KEY HEADER_OFFER_FK_KEY, LINE_OFFER_FK_KEY LINE_OFFER_FK_KEY, LEAD_FK_KEY LEAD_FK_KEY, LEADSTATUS_FK_KEY LEADSTATUS_FK_KEY, OPPORTUNITY_FK_KEY OPPORTUNITY_FK_KEY, OPPSTATUS_FK_KEY OPPSTATUS_FK_KEY, CUSTOMER_FK_KEY CUSTOMER_FK_KEY, TIME_FK_KEY TIME_FK_KEY, ORG_FK_KEY ORG_FK_KEY, ITEM_FK_KEY ITEM_FK_KEY, UOM_FK_KEY UOM_FK_KEY, SLSCHNL_FK_KEY SLSCHNL_FK_KEY, BASE_CURRENCY_FK_KEY BASE_CURRENCY_FK_KEY, GLOBAL_CURRENCY_FK_KEY GLOBAL_CURRENCY_FK_KEY, TRX_CURRENCY_FK_KEY TRX_CURRENCY_FK_KEY, BILL_TO_SITE_FK_KEY BILL_TO_SITE_FK_KEY, SHIP_TO_SITE_FK_KEY SHIP_TO_SITE_FK_KEY, CMPGN_ACTUAL_COST_G CMPGN_ACTUAL_COST_G, CMPGN_ACTUAL_COST_B CMPGN_ACTUAL_COST_B, CMPGN_ACTUAL_COST_T CMPGN_ACTUAL_COST_T, CMPGN_FRCST_COST_G CMPGN_FRCST_COST_G, CMPGN_FRCST_COST_B CMPGN_FRCST_COST_B, CMPGN_FRCST_COST_T CMPGN_FRCST_COST_T, CMPGN_FRCST_REVENUE_G CMPGN_FRCST_REVENUE_G, CMPGN_FRCST_REVENUE_B CMPGN_FRCST_REVENUE_B, CMPGN_FRCST_REVENUE_T CMPGN_FRCST_REVENUE_T, EVENT_ACTUAL_COST_G EVENT_ACTUAL_COST_G, EVENT_ACTUAL_COST_B EVENT_ACTUAL_COST_B, EVENT_ACTUAL_COST_T EVENT_ACTUAL_COST_T, EVENT_REGISTRATION_REVENUE_G EVENT_REGISTRATION_REVENUE_G, EVENT_REGISTRATION_REVENUE_B EVENT_REGISTRATION_REVENUE_B, EVENT_REGISTRATION_REVENUE_T EVENT_REGISTRATION_REVENUE_T, EVENT_FRCST_COST_G EVENT_FRCST_COST_G, EVENT_FRCST_COST_B EVENT_FRCST_COST_B, EVENT_FRCST_COST_T EVENT_FRCST_COST_T, EVENT_FRCST_REVENUE_G EVENT_FRCST_REVENUE_G, EVENT_FRCST_REVENUE_B EVENT_FRCST_REVENUE_B, EVENT_FRCST_REVENUE_T EVENT_FRCST_REVENUE_T, EVENT_NUMBER_CANCELLED EVENT_NUMBER_CANCELLED, EVENT_NUMBER_ATTENDED EVENT_NUMBER_ATTENDED, EVENT_NUMBER_AVAILABLE EVENT_NUMBER_AVAILABLE, EVENT_NUMBER_ENROLLED EVENT_NUMBER_ENROLLED, NUMBER_TARGETED NUMBER_TARGETED, NUMBER_RESPONDED NUMBER_RESPONDED, LEAD_AMOUNT_G LEAD_AMOUNT_G, LEAD_AMOUNT_B LEAD_AMOUNT_B, LEAD_AMOUNT_T LEAD_AMOUNT_T, OPPORTUNITY_AMOUNT_G OPPORTUNITY_AMOUNT_G, OPPORTUNITY_AMOUNT_B OPPORTUNITY_AMOUNT_B, OPPORTUNITY_AMOUNT_T OPPORTUNITY_AMOUNT_T, SLIST_ACTUAL_COST_G SLIST_ACTUAL_COST_G, SLIST_ACTUAL_COST_B SLIST_ACTUAL_COST_B, SLIST_ACTUAL_COST_T SLIST_ACTUAL_COST_T, COGS_G COGS_G, COGS_B COGS_B, COGS_T COGS_T, ACTUAL_REVENUE_G ACTUAL_REVENUE_G, ACTUAL_REVENUE_B ACTUAL_REVENUE_B, ACTUAL_REVENUE_T ACTUAL_REVENUE_T, INITIATED_REVENUE_G INITIATED_REVENUE_G, INITIATED_REVENUE_B INITIATED_REVENUE_B, INITIATED_REVENUE_T INITIATED_REVENUE_T, USER_MEASURE1 USER_MEASURE1, USER_MEASURE2 USER_MEASURE2, USER_MEASURE3 USER_MEASURE3, USER_MEASURE4 USER_MEASURE4, USER_MEASURE5 USER_MEASURE5, USER_FK1_KEY USER_FK1_KEY, USER_FK2_KEY USER_FK2_KEY, USER_FK3_KEY USER_FK3_KEY, USER_FK4_KEY USER_FK4_KEY, USER_FK5_KEY USER_FK5_KEY, USER_ATTRIBUTE1 USER_ATTRIBUTE1, USER_ATTRIBUTE2 USER_ATTRIBUTE2, USER_ATTRIBUTE3 USER_ATTRIBUTE3, USER_ATTRIBUTE4 USER_ATTRIBUTE4, USER_ATTRIBUTE5 USER_ATTRIBUTE5, USER_ATTRIBUTE6 USER_ATTRIBUTE6, USER_ATTRIBUTE7 USER_ATTRIBUTE7, USER_ATTRIBUTE8 USER_ATTRIBUTE8, USER_ATTRIBUTE9 USER_ATTRIBUTE9, USER_ATTRIBUTE10 USER_ATTRIBUTE10, USER_ATTRIBUTE11 USER_ATTRIBUTE11, USER_ATTRIBUTE12 USER_ATTRIBUTE12, USER_ATTRIBUTE13 USER_ATTRIBUTE13, USER_ATTRIBUTE14 USER_ATTRIBUTE14, USER_ATTRIBUTE15 USER_ATTRIBUTE15, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, INITIATED_COGS_G INITIATED_COGS_G, INITIATED_COGS_B INITIATED_COGS_B, INITIATED_COGS_T INITIATED_COGS_T, ACTUAL_COGS_G ACTUAL_COGS_G, ACTUAL_COGS_B ACTUAL_COGS_B, ACTUAL_COGS_T ACTUAL_COGS_T, INITIATED_ORDER_AMT_G INITIATED_ORDER_AMT_G, INITIATED_ORDER_AMT_B INITIATED_ORDER_AMT_B, INITIATED_ORDER_AMT_T INITIATED_ORDER_AMT_T, ACTUAL_ORDER_AMT_G ACTUAL_ORDER_AMT_G, ACTUAL_ORDER_AMT_B ACTUAL_ORDER_AMT_B, ACTUAL_ORDER_AMT_T ACTUAL_ORDER_AMT_T, INITIATED_NO_OF_ORDERS INITIATED_NO_OF_ORDERS, ACTUAL_NO_OF_ORDERS ACTUAL_NO_OF_ORDERS from "BIM"."BIM_EDW_RVCT_MTH_F"

View Text - HTML Formatted

SELECT REVCOST_PK_KEY REVCOST_PK_KEY
, REVCOST_PK REVCOST_PK
, CMPGN_FK_KEY CMPGN_FK_KEY
, CMPGN_STATUS_FK_KEY CMPGN_STATUS_FK_KEY
, EVENT_FK_KEY EVENT_FK_KEY
, MEDCHNL_FK_KEY MEDCHNL_FK_KEY
, MKTSGMT_FK_KEY MKTSGMT_FK_KEY
, TGTSGMT_FK_KEY TGTSGMT_FK_KEY
, SRCLST_FK_KEY SRCLST_FK_KEY
, HEADER_OFFER_FK_KEY HEADER_OFFER_FK_KEY
, LINE_OFFER_FK_KEY LINE_OFFER_FK_KEY
, LEAD_FK_KEY LEAD_FK_KEY
, LEADSTATUS_FK_KEY LEADSTATUS_FK_KEY
, OPPORTUNITY_FK_KEY OPPORTUNITY_FK_KEY
, OPPSTATUS_FK_KEY OPPSTATUS_FK_KEY
, CUSTOMER_FK_KEY CUSTOMER_FK_KEY
, TIME_FK_KEY TIME_FK_KEY
, ORG_FK_KEY ORG_FK_KEY
, ITEM_FK_KEY ITEM_FK_KEY
, UOM_FK_KEY UOM_FK_KEY
, SLSCHNL_FK_KEY SLSCHNL_FK_KEY
, BASE_CURRENCY_FK_KEY BASE_CURRENCY_FK_KEY
, GLOBAL_CURRENCY_FK_KEY GLOBAL_CURRENCY_FK_KEY
, TRX_CURRENCY_FK_KEY TRX_CURRENCY_FK_KEY
, BILL_TO_SITE_FK_KEY BILL_TO_SITE_FK_KEY
, SHIP_TO_SITE_FK_KEY SHIP_TO_SITE_FK_KEY
, CMPGN_ACTUAL_COST_G CMPGN_ACTUAL_COST_G
, CMPGN_ACTUAL_COST_B CMPGN_ACTUAL_COST_B
, CMPGN_ACTUAL_COST_T CMPGN_ACTUAL_COST_T
, CMPGN_FRCST_COST_G CMPGN_FRCST_COST_G
, CMPGN_FRCST_COST_B CMPGN_FRCST_COST_B
, CMPGN_FRCST_COST_T CMPGN_FRCST_COST_T
, CMPGN_FRCST_REVENUE_G CMPGN_FRCST_REVENUE_G
, CMPGN_FRCST_REVENUE_B CMPGN_FRCST_REVENUE_B
, CMPGN_FRCST_REVENUE_T CMPGN_FRCST_REVENUE_T
, EVENT_ACTUAL_COST_G EVENT_ACTUAL_COST_G
, EVENT_ACTUAL_COST_B EVENT_ACTUAL_COST_B
, EVENT_ACTUAL_COST_T EVENT_ACTUAL_COST_T
, EVENT_REGISTRATION_REVENUE_G EVENT_REGISTRATION_REVENUE_G
, EVENT_REGISTRATION_REVENUE_B EVENT_REGISTRATION_REVENUE_B
, EVENT_REGISTRATION_REVENUE_T EVENT_REGISTRATION_REVENUE_T
, EVENT_FRCST_COST_G EVENT_FRCST_COST_G
, EVENT_FRCST_COST_B EVENT_FRCST_COST_B
, EVENT_FRCST_COST_T EVENT_FRCST_COST_T
, EVENT_FRCST_REVENUE_G EVENT_FRCST_REVENUE_G
, EVENT_FRCST_REVENUE_B EVENT_FRCST_REVENUE_B
, EVENT_FRCST_REVENUE_T EVENT_FRCST_REVENUE_T
, EVENT_NUMBER_CANCELLED EVENT_NUMBER_CANCELLED
, EVENT_NUMBER_ATTENDED EVENT_NUMBER_ATTENDED
, EVENT_NUMBER_AVAILABLE EVENT_NUMBER_AVAILABLE
, EVENT_NUMBER_ENROLLED EVENT_NUMBER_ENROLLED
, NUMBER_TARGETED NUMBER_TARGETED
, NUMBER_RESPONDED NUMBER_RESPONDED
, LEAD_AMOUNT_G LEAD_AMOUNT_G
, LEAD_AMOUNT_B LEAD_AMOUNT_B
, LEAD_AMOUNT_T LEAD_AMOUNT_T
, OPPORTUNITY_AMOUNT_G OPPORTUNITY_AMOUNT_G
, OPPORTUNITY_AMOUNT_B OPPORTUNITY_AMOUNT_B
, OPPORTUNITY_AMOUNT_T OPPORTUNITY_AMOUNT_T
, SLIST_ACTUAL_COST_G SLIST_ACTUAL_COST_G
, SLIST_ACTUAL_COST_B SLIST_ACTUAL_COST_B
, SLIST_ACTUAL_COST_T SLIST_ACTUAL_COST_T
, COGS_G COGS_G
, COGS_B COGS_B
, COGS_T COGS_T
, ACTUAL_REVENUE_G ACTUAL_REVENUE_G
, ACTUAL_REVENUE_B ACTUAL_REVENUE_B
, ACTUAL_REVENUE_T ACTUAL_REVENUE_T
, INITIATED_REVENUE_G INITIATED_REVENUE_G
, INITIATED_REVENUE_B INITIATED_REVENUE_B
, INITIATED_REVENUE_T INITIATED_REVENUE_T
, USER_MEASURE1 USER_MEASURE1
, USER_MEASURE2 USER_MEASURE2
, USER_MEASURE3 USER_MEASURE3
, USER_MEASURE4 USER_MEASURE4
, USER_MEASURE5 USER_MEASURE5
, USER_FK1_KEY USER_FK1_KEY
, USER_FK2_KEY USER_FK2_KEY
, USER_FK3_KEY USER_FK3_KEY
, USER_FK4_KEY USER_FK4_KEY
, USER_FK5_KEY USER_FK5_KEY
, USER_ATTRIBUTE1 USER_ATTRIBUTE1
, USER_ATTRIBUTE2 USER_ATTRIBUTE2
, USER_ATTRIBUTE3 USER_ATTRIBUTE3
, USER_ATTRIBUTE4 USER_ATTRIBUTE4
, USER_ATTRIBUTE5 USER_ATTRIBUTE5
, USER_ATTRIBUTE6 USER_ATTRIBUTE6
, USER_ATTRIBUTE7 USER_ATTRIBUTE7
, USER_ATTRIBUTE8 USER_ATTRIBUTE8
, USER_ATTRIBUTE9 USER_ATTRIBUTE9
, USER_ATTRIBUTE10 USER_ATTRIBUTE10
, USER_ATTRIBUTE11 USER_ATTRIBUTE11
, USER_ATTRIBUTE12 USER_ATTRIBUTE12
, USER_ATTRIBUTE13 USER_ATTRIBUTE13
, USER_ATTRIBUTE14 USER_ATTRIBUTE14
, USER_ATTRIBUTE15 USER_ATTRIBUTE15
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, INITIATED_COGS_G INITIATED_COGS_G
, INITIATED_COGS_B INITIATED_COGS_B
, INITIATED_COGS_T INITIATED_COGS_T
, ACTUAL_COGS_G ACTUAL_COGS_G
, ACTUAL_COGS_B ACTUAL_COGS_B
, ACTUAL_COGS_T ACTUAL_COGS_T
, INITIATED_ORDER_AMT_G INITIATED_ORDER_AMT_G
, INITIATED_ORDER_AMT_B INITIATED_ORDER_AMT_B
, INITIATED_ORDER_AMT_T INITIATED_ORDER_AMT_T
, ACTUAL_ORDER_AMT_G ACTUAL_ORDER_AMT_G
, ACTUAL_ORDER_AMT_B ACTUAL_ORDER_AMT_B
, ACTUAL_ORDER_AMT_T ACTUAL_ORDER_AMT_T
, INITIATED_NO_OF_ORDERS INITIATED_NO_OF_ORDERS
, ACTUAL_NO_OF_ORDERS ACTUAL_NO_OF_ORDERS
FROM "BIM"."BIM_EDW_RVCT_MTH_F"