RSF_FCFLT_CU_V2

(SQL View)
Index Back

Forecast Filter Customer VW

Forecast Filter view on customer name via forecast and bo_id.

SELECT DISTINCT BO_ID_CUST , NAME1 FROM PS_RSF_FCAST_DTL WHERE BO_ID_CUST <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.
2 NAME1 Character(50) VARCHAR2(50) NOT NULL Generic 50 character name field for storing names.