SETIDCNTRCT_IDCS_CNT_RLS_VW(SQL View) |
Index Back |
|---|---|
Group Contract Released AmountGroup Contract Released Acount |
| SELECT A.SETID , A.CNTRCT_ID , %Coalesce(R.AMT_RELSD_OPEN_ITM,0) , %Coalesce(L.AMT_LINE_RELEASED,0) , %Coalesce(C.AMT_LINE_RELEASED,0) ,(%Coalesce(R.AMT_RELSD_OPEN_ITM,0) + %Coalesce(L.AMT_LINE_RELEASED,0) + %Coalesce(C.AMT_LINE_RELEASED,0)) FROM ((PS_CNTRCT_HDR A LEFT OUTER JOIN PS_CNTRCT_HDR_RLS R ON A.SETID = R.SETID AND A.CNTRCT_ID = R.CNTRCT_ID ) LEFT OUTER JOIN PS_CS_CNT_SUMLN_VW L ON A.SETID = L.SETID AND A.CNTRCT_ID = L.CNTRCT_ID ) LEFT OUTER JOIN PS_CS_CNT_SUMCT_VW C ON A.SETID = C.SETID AND A.CNTRCT_ID = C.CNTRCT_ID |
| # | 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 |