AP_WC_TSE_VW

(SQL View)
 Index Back

AP Workcenter Recycled Vchrs

AP Workcenter Recycled Vouchers

SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , B.COUNTER + C.COUNTER + D.COUNTER + E.COUNTER FROM PS_VOUCHER A ,PS_AP_WC_TSEVCH_VW B , PS_AP_WC_TSEVLN_VW C , PS_AP_WC_TSEACC_VW D , PS_AP_WC_TSEPYM_VW E WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.VOUCHER_ID = E.VOUCHER_ID AND A.ENTRY_STATUS = 'R' AND A.VCHR_DRAFT_FLG IN ('N',' ')

# 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 COUNTER Number(10,0) DECIMAL(10) NOT NULL Counter