SETIDCNTRCT_IDCNTRCT_ID_DSTCNT_DST_RLS_VW(SQL View) |
Index Back |
|---|---|
Distributor Contract ViewPO002 Manufacturer Contract. Related display view of distributor contract on distributor contract list grid of Manufacturer Contract. |
| SELECT A.SETID , A.CNTRCT_ID , A.CNTRCT_ID_DST , SUM(A.AMT_LINE_RELEASED) , A.CURRENCY_CD FROM PS_CNTRCT_DST_RLS A GROUP BY A.SETID , A.CNTRCT_ID , A.CNTRCT_ID_DST , A.CURRENCY_CD |
| # | 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 | CNTRCT_ID_DST |
Character(25) | VARCHAR2(25) NOT NULL | Contract ID To |
| 4 | TOTAL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Amount |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |