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: BIL_FCTV_COMP_REVENUE

Product:	BIL - Sales Intelligence (Obsolete)
Description:	Quantitative measure related to revenue return on sales compensation
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT CPS.PERIOD_NAME
, CL.PROCESSED_DATE
, JRS.RESOURCE_ID
, CH.ORG_ID
, CL.ROLE_ID
, CQA.COMP_PLAN_ID
, CH.SALES_CHANNEL
, CH.INVENTORY_ITEM_ID
, CH.COMMISSION_HEADER_ID
, CL.COMMISSION_LINE_ID
, CQ.QUOTA_ID
, CL.COMMISSION_AMOUNT
, CH.TRANSACTION_AMOUNT
, JRRE.COMPENSATION_CURRENCY_CODE
, CH.TRANSACTION_AMOUNT_ORIG
, CH.ORIG_CURRENCY_CODE
FROM CN_PERIOD_STATUSES_ALL CPS
, CN_QUOTA_ASSIGNS_ALL CQA
, CN_QUOTAS_ALL CQ
, CN_COMMISSION_LINES_ALL CL
, CN_COMMISSION_HEADERS_ALL CH
, CN_CREDIT_TYPES_ALL_B CCTB
, JTF_RS_SALESREPS JRS
, JTF_RS_RESOURCE_EXTNS JRRE
WHERE CH.COMMISSION_HEADER_ID = CL.COMMISSION_HEADER_ID
AND CH.PROCESSED_PERIOD_ID = CPS.PERIOD_ID
AND CL.QUOTA_ID = CQ.QUOTA_ID
AND CQA.QUOTA_ID = CQ.QUOTA_ID
AND CQ.CREDIT_TYPE_ID = CCTB.CREDIT_TYPE_ID
AND UPPER(CCTB.MONETARY_FLAG) = 'Y'
AND UPPER(CL.STATUS) = ('CALC')
AND JRS.SALESREP_ID = CL.CREDITED_SALESREP_ID
AND JRS.RESOURCE_ID = JRRE.RESOURCE_ID
AND JRS.ORG_ID = CH.ORG_ID WITH READ ONLY

Columns

Name
PERIOD_NAME
PROCESSED_DATE
SALESFORCE_FK
ORG_FK
ROLE_FK
COMP_PLAN_FK
SALES_CHANNEL_FK
INVENTORY_ITEM_FK
COMMISSION_HDR_FK
COMMISSION_LINE_FK
QUOTA_FK
COMMISSION_AMOUNT
SALES_CREDIT_AMOUNT
SALES_CREDIT_CURRENCY_CODE
TRANSACTION_AMOUNT_ORIG
CURRENCY_CODE_ORIG