RC_SERIAL_VW (SQL View)	Index Back
Serial ID view Used in Customer ID BO Search Setup Components. Identifies Customers based on Serial Number

RC_SERIAL_VW

(SQL View)

Serial ID view

Used in Customer ID BO Search Setup Components. Identifies Customers based on Serial Number

SELECT CASE WHEN A.BO_ID_CONTACT > 0 THEN A.BO_ID_CONTACT WHEN A.BO_ID_CONTACT = 0 THEN A.BO_ID_CUST END , A.BO_ID_CUST , A.SERIAL_ID FROM PS_RF_INST_PROD A , PS_RF_INST_PROD_ST B WHERE A.SETID = B.SETID AND A.INST_PROD_ID = B.INST_PROD_ID AND B.INST_PROD_STATUS <> 'UNI' AND A.SERIAL_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
3	SERIAL_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the Serial ID of an item or installed product