RO_AGREECODE_VW(SQL View) |
Index Back |
|---|---|
View of customer's agreementsView of this customer's current agreement codes. |
| SELECT MAX(AGR_RENEWAL_NUM) , AGREEMENT_CODE , SETID , BO_ID_CUST , AGR_TEMPLATE_ID , CURRENCY_CD , START_DT , END_DT FROM PS_RF_AGREEMENT WHERE AGRT_STATUS <> '009' AND RO_CAPTURE_FLAG <> 'N' AND AGR_TEMPLATE_FLG <> 'Y' AND END_DT >= %CurrentDateIn GROUP BY AGREEMENT_CODE , SETID , BO_ID_CUST , AGR_TEMPLATE_ID , CURRENCY_CD , START_DT , END_DT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | AGR_RENEWAL_NUM | Number(4,0) | SMALLINT NOT NULL | This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal) |
| 2 | AGREEMENT_CODE | Character(30) | VARCHAR2(30) NOT NULL | This field represents the agreement code (name) for an agreement |
| 3 | SETID | Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 4 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 5 | AGR_TEMPLATE_ID | Character(30) | VARCHAR2(30) NOT NULL | This field stores the Agreement template id. |
| 6 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | This field stores the Currency Code value. |
| 7 | START_DT | Date(10) | DATE | Start date field to store start date value. |
| 8 | END_DT | Date(10) | DATE | This field stores the end date values. |