RF_INST_PROD_VW (SQL View)	Index Back
Installed Product View Installed Product View to obtain the SetId for the Site

RF_INST_PROD_VW

(SQL View)

Installed Product View

Installed Product View to obtain the SetId for the Site

SELECT A.SETID ,A.INST_PROD_ID ,A.BO_ID_CUST ,A.ROLE_TYPE_ID_CUST ,A.SITE_ID ,A.PRODUCT_ID ,A.SERIAL_ID ,A.ASSETTAG ,A.PARENT_INST_PRODID ,B.SETID FROM PS_RF_INST_PROD A , PS_SET_CNTRL_REC B WHERE A.SETID=B.SETCNTRLVALUE AND B.RECNAME='RD_SITE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW

2 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)
Default Value: NEXT

3 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

4 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

5 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: RF_COMPSITE3_VW
Set Control Field: SETID

6 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
Prompt Table: RF_PROD_PMPT_VW

7 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product

8 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag

9 PARENT_INST_PRODID Character(20) VARCHAR2(20) NOT NULL This field is used to store the installed product ID of the parent installed product
Prompt Table: RF_IPRD_CUST_VW

10 SETID_WRK Character(5) VARCHAR2(5) NOT NULL SetID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW
2	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field) Default Value: NEXT
3	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
4	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
5	SITE_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. Prompt Table: RF_COMPSITE3_VW Set Control Field: SETID
6	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID Prompt Table: RF_PROD_PMPT_VW
7	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product
8	ASSETTAG	Character(40)	VARCHAR2(40) NOT NULL	Asset Tag
9	PARENT_INST_PRODID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to store the installed product ID of the parent installed product Prompt Table: RF_IPRD_CUST_VW
10	SETID_WRK	Character(5)	VARCHAR2(5) NOT NULL	SetID