CNTRCT_SUMM_VW(SQL View) |
Index Back |
|---|---|
Child Cntrct Released Amt11/15/2015 JOHAN PO0025 - Master contract fluid |
| SELECT SETID , CNTRCT_ID , AMT_RELSD_OPEN_ITM , AMT_LINE_RELEASED , AMT_CAT_RELEASED ,(AMT_RELSD_OPEN_ITM + AMT_LINE_RELEASED + AMT_CAT_RELEASED) , AMT_CNTRCT_MAX , CURRENCY_CD FROM ( SELECT A.SETID , A.CNTRCT_ID ,( SELECT %Coalesce(SUM(H.AMT_RELSD_OPEN_ITM),0) FROM PS_CNTRCT_HDR_RLS H WHERE A.SETID = H.SETID AND A.CNTRCT_ID = H.CNTRCT_ID) AS AMT_RELSD_OPEN_ITM ,( SELECT %Coalesce(SUM(B.amt_line_released),0) FROM PS_CNTRCT_LIN_RLS B WHERE B.setid = A.setid AND B.cntrct_id = A.cntrct_id) AS AMT_LINE_RELEASED ,( SELECT %Coalesce(SUM(c.amt_line_released),0) FROM PS_CNTRCT_CAT_RLS C WHERE C.setid = A.setid AND C.cntrct_id = A.cntrct_id) AS AMT_CAT_RELEASED , 0 AS TOTAL_AMT, A.AMT_CNTRCT_MAX , A.CURRENCY_CD FROM PS_CNTRCT_HDR A WHERE A.VERSION_STATUS = 'C') HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL | Buying Agreement ID |
| 3 | AMT_RELSD_OPEN_ITM | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Amt relsd for Open Item |
| 4 | AMT_LINE_RELEASED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Line Amt Released |
| 5 | AMT_CAT_RELEASED | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Category Amt Released |
| 6 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |
| 7 | AMT_CNTRCT_MAX | Number(27,3) | DECIMAL(26,3) NOT NULL | Maximum Amount of Contract. |
| 8 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |