RTV_DIST_AP_VW

(SQL View)
 Index Back

Receipt - RTV View


SELECT A.BUSINESS_UNIT_RECV , A.RECEIVER_ID , A.RECV_LN_NBR , A.RECV_SHIP_SEQ_NBR , A.DISTRIB_LINE_NUM , SUM(A.MERCHANDISE_AMT) , SUM(A.MERCH_AMT_BSE) , SUM(A.QTY_AM_RETRN_VUOM) FROM PS_RTV_LN_DISTRIB A , PS_BUS_UNIT_TBL_PM B , PS_RTV_LN C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND B.RTV_ADJ_SOURCE = 'Y' AND A.RTV_DIST_STATUS <> 'X' AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.RTV_ID = C.RTV_ID AND A.RTV_LN_NBR = C.RTV_LN_NBR AND C.RTV_LN_STATUS <> 'X' GROUP BY A.BUSINESS_UNIT_RECV, A.RECEIVER_ID, A.RECV_LN_NBR, A.RECV_SHIP_SEQ_NBR, A.DISTRIB_LINE_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RECEIVER_ID Character(10) VARCHAR2(10) NOT NULL Receiver number
3 RECV_LN_NBR Number(5,0) INTEGER NOT NULL Receipt Line
4 RECV_SHIP_SEQ_NBR Number(3,0) SMALLINT NOT NULL Receiver Shipping Sequence
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 ADJUSTMENT_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Amount
7 ADJUSTMENT_AMT_BSE Signed Number(28,3) DECIMAL(26,3) NOT NULL Adjustment Amount (base)
8 ADJUST_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Adjust Quantity