RC_ASSET_VW5

(SQL View)
 Index Back

Asset Tag Search Record

This is a search record to return Asset Tag values for business object search.

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.ASSETTAG 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.ASSETTAG <> ' '

# 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 ASSETTAG Character(40) VARCHAR2(40) NOT NULL Asset Tag