RSFD_RV_TYPE_VW

(SQL View)
 Index Back

Revenue Type for Dashboard

Dashboard view on revenue type descriptors.

SELECT REVENUE_TYPE , DESCR , REVENUE_DIMENSION1 , REVENUE_DIMENSION2 FROM PS_RSF_REV_TYPE WHERE STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 REVENUE_TYPE Character(15) VARCHAR2(15) NOT NULL This field is used to store revenue type related to a product sales and used within forecasting.
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
3 REVENUE_DIMENSION1 Character(15) VARCHAR2(15) NOT NULL Descriptor of revenue category for forecast.
4 REVENUE_DIMENSION2 Character(15) VARCHAR2(15) NOT NULL Descriptor of revenue category for forecast.