BO_ID_CUSTBO_ID_CONTACTRB_BC_REP_VW01(SQL View) |
Index Back |
|---|---|
ContactContact view to have all contacts. CDM view. |
| SELECT DISTINCT A.BO_ID , B.BO_ID_1 , D.BO_NAME , C.BO_NAME , F.BO_NAME_AC , D.BO_NAME , F.BO_NAME_AC , F.BO_NAME_DISPLAY , F.FIRST_NAME , F.LAST_NAME FROM PS_BC A , PS_BO_REL B , PS_BO C , PS_BO D , PS_BO_REL_CAT_ITEM E , PS_BO_NAME F WHERE A.BO_ID = B.BO_ID_2 AND A.CUSTOMER_IND = 'Y' AND B.REL_TYPE_ID = E.REL_TYPE_ID AND E.BO_REL_CATEGORY_ID IN (1, 2) AND C.BO_ID = B.BO_ID_2 AND D.BO_ID = B.BO_ID_1 AND F.BO_ID = B.BO_ID_1 AND B.START_DT <= %CurrentDateIn AND (B.END_DT > %CurrentDateIn OR B.END_DT IS NULL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_CUST |
Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 2 | BO_ID_CONTACT |
Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 3 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | BO_NAME_1 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 1 |
| 5 | BO_NAME_PARENT_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 6 | BO_NAME_2 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 2 |
| 7 | BO_NAME_AC | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 8 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 9 | FIRST_NAME | Character(30) | VARCHAR2(30) NOT NULL | First Name |
| 10 | LAST_NAME | Character(30) | VARCHAR2(30) NOT NULL | Last Name |