BO_ID_1BO_ID_2RC_AGR_REL_VW(SQL View) |
Index Back |
|---|---|
Agreement ViewCall Center Agreement View for BO Search Setup |
| SELECT B.BO_ID_CONTACT , A.BO_ID_CUST , A.AGREEMENT_CODE FROM PS_RF_AGREEMENT A , PS_RF_AGR_CONTACT B WHERE A.AGRT_STATUS = '005' AND A.SETID = B.SETID AND A.AGREEMENT_CODE = B.AGREEMENT_CODE AND A.AGR_RENEWAL_NUM = B.AGR_RENEWAL_NUM AND A.AGR_SCOPE = 'CONT' |
| # | 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 | AGREEMENT_CODE | Character(30) | VARCHAR2(30) NOT NULL | This field represents the agreement code (name) for an agreement |