RSF_RFRD_BY_VW(SQL View) |
Index Back |
---|---|
Business Object NameCRM Sales - View of all Business Object Names |
SELECT B.BO_ID , B.PRIMARY_IND , B.BO_NAME_DISPLAY , B.BO_NAME_DISP_UPPER FROM PS_BO_NAME B , PS_RSF_LEAD L WHERE L.BO_ID_REFERRED_BY = B.BO_ID |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BO_ID_REFERRED_BY | Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID of Referred By (for Partners). |
2 | PRIMARY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Flag that indicates whether or not it is Primary
N=No Y=Yes |
3 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
4 | BO_NAME_DISP_UPPER | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object in Upper |