BUSINESS_UNITPO_IDSHIP_ID_ESTPO_FRT_CLC(SQL View) |
Index Back |
|---|---|
Purchaser Order freight viewUsed to calculate PO freight charges. |
| SELECT S.BUSINESS_UNIT , S.PO_ID , S.SHIP_ID_EST , OS.TRFT_SET_ID , SUM(S.QTY_PO) , %Round(SUM(S.PRICE_PO),4) , %Round(SUM(%DecMult(S.QTY_PO, L.PACKING_VOLUME)),4) , %Round(SUM(%DecMult(S.QTY_PO, L.PACKING_WEIGHT)),4) FROM PS_PO_FRT_SET OS , PS_PO_LINE_SHIP S , PS_PO_LINE L WHERE OS.BUSINESS_UNIT = S.BUSINESS_UNIT AND OS.PO_ID = S.PO_ID AND OS.SHIP_ID_EST = S.SHIP_ID_EST AND L.BUSINESS_UNIT = S.BUSINESS_UNIT AND L.PO_ID = S.PO_ID AND L.LINE_NBR = S.LINE_NBR GROUP BY S.BUSINESS_UNIT, S.PO_ID, S.SHIP_ID_EST, OS.TRFT_SET_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | SHIP_ID_EST |
Character(10) | VARCHAR2(10) NOT NULL | Estimated Ship ID |
| 4 | TRFT_SET_ID | Character(10) | VARCHAR2(10) NOT NULL | Rule Cd |
| 5 | TOT_QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Quantity |
| 6 | TOT_NET | Signed Number(29,4) | DECIMAL(27,4) NOT NULL | Total Net Price |
| 7 | TOTAL_WEIGHT | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Weight |
| 8 | TOTAL_VOLUME | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Total Volume |