BO_ID_CONTACTREL_TYPE_IDPrompt Table: RB_VALID_RELTYP
BO_ID_1RIT_RELTYPE2_VW(SQL View) |
Index Back |
|---|---|
Bus Object Relationship InstanAn instance of a relationship between Business Objects |
| SELECT DISTINCT a.BO_ID_1 , a.REL_TYPE_ID , a.BO_ID_2 , b.BO_NAME , c.BO_NAME FROM PS_BO_REL a , PS_BO b , PS_BO c WHERE a.BO_ID_1 = b.BO_ID AND a.BO_ID_2 = c.BO_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BO_ID_CONTACT |
Number(31,0) | DECIMAL(31) NOT NULL | This field indicates the Business Object ID for the contact. |
| 2 | REL_TYPE_ID |
Number(12,0) | DECIMAL(12) NOT NULL |
Relationship Type ID
Prompt Table: RB_VALID_RELTYP |
| 3 | BO_ID_1 |
Signed Number(32,0) | DECIMAL(31) NOT NULL | Business Object ID 1 |
| 4 | BO_NAME_1 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 1 |
| 5 | BO_NAME_2 | Character(50) | VARCHAR2(50) NOT NULL | BO Name 2 |