DP_PUBFCSQUA1VW (SQL View)	Index Back
DP_PUBRLFCITMVW DP_PUBRLFCITMVW

DP_PUBFCSQUA1VW

(SQL View)

DP_PUBRLFCITMVW

SELECT DISTINCT A.OPRID , B.DP_PUBLISHNAME , D.DP_CONFIGVIEW , B.SUBCUST_QUAL1 FROM PS_DP_ROLEFCITMVW4 A , PS_DP_PUB_FCITEMS B , PS_DP_PUB_FCAST D WHERE A.DP_CONFIGVIEW = D.DP_CONFIGVIEW AND A.DP_CONFIGLEVEL = D.DP_CONFIGLEVEL AND B.DP_PUBLISHNAME = D.DP_PUBLISHNAME AND B.DP_PUBLISH_DATE = D.DP_PUBLISH_DATE AND A.DP_FORECASTITEM = B.DP_FORECASTITEM

Parent record: DP_PUB_FCAST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 DP_PUBLISHNAME Character(20) VARCHAR2(20) NOT NULL Publish Name

3 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
Prompt Table: %EDITTABLE

4 SUBCUST_QUAL1 Character(15) VARCHAR2(15) NOT NULL Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	DP_PUBLISHNAME	Character(20)	VARCHAR2(20) NOT NULL	Publish Name
3	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW Prompt Table: %EDITTABLE
4	SUBCUST_QUAL1	Character(15)	VARCHAR2(15) NOT NULL	Specifies a user-defined grouping of customer receivables activity. A subcustomer qualifier provides the ability to record and report receivables activity across multiple business units and/or multiple customers. For example a subcustomer qualifier could represent a sales region or a geographic area. There are two possible subcustomer qualifiers: SUBCUST_QUAL1 and SUBCUST_QUAL2.