RC_SERIAL_RELVW

(SQL View)
 Index Back

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_1 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 1
2 BO_ID_2 Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID 2
3 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the Serial ID of an item or installed product