SETIDCNTRCT_IDLINE_NBRSCN_LN_ORD_DVW(SQL View) |
Index Back |
|---|---|
Sales Contract Line Ordered |
| SELECT E.SETID , E.CNTRCT_ID , E.LINE_NBR , SUM(B.QTY_ORDERED) , %Round(SUM(%DecMult(B.QTY_ORDERED, B.PRICE)) ,4) , %Round(SUM(%DecMult(B.QTY_ORDERED, B.PRICE_BASE)) ,4) FROM PS_SCN_ORD_LINE_VW B , PS_SCN_SETCNTL_VW C , PS_SCON_LINE E WHERE C.SETCNTRLVALUE=B.BUSINESS_UNIT AND C.RECNAME = 'SCON_LINE' AND E.SETID=C.SETID_UNIQUE AND E.CNTRCT_ID=B.CNTRCT_ID_UNIQUE AND E.LINE_NBR=B.CNTRCT_LINE_NBR GROUP BY E.SETID, E.CNTRCT_ID, E.LINE_NBR |
| # | 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 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | QTY_ORDERED | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Order Qty |
| 5 | EXTENDED_NET_PRICE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Ext Net Amount |
| 6 | EXT_NET_PRC_BASE | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Extended Net Price (base) |