AP_VCHR_PYMT_VW

(SQL View)
 Index Back

Voucher Payament Info view

Voucher Payament Info view

SELECT A.BUSINESS_UNIT, A.VOUCHER_ID ,(SELECT COUNT(*) FROM PS_PYMNT_VCHR_XREF P1 WHERE P1.PYMNT_SELCT_STATUS <> 'X' AND P1.PYMNT_TYPE <> 'W' AND ((A.VOUCHER_STYLE = 'PPAY' AND P1.PREPAID_STATUS = 'P') OR (A.VOUCHER_STYLE <> 'PPAY')) AND (( A.PROCESS_MAN_CLOSE = 'N' OR A.CLOSE_STATUS <> 'C') OR ( A.PROCESS_MAN_CLOSE <> 'N' AND A.CLOSE_STATUS = 'C' AND P1.PYMNT_SELCT_STATUS ='E' ) ) AND P1.BUSINESS_UNIT = A.BUSINESS_UNIT AND P1.VOUCHER_ID = A.VOUCHER_ID) , (SELECT COUNT(*) FROM PS_PYMNT_VCHR_XREF P2 WHERE P2.PYMNT_TYPE <> 'W' AND ((A.VOUCHER_STYLE = 'PPAY' AND P2.PREPAID_STATUS = 'P') OR (A.VOUCHER_STYLE <> 'PPAY')) AND P2.PYMNT_SELCT_STATUS IN ('P','E','S') AND (( A.PROCESS_MAN_CLOSE = 'N' OR A.CLOSE_STATUS <> 'C') OR ( A.PROCESS_MAN_CLOSE <> 'N' AND A.CLOSE_STATUS = 'C' AND P2.PYMNT_SELCT_STATUS ='E' ) ) AND P2.BUSINESS_UNIT = A.BUSINESS_UNIT AND P2.VOUCHER_ID = A.VOUCHER_ID) FROM PS_VOUCHER A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 VOUCHER_ID Character(8) VARCHAR2(8) NOT NULL Voucher ID
3 COUNTER2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Counter 2
4 COUNTER3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Counter 3