PO_DIST_VCHR_VW

(SQL View)
 Index Back

PO - Voucher Distribution Line

Date Initials Reference # Description 08/25/2009 SF 1908804002 Resolved the issue so that validation gets fired when user tries to change the chartfields in PO Defaults page once the voucher has been closed to avoid restoring encumberance.

SELECT L.BUSINESS_UNIT_PO , L.PO_ID , D.LINE_NBR , D.SCHED_NBR , D.PO_DIST_LINE_NUM FROM PS_VOUCHER H , PS_VOUCHER_LINE L , PS_DISTRIB_LINE D WHERE H.BUSINESS_UNIT = L.BUSINESS_UNIT AND H.VOUCHER_ID = L.VOUCHER_ID AND L.BUSINESS_UNIT = D.BUSINESS_UNIT AND L.VOUCHER_ID = D.VOUCHER_ID AND L.VOUCHER_LINE_NUM = D.VOUCHER_LINE_NUM 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'))

# 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 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