BCH_CYC_VND_VW

(SQL View)
 Index Back

Bch Pcycle Supplier Vw


SELECT a.BUSINESS_UNIT , a.VOUCHER_ID , a.PAY_DOC_SEQ , c.REMIT_SETID , c.REMIT_VENDOR , c.VNDR_LOC FROM PS_PYCYCL_DATA a , PS_VENDOR_PAY b , PS_PYMNT_VCHR_XREF c WHERE c.BUSINESS_UNIT = a.BUSINESS_UNIT AND c.VOUCHER_ID = a.VOUCHER_ID AND c.PYMNT_CNT = a.PAY_DOC_SEQ AND a.PYMNT_SELCT_STATUS IN('R', 'V', 'D') AND a.PYMNT_METHOD = 'EFT' AND b.BCH_TRNCOST_CD ='2' AND c.REMIT_SETID = b.SETID AND c.REMIT_VENDOR = b.VENDOR_ID AND c.VNDR_LOC = b.VNDR_LOC AND b.EFFDT = ( SELECT MAX(b2.EFFDT) FROM PS_PYCYCL d , PS_VENDOR_PAY b2 WHERE d.PAY_CYCLE = a.PAY_CYCLE AND b2.SETID = b.SETID AND b2.VENDOR_ID = b.VENDOR_ID AND b2.VNDR_LOC = b.VNDR_LOC AND b2.EFFDT <= d.PYMNT_DT)

# 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 PYMNT_CNT Number(5,0) INTEGER NOT NULL Payments
4 REMIT_SETID Character(5) VARCHAR2(5) NOT NULL Remit SetID
5 REMIT_VENDOR Character(10) VARCHAR2(10) NOT NULL Remit Vendor
6 REMIT_LOC Character(10) VARCHAR2(10) NOT NULL Remit to Location