PO_DS_VC_VW1

(SQL View)
 Index Back

PO - Voucher Distribution Line

Date Initials Reference # Description 03.20/2020 Nash 30960043 Created this new view to get the sum of qty of all kind of PO Vouchers except third party.

SELECT D.BUSINESS_UNIT_PO , D.PO_ID , D.LINE_NBR , D.SCHED_NBR , D.PO_DIST_LINE_NUM , SUM(D.MERCHANDISE_AMT) , SUM(D.QTY_VCHR) FROM PS_VOUCHER H , PS_DISTRIB_LINE D WHERE H.BUSINESS_UNIT = D.BUSINESS_UNIT AND H.VOUCHER_ID = D.VOUCHER_ID AND ((H.ENTRY_STATUS <> 'X' AND H.MANUAL_CLOSE_DT IS NULL) OR (H.MANUAL_CLOSE_DT IS NOT NULL AND D.KK_PROCESS_PRIOR = 'N' AND H.CLOSE_STATUS <> 'C') OR (H.MANUAL_CLOSE_DT IS NOT NULL AND D.KK_PROCESS_PRIOR = 'Y' AND H.CLOSE_STATUS <> 'C')) AND H.VOUCHER_STYLE <> 'THRD' GROUP BY D.BUSINESS_UNIT_PO,D.PO_ID,D.LINE_NBR,D.SCHED_NBR,D.PO_DIST_LINE_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_PO Character(5) VARCHAR2(5) NOT NULL PO Business Unit
2 PO_ID Character(10) VARCHAR2(10) NOT NULL Purchase Order
3 LINE_NBR Number(5,0) INTEGER NOT NULL Line Number: 11/24/08 - Added TARGET label [PC product]
4 SCHED_NBR Number(3,0) SMALLINT NOT NULL Schedule Number
5 DISTRIB_LINE_NUM Number(5,0) INTEGER NOT NULL Distribution Line
6 MERCHANDISE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Merchandise Amt F_KDHIL_R87H8 062804 MLM: Added new Line Amount Received Label
7 QTY_VCHR Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Vouchered